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

Styves
 
JohntheFish replied on at Permalink Reply
JohntheFish
Have you recently upgraded? What version are you running? What version before the upgrade?
Styves replied on at Permalink Reply
Styves
Hi,
it's a new installation version 5.6.2.1
This is why i don't understand.
Thanks.
JohntheFish replied on at Permalink Reply
JohntheFish
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.
Styves replied on at Permalink Reply
Styves
it may be possible that an addon is causing this error. How do you suggest me to find which one?
JohntheFish replied on at Permalink Reply
JohntheFish
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.
Styves replied on at Permalink Reply
Styves
ok, I will try that.
Thanks for all. Have a nice weekend. Cheers!