Migrating from Windows to Linux
Permalink
I'm moving some C5 sites from a Windows server to a shared Linux environment.
When the site loads I get:
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 'hoplite.Packages' doesn't exist
This is because the table is named hoplite.packages. Renaming the table to Packages solves the problem and moves on to the next missing (lower case named) table.
No, the hosting provider will not change lower_case_table_names.
Are there any solutions besides manually renaming all the tables?
When the site loads I get:
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 'hoplite.Packages' doesn't exist
This is because the table is named hoplite.packages. Renaming the table to Packages solves the problem and moves on to the next missing (lower case named) table.
No, the hosting provider will not change lower_case_table_names.
Are there any solutions besides manually renaming all the tables?
