Bad SubDomain SQL query!

[shampaz]

Sveiki,

 

gal kam teko susidurti su sia problema? Vietoje puslapio liko tik sis uzrasas: Bad SubDomain SQL query.

Cia radau angliskame forume toki sprendimo buda:

 

Please execute this SQL request in your PhpMyAdmin:

INSERT INTO `ps_subdomain` (`id_subdomain`, `name`) VALUES

(1, 'www');

 

bet poto man ismeta klaida

#1062 - Duplicate entry '1' for key 1

ir niekas nepasikeicia.

[Richard S]

Kokią versiją naudojate? Ką bandote padaryti?

[shampaz]

i back offica taip pat negaliu patekti, todel kokia tiksliai buvo versija nlb ir atsimenu, kazkur pusmecio senumo.

[rrsca]

Hi

 

I recently changed my hosting account and had to transfer my site to a new server. All worked well I thought but I am getting this message:

 

Bad SubDomain SQL query.

 

I understand from this forum I have to :

 

"Please execute this SQL request in your PhpMyAdmin:

 

INSERT INTO `ps_subdomain` (`id_subdomain`, `name`) VALUES

(1, 'www'); "

 

Please can someone tell me what that means and give step by step instructions.

 

I went to my hosting and signed into my phpadmin, but I don't know where to put these characters. Wjats is ps_subdomain and where do I find it?

 

When I find it do I type `id_subdomain`, `name` 1, 'www' or (`id_subdomain`, `name`) VALUES

(1, 'www');

 

Please help.

[innercode]

Hi rrsca,

 

When you log in to your phpmyadmin account, select the database which is used for prestashop.

 

Then select "Query" from the top menu. Copy/paste the line:

"INSERT INTO `ps_subdomain` (`id_subdomain`, `name`) VALUES (1, 'www');" (without double quotes) into the textarea ("SQL query on database "db_name_here") below and hit "Submit query".

 

I don't know if it is the correct solution to your problem, haven't encountered it, so use it at your own risk, just gave the instructions how to execute it;)

Edited February 12, 2013 by dovis (see edit history)