itfitz Posted January 8, 2005 Share Posted January 8, 2005 here is the error I get when I go in and try to edit an item: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/lotions2/public_html/ecommerce/os/catalog/admin/includes/functions/database.php on line 99 Warning: reset(): Passed variable is not an array or object in /home/lotions2/public_html/ecommerce/os/catalog/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/lotions2/public_html/ecommerce/os/catalog/admin/includes/classes/object_info.php on line 18 Any ideas? If it was easy, anyone could do it! Link to comment Share on other sites More sharing options...
boxtel Posted January 8, 2005 Share Posted January 8, 2005 here is the error I get when I go in and try to edit an item: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/lotions2/public_html/ecommerce/os/catalog/admin/includes/functions/database.php on line 99 Warning: reset(): Passed variable is not an array or object in /home/lotions2/public_html/ecommerce/os/catalog/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/lotions2/public_html/ecommerce/os/catalog/admin/includes/classes/object_info.php on line 18 Any ideas? <{POST_SNAPBACK}> check the last contribution you put into your admin. Treasurer MFC Link to comment Share on other sites More sharing options...
itfitz Posted January 8, 2005 Author Share Posted January 8, 2005 I think it is the totalb2b that is causeing the problem, how do I undu items in the database, since I think thats where the problem lies? If it was easy, anyone could do it! Link to comment Share on other sites More sharing options...
itfitz Posted January 8, 2005 Author Share Posted January 8, 2005 here is the object_info.php file <?php /* $Id: object_info.php,v 1.6 2003/06/20 16:23:08 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ class objectInfo { // class constructor function objectInfo($object_array) { reset($object_array); while (list($key, $value) = each($object_array)) { $this->$key = tep_db_prepare_input($value); } } } ?> If it was easy, anyone could do it! Link to comment Share on other sites More sharing options...
boxtel Posted January 8, 2005 Share Posted January 8, 2005 I think it is the totalb2b that is causeing the problem, how do I undu items in the database, since I think thats where the problem lies? <{POST_SNAPBACK}> Somewhere in your added / changed code there is a statement like this : $xxxxx= tep_db_query("query statement"); $yyyyy = tep_db_fetch_array($xxxxxx); your code has a problem with the $xxxxxx argument to tep_db_fetch_array. It states that it is not a valid sql result. So it could be in the data but it could also be in the code. I suggest you put this question to the B2B contribution forum. best chance of getting ahead. Treasurer MFC Link to comment Share on other sites More sharing options...
itfitz Posted January 8, 2005 Author Share Posted January 8, 2005 I am in the process of restoring the website right now from a backup from early last night. The database was a little older, but still from yesterday. Today I am going to install a local test webserver so I can make all of my mistakes without interupting the business. Thanks, Shawn If it was easy, anyone could do it! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.