PEAR::db / oci8 trouble

From: Date: Mon, 27 May 2002 13:42:40 +0000
Subject: PEAR::db / oci8 trouble
Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-6471@lists.php.net to get a copy of this message
Hi, I am trying to execute a query: SELECT * FROM random_players WHERE status='A' AND rownum <=1 AND msisdn NOT IN (SELECT msisdn FROM user_state) AND id NOT IN (24) I am using oracle 8 and PEAR::DB 1.2 While looking at my log file, I can see that PEAR::db tries to execute two queries where there should be only one. I am guessing this is a workaround for some compatibility issues, but it is stopping my application from working. Why is this first query being executed and how can I prevent that? May 27 15:16:00 [critical] DB Error: no such field ::debug:: SELECT COUNT(*) FROM random_players WHERE status='A' AND rownum <=1 AND msisdn NOT IN (SELECT msisdn FROM user_state) AND id NOT IN (24) [nativecode=ORA-00904: invalid column name] May 27 15:16:00 [critical] DB Error: DB backend not capable ::debug:: SELECT * FROM random_players WHERE status='A' AND rownum <=1 AND msisdn NOT IN (SELECT msisdn FROM user_state) AND id NOT IN (24) Cheers Roko

« previous php.pear.dev (#6471) next »