ACCORD5
Add a reply

ACCORD5 Company Forums » Trellis Desk » Peer-to-Peer Support

MySQL problem

 
  • Started 2 years ago by martini5470
  • 4 posts in this topic
  • Latest reply from morningshadow
  1. User has not uploaded an avatar

    martini5470

    offline
    Member

    Whenever I try to submit new ticket, create new members, edit anything I have issues with my MySql database. I get error message saying:

    There has been a fatal error with the A5 Core.

    --------------

    The MySQL Database Drive has unable been to process the following query.

    The following error was returned.
    Field 'notes' doesn't have a default value

    --------------------

    You can see that field "notes" has an issue in this example, but it get it with everything else as well. Is my sql file for db corrupt? Or do I have to set a default value to be something? Please help

    Posted 2 years ago #
  2. DJ

    DJ

    offline
    Project Lead, Trellis Desk

    Do you have MySQL strict mode enabled?

    Posted 2 years ago #
  3. csalle01

    csalle01

    offline
    Member

    same issue.

    Does MySql strict mode need to be disabled or enabled?

    Posted 1 year ago #
  4. morningshadow

    morningshadow

    offline
    Member

    I have strict mode enabled, and I get this problem as well. Should we have it disabled? I will try that out to see what happens, but when we set MySQL up, it says that it's recommended that we have it enabled. I can't really figure this out either.

    Posted 1 year ago #

RSS feed for this topic

Reply to this topic

You must log in to post.