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

2001-10-29 Thread ahill 

ID: 11595
Updated by: ahill
Reported By: [EMAIL PROTECTED]
Old Status: Assigned
Status: Closed
Bug Type: ODBC related
Operating System: Solaris 2.7
PHP Version: 4.0.4pl1
Assigned To: ahill
New Comment:

unable to duplicate, no feedback

Previous Comments:


[2001-07-30 12:08:34] [EMAIL PROTECTED]

Hi,

Please try with 4.0.6 or submit an ODBC trace; I am unable to reproduce.

Best regards,
Andrew




[2001-07-09 16:08:07] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

assigning to ahill as he knows openlink best :)



[2001-06-21 11:13:00] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

marking as feedback until user responds...



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


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-07-30 Thread ahill 

ID: 11595
Updated by: ahill
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

assigning to ahill as he knows openlink best :)



[2001-06-21 11:13:00] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

marking as feedback until user responds...



[2001-06-21 09:50:44] [EMAIL PROTECTED]

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


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-07-09 Thread ahill 

ID: 11595
Updated by: ahill
Reported By: [EMAIL PROTECTED]
Status: Assigned
Bug Type: ODBC related
Operating System: Solaris 2.7
PHP Version: 4.0.4pl1
Assigned To: ahill
New Comment:

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 

Previous Comments:


[2001-06-26 17:59:09] [EMAIL PROTECTED]

assigning to ahill as he knows openlink best :)



[2001-06-21 11:13:00] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

marking as feedback until user responds...



[2001-06-21 09:50:44] [EMAIL PROTECTED]

Nico,

What error to you show?

Best regards,
Andrew Hill
OpenLink Software



[2001-06-20 18:27:41] [EMAIL PROTECTED]

When I migrated from PHP3 to PHP4 this script didn't work any more.
I don't have connection problems and the error appears just in some cases. 
The following is an ad-hoc script that reproduce the odbc error. 

// PHP Version 4.0.4pl1
// OS: Solaris 2.7
// Driver: ODBC-Openlink multi-tier 3.2
// this connection works fine.

  $conn_id = 
