PDO error message

Question

Here is a snippet of my code    qry         INSERT INTO non-existant-table  id  score       SELECT id  40      FROM another-non-existant-table     WHERE description LIKE    search string       AND available    yes      ON DUPLICATE KEY UPDATE score   score   40     sth    this- gt pdo- gt prepare  qry    sth- gt execute  data    print r  this- gt pdo- gt errorInfo       This should give me an error because the tables don t even exist  All I get however is this      Array    0     00000     How can I get a better description of the error so I can debug the issue

User · Answer

Old thread  but maybe my answer will help someone  I resolved by executing the query first  then setting an errors variable  then checking if that errors variable array is empty  see simplified example    field1    foo    field2    bar     insert QUERY    db- gt prepare  INSERT INTO table bogus field1  field2  VALUES   field1   field2      insert QUERY- gt bindParam   field1    field1    insert QUERY- gt bindParam   field2    field2     insert QUERY- gt execute      databaseErrors    insert QUERY- gt errorInfo     if   empty  databaseErrors            errorInfo   print r  databaseErrors  true     true flag returns val rather than print      errorLogMsg    error info   errorInfo     do what you wish with this var  write to log file etc                    errorLogMsg will return something like    error info     Array     0    gt  42000    1    gt  1064    2    gt  You have an error in your SQL syntax  check the manual that corresponds to your MySQL server version for the right syntax to use near  table bogus field1  field2  VALUES                                                    bar   NULL   at line 1         else         no SQL errors

User · Answer

Maybe this post is too old but it may help as a suggestion for someone looking around on this   Instead of using    print r  this- gt pdo- gt errorInfo       Use PHP implode   function    echo  Error occurred   implode      this- gt pdo- gt errorInfo       This should print the error code  detailed error information etc  that you would usually get if you were using some SQL User interface   Hope it helps

User · Answer

Try this instead   print r  sth- gt errorInfo       Add this before your prepare    this- gt pdo- gt setAttribute  PDO  ATTR ERRMODE  PDO  ERRMODE WARNING      This will change the PDO error reporting type and cause it to emit a warning whenever there is a PDO error   It should help you track it down  although your errorInfo should have bet set

User · Answer

From the manual      If the database server successfully   prepares the statement  PDO  prepare     returns a PDOStatement object  If the   database server cannot successfully   prepare the statement  PDO  prepare     returns FALSE or emits PDOException    depending on error handling     The prepare statement likely caused an error because the db would be unable to prepare the statement   Try testing for an error immediately after you prepare your query and before you execute it    qry         INSERT INTO non-existant-table  id  score       SELECT id  40      FROM another-non-existant-table     WHERE description LIKE    search string       AND available    yes      ON DUPLICATE KEY UPDATE score   score   40     sth    this- gt pdo- gt prepare  qry   print r  this- gt pdo- gt errorInfo

[php] PDO error message?

Examples related to php

Examples related to pdo