Errors after changing database names

[sheepstations]

Hi, I have 2 sites using PS1.7.5.0 and PHP 7.2. I had to change the DB name for both sites to be less than 16 characters for a third-party service provider. (It's a long story).

I did re-name the databases and then made sure the DB user was given all permissions to the re-named databases again. I changed the DB name values in ../parameters.php. I also cleared the cache in ../cache/smarty.

No problem then logging on and viewing the frontend of both sites. This proves the change to the database name was implemented OK. The problem is viewing the backend login pages.

The first site just returns a blank white page.

The second site gives an error  Access denied for user 'gwoyrfze_vbn2'@'localhost' to database 'gwoyrfze_cherbourg' The database has been re-named to gwoyrfze_cher and this value is definitely in the ../parameters.php file.

What else could be stopping me viewing the backend login pages when I can see the frontend of the websites without any problem?

Thanks in anticipation.

JR

[sheepstations]

I suppose the obvious problem with the second site issue is that PS is trying to lookup a database connection using the old database name. Is there any other cache or setting that needs to be cleared / modified so that PS can connect to the DB using the new database name?

[Futamiya]

attention it is imperative then to empty the cache "app" by the FTP therefore delete the "prod" directory (it will be reconstituted automatically) located: either on (depending on your version) / :

 

/app/cache/prod/

or

/var/cache/prod/

Edited October 18, 2021 by Futamiya (see edit history)