[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * @version V5.19  23-Apr-2014  (c) 2000-2014 John Lim (jlim#natsoft.com). All rights reserved.
   4   * Released under both BSD license and Lesser GPL library license.
   5   * Whenever there is any discrepancy between the two licenses,
   6   * the BSD license will take precedence.
   7   *
   8   * Set tabs to 4 for best viewing.
   9   *
  10   * The following code is adapted from the PEAR DB error handling code.
  11   * Portions (c)1997-2002 The PHP Group.
  12   */
  13  
  14  
  15  if (!defined("DB_ERROR")) define("DB_ERROR",-1);
  16  
  17  if (!defined("DB_ERROR_SYNTAX")) {
  18      define("DB_ERROR_SYNTAX",              -2);
  19      define("DB_ERROR_CONSTRAINT",          -3);
  20      define("DB_ERROR_NOT_FOUND",           -4);
  21      define("DB_ERROR_ALREADY_EXISTS",      -5);
  22      define("DB_ERROR_UNSUPPORTED",         -6);
  23      define("DB_ERROR_MISMATCH",            -7);
  24      define("DB_ERROR_INVALID",             -8);
  25      define("DB_ERROR_NOT_CAPABLE",         -9);
  26      define("DB_ERROR_TRUNCATED",          -10);
  27      define("DB_ERROR_INVALID_NUMBER",     -11);
  28      define("DB_ERROR_INVALID_DATE",       -12);
  29      define("DB_ERROR_DIVZERO",            -13);
  30      define("DB_ERROR_NODBSELECTED",       -14);
  31      define("DB_ERROR_CANNOT_CREATE",      -15);
  32      define("DB_ERROR_CANNOT_DELETE",      -16);
  33      define("DB_ERROR_CANNOT_DROP",        -17);
  34      define("DB_ERROR_NOSUCHTABLE",        -18);
  35      define("DB_ERROR_NOSUCHFIELD",        -19);
  36      define("DB_ERROR_NEED_MORE_DATA",     -20);
  37      define("DB_ERROR_NOT_LOCKED",         -21);
  38      define("DB_ERROR_VALUE_COUNT_ON_ROW", -22);
  39      define("DB_ERROR_INVALID_DSN",        -23);
  40      define("DB_ERROR_CONNECT_FAILED",     -24);
  41      define("DB_ERROR_EXTENSION_NOT_FOUND",-25);
  42      define("DB_ERROR_NOSUCHDB",           -25);
  43      define("DB_ERROR_ACCESS_VIOLATION",   -26);
  44      define("DB_ERROR_DEADLOCK",           -27);
  45      define("DB_ERROR_STATEMENT_TIMEOUT",  -28);
  46      define("DB_ERROR_SERIALIZATION_FAILURE", -29);
  47  }
  48  
  49  function adodb_errormsg($value)
  50  {
  51  global $ADODB_LANG,$ADODB_LANG_ARRAY;
  52  
  53      if (empty($ADODB_LANG)) $ADODB_LANG = 'en';
  54      if (isset($ADODB_LANG_ARRAY['LANG']) && $ADODB_LANG_ARRAY['LANG'] == $ADODB_LANG) ;
  55      else {
  56          include_once(ADODB_DIR."/lang/adodb-$ADODB_LANG.inc.php");
  57      }
  58      return isset($ADODB_LANG_ARRAY[$value]) ? $ADODB_LANG_ARRAY[$value] : $ADODB_LANG_ARRAY[DB_ERROR];
  59  }
  60  
  61  function adodb_error($provider,$dbType,$errno)
  62  {
  63      //var_dump($errno);
  64      if (is_numeric($errno) && $errno == 0) return 0;
  65      switch($provider) {
  66      case 'mysql': $map = adodb_error_mysql(); break;
  67  
  68      case 'oracle':
  69      case 'oci8': $map = adodb_error_oci8(); break;
  70  
  71      case 'ibase': $map = adodb_error_ibase(); break;
  72  
  73      case 'odbc': $map = adodb_error_odbc(); break;
  74  
  75      case 'mssql':
  76      case 'sybase': $map = adodb_error_mssql(); break;
  77  
  78      case 'informix': $map = adodb_error_ifx(); break;
  79  
  80      case 'postgres': return adodb_error_pg($errno); break;
  81  
  82      case 'sqlite': return $map = adodb_error_sqlite(); break;
  83      default:
  84          return DB_ERROR;
  85      }
  86      //print_r($map);
  87      //var_dump($errno);
  88      if (isset($map[$errno])) return $map[$errno];
  89      return DB_ERROR;
  90  }
  91  
  92  //**************************************************************************************
  93  
  94  function adodb_error_pg($errormsg)
  95  {
  96      if (is_numeric($errormsg)) return (integer) $errormsg;
  97      // Postgres has no lock-wait timeout.  The best we could do would be to set a statement timeout.
  98      static $error_regexps = array(
  99              '(Table does not exist\.|Relation [\"\'].*[\"\'] does not exist|sequence does not exist|class ".+" not found)$' => DB_ERROR_NOSUCHTABLE,
 100              'Relation [\"\'].*[\"\'] already exists|Cannot insert a duplicate key into (a )?unique index.*|duplicate key.*violates unique constraint'     => DB_ERROR_ALREADY_EXISTS,
 101              'database ".+" does not exist$'       => DB_ERROR_NOSUCHDB,
 102              '(divide|division) by zero$'          => DB_ERROR_DIVZERO,
 103              'pg_atoi: error in .*: can\'t parse ' => DB_ERROR_INVALID_NUMBER,
 104              'ttribute [\"\'].*[\"\'] not found|Relation [\"\'].*[\"\'] does not have attribute [\"\'].*[\"\']' => DB_ERROR_NOSUCHFIELD,
 105              '(parser: parse|syntax) error at or near \"'   => DB_ERROR_SYNTAX,
 106              'referential integrity violation'     => DB_ERROR_CONSTRAINT,
 107              'deadlock detected$'                  => DB_ERROR_DEADLOCK,
 108              'canceling statement due to statement timeout$' => DB_ERROR_STATEMENT_TIMEOUT,
 109              'could not serialize access due to'   => DB_ERROR_SERIALIZATION_FAILURE
 110          );
 111      reset($error_regexps);
 112      while (list($regexp,$code) = each($error_regexps)) {
 113          if (preg_match("/$regexp/mi", $errormsg)) {
 114              return $code;
 115          }
 116      }
 117      // Fall back to DB_ERROR if there was no mapping.
 118      return DB_ERROR;
 119  }
 120  
 121  function adodb_error_odbc()
 122  {
 123  static $MAP = array(
 124              '01004' => DB_ERROR_TRUNCATED,
 125              '07001' => DB_ERROR_MISMATCH,
 126              '21S01' => DB_ERROR_MISMATCH,
 127              '21S02' => DB_ERROR_MISMATCH,
 128              '22003' => DB_ERROR_INVALID_NUMBER,
 129              '22008' => DB_ERROR_INVALID_DATE,
 130              '22012' => DB_ERROR_DIVZERO,
 131              '23000' => DB_ERROR_CONSTRAINT,
 132              '24000' => DB_ERROR_INVALID,
 133              '34000' => DB_ERROR_INVALID,
 134              '37000' => DB_ERROR_SYNTAX,
 135              '42000' => DB_ERROR_SYNTAX,
 136              'IM001' => DB_ERROR_UNSUPPORTED,
 137              'S0000' => DB_ERROR_NOSUCHTABLE,
 138              'S0001' => DB_ERROR_NOT_FOUND,
 139              'S0002' => DB_ERROR_NOSUCHTABLE,
 140              'S0011' => DB_ERROR_ALREADY_EXISTS,
 141              'S0012' => DB_ERROR_NOT_FOUND,
 142              'S0021' => DB_ERROR_ALREADY_EXISTS,
 143              'S0022' => DB_ERROR_NOT_FOUND,
 144              'S1000' => DB_ERROR_NOSUCHTABLE,
 145              'S1009' => DB_ERROR_INVALID,
 146              'S1090' => DB_ERROR_INVALID,
 147              'S1C00' => DB_ERROR_NOT_CAPABLE
 148          );
 149          return $MAP;
 150  }
 151  
 152  function adodb_error_ibase()
 153  {
 154  static $MAP = array(
 155              -104 => DB_ERROR_SYNTAX,
 156              -150 => DB_ERROR_ACCESS_VIOLATION,
 157              -151 => DB_ERROR_ACCESS_VIOLATION,
 158              -155 => DB_ERROR_NOSUCHTABLE,
 159              -157 => DB_ERROR_NOSUCHFIELD,
 160              -158 => DB_ERROR_VALUE_COUNT_ON_ROW,
 161              -170 => DB_ERROR_MISMATCH,
 162              -171 => DB_ERROR_MISMATCH,
 163              -172 => DB_ERROR_INVALID,
 164              -204 => DB_ERROR_INVALID,
 165              -205 => DB_ERROR_NOSUCHFIELD,
 166              -206 => DB_ERROR_NOSUCHFIELD,
 167              -208 => DB_ERROR_INVALID,
 168              -219 => DB_ERROR_NOSUCHTABLE,
 169              -297 => DB_ERROR_CONSTRAINT,
 170              -530 => DB_ERROR_CONSTRAINT,
 171              -803 => DB_ERROR_CONSTRAINT,
 172              -551 => DB_ERROR_ACCESS_VIOLATION,
 173              -552 => DB_ERROR_ACCESS_VIOLATION,
 174              -922 => DB_ERROR_NOSUCHDB,
 175              -923 => DB_ERROR_CONNECT_FAILED,
 176              -924 => DB_ERROR_CONNECT_FAILED
 177          );
 178  
 179          return $MAP;
 180  }
 181  
 182  function adodb_error_ifx()
 183  {
 184  static $MAP = array(
 185              '-201'    => DB_ERROR_SYNTAX,
 186              '-206'    => DB_ERROR_NOSUCHTABLE,
 187              '-217'    => DB_ERROR_NOSUCHFIELD,
 188              '-329'    => DB_ERROR_NODBSELECTED,
 189              '-1204'   => DB_ERROR_INVALID_DATE,
 190              '-1205'   => DB_ERROR_INVALID_DATE,
 191              '-1206'   => DB_ERROR_INVALID_DATE,
 192              '-1209'   => DB_ERROR_INVALID_DATE,
 193              '-1210'   => DB_ERROR_INVALID_DATE,
 194              '-1212'   => DB_ERROR_INVALID_DATE
 195         );
 196  
 197         return $MAP;
 198  }
 199  
 200  function adodb_error_oci8()
 201  {
 202  static $MAP = array(
 203               1 => DB_ERROR_ALREADY_EXISTS,
 204              900 => DB_ERROR_SYNTAX,
 205              904 => DB_ERROR_NOSUCHFIELD,
 206              923 => DB_ERROR_SYNTAX,
 207              942 => DB_ERROR_NOSUCHTABLE,
 208              955 => DB_ERROR_ALREADY_EXISTS,
 209              1476 => DB_ERROR_DIVZERO,
 210              1722 => DB_ERROR_INVALID_NUMBER,
 211              2289 => DB_ERROR_NOSUCHTABLE,
 212              2291 => DB_ERROR_CONSTRAINT,
 213              2449 => DB_ERROR_CONSTRAINT
 214          );
 215  
 216      return $MAP;
 217  }
 218  
 219  function adodb_error_mssql()
 220  {
 221  static $MAP = array(
 222            208 => DB_ERROR_NOSUCHTABLE,
 223            2601 => DB_ERROR_ALREADY_EXISTS
 224         );
 225  
 226      return $MAP;
 227  }
 228  
 229  function adodb_error_sqlite()
 230  {
 231  static $MAP = array(
 232            1 => DB_ERROR_SYNTAX
 233         );
 234  
 235      return $MAP;
 236  }
 237  
 238  function adodb_error_mysql()
 239  {
 240  static $MAP = array(
 241             1004 => DB_ERROR_CANNOT_CREATE,
 242             1005 => DB_ERROR_CANNOT_CREATE,
 243             1006 => DB_ERROR_CANNOT_CREATE,
 244             1007 => DB_ERROR_ALREADY_EXISTS,
 245             1008 => DB_ERROR_CANNOT_DROP,
 246             1045 => DB_ERROR_ACCESS_VIOLATION,
 247             1046 => DB_ERROR_NODBSELECTED,
 248             1049 => DB_ERROR_NOSUCHDB,
 249             1050 => DB_ERROR_ALREADY_EXISTS,
 250             1051 => DB_ERROR_NOSUCHTABLE,
 251             1054 => DB_ERROR_NOSUCHFIELD,
 252             1062 => DB_ERROR_ALREADY_EXISTS,
 253             1064 => DB_ERROR_SYNTAX,
 254             1100 => DB_ERROR_NOT_LOCKED,
 255             1136 => DB_ERROR_VALUE_COUNT_ON_ROW,
 256             1146 => DB_ERROR_NOSUCHTABLE,
 257             1048 => DB_ERROR_CONSTRAINT,
 258              2002 => DB_ERROR_CONNECT_FAILED,
 259              2005 => DB_ERROR_CONNECT_FAILED
 260         );
 261  
 262      return $MAP;
 263  }