odbc_connect("Driver=/psitio/openlink/odbcsdk/lib/oplodbc.so.1;Host=sql02.local;SVT=SQLServer
 7;UID=batalla_web;PWD=mundial86;DATABASE=elsitiodb2;FetchBufferSize=4","","");

  echo "my connection $conn_id";

  $qry = "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = '" . $idioma . "' "
. "AND P.ID_PADRE IN (SELECT H.ID_HIJO FROM REAL_CAT_HIJO H 
WHERE "
. " H.ID_PADRE = '" . $cat . "') ";

  // this query works.
  $qry = "SELECT * FROM REAL_CAT_HIJO";

  // this query doesn't work IN PHP4 but works fine in PHP3 with the same 
ODBC-OPENLINK drive(??).
  $qry = "SELECT idvalor,Valor,Tipo_rango FROM Fot_atributo_valor WHERE idcanal=41 AND 
idaplic=1 AND idatrib=2 ORDER BY idvalor";

  $res_id = odbc_prepare($conn_id,$qry);

  // the error occur in this code line (IN PHP4).
  $result = odbc_execute($res_id);


Thanks in advance.

Nico.





ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11595&edit=1


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-06-27 Thread sniper 

ID: 11595
Updated by: sniper
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Assigned
Bug Type: ODBC related
Operating system: 
PHP Version: 4.0.4pl1
Assigned To: ahill
Comments:



Previous Comments:
---

[2001-06-21 11:13:00] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
marking as feedback until user responds...

---

[2001-06-21 09:50:44] [EMAIL PROTECTED]
Nico,

What error to you show?

Best regards,
Andrew Hill
OpenLink Software

---

[2001-06-20 18:27:41] [EMAIL PROTECTED]
When I migrated from PHP3 to PHP4 this script didn't work any more.
I don't have connection problems and the error appears just in some cases. 
The following is an ad-hoc script that reproduce the odbc error. 

// PHP Version 4.0.4pl1
// OS: Solaris 2.7
// Driver: ODBC-Openlink multi-tier 3.2
// this connection works fine.

  $conn_id = 
odbc_connect("Driver=/psitio/openlink/odbcsdk/lib/oplodbc.so.1;Host=sql02.local;SVT=SQLServer
 7;UID=batalla_web;PWD=mundial86;DATABASE=elsitiodb2;FetchBufferSize=4","","");

  echo "my connection $conn_id";

  $qry = "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = '" . $idioma . "' "
. "AND P.ID_PADRE IN (SELECT H.ID_HIJO FROM REAL_CAT_HIJO H 
WHERE "
. " H.ID_PADRE = '" . $cat . "') ";

  // this query works.
  $qry = "SELECT * FROM REAL_CAT_HIJO";

  // this query doesn't work IN PHP4 but works fine in PHP3 with the same 
ODBC-OPENLINK drive(??).
  $qry = "SELECT idvalor,Valor,Tipo_rango FROM Fot_atributo_valor WHERE idcanal=41 AND 
idaplic=1 AND idatrib=2 ORDER BY idvalor";

  $res_id = odbc_prepare($conn_id,$qry);

  // the error occur in this code line (IN PHP4).
  $result = odbc_execute($res_id);


Thanks in advance.

Nico.

---



ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11595&edit=2


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-06-27 Thread kalowsky 

ID: 11595
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Operating system: 
PHP Version: 4.0.4pl1
Assigned To: ahill
Comments:

assigning to ahill as he knows openlink best :)

Previous Comments:
---

[2001-06-21 11:13:00] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
marking as feedback until user responds...

---

[2001-06-21 09:50:44] [EMAIL PROTECTED]
Nico,

What error to you show?

Best regards,
Andrew Hill
OpenLink Software

---

[2001-06-20 18:27:41] [EMAIL PROTECTED]
When I migrated from PHP3 to PHP4 this script didn't work any more.
I don't have connection problems and the error appears just in some cases. 
The following is an ad-hoc script that reproduce the odbc error. 

// PHP Version 4.0.4pl1
// OS: Solaris 2.7
// Driver: ODBC-Openlink multi-tier 3.2
// this connection works fine.

  $conn_id = 
odbc_connect("Driver=/psitio/openlink/odbcsdk/lib/oplodbc.so.1;Host=sql02.local;SVT=SQLServer
 7;UID=batalla_web;PWD=mundial86;DATABASE=elsitiodb2;FetchBufferSize=4","","");

  echo "my connection $conn_id";

  $qry = "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = '" . $idioma . "' "
. "AND P.ID_PADRE IN (SELECT H.ID_HIJO FROM REAL_CAT_HIJO H 
WHERE "
. " H.ID_PADRE = '" . $cat . "') ";

  // this query works.
  $qry = "SELECT * FROM REAL_CAT_HIJO";

  // this query doesn't work IN PHP4 but works fine in PHP3 with the same 
ODBC-OPENLINK drive(??).
  $qry = "SELECT idvalor,Valor,Tipo_rango FROM Fot_atributo_valor WHERE idcanal=41 AND 
idaplic=1 AND idatrib=2 ORDER BY idvalor";

  $res_id = odbc_prepare($conn_id,$qry);

  // the error occur in this code line (IN PHP4).
  $result = odbc_execute($res_id);


Thanks in advance.

Nico.

---



ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11595&edit=2


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-06-21 Thread nicolasperalta 

ID: 11595
User Update by: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Open
Bug Type: ODBC related
Operating system: Solaris 2.7
PHP Version: 4.0.4pl1
Description: Error in the migration PHP3 to PHP4 with OpenLink-ODBC drive

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.

Previous Comments:
---

[2001-06-21 11:10:52] [EMAIL PROTECTED]
marking as feedback until user responds...

---

[2001-06-21 09:50:44] [EMAIL PROTECTED]
Nico,

What error to you show?

Best regards,
Andrew Hill
OpenLink Software

---

[2001-06-20 18:27:41] [EMAIL PROTECTED]
When I migrated from PHP3 to PHP4 this script didn't work any more.
I don't have connection problems and the error appears just in some cases. 
The following is an ad-hoc script that reproduce the odbc error. 

// PHP Version 4.0.4pl1
// OS: Solaris 2.7
// Driver: ODBC-Openlink multi-tier 3.2
// this connection works fine.

  $conn_id = 
odbc_connect("Driver=/psitio/openlink/odbcsdk/lib/oplodbc.so.1;Host=sql02.local;SVT=SQLServer
 7;UID=batalla_web;PWD=mundial86;DATABASE=elsitiodb2;FetchBufferSize=4","","");

  echo "my connection $conn_id";

  $qry = "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = '" . $idioma . "' "
. "AND P.ID_PADRE IN (SELECT H.ID_HIJO FROM REAL_CAT_HIJO H 
WHERE "
. " H.ID_PADRE = '" . $cat . "') ";

  // this query works.
  $qry = "SELECT * FROM REAL_CAT_HIJO";

  // this query doesn't work IN PHP4 but works fine in PHP3 with the same 
ODBC-OPENLINK drive(??).
  $qry = "SELECT idvalor,Valor,Tipo_rango FROM Fot_atributo_valor WHERE idcanal=41 AND 
idaplic=1 AND idatrib=2 ORDER BY idvalor";

  $res_id = odbc_prepare($conn_id,$qry);

  // the error occur in this code line (IN PHP4).
  $result = odbc_execute($res_id);


Thanks in advance.

Nico.

---


Full Bug description available at: http://bugs.php.net/?id=11595


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-06-21 Thread kalowsky 

ID: 11595
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
Operating system: 
PHP Version: 4.0.4pl1
Assigned To: 
Comments:

marking as feedback until user responds...

Previous Comments:
---

[2001-06-21 09:50:44] [EMAIL PROTECTED]
Nico,

What error to you show?

Best regards,
Andrew Hill
OpenLink Software

---

[2001-06-20 18:27:41] [EMAIL PROTECTED]
When I migrated from PHP3 to PHP4 this script didn't work any more.
I don't have connection problems and the error appears just in some cases. 
The following is an ad-hoc script that reproduce the odbc error. 

// PHP Version 4.0.4pl1
// OS: Solaris 2.7
// Driver: ODBC-Openlink multi-tier 3.2
// this connection works fine.

  $conn_id = 
odbc_connect("Driver=/psitio/openlink/odbcsdk/lib/oplodbc.so.1;Host=sql02.local;SVT=SQLServer
 7;UID=batalla_web;PWD=mundial86;DATABASE=elsitiodb2;FetchBufferSize=4","","");

  echo "my connection $conn_id";

  $qry = "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = '" . $idioma . "' "
. "AND P.ID_PADRE IN (SELECT H.ID_HIJO FROM REAL_CAT_HIJO H 
WHERE "
. " H.ID_PADRE = '" . $cat . "') ";

  // this query works.
  $qry = "SELECT * FROM REAL_CAT_HIJO";

  // this query doesn't work IN PHP4 but works fine in PHP3 with the same 
ODBC-OPENLINK drive(??).
  $qry = "SELECT idvalor,Valor,Tipo_rango FROM Fot_atributo_valor WHERE idcanal=41 AND 
idaplic=1 AND idatrib=2 ORDER BY idvalor";

  $res_id = odbc_prepare($conn_id,$qry);

  // the error occur in this code line (IN PHP4).
  $result = odbc_execute($res_id);


Thanks in advance.

Nico.

---



ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11595&edit=2


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

2001-06-21 Thread ahill 

ID: 11595
Updated by: ahill
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Operating system: 
PHP Version: 4.0.4pl1
Assigned To: 
Comments:

Nico,

What error to you show?

Best regards,
Andrew Hill
OpenLink Software

Previous Comments:
---

[2001-06-20 18:27:41] [EMAIL PROTECTED]
When I migrated from PHP3 to PHP4 this script didn't work any more.
I don't have connection problems and the error appears just in some cases. 
The following is an ad-hoc script that reproduce the odbc error. 

// PHP Version 4.0.4pl1
// OS: Solaris 2.7
// Driver: ODBC-Openlink multi-tier 3.2
// this connection works fine.

  $conn_id = 
odbc_connect("Driver=/psitio/openlink/odbcsdk/lib/oplodbc.so.1;Host=sql02.local;SVT=SQLServer
 7;UID=batalla_web;PWD=mundial86;DATABASE=elsitiodb2;FetchBufferSize=4","","");

  echo "my connection $conn_id";

  $qry = "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = '" . $idioma . "' "
. "AND P.ID_PADRE IN (SELECT H.ID_HIJO FROM REAL_CAT_HIJO H 
WHERE "
. " H.ID_PADRE = '" . $cat . "') ";

  // this query works.
  $qry = "SELECT * FROM REAL_CAT_HIJO";

  // this query doesn't work IN PHP4 but works fine in PHP3 with the same 
ODBC-OPENLINK drive(??).
  $qry = "SELECT idvalor,Valor,Tipo_rango FROM Fot_atributo_valor WHERE idcanal=41 AND 
idaplic=1 AND idatrib=2 ORDER BY idvalor";

  $res_id = odbc_prepare($conn_id,$qry);

  // the error occur in this code line (IN PHP4).
  $result = odbc_execute($res_id);


Thanks in advance.

Nico.

---



ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11595&edit=2


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]