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

[Guest]

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????????????

[Jan Zonjee]

.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.

[Guest]

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