0

I've got a single meta variable with a string value that should always be 0 or 1 being stored on pages. I can set it using a simple dropdown box in a metabox and it seems to work great. For some bizarre reason, it sometimes gets changed from 1 to 0 seemingly randomly. I have no clue why, and it seems to happen even on a page I wasn't editing or updating. I'm baffled and don't even know where to begin looking because I haven't figured out how to replicate the problem.

Does anyone have any suggestions to search for a possible way to replicate this or figure out the cause?

JamesHoux
  • 2,999
  • 3
  • 32
  • 50

1 Answers1

1

IMO: That kind of bugs only can be catch debugging. Exists a tool called mtop that allows you see at all DB actions...

enter image description here

UPDATE

More easy is to log all queries in a period of time (until you see the malfunction) Here a related issue: Log all queries in mysql. Then you only need to look closer at update actions in the appropriate table. This can be done in windows or *nix. Good luck...

Community
  • 1
  • 1
Igor Parra
  • 10,214
  • 10
  • 69
  • 101
  • You are awesome, Nomik! Thank you! The query logging suggestion is going to work perfectly, because the bug happens so rarely. But I didn't know about mtop so that's extremely helpful! Installing it now. :) – JamesHoux Jan 01 '13 at 05:28