CMS Made Simple Forums

Hi, I have been having trouble moving a site from a local installation to the webserver. I have tried just copying the files (ftp) to the server and migrating the database information via phpMyAdmin. I have also tried a clean install on the webserver, plus adding the additional modules through module manager. Clean install is no problem, seems to be working fine. But I then get an error when I transfer the database info. Both sites, local and server are running 1.11.4, with all the modules up-to-date. PHP versions are 5.3.2 (MAMP local) and 5.3.2 on the VPS.

CGExtensions
CGSimpleSmarty
CGGoogleMaps
CGCalendar
FormBuilder

The error I get is a blank page on both admin and site with this message:

INSERT INTO catton_routes (term,key1,key2,key3,data,created) VALUES ('/[nN]ews\\/(?P[0-9]+)\\/(?P[0-9]+)\\/(?P.*?)\\/d,(?P.*?)$/','News',NULL,NULL,'O:8:\"CmsRoute\":2:{s:15:\"\0CmsRoute\0_data\";a:4:{s:4:\"term\";s:97:\"/[nN]ews\\/(?P[0-9]+)\\/(?P[0-9]+)\\/(?P.*?)\\/d,(?P.*?)$/\";s:8:\"absolute\";b:0;s:4:\"key1\";s:4:\"News\";s:4:\"key2\";N;}s:18:\"\0CmsRoute\0_results\";N;}',NOW()) -- Table 'c1ttonh1.catton_routes' doesn't exist

I haven't a clue what this means, but it does mention news?

Any help suggestions greatly appreciated.

You did change the config.php file in the root so it has the database connection details of the new server?

Hi, yes I checked just in case in both instances. I had tried a fresh install as well as copied folders. With the fresh install the config was generated from scratch.

change the name of the News folder in /modules, then you should be able to get into admin, go to system maintenance to fix routes, then rename News folder back to News...