MySQL Error in C5.6.2.1 - Queues doesn't exit
Permalink 1 user found helpful
Hi,
I got this message from C5 after i selected Sitemap (version 5621):
An unexpected error occurred.
mysqlt error: [1146: Table 'soustesa_sta5621.Queues' doesn't exist] in EXECUTE("select queue_id from Queues where queue_name = 'copy_page' LIMIT 1").
How can I solve the problem? I never got this kind of problem.
Thanks in advance
I got this message from C5 after i selected Sitemap (version 5621):
An unexpected error occurred.
mysqlt error: [1146: Table 'soustesa_sta5621.Queues' doesn't exist] in EXECUTE("select queue_id from Queues where queue_name = 'copy_page' LIMIT 1").
How can I solve the problem? I never got this kind of problem.
Thanks in advance
Have you recently upgraded? What version are you running? What version before the upgrade?
Hi,
it's a new installation version 5.6.2.1
This is why i don't understand.
Thanks.
it's a new installation version 5.6.2.1
This is why i don't understand.
Thanks.
A very long shot. If it is on a host you have not used before, an issue I have encountered very rarely is that some old versions of unzip screw up case and lowercase filenames when unzipping. That is OK for c5, but not for 3rd party libraries such as Zend that use Camel cased filenames and directories.
Your error doesn't have the feel for that because it is a database table. The only hint in that direction is that c5 uses Zend for queues.
Your error doesn't have the feel for that because it is a database table. The only hint in that direction is that c5 uses Zend for queues.
it may be possible that an addon is causing this error. How do you suggest me to find which one?
If you can get into the dashboard at
yoursite.com/index.php/dashboard/system/backup_restore/database/
There is an option to
"Refresh core database tables and blocks."
Probably best to make a backup first, just in case. If you cant do it through the dashboard you will have to use phpMyAdmin or your host account backup.
yoursite.com/index.php/dashboard/system/backup_restore/database/
There is an option to
"Refresh core database tables and blocks."
Probably best to make a backup first, just in case. If you cant do it through the dashboard you will have to use phpMyAdmin or your host account backup.
ok, I will try that.
Thanks for all. Have a nice weekend. Cheers!
Thanks for all. Have a nice weekend. Cheers!