cannot add or delete page in 5.7
Permalink
Hello!
on a clean install of 5.7 i try to add or delete a page and gives me this error message:
{"error":{"message":"An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params [\"175\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist"},"errors":["An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params [\"175\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist"]}
Still, i am able to copy / move or rename the pages.
Please advice
Thank you
George
i also include environment info:
# concrete5 Version
Core Version - 5.7.3.1
Version Installed - 5.7.3.1
Database Version - 20150109000000
# concrete5 Packages
None
# concrete5 Overrides
languages/de_DE, languages/nl_NL, languages/ja_JP, languages/sv_SE, languages/it_IT, languages/sl_SI, languages/ru_RU, languages/fi_FI, languages/da_DK, languages/fr_FR, languages/tr_TR, languages/el_GR
# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).
# Server Software
Apache
# Server API
cgi-fcgi
# PHP Version
5.3.29
# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, memcache, mssql, mysql, mysqli, openssl, pcntl, pcre, PDO, pdo_dblib, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, SQLite, sqlite3, standard, suhosin, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.
# PHP Settings
max_execution_time - 60
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 5120
memory_limit - 192M
post_max_size - 64M
safe_mode - Off
safe_mode_exec_dir - /usr/bin
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 64M
memcache.max_failover_attempts - 20
mssql.max_links - Unlimited
mssql.max_persistent - Unlimited
mssql.max_procs - Unlimited
mssql.textlimit - Server default
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH
suhosin.cookie.max_array_depth - 50
suhosin.cookie.max_array_index_length - 64
suhosin.cookie.max_name_length - 1024
suhosin.cookie.max_totalname_length - 1100
suhosin.cookie.max_value_length - 4096
suhosin.cookie.max_vars - 1000
suhosin.executor.include.max_traversal - 0
suhosin.executor.max_depth - 0
suhosin.get.max_array_depth - 50
suhosin.get.max_array_index_length - 64
suhosin.get.max_name_length - 1024
suhosin.get.max_totalname_length - 1100
suhosin.get.max_value_length - 4096
suhosin.get.max_vars - 1000
suhosin.log.phpscript.is_safe - Off
suhosin.memory_limit - 256M
suhosin.post.max_array_depth - 50
suhosin.post.max_array_index_length - 64
suhosin.post.max_name_length - 1024
suhosin.post.max_totalname_length - 1100
suhosin.post.max_value_length - 62914560
suhosin.post.max_vars - 7200
suhosin.request.max_array_depth - 50
suhosin.request.max_array_index_length - 64
suhosin.request.max_totalname_length - 1100
suhosin.request.max_value_length - 62914560
suhosin.request.max_varname_length - 1024
suhosin.request.max_vars - 7200
suhosin.session.max_id_length - 128
suhosin.upload.max_uploads - 25
on a clean install of 5.7 i try to add or delete a page and gives me this error message:
{"error":{"message":"An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params [\"175\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist"},"errors":["An exception occurred while executing 'select cID, msLanguage, msCountry from MultilingualSections where cID = ?' with params [\"175\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist"]}
Still, i am able to copy / move or rename the pages.
Please advice
Thank you
George
i also include environment info:
# concrete5 Version
Core Version - 5.7.3.1
Version Installed - 5.7.3.1
Database Version - 20150109000000
# concrete5 Packages
None
# concrete5 Overrides
languages/de_DE, languages/nl_NL, languages/ja_JP, languages/sv_SE, languages/it_IT, languages/sl_SI, languages/ru_RU, languages/fi_FI, languages/da_DK, languages/fr_FR, languages/tr_TR, languages/el_GR
# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).
# Server Software
Apache
# Server API
cgi-fcgi
# PHP Version
5.3.29
# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, memcache, mssql, mysql, mysqli, openssl, pcntl, pcre, PDO, pdo_dblib, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, SQLite, sqlite3, standard, suhosin, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.
# PHP Settings
max_execution_time - 60
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 5120
memory_limit - 192M
post_max_size - 64M
safe_mode - Off
safe_mode_exec_dir - /usr/bin
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 64M
memcache.max_failover_attempts - 20
mssql.max_links - Unlimited
mssql.max_persistent - Unlimited
mssql.max_procs - Unlimited
mssql.textlimit - Server default
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH
suhosin.cookie.max_array_depth - 50
suhosin.cookie.max_array_index_length - 64
suhosin.cookie.max_name_length - 1024
suhosin.cookie.max_totalname_length - 1100
suhosin.cookie.max_value_length - 4096
suhosin.cookie.max_vars - 1000
suhosin.executor.include.max_traversal - 0
suhosin.executor.max_depth - 0
suhosin.get.max_array_depth - 50
suhosin.get.max_array_index_length - 64
suhosin.get.max_name_length - 1024
suhosin.get.max_totalname_length - 1100
suhosin.get.max_value_length - 4096
suhosin.get.max_vars - 1000
suhosin.log.phpscript.is_safe - Off
suhosin.memory_limit - 256M
suhosin.post.max_array_depth - 50
suhosin.post.max_array_index_length - 64
suhosin.post.max_name_length - 1024
suhosin.post.max_totalname_length - 1100
suhosin.post.max_value_length - 62914560
suhosin.post.max_vars - 7200
suhosin.request.max_array_depth - 50
suhosin.request.max_array_index_length - 64
suhosin.request.max_totalname_length - 1100
suhosin.request.max_value_length - 62914560
suhosin.request.max_varname_length - 1024
suhosin.request.max_vars - 7200
suhosin.session.max_id_length - 128
suhosin.upload.max_uploads - 25
Try to upgrade to the latest version of Concrete5.
Thank you for your fast reply ronyD
But, i press Check for updates and it says: No updates available.
Can i manually download the zip, and replace the /concrete folder? or some more folders?
will that do the job?
George
But, i press Check for updates and it says: No updates available.
Can i manually download the zip, and replace the /concrete folder? or some more folders?
will that do the job?
George
You can view this tutorial for upgrading your 5.7 install!
http://www.concrete5.org/documentation/how-tos/developers/how-to-ma...
http://www.concrete5.org/documentation/how-tos/developers/how-to-ma...
Nope!
I followed the instructions exactly and when i went to the link to upgrade it gave me :
Access Denied
Is there any file permissions thing?
thanx
I followed the instructions exactly and when i went to the link to upgrade it gave me :
Access Denied
Is there any file permissions thing?
thanx
When 'upgrading' were you 'logged in'?
Yes, i was.
After many trials, it showed option to upgrade to 5.7.4.2, i downloaded it, it said "Backup Database", i clicked it, it says, "This option has not been implemented yet on 5.7"!!!!!!!!
Come on!!
You get warnings to backup and then it tells you "sorry, no such option yet" !!!
Well i really regret it going to 5.7.....it's absolutely stupid move to do at the moment, since it is NOT mature or ready yet, no backup, no upgrade from 5.6, no books out there...!
Anyway, back to my problem, it gives me all the time this error message:
An exception occurred while executing 'select count(cID) from MultilingualSections': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist
Can i implant this table manually and get on with it?
Or any other ideas anyone?
Thank you all in advance
George
After many trials, it showed option to upgrade to 5.7.4.2, i downloaded it, it said "Backup Database", i clicked it, it says, "This option has not been implemented yet on 5.7"!!!!!!!!
Come on!!
You get warnings to backup and then it tells you "sorry, no such option yet" !!!
Well i really regret it going to 5.7.....it's absolutely stupid move to do at the moment, since it is NOT mature or ready yet, no backup, no upgrade from 5.6, no books out there...!
Anyway, back to my problem, it gives me all the time this error message:
An exception occurred while executing 'select count(cID) from MultilingualSections': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist
Can i implant this table manually and get on with it?
Or any other ideas anyone?
Thank you all in advance
George
I don't know what version you were on, but if you downloaded from the download page (http://www.concrete5.org/get-started), you will see this message:
"Upgrading: If you are using a version of 5.7 below 5.7.3, you must update to 5.7.3 before updating to 5.7.4 or greater."
So I do hope you did this (if on a pre 5.7.3 version), before upgrading to the latest version. I haven't got any experience without doing these steps, so not sure what to do next..
"Upgrading: If you are using a version of 5.7 below 5.7.3, you must update to 5.7.3 before updating to 5.7.4 or greater."
So I do hope you did this (if on a pre 5.7.3 version), before upgrading to the latest version. I haven't got any experience without doing these steps, so not sure what to do next..
Oh God...
I was on 5.7.3
went on to 5.7.4.2
Offered to update to 5.7.5.1
Did it...
And ... site is crashed : gives only this error again and again!!!!!
An unexpected error occurred.
An exception occurred while executing 'select count(cID) from MultilingualSections': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist
PLEASE HELP!!!
I was on 5.7.3
went on to 5.7.4.2
Offered to update to 5.7.5.1
Did it...
And ... site is crashed : gives only this error again and again!!!!!
An unexpected error occurred.
An exception occurred while executing 'select count(cID) from MultilingualSections': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB-xeir-atm.MultilingualSections' doesn't exist
PLEASE HELP!!!
As the error message says. There is something wrong with 'Multilingual'.
Your environment under 'concrete5 Overrides' is not showing even half of what many of my environments show?
Make sure you have the 'System Requirements' for 5.7. Could it be your PHP version is not 5.3.3 (even though it seems you have installed C5)?
Concrete5 Version 7 requires the following:
PHP 5.3.3. or greater
The following PHP modules:
MySQL (with PDO extensions)
DOM
SimpleXML
GD Library with Freetype
CURL
Mcrypt
PHP Safe Mode Off
PHP Memory Limit at least 64 MB (more might be required for the processing and handling of large image files.)
MySQL 5.1.5 or Higher
MySQL InnoDB Table Support
Concrete5 is run mostly on Apache 2, but will also work on IIS and Nginx.
Your environment under 'concrete5 Overrides' is not showing even half of what many of my environments show?
Make sure you have the 'System Requirements' for 5.7. Could it be your PHP version is not 5.3.3 (even though it seems you have installed C5)?
Concrete5 Version 7 requires the following:
PHP 5.3.3. or greater
The following PHP modules:
MySQL (with PDO extensions)
DOM
SimpleXML
GD Library with Freetype
CURL
Mcrypt
PHP Safe Mode Off
PHP Memory Limit at least 64 MB (more might be required for the processing and handling of large image files.)
MySQL 5.1.5 or Higher
MySQL InnoDB Table Support
Concrete5 is run mostly on Apache 2, but will also work on IIS and Nginx.
I have installed on the same server - a shared hosting one - more than 20 C5 5.6 sites without any problem, and 5-6 sites of C5 5.7, also with no such issues, so it mustn't be the server thing.
But as you said, since its about the Multilingual Sessions table in the DBase, isn't there a way to add/edit it manually?
The funny thing is that on PHPMyAdmin, i can see all "Multilingual" tables normally...
Any ideas anyone?
George
But as you said, since its about the Multilingual Sessions table in the DBase, isn't there a way to add/edit it manually?
The funny thing is that on PHPMyAdmin, i can see all "Multilingual" tables normally...
Any ideas anyone?
George
