Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL Problem, I don't know how to fix this


Guest

Recommended Posts

Posted

I really need help. I think I may have messed my entire store up and I don't know how to fix it. Or maybe it's something not too bad...(I hope).

 

Yesterday, I installed the Quantity Price Break contribution but I was having a big problem with it, so I decided to install the Simple Price Break instead.

 

I'm now getting this error when I try to add something to my shopping cart:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web110/b1104/sl.bellafavori/public_html/store/includes/functions/database.php on line 99

 

Which is this:

 

line 98) function tep_db_fetch_array($db_query) {

line 99) return mysql_fetch_array($db_query, MYSQL_ASSOC);

 

I restored my database to pre-Quantity Price Break but the error still appears.

 

Obviously (?) I screwed something up in the databases, but I really am a total dummie when it comes to MySQL. I haven't a clue as to what I should do now.

 

I hope to heaven I don't have to start all over again, I have so many contributions installed and have been working on the store for so long...Anyone out there have any ideas as to what I should do????????????

Posted
.Anyone out there have any ideas as to what I should do????????????

This has nothing to do with MySQL really. It is about code that does a retrieval of query results (tep_db_fetch_array("name of query")) where the query itself hasn't been done. So you did not remove all the code associated with QPBPP.

Posted

Thanks Jan. I'm going to go back through all the changed pages to triple check. If that's all it is, I'll be a happy woman :D

Archived

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

×
×
  • Create New...