Bug #11595 Updated: Error in the migration PHP3 to PHP4 with OpenLink-ODBC drive

ID: 11595 Updated by: ahill Reported By: nicolasperalta@bigfoot.com Status: Assigned Bug Type: ODBC related Operating System: Solaris 2.7 PHP Version: 4.0.4pl1 Assigned To: ahill New Comment: Hi, Please try with 4.0.6 or submit an ODBC trace; I am unable to reproduce. Best regards, Andrew Previous Comments: ------------------------------------------------------------------------ [2001-07-09 16:08:07] ahill@php.net Nico, Can you please generate a trace? I expect we will see a problem in the SQLPrepare where it's dropping your subquery. To enable tracing, add or uncomment the following line in the $ODBCINI file: DebugFile=/tmp/opl_debug.out and then please paste the resultant trace in. Best regards, Andrew Hill OpenLink Software ------------------------------------------------------------------------ [2001-06-26 17:59:09] kalowsky@php.net assigning to ahill as he knows openlink best :) ------------------------------------------------------------------------ [2001-06-21 11:13:00] nicolasperalta@bigfoot.com Sorry, message error: Warning: SQL error: [OpenLink][ODBC][Driver]General error, SQL state S1000 in SQLPrepare in /psitio/multihomed/www.elsitio.com/pub/cgi-bin/gl/av/player/test.php3 on line 19 The most strange is that I reduce the query string "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = 'C' AND P.ID_PADRE IN ( SELECT ID_HIJO FROM REAL_CAT_HIJO )" to "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = 'C'" it works fine IN PHP4... I don't know is very strange. Nico. ------------------------------------------------------------------------ [2001-06-21 11:10:52] kalowsky@php.net marking as feedback until user responds... ------------------------------------------------------------------------ [2001-06-21 09:50:44] ahill@php.net Nico, What error to you show? Best regards, Andrew Hill OpenLink Software ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/?id=11595 Edit this bug report at http://bugs.php.net/?id=11595&edit=1