Upgrade from v.1.1.0.rc3 to 1.1.0.rc4.6 fails SQLSTATE[42000]:

itahosting · Nov 2nd 2013

I have one ispCP Installation migrate to i-mscp 1.1.0RC3 successful, and now Iám try to upgrade this installation to the version 1.1.0.rc4.6 but this fails.

This is the following error:

Code

[ERROR]
main::setupUpdateDatabase: [ERROR] Database update failed: Database update 152
failed.
Exception message was:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too
long; max key length is 1000 bytes
Query was:
ALTER TABLE
`domain_dns`
CHANGE
`domain_dns` `domain_dns` VARCHAR(255)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
iMSCP::Debug::END: Exit code: 1

Display More

The MySQL DB is in myisam format and the innoDB was not activate. If i install the rc.4.6 on an new system than the installer works fine.

Does anyone have an idea why this might be and how can I fix the problem?

itahosting · Nov 4th 2013

I have reconfigure mysql and avtivate the innoDB. after that I have migrate again from ispCP to i-mscp the 1.1.0.rc4 release works and build the new Database with InnoDB format after that i can upgrade to 1.1.0.rc4.6 without errors

Upgrade from v.1.1.0.rc3 to 1.1.0.rc4.6 fails SQLSTATE[42000]:

Share

Daily visitors