AfterWorldForum
06-22-2010, 06:12 PM
How would one go about trouble-shooting what is fired off as the result of a POST action?
I'm trying to convert one of our custom mods to vB4, and seem to have run into a wall. I can fire off a POST search, but the expected results do not show up. I use a similar template for another search, and no problems there.
If I turn on DEBUG mode, I can check queries that are fired as part of a REQ action, but how would I see whatever is generated as a result of the POST? I tried being quick about it and run a SHOW PROCESSLIST on the mySQL DB, but never seem to catch it. Is there anything like the Profiler option that SQL Server offers, where you can see all activity on a database for mySQL by any chance?
I know mySQL has a profiler, but that's only good if you already know the query, as opposed to me trying to figure out exactly what my PHP is shooting at the db.
Thanks in advance.
Peter
I'm trying to convert one of our custom mods to vB4, and seem to have run into a wall. I can fire off a POST search, but the expected results do not show up. I use a similar template for another search, and no problems there.
If I turn on DEBUG mode, I can check queries that are fired as part of a REQ action, but how would I see whatever is generated as a result of the POST? I tried being quick about it and run a SHOW PROCESSLIST on the mySQL DB, but never seem to catch it. Is there anything like the Profiler option that SQL Server offers, where you can see all activity on a database for mySQL by any chance?
I know mySQL has a profiler, but that's only good if you already know the query, as opposed to me trying to figure out exactly what my PHP is shooting at the db.
Thanks in advance.
Peter