Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.12.1

Bug #386 query hangs
Submitted: 2003-12-09 09:55 UTC
From: warpje at yahoo dot com Assigned:
Status: Bogus Package: DB
PHP Version: 4.3.3 OS: Windows NT
Roadmaps: (Not assigned)    
Subscription  


 [2003-12-09 09:55 UTC] warpje at yahoo dot com
Description: ------------ Query doesn't work with DB while it works with standard php mysql. After issuing: echo "BEFORE"; if(!($result = $db_object->query($query))){ die("ERROR"); } echo "HI"; Nothing comes out of it. seems like it dies. I neither see ERROR or HI printed on the screen, while I see before. Reproduce code: --------------- SELECT pt.pt , (regels.pick_date) as pick_date , (ship.ship_date) as ship_date , sum(aant_gepick) as aantal FROM ( pt left join regels on pt.pt=regels.pt ) left join ship on pt.pt=ship.pt where (pick_date between '2003-12-1' and '2003-12-15') and ( (ship_date not between '2003-12-1' and '2003-12-15') or (ship_date is null) ) group by pt.pt order by pick_date ;

Comments

 [2003-12-09 09:57 UTC] warpje at yahoo dot com
Description: ------------ Query doesn't work with DB while it works with standard php mysql. After issuing: echo "BEFORE"; if(!($result = $db_object->query($query))){ die("ERROR"); } echo "HI"; Nothing comes out of it. seems like it dies. I neither see ERROR or HI printed on the screen, while I see before. Reproduce code: --------------- SELECT pt.pt , max(regels.pick_date) as pick_date , max(ship.ship_date) as ship_date , sum(aant_gepick) as aantal FROM ( pt left join regels on pt.pt=regels.pt ) left join ship on pt.pt=ship.pt where (pick_date between '2003-12-1' and '2003-12-15') and ( (ship_date not between '2003-12-1' and '2003-12-15') or (ship_date is null) ) group by pt.pt order by pick_date ;
 [2003-12-09 10:42 UTC] warpje at yahoo dot com
In mysql.php::simpleQuery($query) there is a line: $result = @mysql_query($query, $this->connection); it seems to work after changing it to: $result = @mysql_query($query);//, $this->connection); Why is that? And why does it work with other queries? Thanks, Jeroen
 [2003-12-09 11:11 UTC] warpje at yahoo dot com
Problem was timing. After setting: set_time_limit(0); The problem went away. I don't understand why, because php used to give a warning when timer went of. Sorry for the misplaced bug. Jeroen