abduljabbar Posted July 18, 2013 Share Posted July 18, 2013 Hello please i need help badly i was trying to transfer my prestashop store from a hosting plan to a new one because the old one is not stay able then i thought the best to do that was for me to download the whole site via FTP which i did .and after uploading the files via FTP to the new server the store could not load.when i try to open the site i get this error message Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'hawansto_pres147'@'localhost' (using password: YES) i will really be hard for me starting back from noting to build back the store Please i need Thanks in advance Link to comment Share on other sites More sharing options...
vekia Posted July 18, 2013 Share Posted July 18, 2013 you have to change the database credentials located in the configuration file config/settings.inc.php <?php define('_DB_SERVER_', 'localhost'); define('_DB_NAME_', 'name'); define('_DB_USER_', 'user'); define('_DB_PASSWD_', 'password'); define('_DB_PREFIX_', 'ps_'); define('_MYSQL_ENGINE_', 'InnoDB'); Link to comment Share on other sites More sharing options...
abduljabbar Posted July 26, 2013 Author Share Posted July 26, 2013 Thanks i did the changes but now the front website when you load it remain blank i did only change the DB name ,User and password the others remain on change Link to comment Share on other sites More sharing options...
vekia Posted July 26, 2013 Share Posted July 26, 2013 turn error reporting on and check front page, you should see some errors right now (with error reporting mode on) Link to comment Share on other sites More sharing options...
abduljabbar Posted July 26, 2013 Author Share Posted July 26, 2013 Thanks for the help .But i can`t access my admin settings on prestashop it load i remain blank as the complete site Link to comment Share on other sites More sharing options...
vekia Posted July 26, 2013 Share Posted July 26, 2013 but you can log in to your FTP service probably ? in this case you have to use FTP connection to edit the config file settings (you don't have to connect to the prestashop back office) Link to comment Share on other sites More sharing options...
abduljabbar Posted July 26, 2013 Author Share Posted July 26, 2013 the problem i transfer this site from a old server to a new one and before transfering i creat a new databased on the new server and change the old one of the other server to the new one on the new server then upload the complete download files from the old one to the new server .after a complete uploading the site does not load it load and remain blank Link to comment Share on other sites More sharing options...
vekia Posted July 26, 2013 Share Posted July 26, 2013 turn error reporting on in the configuration file not in the back office (moreover there is no option to turn error reporting mode on) Link to comment Share on other sites More sharing options...
masknight Posted July 27, 2013 Share Posted July 27, 2013 can you solve this question if not ,contact me Link to comment Share on other sites More sharing options...
vekia Posted July 27, 2013 Share Posted July 27, 2013 can you solve this question if not ,contact me please help in public. Link to comment Share on other sites More sharing options...
Nodge Posted July 28, 2013 Share Posted July 28, 2013 (edited) abduljabbar, did you actually make a backup of the old database and save it and then import it into your new database using PHPmyAdmin? Edited July 28, 2013 by Nodge (see edit history) Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts