C5.7.3 error adding new page

Permalink
Hi. I have tried C5.7 already and was happy with it building my site with Elemental theme but after updating to C5.7.3 version It won't allow me to add pages anymore. I am getting this error:

"An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params ["162"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fqrhizrz_C5Test.MultilingualSections' doesn't exist"

Did anyone encounter the same problem?
I hope this bug will be fixed soon

View Replies:
triplei replied on at Permalink Reply
triplei
Is there any chance you can go to <yoursite>/index.php/tools/required/upgrade and see if there is an upgrade script that needs to run? It sounds like there may be a table that hasn't been created.
LTO replied on at Permalink Reply
My first action was to check if there are any updates available accessing dashboard/system/backup/update but there are none.
I've also tried a new install but same error appears when trying to add a new page.
imJack replied on at Permalink Reply
imJack
I have this same thing happening and have been a ll over the threads looking for a resolution.

Does anyone have a clue as to how to fix this? I host at Media Temple, this was a Plesk install. I have overwritten the concrete directory in the core, and forced upgrades several times.

Specific Error::
An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params ["127"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'plcwatertown.MultilingualSections' doesn't exist

I have even repaired tables within MySQL. The table specifically named 'plcwatertown.MultilingualSections' is there... and status is ok.

This error is thrown whenever I create a page from the site map, or the front end, and also when I try to delete an existing page.

Here is the kicker tho, when creating a page in Composer, if I click past the error twice, it will allow me to create the page.

When I try to publish said page I have to take the same steps. But it works, albeit in a most crippled way.

I cannot access the multilingual area at all from the systems settings panel. I get this lovely:

Doctrine \ DBAL \ DBALException
An exception occurred while executing 'select MultilingualSections.cID from MultilingualSections inner join Pages on MultilingualSections.cID = Pages.cID order by cDisplayOrder asc': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'plcwatertown.MultilingualSections' doesn't exist

Does anyone have any idea why this error is happening?

tx in advance.
K.
imJack replied on at Permalink Reply
imJack
I have this same thing happening and have been a ll over the threads looking for a resolution.

Does anyone have a clue as to how to fix this? I host at Media Temple, this was a Plesk install. I have overwritten the concrete directory in the core, and forced upgrades several times.

Specific Error::
An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params ["127"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'plcwatertown.MultilingualSections' doesn't exist

I have even repaired tables within MySQL. The table specifically named 'plcwatertown.MultilingualSections' is there... and status is ok.

This error is thrown whenever I create a page from the site map, or the front end, and also when I try to delete an existing page.

Here is the kicker tho, when creating a page in Composer, if I click past the error twice, it will allow me to create the page.

When I try to publish said page I have to take the same steps. But it works, albeit in a most crippled way.

I cannot access the multilingual area at all from the systems settings panel. I get this lovely:

Doctrine \ DBAL \ DBALException
An exception occurred while executing 'select MultilingualSections.cID from MultilingualSections inner join Pages on MultilingualSections.cID = Pages.cID order by cDisplayOrder asc': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'plcwatertown.MultilingualSections' doesn't exist

Does anyone have any idea why this error is happening?

tx in advance.
K.
AndyJ replied on at Permalink Reply
I'm afraid I haven't seen this issue but my first thing would be to check the spelling and capitalisation for that table are exactly the same as in the error message.

Then I'd run a few queries across the table either via command line or via phpmyadmin and see what (if anything falls out from that).
lbrancamisha replied on at Permalink Reply
lbrancamisha
Hi,

This is the way a solved this problem. Take a look athttp://www.concrete5.org/developers/bugs/5-7-3-1/publishing-page-fr... for my post for more details.

In short, had to rename tables via PhpMyAdmin :

RENAME TABLE MultiLingualSections TO MultilingualSections;
RENAME TABLE MultiLingualPageRelations TO MultilingualPageRelations;
zanedev replied on at Permalink Reply
zanedev
Just wanted to say you also want to do it with: MultilingualTranslations table, ran into that after trying to upgrade.
dema001 replied on at Permalink Reply
thanks! it works
AndyJ replied on at Permalink Reply
hi,
which exact versions were you upgrading to and from and how were you performing the upgrade?
linderoths replied on at Permalink Reply
Had the same problem after upgrading from 5.7.2.1 to 5.7.3.1, going to "dashboard/system/backup/update" and running the script fixed it for me.

Thanks LTO!
michaelvoss replied on at Permalink Reply
Hi, I still have the same problem, although I installed the latest concrete5.
I can't change the language. If I delete or add a page, I get the same error message.
I'm glad for any help.