You might want to try flush your mysql privileges
by entering this query:

FLUSH PRIVILEGES;

Or to make sure your user has been granted all permissions, you could enter this query:

GRANT ALL PRIVILEGES ON database.* TO user@localhost;

Just some suggestions not sure if this will fix your problem.

Thanks for your prompt reply. Passed your suggestions on to hosting service provider. They came back saying "change the database password and then reflect the new password within the update script." Not sure if they even ran the suggested queries. Any thoughts on this?

Meanwhile, I tried to go back to the old c5 release (restored my site backup), a new error occurred:


Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'user.CollectionAttributeKeys' doesn't exist] in EXECUTE("select akHandle, value, akType from CollectionAttributeValues inner join CollectionAttributeKeys on CollectionAttributeKeys.akID = CollectionAttributeValues.akID where cID = '1' and cvID = '41'") ' in /home/www/user/html/cms/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/www/user/html/cms/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'usr_web1...', 'select akHandle...', false, Object(ADODB_mysql)) #1 /home/www/user/html/cms/concrete/libraries/3rdparty/adodb/adodb.inc.php(998): ADOConnection->_Execute('select akHandle...') #2 [internal function]: ADOConnection->Execute('select akHandle...', Array) #3 /home/www/user/html/cms/concrete/libraries/database.php(73): call_user_func_array(Array, Array) #4 [internal function]: Database->__call('Execute', Array) #5 /home/www/user/ in /home/www/user/html/cms/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

FYI: I dropped a few indexes from the database manually as suggested by the initial error message :-( How stupid. Anyway, I can't even get to the dashboard and restore my database backup. Any suggestions?

Sounds like your hosting service provider thinks that your mySQL password is wrong.

You can check this in your Concrete5 folder:

In this file - html/cms/config/site.php

---------

That error seems to be saying:

[ Table CollectionAttributeKeys doesn't exist ]
and a few other errors.

Looks like your database structure has some missing tables and possibly other data.

Yea I would suggest that you restore your database backup.
Do you have access to the myPhpAdmin control panel for your database?

If you do, login into that control panel, then go to the database you use for Concrete5. Before running the backup import process it is recommended that you delete the existing tables in the Concrete5 database. Then press the 'Import' button up the top and select your backup.sql file from your hard-drive and restore the backed up tables into the Concrete5 database.

Thanks for that. The site is up and running again (back to version 5.3.2 unfortunately). Before going for a new upgrade attempt, I need to get two things fixed.

1. when calling the index.php (all other pages are working fine) I still get the following error:
Fatal error: Call to a member function getPackageHandle() on a non-object in /home/www/user/html/cms/concrete/libraries/loader.php on line 270

I tried to follow the instructions given here:http://www.concrete5.org/community/bugs/add_content_is_blank/...

Unfortunately there is no .htaccess which I could possibly delete.

2. Within the site's dashboard the File Manager section would not open. When I click the corresponding link on the left hand side, all the system does is to refresh the Statistics chart, which by the way seems reset after the database restore.

Any suggestions?

Is your server running on Windows?

Made some progress last night. File Manager is up and running again. Did a refresh of all dashboard related pages.

The only problem I still need to solve are the missing captcha images. Did review all related threats and performed some of the recommended actions with no success so far.

Any help would be much appreciated.

(Version 5.3.2; Webserver OS = Debian)