Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL ERROR on new live store


itfitz

Recommended Posts

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

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?

 

check the last contribution you put into your admin.

Treasurer MFC

Link to comment
Share on other sites

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

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

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?

 

 

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...