Bad SubDomain SQL query.

[Albal]

I'm trying to restore a database back up. Prestashop when run from the installer works fine, when I drop the tables, upload the backup I get the following error

 

Bad SubDomain SQL query.

 

 

I have tried

INSERT INTO `ps_subdomain` (`id_subdomain`, `name`) VALUES (1, 'www');

 

As well as other suggestions. None of which have worked.

I've tried to drop and reupload, doesnt work either.

 

Does anyone know what to do? :/

[Albal]

Bump.

[edwiny]

I have encountered the same issue. I just purchased a Prestashop Theme from TemplateMonster.com. I dropped the database tables from the Prestashop install and imported the Database Dump file from the theme.

 

Now getting this error of Bad Subdomain SQL Query.

 

I have tried

INSERT INTO `ps_subdomain` (`id_subdomain`, `name`) VALUES (1, 'www');

 

However, get the error that ps_subdomain table does not exist.

 

 

However, When I restore the DB from the original install, works again, but obviously not with the Theme I intend to use.

 

Using Prestashop 1.4.7.3