BO and FO not accessible - Error "Bad SubDomain SQL query"

[Ranky]

Hello All,

 

I am encountering serious problem in upgrading from Prestashop 1.4.9.0 to 1.5.4.x. I started my upgrade by creating a copy of my shop offline then make an upgrade to version 1.5.4.1. It works fine but I transfer the files and database online this is what I get: “Bad SubDomain SQL query”. I tried this solution but no success:

 

CREATE TABLE `psv_subdomain` (
 `id_subdomain` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `name` varchar(16) NOT NULL,
 PRIMARY KEY (`id_subdomain`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `psv_subdomain` VALUES (1, 'www');

 

I have tried all solution I could find on this forum but non of them works. Please any help? My site is offline since over 2 days.

 

I have tried to update with a copy of my production shop and this is the steps I followed:

 

1) Through FTP I downloaded all files I have in my production site (Version: 1.4.9.0).

2) Then from the production site back office I exported (backed up) the database.

3) I now copy the folder of my production site to my local server.

4) With phpMyAdmin I imported the database backup.

5) I changed the database settings in file: .../config/settings.inc.php to match my local DB info.

6) Now I could access the site both OB and FO locally.

7) My next step was to go to Back Office and install the automatic update module.

8) I then upgraded the site to version 1.5.1.1 – so far working fine.

 

The stage of transferring the local site online to a different domain (online test domain) – not direct to the production site and here I have problem:

 

9) I copied all files from the site main folder to “online test domain”.

10) I export the local database and import it to database I created for “online test domain”.

11) Now I am getting this message “Bad SubDomain SQL query.” when I try to access the site.

 

Please is there any idea why this didn’t work?

 

 

 

 

Thanks

Edited July 16, 2013 by Ranky (see edit history)

[tuk66]

There is no *_subdomain table in v1.5.4.1.

[Cloud Nine]

@Ranky

 

Did you solve your issue ?