Page 1 of 1

Server Migration

Posted: Tue Dec 18, 2007 10:11 am
by toclifrench
Hi,

I'm moving my sites to a newer version of Plesk (from 7.5.4 to 8.2.1) I'm using CMSMS from 1.0.8 to 1.2.2. The Migration haven't been smooth but i finally managed to do it. One execption: the module_template table in the database won't be accepted as it's too big.

"Error shown"
"#1071 - Specified key was too long; max key length is 1000 bytes".

So i had to leave this table. The site seems to work ok but i'm sure it is affected it somehow. Does anyone can tell me by not having the module_template in the table of the database how can it affect the site? and if someone came across the same problem, how did you get around it? Thanks very much for you help.

Pascal

Re: Server Migration

Posted: Wed Dec 19, 2007 1:49 pm
by Ted
Sounds like you changed mysql versions as well.  module_templates is going to be a problem because any modules that use database templates (pretty much all of them that display something on the site) will give you errors because the templates can't be found.

The solution to fixing that issue would be to remove the primary key from the database import file...  but given that the database dump and your new site are probably out of sync now, it's going to be a lot more difficult to fix.