AutorÃa | Ultima modificación | Ver Log |
<?php/*** Error handling code and constants.** Adapted from the PEAR DB error handling code.* Portions (c)1997-2002 The PHP Group** This file is part of ADOdb, a Database Abstraction Layer library for PHP.** @package ADOdb* @link https://adodb.org Project's web site and documentation* @link https://github.com/ADOdb/ADOdb Source code and issue tracker** The ADOdb Library is dual-licensed, released under both the BSD 3-Clause* and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,* any later version. This means you can use it in proprietary products.* See the LICENSE.md file distributed with this source code for details.* @license BSD-3-Clause* @license LGPL-2.1-or-later** @copyright 2000-2013 John Lim* @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community*/if (!defined("DB_ERROR")) define("DB_ERROR",-1);if (!defined("DB_ERROR_SYNTAX")) {define("DB_ERROR_SYNTAX", -2);define("DB_ERROR_CONSTRAINT", -3);define("DB_ERROR_NOT_FOUND", -4);define("DB_ERROR_ALREADY_EXISTS", -5);define("DB_ERROR_UNSUPPORTED", -6);define("DB_ERROR_MISMATCH", -7);define("DB_ERROR_INVALID", -8);define("DB_ERROR_NOT_CAPABLE", -9);define("DB_ERROR_TRUNCATED", -10);define("DB_ERROR_INVALID_NUMBER", -11);define("DB_ERROR_INVALID_DATE", -12);define("DB_ERROR_DIVZERO", -13);define("DB_ERROR_NODBSELECTED", -14);define("DB_ERROR_CANNOT_CREATE", -15);define("DB_ERROR_CANNOT_DELETE", -16);define("DB_ERROR_CANNOT_DROP", -17);define("DB_ERROR_NOSUCHTABLE", -18);define("DB_ERROR_NOSUCHFIELD", -19);define("DB_ERROR_NEED_MORE_DATA", -20);define("DB_ERROR_NOT_LOCKED", -21);define("DB_ERROR_VALUE_COUNT_ON_ROW", -22);define("DB_ERROR_INVALID_DSN", -23);define("DB_ERROR_CONNECT_FAILED", -24);define("DB_ERROR_EXTENSION_NOT_FOUND",-25);define("DB_ERROR_NOSUCHDB", -25);define("DB_ERROR_ACCESS_VIOLATION", -26);define("DB_ERROR_DEADLOCK", -27);define("DB_ERROR_STATEMENT_TIMEOUT", -28);define("DB_ERROR_SERIALIZATION_FAILURE", -29);}function adodb_errormsg($value){global $ADODB_LANG,$ADODB_LANG_ARRAY;if (empty($ADODB_LANG)) $ADODB_LANG = 'en';if (isset($ADODB_LANG_ARRAY['LANG']) && $ADODB_LANG_ARRAY['LANG'] == $ADODB_LANG) ;else {include_once(ADODB_DIR."/lang/adodb-$ADODB_LANG.inc.php");}return isset($ADODB_LANG_ARRAY[$value]) ? $ADODB_LANG_ARRAY[$value] : $ADODB_LANG_ARRAY[DB_ERROR];}function adodb_error($provider,$dbType,$errno){//var_dump($errno);if (is_numeric($errno) && $errno == 0) return 0;switch($provider) {case 'mysql': $map = adodb_error_mysql(); break;case 'oracle':case 'oci8': $map = adodb_error_oci8(); break;// As discussed in https://github.com/ADOdb/ADOdb/issues/201#issuecomment-188154980// firebird uses the ibase error handler for now. This may change if and// when the PHP driver is updated to use the new SQLSTATE error codescase 'firebird':case 'ibase': $map = adodb_error_ibase(); break;case 'odbc': $map = adodb_error_odbc(); break;case 'mssql':case 'sybase': $map = adodb_error_mssql(); break;case 'informix': $map = adodb_error_ifx(); break;case 'postgres': return adodb_error_pg($errno); break;case 'sqlite': return $map = adodb_error_sqlite(); break;default:return DB_ERROR;}//print_r($map);//var_dump($errno);if (isset($map[$errno])) return $map[$errno];return DB_ERROR;}//**************************************************************************************function adodb_error_pg($errormsg){if (is_numeric($errormsg)) return (integer) $errormsg;// Postgres has no lock-wait timeout. The best we could do would be to set a statement timeout.static $error_regexps = array('(Table does not exist\.|Relation [\"\'].*[\"\'] does not exist|sequence does not exist|class ".+" not found)$' => DB_ERROR_NOSUCHTABLE,'Relation [\"\'].*[\"\'] already exists|Cannot insert a duplicate key into (a )?unique index.*|duplicate key.*violates unique constraint' => DB_ERROR_ALREADY_EXISTS,'database ".+" does not exist$' => DB_ERROR_NOSUCHDB,'(divide|division) by zero$' => DB_ERROR_DIVZERO,'pg_atoi: error in .*: can\'t parse ' => DB_ERROR_INVALID_NUMBER,'ttribute [\"\'].*[\"\'] not found|Relation [\"\'].*[\"\'] does not have attribute [\"\'].*[\"\']' => DB_ERROR_NOSUCHFIELD,'(parser: parse|syntax) error at or near \"' => DB_ERROR_SYNTAX,'referential integrity violation' => DB_ERROR_CONSTRAINT,'deadlock detected$' => DB_ERROR_DEADLOCK,'canceling statement due to statement timeout$' => DB_ERROR_STATEMENT_TIMEOUT,'could not serialize access due to' => DB_ERROR_SERIALIZATION_FAILURE);reset($error_regexps);foreach ($error_regexps as $regexp => $code) {if (preg_match("/$regexp/mi", $errormsg)) {return $code;}}// Fall back to DB_ERROR if there was no mapping.return DB_ERROR;}function adodb_error_odbc(){static $MAP = array('01004' => DB_ERROR_TRUNCATED,'07001' => DB_ERROR_MISMATCH,'21S01' => DB_ERROR_MISMATCH,'21S02' => DB_ERROR_MISMATCH,'22003' => DB_ERROR_INVALID_NUMBER,'22008' => DB_ERROR_INVALID_DATE,'22012' => DB_ERROR_DIVZERO,'23000' => DB_ERROR_CONSTRAINT,'24000' => DB_ERROR_INVALID,'34000' => DB_ERROR_INVALID,'37000' => DB_ERROR_SYNTAX,'42000' => DB_ERROR_SYNTAX,'IM001' => DB_ERROR_UNSUPPORTED,'S0000' => DB_ERROR_NOSUCHTABLE,'S0001' => DB_ERROR_NOT_FOUND,'S0002' => DB_ERROR_NOSUCHTABLE,'S0011' => DB_ERROR_ALREADY_EXISTS,'S0012' => DB_ERROR_NOT_FOUND,'S0021' => DB_ERROR_ALREADY_EXISTS,'S0022' => DB_ERROR_NOT_FOUND,'S1000' => DB_ERROR_NOSUCHTABLE,'S1009' => DB_ERROR_INVALID,'S1090' => DB_ERROR_INVALID,'S1C00' => DB_ERROR_NOT_CAPABLE);return $MAP;}function adodb_error_ibase(){static $MAP = array(-104 => DB_ERROR_SYNTAX,-150 => DB_ERROR_ACCESS_VIOLATION,-151 => DB_ERROR_ACCESS_VIOLATION,-155 => DB_ERROR_NOSUCHTABLE,-157 => DB_ERROR_NOSUCHFIELD,-158 => DB_ERROR_VALUE_COUNT_ON_ROW,-170 => DB_ERROR_MISMATCH,-171 => DB_ERROR_MISMATCH,-172 => DB_ERROR_INVALID,-204 => DB_ERROR_INVALID,-205 => DB_ERROR_NOSUCHFIELD,-206 => DB_ERROR_NOSUCHFIELD,-208 => DB_ERROR_INVALID,-219 => DB_ERROR_NOSUCHTABLE,-297 => DB_ERROR_CONSTRAINT,-530 => DB_ERROR_CONSTRAINT,-803 => DB_ERROR_CONSTRAINT,-551 => DB_ERROR_ACCESS_VIOLATION,-552 => DB_ERROR_ACCESS_VIOLATION,-922 => DB_ERROR_NOSUCHDB,-923 => DB_ERROR_CONNECT_FAILED,-924 => DB_ERROR_CONNECT_FAILED);return $MAP;}function adodb_error_ifx(){static $MAP = array('-201' => DB_ERROR_SYNTAX,'-206' => DB_ERROR_NOSUCHTABLE,'-217' => DB_ERROR_NOSUCHFIELD,'-329' => DB_ERROR_NODBSELECTED,'-1204' => DB_ERROR_INVALID_DATE,'-1205' => DB_ERROR_INVALID_DATE,'-1206' => DB_ERROR_INVALID_DATE,'-1209' => DB_ERROR_INVALID_DATE,'-1210' => DB_ERROR_INVALID_DATE,'-1212' => DB_ERROR_INVALID_DATE);return $MAP;}function adodb_error_oci8(){static $MAP = array(1 => DB_ERROR_ALREADY_EXISTS,900 => DB_ERROR_SYNTAX,904 => DB_ERROR_NOSUCHFIELD,923 => DB_ERROR_SYNTAX,942 => DB_ERROR_NOSUCHTABLE,955 => DB_ERROR_ALREADY_EXISTS,1476 => DB_ERROR_DIVZERO,1722 => DB_ERROR_INVALID_NUMBER,2289 => DB_ERROR_NOSUCHTABLE,2291 => DB_ERROR_CONSTRAINT,2449 => DB_ERROR_CONSTRAINT);return $MAP;}function adodb_error_mssql(){static $MAP = array(208 => DB_ERROR_NOSUCHTABLE,2601 => DB_ERROR_ALREADY_EXISTS);return $MAP;}function adodb_error_sqlite(){static $MAP = array(1 => DB_ERROR_SYNTAX);return $MAP;}function adodb_error_mysql(){static $MAP = array(1004 => DB_ERROR_CANNOT_CREATE,1005 => DB_ERROR_CANNOT_CREATE,1006 => DB_ERROR_CANNOT_CREATE,1007 => DB_ERROR_ALREADY_EXISTS,1008 => DB_ERROR_CANNOT_DROP,1045 => DB_ERROR_ACCESS_VIOLATION,1046 => DB_ERROR_NODBSELECTED,1049 => DB_ERROR_NOSUCHDB,1050 => DB_ERROR_ALREADY_EXISTS,1051 => DB_ERROR_NOSUCHTABLE,1054 => DB_ERROR_NOSUCHFIELD,1062 => DB_ERROR_ALREADY_EXISTS,1064 => DB_ERROR_SYNTAX,1100 => DB_ERROR_NOT_LOCKED,1136 => DB_ERROR_VALUE_COUNT_ON_ROW,1146 => DB_ERROR_NOSUCHTABLE,1048 => DB_ERROR_CONSTRAINT,2002 => DB_ERROR_CONNECT_FAILED,2005 => DB_ERROR_CONNECT_FAILED);return $MAP;}