Author Topic: user_email NULL (need help fixing)  (Read 2511 times)

Michael West

  • Jr. Member
  • **
  • Posts: 120
    • The Website
user_email NULL (need help fixing)
« 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
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

  • Global Moderator
  • Full Member
  • *
  • Posts: 1464
    • lowmips.com
Re: user_email NULL (need help fixing)
« Reply #1 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.
Visit my website at www.lowmips.com
View my newsletters Here (sign up for newsletters on the front page of my website)

Michael West

  • Jr. Member
  • **
  • Posts: 120
    • The Website
Re: user_email NULL (need help fixing)
« Reply #2 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.
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

  • Beginner
  • *
  • Posts: 8
    • Mikro Princ
Re: user_email NULL (need help fixing)
« Reply #3 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...  :-\

Michael West

  • Jr. Member
  • **
  • Posts: 120
    • The Website
Re: user_email NULL (need help fixing)
« Reply #4 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.
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?