News:

Support the VirtueMart project and become a member

Main Menu

user_email NULL (need help fixing)

Started by Michael West, January 30, 2011, 11:29:28 AM

Previous topic - Next topic

Michael West

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
Try posting a link to your website in your profile, or a link to the error page if possible.

A picture is worth a thousand words. For XP get http://www.bhelpuri.net/Snippy/SnippyDownload.htm, or...

Windows Vista has a Snipping Tool in the Accessories area of the Start Button.

"We look for things that make us go, computer things."
(StarTrek NG: Pakleds Episode http://www.youtube.com/watch?v=4lxIL1WlxSQ).


Have you read the manual? http://virtuemart.net/documentation/User_Manual/index.html I did, huh?

lowmips

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.
Visit my website at www.lowmips.com
View my newsletters Here (sign up for newsletters on the front page of my website)

Michael West

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.
Try posting a link to your website in your profile, or a link to the error page if possible.

A picture is worth a thousand words. For XP get http://www.bhelpuri.net/Snippy/SnippyDownload.htm, or...

Windows Vista has a Snipping Tool in the Accessories area of the Start Button.

"We look for things that make us go, computer things."
(StarTrek NG: Pakleds Episode http://www.youtube.com/watch?v=4lxIL1WlxSQ).


Have you read the manual? http://virtuemart.net/documentation/User_Manual/index.html I did, huh?

beneath

Hi, did you find any solution until now? I just noticed the same thing happening to me...  :-\

Michael West

Upgrading from Virtuemart 1.1.5 to VM 1.1.8 seemed to fix the issue if I recall correctly.
Try posting a link to your website in your profile, or a link to the error page if possible.

A picture is worth a thousand words. For XP get http://www.bhelpuri.net/Snippy/SnippyDownload.htm, or...

Windows Vista has a Snipping Tool in the Accessories area of the Start Button.

"We look for things that make us go, computer things."
(StarTrek NG: Pakleds Episode http://www.youtube.com/watch?v=4lxIL1WlxSQ).


Have you read the manual? http://virtuemart.net/documentation/User_Manual/index.html I did, huh?