Jump to content
rrsca

Bad SubDomain SQL query.

Recommended Posts

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.

Share this post


Link to post
Share on other sites

In phpMyAdmin, when you access your prestashop database, in the top right part of the screen you should find "SQL". Click on it, paste the query in the field and click "execute"

 

it should fix it ;)

Share this post


Link to post
Share on other sites

Thanks I found SQL Query. Do I type in exactly as below incl brackets

 

 

 

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

I really have no idea what I am doing. If so that did not work.

Share this post


Link to post
Share on other sites

Can you open up that table (ps_subdomain) and see which values are stored there?

Share this post


Link to post
Share on other sites

×

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More