vasvra Posted February 19, 2013 Share Posted February 19, 2013 Hi Hope somebody can help me after spending many hours trying to get my live shop back again after an upgrade. I had to replace all my files from a previous back up after an update crash. Checked the config/settings.inc.php and all seems OK. I cannot open the site or the back end and I get the message "Bad SubDomain SQL query." Not being able to get to the back office I cannot check the preferences etc Below is my settings.inc.php <?php define('_DB_SERVER_', 'localhost'); define('_DB_TYPE_', 'MySQL'); define('_DB_NAME_', 'presta14'); define('_DB_USER_', 'presta14'); define('_DB_PASSWD_', 'xxxxxx'); define('_DB_PREFIX_', 'ps_'); define('_MYSQL_ENGINE_', 'MyISAM'); define('_PS_CACHING_SYSTEM_', 'MCached'); define('_PS_CACHE_ENABLED_', '0'); define('_MEDIA_SERVER_1_', ''); define('_MEDIA_SERVER_2_', ''); define('_MEDIA_SERVER_3_', ''); define('_COOKIE_KEY_', 'e0T6DpD4ktTHpDcYfoCWQf5IK4uVFqTDNwPuurxI4icqSZS0P4cFS4hU'); define('_COOKIE_IV_', '6vbAEGYm'); define('_PS_CREATION_DATE_', '2012-02-13'); define('_PS_VERSION_', '1.4.8.2'); define('_RIJNDAEL_KEY_', 'U4d7tm71xH21CN6TTfWcRW0mnFiH4OWp'); define('_RIJNDAEL_IV_', 'KlWxAEZ26h53kt3qZvLxcA=='); define('__PS_BASE_URI__', '/'); define('_THEME_NAME_', 'prestashop'); some help the right way will be appreciated Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 19, 2013 Share Posted February 19, 2013 when you said that you restored your files, did you also restore you mysql db? Link to comment Share on other sites More sharing options...
vasvra Posted February 20, 2013 Author Share Posted February 20, 2013 Thanks for reply. No I did not. The data was not affected but I will try and replace just in case since you mentioned it as I have a back up and let you know later Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 20, 2013 Share Posted February 20, 2013 it would have been affected... Link to comment Share on other sites More sharing options...
vasvra Posted February 20, 2013 Author Share Posted February 20, 2013 Thank you Elpatron for the tip. I did change the data base and it worked. I feel silly that I did not think of it as I was so sure that it was not touched during the update. I would like to mark this post as closed but I do not know how vas Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 20, 2013 Share Posted February 20, 2013 jajaja..not touched during update...that is the first thing it touched...remember this is a database driven cms... kudos for taking the proper back up!...if everyone did that this forum would have 50% less posts Link to comment Share on other sites More sharing options...
Recommended Posts