Migration from SQLite to MySQL: Adding users failes

[jthomaschewski]

I've used the migration instructions on https://github.com/haiwen/seafile/wiki/Migrate-data-from-SQLite-to-MySQL to migrate from SQLite to MySQL.

Now creation of users and even deleting them failes:

Error exec query INSERT INTO EmailUser(email, passwd, is_staff, is_active, ctime) VALUES ('test@example.com', 'XXXXXXXXXXX', '0', '1', 1381504900000000): Duplicate entry '0' for key 'PRIMARY'.

I'm getting a lot more similar errors (duplicate entry 0) in the logs

2013-10-11 18:34:46,206 [WARNING] seahub.utils:807 calc_dir_files_last_modified (1062, "Duplicate entry '0' for key 'PRIMARY'")

Seems as if "auto_increment" isn't enabled for IDs in mysql but altering columns to enable it fails to (same error).

I've checked table "EmailUser" and there is only one entry for "0"

[xiez]

Hi @JBBr , I've updated the scripts in the wiki, I'd appreciate if you can take a test, and please let me know if you have other problems.
Thanks!

[jthomaschewski]

Hi @xiez , thanks for the update and generally for creating the migration guide and scripts!
I've recreated the .sql files with your script and tried importing them in a new clean test db. Importing succeeded without any errors.
In the "production" DB I already altered all tables with primary key ID column and enabled auto increment. Enabling does not work if there is any row with id=0 - so I just renamed it to something else, altered table and than renamed id back to 0.