truknpk Posted September 20, 2014 Share Posted September 20, 2014 (edited) Hello all I get this error in a new installation of prestashop v1.6.0.9. I have tried to add 775 permisions to the folder and change the .httpacces but still doesn't work. The error when I try to enter to the index is: *ERROR* 2014/09/20 - 13:19:52: Table '.ps_shop_url' doesn't exist<br /><br /><pre>SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'mydomain OR su.domain_ssl = 'mydomain.es') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC</pre> at line 635 in file classes/db/Db.php *ERROR* 2014/09/20 - 13:19:53: Table 'mydoomain_3.ps_shop_url' doesn't exist<br /><br /><pre>SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'mydomain.es' OR su.domain_ssl = 'mydomain.es') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC</pre> at line 635 in file classes/db/Db.php *ERROR* 2014/09/20 - 13:19:53: Table 'mydomain3.ps_shop_url' doesn't exist<br /><br /><pre>SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'mydomain3es' OR su.domain_ssl = 'mydomain3.es') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC</pre> at line 635 in file classes/db/Db.php But it's because the tables can't be created, i think so. I have searched in google and in this foro and I cant get a good solution. Thank you in advance Edited September 20, 2014 by truknpk (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted September 22, 2014 Share Posted September 22, 2014 Try erasing the whole db, and reinstall it manually (without any automated installer). If it's still the same, at this point add those ones manually once everything is settled Link to comment Share on other sites More sharing options...
truknpk Posted September 22, 2014 Author Share Posted September 22, 2014 I did that and the error is the same. If I add the tables manually will work? Try erasing the whole db, and reinstall it manually (without any automated installer). If it's still the same, at this point add those ones manually once everything is settled Link to comment Share on other sites More sharing options...
benjamin utterback Posted September 22, 2014 Share Posted September 22, 2014 I did that and the error is the same. If I add the tables manually will work? You shouldn't need to add tables manually. Have you created a totally new database instead of replacing the current one? Your hosting provider should be able to give you more details about the cause of this error. Link to comment Share on other sites More sharing options...
truknpk Posted September 22, 2014 Author Share Posted September 22, 2014 Yes I create a new database. I already say to my hosting provider the error. I will tell you the soluition. Thanks You shouldn't need to add tables manually. Have you created a totally new database instead of replacing the current one? Your hosting provider should be able to give you more details about the cause of this error. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now