How to log error queries?

Discussion in 'MySQL' started by Kaizoku, Apr 17, 2010.

0
  1. #1
    I know that there is general_log logs all queries, but I want to find out which query has an error, and get the error message. I have tried running an error query on purpose, but it logs as a normal query and doesn't report it with error. Any ideas?
     
    Kaizoku, Apr 17, 2010 IP
  2. BlastFree

    BlastFree Well-Known Member

    Messages:
    65
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    108
    #2
    BlastFree, Apr 22, 2010 IP
  3. itsupportservice

    itsupportservice Peon

    Messages:
    93
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ehow.com is really so good site... In that I found so many good things.. & Quick guide of that is the great..!!
     
    itsupportservice, Apr 23, 2010 IP
  4. Kaizoku

    Kaizoku Well-Known Member

    Messages:
    1,261
    Likes Received:
    20
    Best Answers:
    1
    Trophy Points:
    105
    #4
    That requires php, I need something more generic, it writes to php log, not mysql log.
     
    Kaizoku, Apr 23, 2010 IP