Error after moving the site

Permalink 1 user found helpful
Hi

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

naresh
View Replies: View Best Answer
Remo replied on at Permalink Reply
Remo
That's common issue because table names on Windows aren't case sensitive. You can find an add on in the marketplace which helps you with this. There are also a number of discussions about it in the forum
naresh replied on at Permalink Reply
naresh
I am kind of novice in these things, please help with what I need to do, which addon I need to use?
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
mozalan replied on at Permalink Best Answer Reply
Hi guys,

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!
JohntheFish replied on at Permalink Reply
JohntheFish
A fixed list of renames is good, because it is simple, but will never be my first choice because of just that. In its simplicity a fixed list can't account for further tables from addons installed, so nearly always requires some site specific adjustment, or c5 version specific adjustment.

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.