Publishing Page from composer

Permalink 16 14 Browser Info Environment
When we are publishing a page from the composer we are getting the following error.

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


Status: Minor
pjhagel
View Best Answer
LTO replied on at Permalink Reply
I have the same issue.


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
pjhagel replied on at Permalink Reply
pjhagel
It seems as though the database didn't initialize correctly. I can't seem to find a core database refresh like in 5.6. This would probably correct the issue.
andrew replied on at Permalink Reply
andrew
Did you fully follow the instructions on this page?

http://www.concrete5.org/documentation/developers/5.7/installation/...

Including clicking through the update process? This will refresh the database and create the necessary tables.
LTO replied on at Permalink Reply
What i did was a clean 5.7.3 install on two different sites using scriptacoulous. I didn't do an upgrade.
tolga replied on at Best Answer Permalink Reply
tolga
Your internationalization tables are missing, i suggest you to make a forced update like:

http://your.site.url/index.php/ccm/system/upgrade?force=1...

This will create your internationalization and possibly other missing tables.
LTO replied on at Permalink Reply
Thank you so much for your advice. I followed your instructions and it worked like a charm. The bug is fixed and i can add pages without problems now.

Thank you
pjhagel replied on at Permalink Reply
pjhagel
Perfect Thanks
andrew replied on at Permalink Reply
andrew
Interesting, it sounds like they have missed certain tables in their update. I will contact them.
tolga replied on at Permalink Reply
tolga
Andrew,
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.
andrew replied on at Permalink Reply
andrew
This notice is already in the docs. From the original docs page:

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.
yoonek replied on at Permalink Reply
I tried doing the updates and it didn't work. What did work was going into the database via MyPhp Admin and, just like lbrancamisha, I simply renamed the tables and voila, problem solved.

The tables weren't missing, it was just a matter of an uppercase "L".
lbrancamisha replied on at Permalink Reply
lbrancamisha
Hi, i am a new Concrete fan, this is my first to this forum, i hope it will help.
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
Laurent B.
tolga replied on at Permalink Reply
tolga
Hi Ibrancamisha,

Your mysql configuration does not use case sensitive table names. Make sure you do not have a setting as
lower_case_table_names=1
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.
lbrancamisha replied on at Permalink Reply 1 Attachment
lbrancamisha
Hi Tolga, thanks for your reply.

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).
andrew replied on at Permalink Reply
andrew
This is strange. I've searched the source for MultiLingual (with case sensitivity turned on) and I can't find any examples of tables being created with this casing. How did you create your database? Was this installed through a third party installer?
lbrancamisha replied on at Permalink Reply
lbrancamisha
Hi Andrew,

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
Laurent
zanedev replied on at Permalink Reply
zanedev
Seeing same thing using plesk 12 auto installer on centos linux. Also not the latest latest version of C5 and the dashboard says no updates.
LeandroSabino replied on at Permalink Reply
I am happy we Brazilians appreciate your help .

concrete5 Environment Information

# concrete5 Version
Core Version - 5.7.3
Version Installed - 5.7.1
Database Version - 20141219000000

# concrete5 Packages
Fundamental (1.0.3), Login (1.1.1), Vivid Carousel (1.0.1).

# concrete5 Overrides
blocks/search, languages/ja_JP, languages/sv_SE, languages/da_DK, languages/tr_TR, languages/fr_FR, languages/de_DE, languages/it_IT, languages/ru_RU, languages/el_GR, languages/nl_NL, languages/fi_FI, languages/sl_SI, themes/StoryRealmLive

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
5.4.35

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, fileinfo, filter, ftp, gd, hash, homeloader, htscanner, iconv, imagick, imap, intl, json, libxml, mbstring, mcrypt, mysql, mysqli, mysqlnd, newrelic, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, sockets, SPL, sqlite3, standard, tokenizer, xml, xmlreader, xmlwriter, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 512M
post_max_size - 128M
sql.safe_mode - Off
upload_max_filesize - 128M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
newrelic.special.max_nesting_level - -1
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_2) AppleWebKit/600.3.10 (KHTML, like Gecko) Version/8.0.3 Safari/600.3.10