Hi,
I'm trying to debug an issue with the queries that the location module is performing. Basically it works flawlessly when logged in but not when you're not. I erred earlier thinking it was working fine, but I guess it's not. The module doesn't seem to be actively maintained so I'm stuck debugging it myself. If anyone has any ideas as to why that may happen or what to look for I would greatly appreciate it (i've already patched the module with a patch someone offered on the support page as well as edited some sql to eliminate an ambiguity issue - I got rid of the errors but not get "Displaying results 1 - 0 of 11 for search on 05401" for a search that has 11 results if you're logged in).
That said I have a more general question that has nothing to do with the module. I want to find out what the queries are that are getting executed on the database so that I can a. compare them to the code (i discovered while debugging the first issue that the queries executed are not always the same as t b. run them directly on the db and see what I get
I found in database.mysql.inc the following: if ($debug)... which is a variable that gets passed to the function and defaults to 0.
How do I turn debug on without editing the mysql file?
thanks, .sander