https://bugs.launchpad.net/mahara/+bug/806764
Cheers,
Francois
]]>Here is what happened, before I got my character set change from "swedish" to "utf8", I did an upgrade attempt from 1.2.4 to 1.3, which add all the new tables introduced in version1.3, it failed half way through with all the new tables added into my database. When I try upgrade to 1.4, this obviously will fail as all new tables already exist in the database.
For mahara dev team, could someone alter the upgrade script to do the requirement check first before attempt do anything else? I have seen few people having similar issue with sweish character set, they'll encounter similar issues if they upgrade their mahara in the future.
The version number in the upgrade script(lib/db/upgrade.php) should be increamented everytime complete any changes to the databse, so upgrade can be carry on if there is any discruptions during the upgrade.
HTH,
Lei
]]>Thanks for your reply. The database has been restored to the pre-upgrade status, and I've also tried to run the sql command in a console, it returns the same error as the browser did.
I'm now trying to upgrade the version from 1.2 to 1.3 first to see if this can resolve my issue...
-Lei
]]>If you're using mysql, make sure you've restored the database back to it's pre-upgrade state before attempting the upgrade again.
If you've done that and you're still getting that error, I guess the most useful thing you could do is try running that SQL command in a console and find out the exact error message so we can find out why it's failing.
It could be that the constraint arte_aut_fk already exists, or it could be that you have some rows in there where the author column has a value that's not in the usr table.
R.
]]>Could not execute command: ALTER TABLE artefact ADD CONSTRAINT arte_aut_fk FOREIGN KEY (author) REFERENCES usr (id)
There are other posts here in this forum having similar issue, but none of them helped. Could someone point me to the right direction?
TIA,
Lei