RE: [PHP-DEV] ODBC error in 4.0.0 not in RC2
| From: | Gustafson, Mårten | Date: | Sat, 20 May 2000 19:44:39 +0000 |
| Subject: | RE: [PHP-DEV] ODBC error in 4.0.0 not in RC2 | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-19019@lists.php.net to get a copy of this message | ||
It´s the same thing if a user has insufficient privligies on a table.
--Marten
> -----Original Message-----
> From: "Gustafson, Mårten" [mailto:marten@jerbro.se]
> Sent: Saturday, May 20, 2000 8:26 PM
> To: 'php-dev@lists.php.net'
> Subject: [PHP-DEV] ODBC error in 4.0.0 not in RC2
>
>
> Hello, installed 4.0.0 eralier today without any problems. But then I
> misstyped a query to select a column that didn´t exist and when I run
> ODBCExec PHP gets into an infinite loop.
> I downgraded to RC2 and the problem disappeard.
>
> Code snippet (column a doesn´t exist in table user):
> $c = odbc_connect('dummy', 'user', 'pass');
> $query = "SELECT a FROM user WHERE username = 'marten'";
> $q = odbc_exec($c, $query);
> odbc_close($c);
>
>
> On RC2 i get:
> Warning: SQL error: [DBMaker] invalid column name : a, SQL
> state S0022 in
> SQLExecDirect in adduser.php on line 5
> Warning: SQL error: , SQL state 00000 in SQLExecDirect in
> adduser.php on
> line 5
> But on 4.0.0 i get:
> Warning: SQL error: [DBMaker] invalid column name : a, SQL
> state S0022 in
> SQLExecDirect in adduser.php on line 5
> Warning: SQL error: , SQL state 00000 in SQLExecDirect in
> adduser.php on
> line 5
> Warning: SQL error: , SQL state 00000 in SQLExecDirect in
> adduser.php on
> line 5
> Warning: SQL error: , SQL state 00000 in SQLExecDirect in
> adduser.php on
> line 5
> Warning: SQL error: , SQL state 00000 in SQLExecDirect in
> adduser.php on
> line 5
> ....ans so on untill I kill the httpd process
>
>
> I run Apache 1.3.12 and configure php like this:
> ./configure
> --disable-debug
> --without-gd
> --enable-track-vars
> --enable-calendar
> --enable-sysvsem
> --enable-sysvshm
> --enable-wddx
> --enable-ftp
> --with-dbmaker=/home/dbmaker/3.6
> --with-mhash
> --with-mcrypt
> --enable-inline-optimization
> --with-mm
> --with-apxs=/usr/local/apache/bin/apxs
>
> Regards
> --Marten
>