Re: [mv] MV4.04 Problem - Multiple Orders In Same Visit

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Randy Moore (ramoore@axion-it.net):
> ******    message to minivend-users from Randy Moore <ramoore@axion-it.net>     ******
> 
>  >****** message to minivend-users from Cameron 
> Prince ><PRINCECB@novachem.com> ******
>  >
>  > I have noticed a problem where the field in the userdb 
> called >order_numbers doesn't get updated properly when a visitor 
> completes >more than one order in the same visit or session.
>  >
>  >For instance if I come to the store and purchase an item the 
> order >number is added order_numbers in the userdb. But if I order 
> something >else without closing my browser, the previous order number 
> in >order_numbers is overwritten with the new order number.
>  >
>  >This doesn't seem to cause any major issues but prevents the order 
> status >from showing all my orders on the account page.
>  >
> 
> I've just found the same problem.
> 
> I'm using MV 4.04 & MySql.
> 
> I checked the MySql logs to see what is going on with this value.  It seems 
> that the '[data
>          table=userdb
>          column=order_numbers
>          key="[data session username]"
>          value=" [value mv_order_number]"
>          append="1"
>          ]'
> 
> tag in 'log_transaction' is appending & writing out the new order number 
> for each order as it should.
> 
> But, some other part of the checkout process (that happens before the code 
> in 'log_transaction' is run) keeps re-writing the order_numbers field back 
> to the value that was read from the database when the user first logged in.
> 

Aha. That would be the [userdb save]. There must be a
$Values->{order_numbers} floating around, probably from the previous
login. I think I need to add a parameter to the UserDB thing:

	UserDB default ignore order_numbers any_other_field_to_ignore

That would prevent this.

For now, if you add this to UserDB:

	UserDB default ord_field order_numbers

That should solve it. I will add it to the demos.

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list