User creation SQL querry returns 1364 error

Administer Subversion repository access rights easily

Brought to you by: tom_krieger

User creation SQL querry returns 1364 error

Forum: Help

Creator: Ed Krumins

Created: 2010-06-29

Updated: 2013-05-14

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.