It could be that the upgrade did not run fully so the database schema was not updated. There are a couple of values in the Config table that tell you what version of concrete5 the core thinks it has, so have a look in phpMyAdmin and check they agree with config/sys.php and the upgrades folder.

I'm having this exact same issue - hoping that we can find some resolution. I'll post here if I find anything.

Thanks for replying - sorry I've taken so long to get back to you.

There wasn't a sys.php file in my root/config directory. I couldn't see a 'version' table in the database. The main site wasn't working correctly on closer examination.

So I backed up my database and files folder, copied them to my PC, removed and reinstalled Concrete5. Now I want to restore my database and files.

When I go to the 'backup database' screen in the Concrete5 admin, there are no databases listed (of course). I copied the database backup from my PC to the folder root/files/backup. However the file is still not listed in the 'restore' list. What else do I need to do to restore my database?

Thanks!
Maggie

Hi

Did anyone ever resolve this? We've just encountered it.

I am facing the same issue after upgrading from 5.6.1.2 to 5.6.2.1. Does anyone know how to solve it?

I thought I had tested this solution previously without success but was able to verify that index privileges were not in fact assigned to my db user. After adding INDEX and all other missing privileges the upgrade process successfully.

As posted here:
http://www.concrete5.org/community/forums/installation/an-unexpecte...

'So, I added the INDEX privilege to the user in mysql and that did the trick!'

My initial instal was through Softaculous, and the upgrade from 5.6.1.2 to 5.6.2.1 was through the C5 update engine. Since then I've encountered the same kind or error messages as above such as:

mysqlt error: [1146: Table 'catalyst_conc221.Queues' doesn't exist] in EXECUTE("select queue_id from Queues where queue_name = 'copy_page' LIMIT 1")

for the site map. This only shows for the admin user, and not other users.

Looking at phpmyadmin and the config table. The following is shown:

SITE_APP_VERSION 2013-08-29 09:06:56
5.6.2.1

SITE_INSTALLED_APP_VERSION 2013-04-03 10:38:56
5.6.1.2

APP_VERSION_LATEST 2014-01-26 21:59:29
5.6.2.1

Softaculous shows that there is an update available for C5, although C5 says there isn't. Looking at the mysql user in the mysql function in CPanel they have full permissions.

Can anyone help and advise? This issue is holding back some development of my website.

Thanks

Justyn

Those errors are typical of an incomplete upgrade. If you look in the INSTALL file with the upgrade zip, it will give instructions for manually running the upgrade file.

To summarise, you can your browser at

http://yoursite.com/index.php/tools/required/upgrade...

There is also an option to force it to repeat
http://yoursite.com/index.php/tools/required/upgrade?force=1...

Helpful. I've been told that it's already been tried. I also just used Softaculous to do the update and although successful from their end, it's not changed the info in the config table as previous displayed.

I just used your previous link to rerun the install script and get the following errors in the heading, although it then says 'update successful' in the main body!

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/!/1): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/!): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/%/7/E): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/%/7): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/%): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/b/l/o): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/b/l): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/b): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c/a/t): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c/a): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c/h/u): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c/h): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c/o/n): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c/o/o): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c/o): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/c): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/d/a/s): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/d/a): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/d): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/f/e/s): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/f/e): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/f): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/l/o/g): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/l/o): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/l): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/m/e/d): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/m/e): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/m): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/p/a/c): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/p/a): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/p/r/o): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/p/r): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/p): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/r/e/s): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/r/e): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/r): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/t/o/o): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/t/o): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/t/r/a): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/t/r): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages/t): Permission denied in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: rmdir(/home/catalyst/public_html/files/cache/pages): Directory not empty in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php on line 99

Warning: Cannot modify header information - headers already sent by (output started at /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/helpers/file.php:99) in /home/catalyst/public_html/updates/concrete5.6.2.1_updater/concrete/core/libraries/view.php on line 957


Any thoughts?

The warnings are all to do with file permissions within the cache directory. The way the cache works has changed a lot over the last few major versions.

You can ignore the warnings. If you want to clean up, just login to your host control panel and delete everything within the /files/cache/ directory.

Hi

Had to contact my hosting company as it wouldn't let me delete/empty the folders. Now have a strange one with the cache folders still filling even though it is all turned off! Reckon that is partly the system not upgraded properly?

Justyn

I had the exact same problem as this (I'm using Concrete5 on a QNAP NAS drive).

I went to "System & Settings", selected "Database XML", ticked "Refresh core datebase tables and blocks" and clicked the "Refresh Databases" button.

Now everything seems to be working fine.

Hope this helps.

Cheers

Nick