Refugecreations Posted April 24, 2013 Share Posted April 24, 2013 Hi... I am a newbie... and so far LOVING Prestashop... but... last night I deleted a category and ever since I am getting this message Bad SQL query Unknown column 'cp.position' in 'field list' Please help!!! Thank you! Rebeca Link to comment Share on other sites More sharing options...
NemoPS Posted April 24, 2013 Share Posted April 24, 2013 Prestashop Version? That error means the current table with the alias 'cp' is missing a column named position. Is your Prestashop an updated or fresh installation? 1 Link to comment Share on other sites More sharing options...
Refugecreations Posted April 24, 2013 Author Share Posted April 24, 2013 It is the latest version 1.5.4 .. just installed it.. Thanks!! Link to comment Share on other sites More sharing options...
Refugecreations Posted April 24, 2013 Author Share Posted April 24, 2013 Actually I just got the Arvixe hosting and I did the Softlicious install of Presta shop... LOVELY!! Anyway the problem started when I deleted the category "Ipad" I think it was number 4 Thanks for the response! Link to comment Share on other sites More sharing options...
Refugecreations Posted April 24, 2013 Author Share Posted April 24, 2013 So... how do I fix it? Link to comment Share on other sites More sharing options...
NemoPS Posted April 24, 2013 Share Posted April 24, 2013 Ok so, in which page are you getting that? Try enabling errors as suggested in my signature, and post what you get Link to comment Share on other sites More sharing options...
Refugecreations Posted April 24, 2013 Author Share Posted April 24, 2013 Thanks Nemo... I actually uninstalled and then reinstalled the store and now everything is fine. Link to comment Share on other sites More sharing options...
lisajef Posted August 23, 2013 Share Posted August 23, 2013 Same here version 1.5.4, when I click on catalogue and then products...the message below comes up...so I can't access any products in the back office: Bad SQL queryUnknown column 'cp.position' in 'field list' Anyone tell me how to fix it? Pretty please? Link to comment Share on other sites More sharing options...
benjamin utterback Posted August 23, 2013 Share Posted August 23, 2013 Hi! I would suggest that you turn on error reporting first to see if it tells you anything. http://www.prestashop.com/forums/topic/224525-how-to-get-debug-information-for-500-error-or-blank-page/ Follow that link for instructions for 1.5.3+ Link to comment Share on other sites More sharing options...
NemoPS Posted August 23, 2013 Share Posted August 23, 2013 @lisajef: I assume cp is category_product. Look for that table in the database and add a column named position, set to INT type and 10 as length Link to comment Share on other sites More sharing options...
lisajef Posted August 23, 2013 Share Posted August 23, 2013 Thanks Nemo1, I will give it a try. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts