Error after moving the site1 user found helpful
I moved my website from windows hosting to linux hosting along with database and configured everything, now getting error "mysql error: [1146: Table 'lanoscom_acs.PermissionAccessEntityTypes' doesn't exist] in EXECUTE("select petID from PermissionAccessEntityTypes order by petID asc")" Please help on this, i am novice with concrete5
99% of the time, it happens because you move your site from Windows Server to Linux Server...
I run into this problem myself the other day and I'm afraid Add-On didn't help me very much, something went wrong.. anyhow, here is the list of tables to be run from your phpMyAdmin, SQL query:
RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes; RENAME TABLE areagroups TO AreaGroups; RENAME TABLE areas TO Areas; RENAME TABLE ataddress TO atAddress; RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries; RENAME TABLE ataddresssettings TO atAddressSettings; RENAME TABLE atboolean TO atBoolean; RENAME TABLE atbooleansettings TO atBooleanSettings; RENAME TABLE atdatetime TO atDateTime; RENAME TABLE atdatetimesettings TO atDateTimeSettings; RENAME TABLE atdefault TO atDefault; RENAME TABLE atfile TO atFile; RENAME TABLE atnumber TO atNumber; RENAME TABLE atselectoptions TO atSelectOptions; RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;
Hope it helps someone out there...
All the best!
On the other hand, the case sensitivity migration tool sniffs out all table names from the db.xml, so will find and process tables associated with addons. Hence would always be my first choice when moving a site from windows to Linux.