We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Problem, Error

Upgraded PHP 5.2 to 5.6 now database not found

I have just updated a client's server from running PHP 5.2 to PHP 5.6 so it can support Perch 2.8.18 and now when I go to the perch login it says database not found.

That database still exists and no details have changed. Please can someone offer some advice.

James Tedder

James Tedder 0 points

  • 3 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

Your host would be the person to speak to, that error isn't coming from Perch so we are not likely to be able to help much in this case.

I have just run a PERCH test and it mentions this:

SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, great. Have you done that?

Solved it - I imported my old database into a new one and updated my config.