[Answered ]-Django/South "python manage.py migrate CaseReport" raises an exception

by

2👍

I had the same issue and spent hours applying different solutions. The problem was there can be either no permissions for MySQL user to operate tables or presence of ROLLBACK_TEST table in database. I had both, so maybe it will help someone:

Grant user required permissions on database, then flush priveleges to take effect:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX 
    ON `databasename`.* TO 'username'@'ip.address' IDENTIFIED BY 'somepass';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'username'@'ip.address';

Delete table ROLLBACK_TEST if any:

USE databasename
DROP TABLE ROLLBACK_TEST;

Then migration went smoothly.

👤akarilimano

Leave a comment