Publishing Page from composer16 14 Browser Info Environment
An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params ["225"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'storyrea_main.MultilingualSections' doesn't exist
We started with the 5.7.1 and now are on 5.7.3
An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params ["1"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fqrhizrz_C5Test.MultilingualSections' doesn't exist
Including clicking through the update process? This will refresh the database and create the necessary tables.
This will create your internationalization and possibly other missing tables.
please also note that, since the dashboard upgrade not working yet, i use to upgrade in old style: move concrete directory on to old one (not suggested, i do it on testing installs). In this case checking on system version from dashboard shows the new version, which leeds to false impression that the update has finished... I have to manually force to update as noted before.
There should be an update/upgrade note within version release announcements or a manual upgrade how to page in the documentation.
By the way thanks for keeping an eye on github/community bug reports, good work.
Replacing the original concrete Directory
If you want to minimize disk space usage and don't need to use the web interface for update Concrete5, you can replace the original concrete directory with a new version, and then upgrade through a particular route.
Login as the super user or someone in the Administrators group. You must do this because upgrading a Concrete5 site requires that the user attempting to do so have access to the "Upgrade Concrete5" permission. By default this is people in the Administrators group (or the super user.)
Download the latest core fromhttp://www.concrete5.org/download...
Unzip the file.
Replace the concrete directory in the web root with the concrete directory you downloaded.
Visit the URLhttp://www.yoursite.com/ccm/system/upgrade.... You should see a message about an upgrade being available. Click through to upgrade your database to the most recent version.
The tables weren't missing, it was just a matter of an uppercase "L".
I am also getting an error about Table MultilingualSections wich doesn't exist.
I looked in the database structure for table names and i noticed that the php scripts are calling 'MultilingualSections' but the table names 'MultiLingualSections' (uppercase L on Lingual).
So i renamed the tables in PhpMyAdmin and it solved the problem.
RENAME TABLE MultiLingualSections TO MultilingualSections;
NB : For the moment I also had to rename MultiLingualPageRelations :
RENAME TABLE MultiLingualPageRelations TO MultilingualPageRelations;
Have a nice day
Your mysql configuration does not use case sensitive table names. Make sure you do not have a setting as
in your my.cnf file. I think you are using mysql on Windows, which is a default behaviour of MySQL on Windows. It adapts OS setting for case sensitivity, if OS is case sensitive MySQL default use case sensitive table names vice versa.
You can simply set lower_case_table_names=0 in my.cnf, but first please readhttp://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.... since this settings may impact other apps and databases in your system. After setting this and restarting MySQL, any tables created further will have CaseSensitive Table Names ;)
Welcome by the way.
Plesk is running on a Centos 6.6 Linux.
The tables have been creatd with both lower and upper case, but the 2 tables i had to rename were slitghtly different, tables were initially named "MultiLingualSections" (upper cas L) instead of the MultilingualSections (lower cas l). Please look at attached file.
I did already have seen the post about my.cnf. I added lower_case_table_names=0, and restarted Mysql (/etc/rc.d/init.d/mysqld stop then /etc/rc.d/init.d/mysqld start). But i could not find any docs on how to have concrete running the tables creation script again...So i decided to Rename Myself. This would be great to be able to Re-Install Concrete the best way (i mean without having to erase everything...). Any SQL Dump of an empty database (just structure, no data) would be very usefull so, do you know where to get this ?
Notice MultiLingualTranslations i also containing an Upper case L, and i guess sooner or later i will face an SQL error and i will have to rename it to "MultilingualTranslations" (l lower case).
Yes this was installed on a Centos 6.6 using Plesk 12.0.8 Application Installer.
If you can't reproduce this error i guess this is a related to this installer, thanks for pointing it
Have a nice day