Zend_Db Crashing Apache

Mordist · #1 (**permalink**) 11-13-2007, 03:35 PM

I have a VERY simple statement, that I am sure is returning results, but it's crashing Apache... it works fine on my dev box (Windows Vista running Xampp), but it crashes my demo box (running CentOS 4, Apache 2)...

SELECT * FROM tablea WHERE field1=<num> AND field2=<num>

That's it...

$stmt = $db->query($query);
$rows = $stmt->fetchAll();

It crashes on the "$stmt = $db->query($query);" line, every time.

warden · #2 (**permalink**) 12-11-2007, 11:09 AM

Enable SQL query logging and check why then

mgordon · #3 (**permalink**) 02-18-2008, 04:13 PM

Use the quoteIdentifier() function and use the quoteInto() for the where see if you get a better query. See also if you get the same result with a select statement:

PHP Code:


			
$sel = $my_db->select();

$sel->from('tablea')

$sel->where(array("field1=?" => $num1, "field2=?" => num2);

$stmt = $sel->query();

This should result in a safe query that shouldn't crash...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode