mysql_fetch_array() boolean given unable to find error

Question

I now am getting this in my error log after fixing another problem. I've looked over everything on stackoverflow and all I come come up with is to get it to display an error, problem is I can't find where the error displays, so I can't troubleshoot it that way. Can anyone help give me some guidance? I'm not trying to do a duplicate, I'm really just trying to understand what is going on, sorry if this is misplaced (and if it is please let me know!).

This is the error:

[Wed Mar 27 01:36:41 2013] [error] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /nas/wp/www/cluster-1434/XXXXXXX/wp-content/themes/mytheme/functions.php on line 574
[Wed Mar 27 01:36:14 2013] [error] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /nas/wp/www/staging/XXXXXXX/wp-content/themes/mytheme/functions.php on line 572

This is line 572:

$ll = mysql_fetch_array($getLL);

This is line 574:

$cou = mysql_fetch_array($getCount);

Here is the code:

<?php
$con = conDB();
$x = 0;
//if ( false === ( $zip = get_transient( 'distinct_zips' ) ) ) {
$getZips = mysql_query("SELECT Distinct(meta_value) FROM wp_postmeta WHERE meta_key='_gmap_zip'",$con);
//$zip = mysql_fetch_array($getZips);
//  set_transient('distinct_zips', $zip, 60*5);
//}
while($zip = mysql_fetch_array($getZips)){
$getLL = mysql_query("SELECT * FROM zipcodes WHERE zip=".$zip['meta_value'],$con);
$ll = mysql_fetch_array($getLL);
$getCount = mysql_query("SELECT Count(*) FROM wp_postmeta WHERE meta_key='_gmap_zip' AND meta_value=".$zip['meta_value'],$con);
$cou = mysql_fetch_array($getCount);
$zipvalue = $zip['meta_value'];
$getNewest = mysql_query('SELECT * FROM wp_postmeta WHERE meta_key="_gmap_zip" AND meta_value="'.$zipvalue.'" LIMIT 5',$con);
if(strlen($ll['lat'])){
?>

Thanks in advance for all your help!

What code is at wp-content/themes/mytheme/functions.php on line 574 ? — , Mar 27 '13 at 04:17
@FoolishSeth I tried, but I don't know what to do from there, because I can't find where the error outputs. — michaelrmcneill, Mar 27 '13 at 04:20
Please **don't use `mysql_*` functions in new code** ([why?](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php)), they are [deprecated](https://wiki.php.net/rfc/mysql_deprecation). Use [PDO or MySQLi](http://php.net/manual/en/mysqlinfo.api.choosing.php) instead — kero, Mar 27 '13 at 04:27
@FoolishSeth the only error log WP Engine gives me. It just is called error log. — michaelrmcneill, Mar 27 '13 at 04:27
And if you follow the accepted answer in the post I linked you don't see any new errors in there? Or printed on the page? — FoolishSeth, Mar 27 '13 at 04:27
@FoolishSeth correct, I see no more errors after following those answers. — michaelrmcneill, Mar 27 '13 at 04:28
Can you reflect in your code what you've tried in order to identify the error? — FoolishSeth, Mar 27 '13 at 04:29
You are showing code for mysql_query, the error is a mysql_fetch_array. Please show the whole function? — , Mar 27 '13 at 04:31
@exampleusername the function is 250 lines of code. Showing the whole function won't work. I'm showing the mysql_fetch_array both lines that are causing the problems? — michaelrmcneill, Mar 27 '13 at 04:47
@kingkero I didn't write the function, but now I'll make sure to change that! Thanks for the info! — michaelrmcneill, Mar 27 '13 at 04:51

score 0 · Answer 1 · answered Mar 27 '13 at 04:23

0

The queries:

$getLL = mysql_query("SELECT * FROM zipcodes WHERE zip=".$zip['meta_value'],$con);
$getCount = mysql_query("SELECT Count(*) FROM wp_postmeta WHERE meta_key='_gmap_zip' AND meta_value=".$zip['meta_value'],$con);

are failing returning false, leading to those two warnings.

As a general rule of thumb you should always check for errors when dealing with queries. You can do that by running:

if (!empty(mysql_error())) // error

answered Mar 27 '13 at 04:23

Shoe

72,892
33
161
264

I understand that it is returning false, but how should I go about fixing that issue, especially since I cannot see the error? – michaelrmcneill Mar 27 '13 at 04:26
@michaelrmcneill, you can see the error by writing `var_dump(mysql_error())`. – Shoe Mar 27 '13 at 04:27
after adding that, my error log stops reporting everything related to this...Does that mean there isn't a problem? Or does that mean it is reporting it somewhere else? – michaelrmcneill Mar 27 '13 at 04:52

score 0 · Answer 2 · answered Mar 27 '13 at 04:23

0

try var_dump($getLL)

It seems that it is returning false, because of any error in mysql_query() execution. Please always try to double check returning answer from mysql function before passing it to another function.

while($zip = mysql_fetch_array($getZips)){
$getLL = mysql_query("SELECT * FROM zipcodes WHERE zip=".$zip['meta_value'],$con);
if($getLL == false)
{
    echo mysql_error();
    exit;
}
$ll = mysql_fetch_array($getLL);
$getCount = mysql_query("SELECT Count(*) FROM wp_postmeta WHERE meta_key='_gmap_zip' AND meta_value=".$zip['meta_value'],$con);
$cou = mysql_fetch_array($getCount);
$zipvalue = $zip['meta_value'];
$getNewest = mysql_query('SELECT * FROM wp_postmeta WHERE meta_key="_gmap_zip" AND meta_value="'.$zipvalue.'" LIMIT 5',$con);

answered Mar 27 '13 at 04:23

Maulik Vora

2,463
5
27
48

Thanks for this, I tried this, but all it does is stop the code from loading, it doesn't display the error anywhere I can seem to find. – michaelrmcneill Mar 27 '13 at 04:25
dude, show us the entire function where the error occurs. – Mar 27 '13 at 04:28
try to echo out this.. 'SELECT * FROM zipcodes WHERE zip=".$zip['meta_value']' – Maulik Vora Mar 27 '13 at 04:39

score 0 · Answer 3 · answered Mar 27 '13 at 05:50

0

Please use below code after $getLL = mysql_query(...

if (!$getLL) { 
    die('Invalid query getLL: ' . mysql_error());
}

and also below code after $getCount = mysql_query(...

if (!$getCount) { 
    die('Invalid query getCount: ' . mysql_error());
}

answered Mar 27 '13 at 05:50

Amir

4,049
4
15
26

mysql_fetch_array() boolean given unable to find error

3 Answers3