| 36 |
kaklik |
1 |
<?php
|
|
|
2 |
/**
|
|
|
3 |
* @version V4.80 8 Mar 2006 (c) 2000-2006 John Lim (jlim@natsoft.com.my). 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 |
}
|
|
|
45 |
|
|
|
46 |
function adodb_errormsg($value)
|
|
|
47 |
{
|
|
|
48 |
global $ADODB_LANG,$ADODB_LANG_ARRAY;
|
|
|
49 |
|
|
|
50 |
if (empty($ADODB_LANG)) $ADODB_LANG = 'en';
|
|
|
51 |
if (isset($ADODB_LANG_ARRAY['LANG']) && $ADODB_LANG_ARRAY['LANG'] == $ADODB_LANG) ;
|
|
|
52 |
else {
|
|
|
53 |
include_once(ADODB_DIR."/lang/adodb-$ADODB_LANG.inc.php");
|
|
|
54 |
}
|
|
|
55 |
return isset($ADODB_LANG_ARRAY[$value]) ? $ADODB_LANG_ARRAY[$value] : $ADODB_LANG_ARRAY[DB_ERROR];
|
|
|
56 |
}
|
|
|
57 |
|
|
|
58 |
function adodb_error($provider,$dbType,$errno)
|
|
|
59 |
{
|
|
|
60 |
//var_dump($errno);
|
|
|
61 |
if (is_numeric($errno) && $errno == 0) return 0;
|
|
|
62 |
switch($provider) {
|
|
|
63 |
case 'mysql': $map = adodb_error_mysql(); break;
|
|
|
64 |
|
|
|
65 |
case 'oracle':
|
|
|
66 |
case 'oci8': $map = adodb_error_oci8(); break;
|
|
|
67 |
|
|
|
68 |
case 'ibase': $map = adodb_error_ibase(); break;
|
|
|
69 |
|
|
|
70 |
case 'odbc': $map = adodb_error_odbc(); break;
|
|
|
71 |
|
|
|
72 |
case 'mssql':
|
|
|
73 |
case 'sybase': $map = adodb_error_mssql(); break;
|
|
|
74 |
|
|
|
75 |
case 'informix': $map = adodb_error_ifx(); break;
|
|
|
76 |
|
|
|
77 |
case 'postgres': return adodb_error_pg($errno); break;
|
|
|
78 |
|
|
|
79 |
case 'sqlite': return $map = adodb_error_sqlite(); break;
|
|
|
80 |
default:
|
|
|
81 |
return DB_ERROR;
|
|
|
82 |
}
|
|
|
83 |
//print_r($map);
|
|
|
84 |
//var_dump($errno);
|
|
|
85 |
if (isset($map[$errno])) return $map[$errno];
|
|
|
86 |
return DB_ERROR;
|
|
|
87 |
}
|
|
|
88 |
|
|
|
89 |
//**************************************************************************************
|
|
|
90 |
|
|
|
91 |
function adodb_error_pg($errormsg)
|
|
|
92 |
{
|
|
|
93 |
if (is_numeric($errormsg)) return (integer) $errormsg;
|
|
|
94 |
static $error_regexps = array(
|
|
|
95 |
'/(Table does not exist\.|Relation [\"\'].*[\"\'] does not exist|sequence does not exist|class ".+" not found)$/' => DB_ERROR_NOSUCHTABLE,
|
|
|
96 |
'/Relation [\"\'].*[\"\'] already exists|Cannot insert a duplicate key into (a )?unique index.*/' => DB_ERROR_ALREADY_EXISTS,
|
|
|
97 |
'/divide by zero$/' => DB_ERROR_DIVZERO,
|
|
|
98 |
'/pg_atoi: error in .*: can\'t parse /' => DB_ERROR_INVALID_NUMBER,
|
|
|
99 |
'/ttribute [\"\'].*[\"\'] not found|Relation [\"\'].*[\"\'] does not have attribute [\"\'].*[\"\']/' => DB_ERROR_NOSUCHFIELD,
|
|
|
100 |
'/parser: parse error at or near \"/' => DB_ERROR_SYNTAX,
|
|
|
101 |
'/referential integrity violation/' => DB_ERROR_CONSTRAINT,
|
|
|
102 |
'/Relation [\"\'].*[\"\'] already exists|Cannot insert a duplicate key into (a )?unique index.*|duplicate key violates unique constraint/'
|
|
|
103 |
=> DB_ERROR_ALREADY_EXISTS
|
|
|
104 |
);
|
|
|
105 |
reset($error_regexps);
|
|
|
106 |
while (list($regexp,$code) = each($error_regexps)) {
|
|
|
107 |
if (preg_match($regexp, $errormsg)) {
|
|
|
108 |
return $code;
|
|
|
109 |
}
|
|
|
110 |
}
|
|
|
111 |
// Fall back to DB_ERROR if there was no mapping.
|
|
|
112 |
return DB_ERROR;
|
|
|
113 |
}
|
|
|
114 |
|
|
|
115 |
function adodb_error_odbc()
|
|
|
116 |
{
|
|
|
117 |
static $MAP = array(
|
|
|
118 |
'01004' => DB_ERROR_TRUNCATED,
|
|
|
119 |
'07001' => DB_ERROR_MISMATCH,
|
|
|
120 |
'21S01' => DB_ERROR_MISMATCH,
|
|
|
121 |
'21S02' => DB_ERROR_MISMATCH,
|
|
|
122 |
'22003' => DB_ERROR_INVALID_NUMBER,
|
|
|
123 |
'22008' => DB_ERROR_INVALID_DATE,
|
|
|
124 |
'22012' => DB_ERROR_DIVZERO,
|
|
|
125 |
'23000' => DB_ERROR_CONSTRAINT,
|
|
|
126 |
'24000' => DB_ERROR_INVALID,
|
|
|
127 |
'34000' => DB_ERROR_INVALID,
|
|
|
128 |
'37000' => DB_ERROR_SYNTAX,
|
|
|
129 |
'42000' => DB_ERROR_SYNTAX,
|
|
|
130 |
'IM001' => DB_ERROR_UNSUPPORTED,
|
|
|
131 |
'S0000' => DB_ERROR_NOSUCHTABLE,
|
|
|
132 |
'S0001' => DB_ERROR_NOT_FOUND,
|
|
|
133 |
'S0002' => DB_ERROR_NOSUCHTABLE,
|
|
|
134 |
'S0011' => DB_ERROR_ALREADY_EXISTS,
|
|
|
135 |
'S0012' => DB_ERROR_NOT_FOUND,
|
|
|
136 |
'S0021' => DB_ERROR_ALREADY_EXISTS,
|
|
|
137 |
'S0022' => DB_ERROR_NOT_FOUND,
|
|
|
138 |
'S1000' => DB_ERROR_NOSUCHTABLE,
|
|
|
139 |
'S1009' => DB_ERROR_INVALID,
|
|
|
140 |
'S1090' => DB_ERROR_INVALID,
|
|
|
141 |
'S1C00' => DB_ERROR_NOT_CAPABLE
|
|
|
142 |
);
|
|
|
143 |
return $MAP;
|
|
|
144 |
}
|
|
|
145 |
|
|
|
146 |
function adodb_error_ibase()
|
|
|
147 |
{
|
|
|
148 |
static $MAP = array(
|
|
|
149 |
-104 => DB_ERROR_SYNTAX,
|
|
|
150 |
-150 => DB_ERROR_ACCESS_VIOLATION,
|
|
|
151 |
-151 => DB_ERROR_ACCESS_VIOLATION,
|
|
|
152 |
-155 => DB_ERROR_NOSUCHTABLE,
|
|
|
153 |
-157 => DB_ERROR_NOSUCHFIELD,
|
|
|
154 |
-158 => DB_ERROR_VALUE_COUNT_ON_ROW,
|
|
|
155 |
-170 => DB_ERROR_MISMATCH,
|
|
|
156 |
-171 => DB_ERROR_MISMATCH,
|
|
|
157 |
-172 => DB_ERROR_INVALID,
|
|
|
158 |
-204 => DB_ERROR_INVALID,
|
|
|
159 |
-205 => DB_ERROR_NOSUCHFIELD,
|
|
|
160 |
-206 => DB_ERROR_NOSUCHFIELD,
|
|
|
161 |
-208 => DB_ERROR_INVALID,
|
|
|
162 |
-219 => DB_ERROR_NOSUCHTABLE,
|
|
|
163 |
-297 => DB_ERROR_CONSTRAINT,
|
|
|
164 |
-530 => DB_ERROR_CONSTRAINT,
|
|
|
165 |
-803 => DB_ERROR_CONSTRAINT,
|
|
|
166 |
-551 => DB_ERROR_ACCESS_VIOLATION,
|
|
|
167 |
-552 => DB_ERROR_ACCESS_VIOLATION,
|
|
|
168 |
-922 => DB_ERROR_NOSUCHDB,
|
|
|
169 |
-923 => DB_ERROR_CONNECT_FAILED,
|
|
|
170 |
-924 => DB_ERROR_CONNECT_FAILED
|
|
|
171 |
);
|
|
|
172 |
|
|
|
173 |
return $MAP;
|
|
|
174 |
}
|
|
|
175 |
|
|
|
176 |
function adodb_error_ifx()
|
|
|
177 |
{
|
|
|
178 |
static $MAP = array(
|
|
|
179 |
'-201' => DB_ERROR_SYNTAX,
|
|
|
180 |
'-206' => DB_ERROR_NOSUCHTABLE,
|
|
|
181 |
'-217' => DB_ERROR_NOSUCHFIELD,
|
|
|
182 |
'-329' => DB_ERROR_NODBSELECTED,
|
|
|
183 |
'-1204' => DB_ERROR_INVALID_DATE,
|
|
|
184 |
'-1205' => DB_ERROR_INVALID_DATE,
|
|
|
185 |
'-1206' => DB_ERROR_INVALID_DATE,
|
|
|
186 |
'-1209' => DB_ERROR_INVALID_DATE,
|
|
|
187 |
'-1210' => DB_ERROR_INVALID_DATE,
|
|
|
188 |
'-1212' => DB_ERROR_INVALID_DATE
|
|
|
189 |
);
|
|
|
190 |
|
|
|
191 |
return $MAP;
|
|
|
192 |
}
|
|
|
193 |
|
|
|
194 |
function adodb_error_oci8()
|
|
|
195 |
{
|
|
|
196 |
static $MAP = array(
|
|
|
197 |
1 => DB_ERROR_ALREADY_EXISTS,
|
|
|
198 |
900 => DB_ERROR_SYNTAX,
|
|
|
199 |
904 => DB_ERROR_NOSUCHFIELD,
|
|
|
200 |
923 => DB_ERROR_SYNTAX,
|
|
|
201 |
942 => DB_ERROR_NOSUCHTABLE,
|
|
|
202 |
955 => DB_ERROR_ALREADY_EXISTS,
|
|
|
203 |
1476 => DB_ERROR_DIVZERO,
|
|
|
204 |
1722 => DB_ERROR_INVALID_NUMBER,
|
|
|
205 |
2289 => DB_ERROR_NOSUCHTABLE,
|
|
|
206 |
2291 => DB_ERROR_CONSTRAINT,
|
|
|
207 |
2449 => DB_ERROR_CONSTRAINT
|
|
|
208 |
);
|
|
|
209 |
|
|
|
210 |
return $MAP;
|
|
|
211 |
}
|
|
|
212 |
|
|
|
213 |
function adodb_error_mssql()
|
|
|
214 |
{
|
|
|
215 |
static $MAP = array(
|
|
|
216 |
208 => DB_ERROR_NOSUCHTABLE,
|
|
|
217 |
2601 => DB_ERROR_ALREADY_EXISTS
|
|
|
218 |
);
|
|
|
219 |
|
|
|
220 |
return $MAP;
|
|
|
221 |
}
|
|
|
222 |
|
|
|
223 |
function adodb_error_sqlite()
|
|
|
224 |
{
|
|
|
225 |
static $MAP = array(
|
|
|
226 |
1 => DB_ERROR_SYNTAX
|
|
|
227 |
);
|
|
|
228 |
|
|
|
229 |
return $MAP;
|
|
|
230 |
}
|
|
|
231 |
|
|
|
232 |
function adodb_error_mysql()
|
|
|
233 |
{
|
|
|
234 |
static $MAP = array(
|
|
|
235 |
1004 => DB_ERROR_CANNOT_CREATE,
|
|
|
236 |
1005 => DB_ERROR_CANNOT_CREATE,
|
|
|
237 |
1006 => DB_ERROR_CANNOT_CREATE,
|
|
|
238 |
1007 => DB_ERROR_ALREADY_EXISTS,
|
|
|
239 |
1008 => DB_ERROR_CANNOT_DROP,
|
|
|
240 |
1045 => DB_ERROR_ACCESS_VIOLATION,
|
|
|
241 |
1046 => DB_ERROR_NODBSELECTED,
|
|
|
242 |
1049 => DB_ERROR_NOSUCHDB,
|
|
|
243 |
1050 => DB_ERROR_ALREADY_EXISTS,
|
|
|
244 |
1051 => DB_ERROR_NOSUCHTABLE,
|
|
|
245 |
1054 => DB_ERROR_NOSUCHFIELD,
|
|
|
246 |
1062 => DB_ERROR_ALREADY_EXISTS,
|
|
|
247 |
1064 => DB_ERROR_SYNTAX,
|
|
|
248 |
1100 => DB_ERROR_NOT_LOCKED,
|
|
|
249 |
1136 => DB_ERROR_VALUE_COUNT_ON_ROW,
|
|
|
250 |
1146 => DB_ERROR_NOSUCHTABLE,
|
|
|
251 |
1048 => DB_ERROR_CONSTRAINT,
|
|
|
252 |
2002 => DB_ERROR_CONNECT_FAILED,
|
|
|
253 |
2005 => DB_ERROR_CONNECT_FAILED
|
|
|
254 |
);
|
|
|
255 |
|
|
|
256 |
return $MAP;
|
|
|
257 |
}
|
|
|
258 |
?>
|