VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: capewellmj on May 07, 2014, 23:37:01 PM

Title: Cart emptying when confirming order intermittent problem.
Post by: capewellmj on May 07, 2014, 23:37:01 PM
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
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: GJC Web Design on May 08, 2014, 00:01:24 AM
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?
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: capewellmj on May 08, 2014, 06:54:14 AM
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
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: GJC Web Design on May 08, 2014, 09:28:22 AM
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?
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: capewellmj on May 08, 2014, 16:49:44 PM
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
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: Milbo on May 08, 2014, 17:11:16 PM
Please check the logs provided in virtuemart.

It should be logged there, check the menu item tools in the BE.
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: capewellmj on May 08, 2014, 17:15:06 PM
Hi Milbo

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

Martin
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: GJC Web Design on May 08, 2014, 17:37:34 PM
normally logged to logs/error.php  but you can read directly from VM admin tools->log
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: capewellmj on May 08, 2014, 20:21:29 PM
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
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: GJC Web Design on May 08, 2014, 21:06:14 PM
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..
Title: Re: Cart emptying when confirming order intermittent problem.
Post by: Milbo on May 08, 2014, 23:07:05 PM
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.