[ic] indirect_login and mv_credit_card_info

Mark Johnson mark at endpoint.com
Tue Aug 22 09:31:45 EDT 2006


Tom Tucker wrote:
> 
>> -----Original Message-----
>> From: interchange-users-bounces at icdevgroup.org
>> [mailto:interchange-users-bounces at icdevgroup.org]On Behalf Of Peter
>> Sent: Monday, August 21, 2006 9:52 PM
>> To: interchange-users at icdevgroup.org
>> Subject: Re: [ic] indirect_login and mv_credit_card_info
>>
>>
>> On 08/21/2006 06:47 PM, Tom Tucker wrote:
>>> No I'm getting the "(Customer record creation): There was an
>> error adding
>>> you to the customer table." error.
>> Set the default in the userdb table for the password field to '' (the
>> empty string).  Also set in the userdb.mysql file.
>>
>> I think that will fix it, if it doesn't then reply back with the full
>> text of the error in the catalog error.log.
>>
>> Peter
>>
> I made the following change to the userdb table:
> 
>     ALTER TABLE `userdb` CHANGE `email` `email` VARCHAR( 42 ) CHARACTER SET
> latin1 \
>     COLLATE latin1_swedish_ci NULL DEFAULT ''
> 
> Then I updated CATROOT/dbconf/mysql/userdb.conf with:
>     Database  userdb  COLUMN_DEF   "password=varchar(64) NOT NULL default
> ''"
> 
> Still getting the following in error.log:
> 
> xxx.yy.zzz.234 vvbMNVY3:xxx.yy.zzz.234 - [21/August/2006:22:34:52 -0500]
> catalog_dev /cgi-bin/catalog_dev/process Safe: Auto-create of user failed.
> Reason: Cannot log in after new account creation: Invalid user name or
> password.
>>  die errmsg("Auto-create of user failed. Reason: %s", $Session->{failure})
>>
> xxx.yy.zzz.234 vvbMNVY3:xxx.yy.zzz.234 - [21/Augu st/2006:22:34:52 -0500]
> catalog_dev /cgi-bin/catalog_dev/process Route log failed.
> xxx.yy.zzz.234 vvbMNVY3:xxx.yy.zzz.234 - [21/August/2006:22:34:52 -0500]
> catalog_dev /cgi-bin/catalog_dev/process ERRORS on ORDER :
>> Error during creation of order routing log:
>> Route log failed. at /usr/local/interchange/lib/Vend/Order.pm line 1835.
>>

It's likely Interchange is never finding the appropriate values for the
indirect_login.

Assuming you're using email for the indirect_login field, and your
Values space is the default, try adding the username explicitly to the
call to [userdb newaccount] in log_transaction:

>                [userdb
>                         function=new_account
>                         assign_username=1
>                         password='[value zip]'
>                         verify='[value zip]'
>                         username='[value email]'
>                 ]

You should also bear in mind this will only work on the initial order
for a given email address. After that, you'll get duplicate-user errors.

Mark

--
Mark Johnson
End Point Corporation
http://www.endpoint.com


More information about the interchange-users mailing list