RE: [PHP-DEV] ODBC error in 4.0.0 not in RC2 From: Andi Gutmans (andi <email protected>)
Date: 05/20/00

I don't think anything has changed in the ODBC code since RC2. Are you sure
you built exactly the same way and with the same options? Against the same
libraries...

Andi

At 09:44 PM 5/20/00 +0200, Gustafson, Mårten wrote:
>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> 

---
Andi Gutmans <andi <email protected>>
http://www.zend.com/

-- 
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>