Updated adodb syysext to upstream version 5.0.8a.
[Packages/TYPO3.CMS.git] / typo3 / sysext / adodb / adodb / adodb-error.inc.php
1 <?php
2 /**
3 * @version V5.06 16 Oct 2008 (c) 2000-2009 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 }
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)$/i' => DB_ERROR_NOSUCHTABLE,
96 '/Relation [\"\'].*[\"\'] already exists|Cannot insert a duplicate key into (a )?unique index.*/i' => DB_ERROR_ALREADY_EXISTS,
97 '/divide by zero$/i' => DB_ERROR_DIVZERO,
98 '/pg_atoi: error in .*: can\'t parse /i' => DB_ERROR_INVALID_NUMBER,
99 '/ttribute [\"\'].*[\"\'] not found|Relation [\"\'].*[\"\'] does not have attribute [\"\'].*[\"\']/i' => DB_ERROR_NOSUCHFIELD,
100 '/parser: parse error at or near \"/i' => DB_ERROR_SYNTAX,
101 '/referential integrity violation/i' => DB_ERROR_CONSTRAINT,
102 '/Relation [\"\'].*[\"\'] already exists|Cannot insert a duplicate key into (a )?unique index.*|duplicate key violates unique constraint/i'
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 ?>