VirtueMart Forum

VirtueMart General => Commercial Jobs => Topic started by: Michael West on January 30, 2011, 11:29:28 AM

Title: user_email NULL (need help fixing)
Post by: Michael West on January 30, 2011, 11:29:28 AM
I have a problem that no-one in the forums has addressed.

In the database at `jos_vm_order_user_info` in the `user_email` intermediately is set as 'NULL' rather than being populated from the email set in the Joomla database.

I other words, VM grabs the email from `jos_vm_user_info` in the field `user_email` and it is supposed to exist there but it is blank. So, the order fails to populate `jos_vm_order_user_info` using `user_email` upon checkout.

This seems to occur with random user records propagating from user_info to order_user_info during checkout.

Questions:

1. Is the cause some code in VM?
2. Missing data is obvious in the Database.
3. Why is it random?
4. Is it a timeout issue?
5. How is this possible when the same people successfully placed previous orders and the email was successfully sent?

Anyone bidding on the job should be willing to supply proper credentials and be willing to supply a comprehensive explanation of the issue so that all in the forums will benefit. Contact me thru GlyCop.com with proposals.

Joomla Version 1.5.22 - Virtuemart 1.1.5 on Apache version 2.2.16 PHP version 5.2.16
Title: Re: user_email NULL (need help fixing)
Post by: lowmips on January 30, 2011, 19:06:20 PM
What percentage of your orders are failing in this manner? It may be worthwhile to introduce some debugging code that writes to file the query and query results, then run test orders until it fails.
Title: Re: user_email NULL (need help fixing)
Post by: Michael West on January 30, 2011, 22:48:19 PM
It is a small percentage and there seems to be no obvious email format that causes the problem.  I suspect issue is a "time-out" parameter between the database and the VM code.

I appreciate anyone that might help as the bug seemed to be addressed in the development archives from past versions of VM as far back as 1.1.2 if I'm not mistaken.
Title: Re: user_email NULL (need help fixing)
Post by: beneath on July 20, 2012, 13:20:23 PM
Hi, did you find any solution until now? I just noticed the same thing happening to me...  :-\
Title: Re: user_email NULL (need help fixing)
Post by: Michael West on August 04, 2012, 10:11:21 AM
Upgrading from Virtuemart 1.1.5 to VM 1.1.8 seemed to fix the issue if I recall correctly.