Quote Originally Posted by ladysaat
I got this error after successfully installing the SQL patch and then clicking on RecoverCart in the tools area:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/hodllc/houseofdiva.com/zencart/admin/recover_cart_sales.php on line 410

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/hodllc/houseofdiva.com/zencart/admin/recover_cart_sales.php on line 410


Line 410 reads: $inrec2 = mysql_fetch_array($query2);


I am using zencart v1.3.0.1 and I just got this mod from the downloads sec. here.

So what does it mean? I looked at the file and I do not know what is "supposed" to be there versus what is.
To fix that error, replace $inrec2 = mysql_fetch_array($query2); with $inrec2 = @mysql_fetch_array($query2);

Also, someone mentioned how the javascript menu wouldn't work on those pages generated by recover carts module, so the fix for that is...

lines 103 -113 of admin > recover_cart_sales.php, replace this code <br /><br />
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET;?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
with this code

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
<script language="javascript" src="includes/menu.js"></script>
<script language="javascript" src="includes/general.js"></script>

<script type="text/javascript">
<!--
function init()
{
cssjsmenu('navbar');
if (document.getElementById)
{
var kill = document.getElementById('hoverJS');
kill.disabled = true;
}
}
// -->
</script>
</head>
<body onLoad="init()">