Jump to content

[SOLVED] Problem after moving DB to new host Error Invalid loadConfiguration() SQL query!


Donner

Recommended Posts

i tryied install prestashop in a domaine and didnt think much about i might have to move it later, so now i made a backup from phpmyadmin, and import it into the phpmyadmin in the new host,

i edited the text in the database to match the new host and username db server and so on.

i edited the settings.inc.php file like this, but i never try before so i dont know if im wrong.........

<?php

define('__PS_BASE_URI__', '/');
define('_THEME_NAME_', 'Earth');
define('_DB_NAME_', 'donner_jewelry'); (changed )
define('_DB_SERVER_', 'mysql1.gigahost.dk'); (changed )
define('_DB_USER_', 'donner'); (changed )
define('_DB_PREFIX_', 'ps_jewelry'); (changed ) But not sure what to write?
define('_DB_PASSWD_', 'XXXXX'); (changed )
define('_DB_TYPE_', 'MySQL');
define('_COOKIE_KEY_', 'J0NQqR99dhHjQMBdHrcIAScTnOSzASuqHeisnKxiNomqAvEzg2kretcP');
define('_COOKIE_IV_', 'g92Lf1f5');
define('_PS_VERSION_', '1.3.1.1');

?>

When i access the website www.abc-jewelry.com i get this message

Invalid loadConfiguration() SQL query!

settings.inc.php

Link to comment
Share on other sites

i think the problem is in the DB

i attach the DB file,

the new database name is

donner_jewelry

but im unsure what i need to change

there are many places where it say " ps_prestaaccess " but my old DB wass named traderj_presta, so i worry to change it ?

any idea ?

db.TXT

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...