User creation SQL querry returns 1364 error

Help
Ed Krumins
2010-06-29
2013-05-14
  • Ed Krumins

    Ed Krumins - 2010-06-29

    Hello,
    we're still using an outdated 0.3 version of SVN Access Manager and recently when trying to create a new user account I've  received an error message "1364: Field 'modified' doesn't have a default value". Our guess was that mysql was updated to 5.1 which now needs a default value set for all datetime fields. If that's right, is it supported in latest 0.5 release?
    Thanks

     
  • Thomas Krieger

    Thomas Krieger - 2010-07-01

    Hello,

    version 0.3 is really an old one. It would be better to update to the recent version which supports Oracle, PostgreSQL and MySQL. You're right that MySQL 5.1 changed its behavior and a default value is necessary now.

    There are update scripts in the "doc" directory which will do the database modifications. Keep in mind to run one script after the other to come to the latest version. Make a backup before updating the database. Database schema changed heavyly between version 0.3 and 0.5.

    Bye

    Thomas

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks