coffman Posted February 26, 2005 Share Posted February 26, 2005 Hello, I am in the process of moving my store to a new host. The new host seems to be setup a little different than my old one. I am seeing an error that I did not see before, and am having problems figuring out how to debug the problem. I have done extensive mods to the store and am pretty sure there is a subtle error in my code or one of the contribs that was ignored on my previous host. The error I am seeing only shows up when loading the product_info.php page. It displays once at the top of the page. The error is: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site3/fst/var/www/html/includes/functions/database.php on line 99 I have been able to figure out that the code in the product_info does various database queries, then a call is made to tep_db_fetch_array in the database.php file which generates the error. I am having a problem figuring out which statment is actually generating the error. I have tried adding code into the database.php file that writes info to a file and I am able to see that some of the queries being passed are not actual db resource id's, but I can't seem to track down the exact calls. I am assume the error is generated because the resource id is not valid.. Anyone have any tips on debugging this? Thanks. -MichaelC Link to comment Share on other sites More sharing options...
Guest Posted February 26, 2005 Share Posted February 26, 2005 Tell your host to upgrade the Zend Optmizer...that is a typical error message given when the host has upgraded PHP version to 4.3.10 and HAS NOT upgraded the Zend optimizer which is not compatible with the new PHP changes. Bobby Link to comment Share on other sites More sharing options...
coffman Posted February 26, 2005 Author Share Posted February 26, 2005 Chemo Before I ask for the upgrade, here is the output of php --version: PHP 4.3.8 (cgi) (built: Jul 16 2004 08:32:27) Copyright © 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies Does this seem consistent with the version problem you mention? -MichaelC Link to comment Share on other sites More sharing options...
coffman Posted March 14, 2005 Author Share Posted March 14, 2005 The suggestion to upgrade zend does not help. Currently running: PHP 4.3.10 (cgi) (built: Dec 21 2004 19:32:11) Copyright © 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies with Zend Extension Manager v1.0.6, Copyright © 2003-2004, by Zend Technologies with Zend Optimizer v2.5.7, Copyright © 1998-2004, by Zend Technologies and I still get the errors. I guess I'll be walking throught mysql fetches to figure out which one is causing the warning. If anyone has any suggestions for how to debug a poblem like this. I would greatly appreciate them. -MichaelC Link to comment Share on other sites More sharing options...
Sinister-Racing Posted March 21, 2005 Share Posted March 21, 2005 The suggestion to upgrade zend does not help. Currently running:PHP 4.3.10 (cgi) (built: Dec 21 2004 19:32:11) Copyright ? 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright ? 1998-2004 Zend Technologies with Zend Extension Manager v1.0.6, Copyright ? 2003-2004, by Zend Technologies with Zend Optimizer v2.5.7, Copyright ? 1998-2004, by Zend Technologies and I still get the errors. I guess I'll be walking throught mysql fetches to figure out which one is causing the warning. If anyone has any suggestions for how to debug a poblem like this. I would greatly appreciate them. <{POST_SNAPBACK}> I was wondering if you have figured out your problem. I have the same issue and I am not quite sure how to solve the problem. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.