Cart emptying when confirming order intermittent problem.

[capewellmj]

Hello

We have had 8 people call us in the last 2 days since we updated virtuemart asking if there orders went through as they clicked to confirm an order but then got either a blank page or their cart went empty.

We only updated virtuemart 2 days. I had it happen to me one time also where it said my cart was empty when I tried to get a shipping calculator.

We also moved server 2 days ago, could it be a execution limit or something or setting that needs to be updated?

Is this a known problem? It is definitely intermittent as we cannot reproduce the problem at will.

What could be causing this?

Martin

[GJC Web Design]

Not a "known" problem no....

Could be lack of memory  etc - updating AND changing servers gives a lot of variables - assume you mean updated to 2.6.0?

server logs?

[capewellmj]

Which logs should I review.

Yes I updated to 2.6 and yes it could be the server. I have no idea how to troubleshoot this issue.

Martin

[GJC Web Design]

It is very difficult because it is intermitant.. but if at some stage the server ran out of resources it will be logged some where - your host is the one to ask ... that's what you pay them for..  any decent host will do some sort of investigation in their logs and resource logging..

You can look in every log folder on your ftp / cpanel to see if anything is there.. you have to start somewhere

You haven't listed the specs of your host? How much memory do you have?

[capewellmj]

I have a dedicated server.

This should be plenty.

Processor:
Intel Xeon E3-1270 V2 3.5GHZ, Quad Core
RAM:
16GB DDR3 SDRAM

Got another customer this morning said they got a blank screen after they hit confirm.

Very frustrating.

Martin

[Milbo]

Please check the logs provided in virtuemart.

It should be logged there, check the menu item tools in the BE.

[capewellmj]

Hi Milbo

I cannot find the Virtuemart logs, where are they located?

Martin

[GJC Web Design]

normally logged to logs/error.php  but you can read directly from VM admin tools->log

[capewellmj]

I'm getting a lot of fatal errors like this in my Joomla error_log.

Any thoughts?

[08-May-2014 18:11:59 UTC] PHP Fatal error:  Maximum execution time of 60 seconds exceeded in /home/Name/public_html/libraries/joomla/database/database/mysql.php on line 534
[08-May-2014 18:12:21 UTC] PHP Fatal error:  Maximum execution time of 60 seconds exceeded in /home/name/public_html/libraries/joomla/database/database.php on line 1094

[GJC Web Design]

that then is for your server noddy to look at... slow sql server maybe?

too many queries? turn your Joomla debug on and see what sort of query numbers your calling on checkout

I'm in the process of debugging a VM site that is making  1400 queries just for a cat page... doesn't seem to be VM related - more a SEF comp they are using - so check out side of VM for calls as well..

[Milbo]

Vm2.6.0a is not using a lot queries anylonger. You have the problem in the cart? Disable all payment plugins which you do not need.