rrsca Posted February 12, 2013 Share Posted February 12, 2013 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. Link to comment Share on other sites More sharing options...
NemoPS Posted February 12, 2013 Share Posted February 12, 2013 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 Link to comment Share on other sites More sharing options...
rrsca Posted February 13, 2013 Author Share Posted February 13, 2013 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. Link to comment Share on other sites More sharing options...
NemoPS Posted February 13, 2013 Share Posted February 13, 2013 Can you open up that table (ps_subdomain) and see which values are stored there? Link to comment Share on other sites More sharing options...
Recommended Posts