source: sandbox/2.5.1-evolucao/phpgwapi/inc/adodb/adodb-error.inc.php @ 8222

Revision 8222, 8.8 KB checked in by angelo, 11 years ago (diff)

Ticket #3491 - Compatibilizar Expresso com novas versoes do PHP
  • Property svn:eol-style set to native
  • Property svn:executable set to *
Line 
1<?php
2/**
3 * @version V5.18 3 Sep 2012  (c) 2000-2012 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
15if (!defined("DB_ERROR")) define("DB_ERROR",-1);
16
17if (!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
49function adodb_errormsg($value)
50{
51global $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
61function 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
94function 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)$/i' => DB_ERROR_NOSUCHTABLE,
100            '/Relation [\"\'].*[\"\'] already exists|Cannot insert a duplicate key into (a )?unique index.*|duplicate key.*violates unique constraint/i'     => DB_ERROR_ALREADY_EXISTS,
101            '/database ".+" does not exist$/i'       => DB_ERROR_NOSUCHDB,
102            '/(divide|division) by zero$/i'          => DB_ERROR_DIVZERO,
103            '/pg_atoi: error in .*: can\'t parse /i' => DB_ERROR_INVALID_NUMBER,
104            '/ttribute [\"\'].*[\"\'] not found|Relation [\"\'].*[\"\'] does not have attribute [\"\'].*[\"\']/i' => DB_ERROR_NOSUCHFIELD,
105            '/(parser: parse|syntax) error at or near \"/i'   => DB_ERROR_SYNTAX,
106            '/referential integrity violation/i'     => DB_ERROR_CONSTRAINT,
107            '/deadlock detected$/i'                  => DB_ERROR_DEADLOCK,
108            '/canceling statement due to statement timeout$/i' => DB_ERROR_STATEMENT_TIMEOUT,
109            '/could not serialize access due to/i'   => DB_ERROR_SERIALIZATION_FAILURE
110        );
111        reset($error_regexps);
112    while (list($regexp,$code) = each($error_regexps)) {
113        if (preg_match($regexp, $errormsg)) {
114            return $code;
115        }
116    }
117    // Fall back to DB_ERROR if there was no mapping.
118    return DB_ERROR;
119}
120       
121function adodb_error_odbc()
122{
123static $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
152function adodb_error_ibase()
153{
154static $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
182function adodb_error_ifx()
183{
184static $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
200function adodb_error_oci8()
201{
202static $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
219function adodb_error_mssql()
220{
221static $MAP = array(
222                  208 => DB_ERROR_NOSUCHTABLE,
223          2601 => DB_ERROR_ALREADY_EXISTS
224       );
225           
226        return $MAP;
227}
228
229function adodb_error_sqlite()
230{
231static $MAP = array(
232                  1 => DB_ERROR_SYNTAX
233       );
234           
235        return $MAP;
236}
237
238function adodb_error_mysql()
239{
240static $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}
264?>
Note: See TracBrowser for help on using the repository browser.