ledelire Posted June 9, 2013 Share Posted June 9, 2013 Hey there! Some new issue "appeared" in my back office, in the product creation. When I click Product to create a new product I get this issue: Bad SQL queryUnknown column 'cp.position' in 'field list' Problem is, I have done so many things these last few days and I'm still a bit unfamiliar with Presta, and sooo unfamiliar with coding, that I cannot make myself an idea of what has triggered this situation nor where to solve it! Thank you for your help! Link to comment Share on other sites More sharing options...
El Patron Posted June 9, 2013 Share Posted June 9, 2013 try this: clear you browser cookies and cache Link to comment Share on other sites More sharing options...
ledelire Posted June 9, 2013 Author Share Posted June 9, 2013 Thank you but it did not work Link to comment Share on other sites More sharing options...
El Patron Posted June 9, 2013 Share Posted June 9, 2013 did you do a category/product csv import. There are lots of reports of this same problem, the solution I posted above worked for one person so was hoping it would work for you. Other solution I found in Spanish forum was to clear the cache. Try turning off cache and forcing smarty compile. here is a link to google search of this issue: https://www.google.com/search?q=prestashop+Unknown+column+%27cp.position%27+in+%27field+list%27&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a 1 Link to comment Share on other sites More sharing options...
ledelire Posted June 9, 2013 Author Share Posted June 9, 2013 I did not do an import, at least recently, I tried about a week ago, but erased the files as it was not satisfactory. I do have a couple of modules installed though, but they seemed to work right all these days. Ine is "fast product creation" (which I cannot access until I enter "product" , and then another one which is "quick administration" which in turn is accessible, fully working and displaying all my products. I am going to check the article you mention, thank you. 1 Link to comment Share on other sites More sharing options...
ledelire Posted June 9, 2013 Author Share Posted June 9, 2013 Ok, it's been solved! Thank you very much! Link to comment Share on other sites More sharing options...
El Patron Posted June 9, 2013 Share Posted June 9, 2013 Ok, it's been solved! Thank you very much! Please tell us what solution you found. Thanks, Fred Link to comment Share on other sites More sharing options...
ledelire Posted June 9, 2013 Author Share Posted June 9, 2013 Well, I'm a bit ashamed to say it hahah... It was deleting the cookies, But I did not see (in chrome) that the delete history was marked on this present session only, so I chose to delete all since yesterday... No big mistery... *shame* *shame* 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts