Need help - Database Issue

[Guest]

I have a problem where when the customers are trying to CONFIRM their order on my submit order page, the next page is timing out and it appears to be an OS Commerce databse error and I do not know how to diagnose the problem. The page imes out, then the customer hits BACK and re-submits the order and their credit card gets charged twice and sometimes 3 times.

[Guest]

what makes you think it is a database error?

 

Is there an error message displayed - if so post that here.

 

What payment module are you using?

 

We need a bit more information first

[Guest]

what makes you think it is a database error?

 

Is there an error message displayed - if so post that here.

 

What payment module are you using?

 

We need a bit more information first

 

I'm using Authorize.net for the payment module. I called them and they said they are getting the orders on their end with no problem. The reason I thought maybe it was a database problem is that I'm having the same problem when I try updating orders from the PENDING status to PROCESSING. When I hit the UPDATE button, I get the same timed out page. The order actually DOES update from pending to processing, but I get Server Not Available page time out. My hosting company checkd everything on their end and says everything is working fine. They don't keep php error logs so I'm not sure where I go from here to diagnose and fix the problem. It seems like an OS Commerce issue.

 

When placing an order on my site, the last page that works fine has the following URL:

 

https://host368.ipowerweb.com/~magnetic/osC...39fc2fdc1cc201f

 

Then the next page shows as Page Unavailable...that's the landing page. any suggestions?

[Guest]

I'm using Authorize.net for the payment module. I called them and they said they are getting the orders on their end with no problem. The reason I thought maybe it was a database problem is that I'm having the same problem when I try updating orders from the PENDING status to PROCESSING. When I hit the UPDATE button, I get the same timed out page. The order actually DOES update from pending to processing, but I get Server Not Available page time out. My hosting company checkd everything on their end and says everything is working fine. They don't keep php error logs so I'm not sure where I go from here to diagnose and fix the problem. It seems like an OS Commerce issue.

 

When placing an order on my site, the last page that works fine has the following URL:

 

https://host368.ipowerweb.com/~magnetic/osC...39fc2fdc1cc201f

 

Then the next page shows as Page Unavailable...that's the landing page. any suggestions?

 

well - you cold manually extract all the sql statements within the checkout_process file and run them all through phpmyadmin to see if any of them are slow to return results. if they are ,then create or rebuild the index on that table.

 

also - it would nice to see your errors printed to screen.

in : /includes/application-top.php

see if you can turn the errors on using : error_reporting(E_ALL & ~E_NOTICE);

 

If not - the just create you own log file to log php errors :

http://ca3.php.net/errorfunc

http://programmabilities.com/php/?id=5

http://www.tonymarston.net/php-mysql/errorhandler.html

 

Corrie

[jasonabc]

Sometimes this timeout is due to a bad/slow host. I had this problem a couple of times with Network Solutions hosted stores. You should be ok with iPower though. Make sure the response/receipt URL fields on the A.net side are both blank.