site moving

[saltydog]

I have installed locally my cms, edited templates, added contents and refined the tuning. Now it is working as I need.
What is the safest and easiest procedure to move all the cms (software abd data) to the new public remote site server?

[Ted]

Check out this forum post for the procedure most people use

http://forum.cmsmadesimple.org/index.ph ... 661.0.html

[saltydog]

I followed the linked procedure but the site is not performing well!

I have the news module that didn't find data, nor the phptemplate...
In the admin section I can see all the pages, but not in the site.
More, in the admin section I can't see the news templates (summary and detail)

urgently need an help..

[Ted]

Double check and make sure EVERY field in config.php is correct.  Make sure the cache is cleared.  Make sure that the database and files were exactly the same they were before you moved them

It sounds to me like the News module wasn't installed or copied over correctly.  But, as long as the files and database are the same as they were in your dev environment, it should be fine.

[saltydog]

I got this error when importing the module_template table:

ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02): Table 'ubuntu_it_www.cms_module_templates' doesn't exist
ERROR 1146 (42S02): Table 'ubuntu_it_www.cms_module_templates' doesn't exist

[saltydog]

how much is it important that the database user is called cms_user. Could it be named differently?

[saltydog]

I have fixed, changing that charset of the modules template to latin1.
There is a known bug of mysql on keys & UTF8

[calguy1000]

how much is it important that the database user is called cms_user. Could it be named differently?

Afaik, the table has to be named _user where prefix is specified in the config.php