RE: [PHP-DEV] ODBC error in 4.0.0 not in RC2 From: Gustafson, Mårten (marten <email protected>)
Date: 05/20/00

It´s the same thing if a user has insufficient privligies on a table.

--Marten

> -----Original Message-----
> From: "Gustafson, Mårten" [mailto:marten <email protected>]
> Sent: Saturday, May 20, 2000 8:26 PM
> To: 'php-dev <email protected>'
> 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
> 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>