Need help with oscommerce

[mwarden]

Been dumped upon with this. Know very little about oscommerce and would love to get some help on this.

When you 'Checkout', an error message appears at the top of the screen, above the shipping charges.

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/includes/functions/database.php on line 99

 

Does any one know what the problem could be and how to resolve it.

 

thanks in advance.

[♥geoffreywalton]

I googled

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /includes/functions/database.php on line 99

 

Got 3210 hits.

 

Seems to point to incrrect installation of a contribution.

 

G

[Gauravs]

A. Diagnosis

a. Is this a new install?

b. Did it ever work?

c. If Yes to above, What has changed - any new contribution added ? Any mod by you ?

 

 

B. Steps to identify the problem

\includes\functions\database.php has following code that is causing the error

return mysql_fetch_array($db_query, MYSQL_ASSOC);

 

function tep_db_fetch_array($db_query) {
return mysql_fetch_array($db_query, MYSQL_ASSOC);
}

 

So what you need to do is,

1. Narrow down which file brings the error during checkout process.

2. Find what $db_query is being created in that particular file. To find that, search how many times is tep_db_fetch_array($db_query) is being invoked.

3. Run each query that you have identified (as in point #2) in phpmyadmin.

4. Fix the query that is causing the error.

------------------------------------