Transferring Site - Missing Multilingual Table Error

Permalink 1 user found helpful
I'm migrating a working site to http://covenantlovers.watsy.net... and receiving this error...

An exception occurred while executing 'select count(cID) from MultilingualSections': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'watsyne1_cl2015.MultilingualSections' doesn't exist


I've read the other posts about manually updating your C5 and case-sensitive issues in the database. I can't get the site to load at all. No other links work. The multilingual table doesn't exist in the original, working site either. My PHP version shouldn't be problem.

I followed the instructions for migrating a site... turning off pretty URLS, archiving the site files and database, extracting and importing everything on the new server and updating the config file. Changed permissions on needed files, etc.

Any ideas/help? Thanks so much!!

1 Attachment

 
mnakalay replied on at Permalink Reply
mnakalay
Hello,
the MultilingualSections table must exist in the original if it is working. It is a default Concrete5 table for your version. Could you check again?
watsydotnet replied on at Permalink Reply
Thanks for your reply! I double checked and the Multilingual table is not in the original database. Attached is a screenshot. (see message below) The original URL is: covenantlovers.com (in case I'm missing something with the version number).
watsydotnet replied on at Permalink Reply 1 Attachment
Screenshot attached.
mnakalay replied on at Permalink Best Answer Reply
mnakalay
I am not 100% sure but maybe you have more than one database and getting the wrong one. Did you have a legacy version of C5 installed before? a 5.6.x version?

In the legacy version, the multilingual functionality required an extra add-on so those tables were not present unless you installed the add-on.

In the new version (your version) it comes installed with the core so those tables are present.
watsydotnet replied on at Permalink Reply
I was curious about that too. I'm only seeing one database though. It's the
one that's listed in the config file. I don't know about the legacy version.
watsydotnet replied on at Permalink Reply
Wow. You were totally right! The config file was pointing to a database in a different cPanel account so I couldn't see it. Thanks for your help!
mnakalay replied on at Permalink Reply
mnakalay
You are very welcome.