Upgrade Database Errors
Permalink
I have a client who used a different table type and when I brought the computer to my local server with the usual setup for Concrete5, I got this error:
An Unexpected Error occurred while upgrading: mysql error: [1210: Incorrect arguments to DATA DIRECTORY] in EXECUTE("ALTER TABLE btFormAnswerSet MODIFY COLUMN asID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT")
I was told by the client's tech support that I have to change the table structure from nodb to myisam. But, I don't know what that means.
I am not allowed to work on their server so I have to do the work locally on my computer and convert the sql file table so not to get these errors. Any SQL experts who can guide me?
An Unexpected Error occurred while upgrading: mysql error: [1210: Incorrect arguments to DATA DIRECTORY] in EXECUTE("ALTER TABLE btFormAnswerSet MODIFY COLUMN asID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT")
I was told by the client's tech support that I have to change the table structure from nodb to myisam. But, I don't know what that means.
I am not allowed to work on their server so I have to do the work locally on my computer and convert the sql file table so not to get these errors. Any SQL experts who can guide me?
