Setting the shop online after testing it localy

[natasha80]

Hello

I had my shop completely configured in my PC, i bought a hosting package and i uploaded the files to the host.
I created a DB with the same name that i was using localy, and i modified the settings.inc.php file:

<?php

define('__PS_BASE_URI__', '/');
define('_THEME_NAME_', 'prestashop');
define('_DB_NAME_', 'cultocom_tabaco');
define('_DB_SERVER_', 'localhost');
define('_DB_USER_', 'cultocom');
define('_DB_PREFIX_', 'cultocom_');
define('_DB_PASSWD_', 'cul60003');
define('_DB_TYPE_', 'MySQL');
define('_COOKIE_KEY_', 'bvF7OskmSqRwDkECuyYHzXQDzONC25rwOS71zjh9NjPU1LHvYiEXCNxI');
define('_COOKIE_IV_', '0NpBvjVw');
define('_PS_VERSION_', '1.1.0.5');

?>

when i access the server (frontoffice or backoffice i get this error:

Invalid loadConfiguration() SQL query!

Does anyone have any idea what might cause this?

cheers

[capclem]

You must indicate the information of your DB Mysql supplied by your host (not localhost)

[natasha80]

But when in cpanel i click on phpmyadmin i'm directed to a page containing the info:

localhost

* Versão do servidor: 5.0.67-community

so, localhost shouldn't be enough?

[natasha80]

my host just replied to my problem

they say is "localhost" that i should use to access mysql database.

any ideas for what's causing the Invalid loadConfiguration() SQL query! erro?

[ploaie]

i got the same problem... did you found a solution?

[natasha80]

Nop, i had to install a fresh version of the shop

[ploaie]

After a few hours i found that my php.ini was wrong.
So... i put in .htaccess the next lines and everyting is good now.

php_flag register_long_arrays off
php_flag register_globals off
php_flag display_errors on
php_flag zend.ze1_compatibility_mode off



Really, i dont know witch of that option was wrong, but there are the differences betwen those 2 servers.

[natasha80]

so you're saying that the trick resides in the .htaccess?

[ploaie]

No. The problem was php.ini wich was modified by me a few months ago to work with an old version of oscommerce.
The .htaccess trick is only a quick solution to modify the php flags for that directory.

It works for me. PHP was the problem for me.

[woclan]

Yes in my case the difference was the zend optimizer installed, so I deactivate the zend compability option and it did the trick. thanks.