Warning when confirming order.

[jschner]

I get this message when I confirm an order when the file checkout_process.php is run.

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/maslanik/public_html/shop/includes/functions/database.php on line 440 -

 

select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

 

After I get this I have to edit my cookies to view the site again and my item is still in the cart. Then it allows me to checkout just fine. When I checkout I'm using check/moneyorder and UPS shipping.

 

Using version 2.2, IE6, Any clues?

[jschner]

I'm really at a loss where to turn on this. Talked with my host and he doesn't know what it is. I have looked through the database.php file and customer_process file and I don't know enough to know what I'm looking for.

 

I have been working on this for hours without a clue except that after some time or so it briefly fixes itself and I can go back to complete the original order. What's really odd is when I get the error message I can't even access the default.php page without seeing the error. Tried refreshing and the whole works. If I go do something else for 10 minutes then go back it seems to work.

 

Any help, clues, ideas at all would be appreciated as I'm at a complete stand still on this.

 

Thank you.

[jschner]

OK a little more info:

First this warning is not just a warning but it kills the OSC program. I get a blank page with just the error message and nothing else. I can't access even the default.php page for like ten minutes after this happens.

 

I tried uploading another sql database into OSC and had the same problem occur. I took the original database and uploaded it into a working copy of OSC on a different website I have and the database works fine. So that leads me to a bad file in OSC or some kind of php thing. Sound logical?

 

Also, I just found out that my host recently upgraded to PHP 4.3.2. I'm not sure how to figure out if that is the problem but OSC runs fine on the my other website with the same host but on a different server.

 

Any clues at all out there?

[Guest]

http://www.oscommerce.com/forums/viewtopic.php...qllink+resource

 

HTH

The_Bear

[jschner]

Bear, I spent half of Father's day yesterday searching these forums for the answer with no luck. What's funny is I would try words like "database" in search and would get "No topics or posts met your search criteria". Basically a Kirok moment I suppose. :roll:

 

Thanks! I'll give your post a try.

[jschner]

I don't know what the little snippet of code does or why it needed to be added to the database.php file or why it's not in the newest releases but it worked.

 

What is really odd is the OSC on one site needs the code and the OSC on my other site with the same host but different server doesn't need the code. Both running php 4.3.2 Go figure.

 

Thanks a bunch!

[jschner]

The code created a different problem.

 

http://www.oscommerce.com/forums/viewtopic.php...p=197711#197711