Error moving site - Packages doesn't exist
Permalink
I am trying to move a local development site to a remote server, and followed the instructions here,http://documentation.concrete5.org/developers/installation/moving-a... but am getting the following error message:
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 'my_database_name.Packages' doesn't exist (database name removed)
I tried to troubleshoot this by going back to the local install, uninstalling the package I created, and removing the package from the directory, along with removing application overrides. I then dropped all the tables and re-imported the database, but the error message still persists. Caching is off, and I cleared any cache files to rule that out.
There is no reference to a package installation in the database table "packages" so I am not sure what is trying to reference the table since the package has been removed and uninstalled through the admin. I am wondering if this is an issue between "Packages" and "packages".
Any suggestions are welcome. Thanks!
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 'my_database_name.Packages' doesn't exist (database name removed)
I tried to troubleshoot this by going back to the local install, uninstalling the package I created, and removing the package from the directory, along with removing application overrides. I then dropped all the tables and re-imported the database, but the error message still persists. Caching is off, and I cleared any cache files to rule that out.
There is no reference to a package installation in the database table "packages" so I am not sure what is trying to reference the table since the package has been removed and uninstalled through the admin. I am wondering if this is an issue between "Packages" and "packages".
Any suggestions are welcome. Thanks!
Yes- but I figured it out. XAMPP on windows.
https://www.concrete5.org/community/forums/5-7-discussion/database-e...
I had to rename the table names as shown. Seemed to fix the problem. Someone should post the potential problem and fix on this page:http://documentation.concrete5.org/developers/installation/moving-a...
Troubleshooting doesn't mention anything about camel case issues and would have saved me a lot of time if I had known.
https://www.concrete5.org/community/forums/5-7-discussion/database-e...
I had to rename the table names as shown. Seemed to fix the problem. Someone should post the potential problem and fix on this page:http://documentation.concrete5.org/developers/installation/moving-a...
Troubleshooting doesn't mention anything about camel case issues and would have saved me a lot of time if I had known.
I had the same problem after local installation and copy to host.
I have to go this way, because I can not install it directly on the server. I dont know why.
That was my solution.
https://www.concrete5.org/community/forums/installation/can-not-inst...
I have to go this way, because I can not install it directly on the server. I dont know why.
That was my solution.
https://www.concrete5.org/community/forums/installation/can-not-inst...
I guess you developed on Windows, right? And all your table names in concrete5 database are lowercase?