Database error when moving servers
Permalink
I'm trying to move my concrete5 website from my local xampp server to a paid host. I found and followed this tutorial:http://www.concrete5.org/documentation/developers/5.7/installation/...
I've followed every step in detail. After finishing the guide I went ahead and test the homepage, however it is giving me two unexpected errors:
An exception occurred while executing 'select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = ? order by pkgID asc' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pgqr288820_concrete5.Packages' doesn't exist
Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found.
I've checked on my live server's phpmyadmin, both tabels packages and logs are present. What can I do? I appreciate any comments, thanks in advance.
I've followed every step in detail. After finishing the guide I went ahead and test the homepage, however it is giving me two unexpected errors:
An exception occurred while executing 'select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = ? order by pkgID asc' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pgqr288820_concrete5.Packages' doesn't exist
Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found.
I've checked on my live server's phpmyadmin, both tabels packages and logs are present. What can I do? I appreciate any comments, thanks in advance.
My concrete5 version is 5.7.2 .
I bet you have a database table casing issue. If your database tables were all lowercased on your local machine, when you move to a Linux server and its case insensitive filesystem you'll have problems, since concrete5's database tables have specific casing. Windows typically likes to just default database tables to lowercase. You'll need to rename your database tables on your web host to match the casing of the database tables that concrete5 specifies when it installs. You could install 5.7.2 in a new installation on your web host, copy the list of database tables that are created, and then rename your affected installation's database tables.
