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
"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
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.
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.
I've also tried a new install but same error appears when trying to add a new page.
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.
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.
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.
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.
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).
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).
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;
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;
Just wanted to say you also want to do it with: MultilingualTranslations table, ran into that after trying to upgrade.
thanks! it works
hi,
which exact versions were you upgrading to and from and how were you performing the upgrade?
which exact versions were you upgrading to and from and how were you performing the upgrade?
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!
Thanks LTO!
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.
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.