Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need help with oscommerce


mwarden

Recommended Posts

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.

Link to comment
Share on other sites

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

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

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.

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

 

 

 

Best Regards,
Gaurav

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...