[solved]Moving site from MAMP local to VPS

[howey]

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.

[velden]

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

[howey]

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.

[Dr.CSS]

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...