Jump to content

bug SQL Manager PS 1.5 [resolved user error]


gr4devel

Recommended Posts

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

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

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

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

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!!! :D

 

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!

  • Like 1
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...