gr4devel Posted December 23, 2013 Share Posted December 23, 2013 Hi community... I sincerely hope that someone will help me this time. The lasts posts that I've written here didn't get much attention... Today I'm facing the inconsistent behavior of the SQL manager with the rest of the PS platform. More specifically: if I write a query the result isn't aligned with the actual state of the db. For example I don't get the correct quantity for the products! Is there some caching behind? Or is it a bug? Please help me. Link to comment Share on other sites More sharing options...
selectshop.at Posted December 23, 2013 Share Posted December 23, 2013 Sincerely, if you know how to use SQL queries, better you use them directly in phpMyAdmin or Heidi-SQL for ex.. I was facing some problems with the SQL-Manager too, but never reported them. If you want to report exactly your query and result of query as bug, so you can use the bug tracker: http://forge.prestashop.com/ 1 Link to comment Share on other sites More sharing options...
gr4devel Posted December 23, 2013 Author Share Posted December 23, 2013 Thank you very much buddy I really appreciate your suggestion However I'm trying to relying on it to extract some information from the DB. Actually I don't want to develop a module only to execute a query and display the results in the BO. I hope that some moderators or some more experienced devs will help us! Link to comment Share on other sites More sharing options...
selectshop.at Posted December 28, 2013 Share Posted December 28, 2013 Hi, as I suggested, you can also use queries directly to your Database acessing with phpMyAdmin or Heidi-SQL for ex. BTW till 2 weeks ago I was moderator, but I've abandoned the free support on the forum. Don't think a mod will directly help you, cause it is not his task. Help here is based on free basis and mod should moderate topics and forum. Link to comment Share on other sites More sharing options...
El Patron Posted December 28, 2013 Share Posted December 28, 2013 I would execute the command in the manager and then as suggested by selectshop.at execute the command in phpmyadmin or similar and compare results. The simple reason you may not be getting the attention is that you are not supplying enough information, i.e. the command you are executing...so if you are not getting attention then review your original post and add more details. Link to comment Share on other sites More sharing options...
gr4devel Posted December 28, 2013 Author Share Posted December 28, 2013 Here I am!!! I'm sorry for my incredible late response! Anyway thank you very much for your support selectshop.at ! And obviously to you El Patron!!! At the end the problem was right what you El Patron suggested! I was querying the wrong table so there's no strange behavior regarding the SQL Manager. I'm really sorry for having raised so much rumor about the SQL Manager, I hope it will never happen again! Btw thanks to everybody! 1 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