This indicates a PHP version compatability issue to your MySQL database. As of PHP 5.3, you need to have the new password format, and it would appear that for whatever reason your MySQL server is still using the old one. You should contact your web host about this.

While not the best answer, the easiest way to solve this error is to go back to PHP 5.2, otherwise you will need to figure out what fields in the database are using the old function, and convert them to use the new one.

From the PHP 5.3 backward incompatibility athttp://www.php.net/manual/en/migration53.incompatible.php...

Thank you very much! I will contact my host about this and see if they can resolve the issue (I don't know enough about php to do it myself). Thanks again :)

Update for anyone else who may come across this problem...

My host downgraded the php to 5.2 but I was then unable to login to the admin dashboard as my password wasn't recognized. Once the php was upgraded again, I could login fine.

The problem is thus ongoing and I have left it with my host for now.

This is because that the encryption method used is different. Basically you have two options, find and convert all of the database fields that are encrypted using the mysql password function, and re-encrypt them using the new one, or option two if you don't need the content from your current site would be to have your host upgrade to php 5.3, and then do a full re-install of your c5 instance. I suspect that only the users table would need to be converted but wouldn't be able to say that with full confidence.

It seems to be working now. What I did was downgrade the php to 5.3 and I was able to login and empty the trash fine. I haven't checked any other functionality but will report back if I come across problems.


This is the response my host made:

I have enabled 'output_buffering' in your php.ini file athttp://www.hostdomain.com/controlpanel/cgiManagement/phpplus.html... . Now, the URLhttp://mydomain.co.uk/index.php/dashboard/sitemap/full/... gives below error in our CGI error log while trying to delete the Trash folder:
--------------------------------------
20140518T034523: mydomain.co.uk/index.php/tools/required/dashboard/sitemap_delete_forever
PHP Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] in /hermes/bosoraweb029/b2582/ipg.mydomain/subdomain/concrete/libraries/3rdparty/Zend/Db/Adapter/Pdo/Abstract.php on line 129
--------------------------------------
Currently, you've set PHP version 5.5 for your account. It appears to be a concrete5 compatibility issue with PHP version 5.5. Unfortunately, we cannot make any server-side changes to the PHP version in our shared platform. If you wish, you can downgrade the PHP version for your account athttp://www.ipage.com/controlpanel/cgiManagement/phpplus.html... and update any PHP settings in the php.ini file. If your concrete5 application require PHP version 5.5 then, I would suggest you to contact concrete5 support regarding the above error or raise the issue in their support forums for any workarounds/fixes.