[ic] IC 5.10.0 git master branch with strap

[Boyd Lynn Gerber]

Hello,

Thank you in advance.

Here is the steps I have done

cd /home/build/interchange/
git clone https://github.com/interchange/interchange.git
cd interchange/
perl Makefile.PL
make
make test
make install
cd /usr/local/interchange/
/usr/local/interchange/bin/makecat
create catalog name Strap
...
adding to interchange.cfg

/usr/local/interchange/bin/restart

Go to catalog
http://site.com/cgi-bin/strap/index.html
choose a product add to cart
click on the check out

I am in
http://site.com/cgi-bin/strap/ord/shipping

The next two methos both fail.

Login
enter email
check no I am a new customer

Then fill in the form with email and password repeated twice

This error message is then displayed.

Cannot log in after new account creation: Invalid user name or password.

or enter all your information click on proceed to check out

Enter CC info click on place order

This is the error message

(Customer record creation): There was an error adding you to the 
customer table.

As per Josh Lavin <jlavin at endpoint.com> digory on Freenode

Here is the Query Log for the failure on strap and all the logs for the 
one transaction.

http://pastebin.com/uX466Gw2

from error.log

168.103.176.53 Ikjq6pAS:168 - [26/January/2017:20:24:09 -0700] 
microfibercleaningclothes 
/cgi-bin/microfibercleaningclothes.com/ord/finalize set_row error as 
called by Vend::Table::DBI: DBD::mysql::db do failed: Field 'password' 
doesn't have a default value at 
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1523.
>
> fields=`username`
> values='U00031'
168.103.176.53 Ikjq6pAS:168 - [26/January/2017:20:24:09 -0700] 
microfibercleaningclothes 
/cgi-bin/microfibercleaningclothes.com/ord/finalize set_row error as 
called by Vend::Table::DBI: DBD::mysql::db do failed: Field 'password' 
doesn't have a default value at 
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1523.
>
> fields=`username`
> values='U00031'
168.103.176.53 Ikjq6pAS:168 - [26/January/2017:20:24:09 -0700] 
microfibercleaningclothes 
/cgi-bin/microfibercleaningclothes.com/ord/finalize set_row error as 
called by Vend::Table::DBI: DBD::mysql::db do failed: Field 'password' 
doesn't have a default value at 
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1523.
>
> fields=`username`
> values='U00031'
168.103.176.53 Ikjq6pAS:168 - [26/January/2017:20:24:09 -0700] 
microfibercleaningclothes 
/cgi-bin/microfibercleaningclothes.com/ord/finalize Safe: Auto-create of 
user failed. at (tag 'perl') line 1.
>
>  die errmsg("Auto-create of user failed.");
>
168.103.176.53 Ikjq6pAS:168 - [26/January/2017:20:24:09 -0700] 
microfibercleaningclothes 
/cgi-bin/microfibercleaningclothes.com/ord/finalize Route log failed.
168.103.176.53 Ikjq6pAS:168 - [26/January/2017:20:24:09 -0700] 
microfibercleaningclothes 
/cgi-bin/microfibercleaningclothes.com/ord/finalize ERRORS on ORDER :
> Error during creation of order routing log:
> Route log failed. at /usr/local/interchange/lib/Vend/Order.pm line 
1861.
>

from logs/log

#### begin order logging of transaction ID 000012 #####
1
Total order: $23.88
Payment processing...payment_method=credit_card
Offline credit card visa 42**4242.
Payment: credit_card
Set order number in values: 1014
Set order number in session: 1014
1
Auto-create of user failed.
There was an error adding you to the customer table.
Add main order 1014 to transactions:
1
#### end order logging of tid=000012, order_number=1014 #####

from userdb.log

20170126201224  usernick        168.103.176.53  Denied attempted login 
with nonexistent (indirect from usernick) user name 'U00030'
20170126201328  gerberb at zenez.com       168.103.176.53  Denied attempted 
login with nonexistent (indirect from usernick) user name 
'gerberb at zenez.com'
20170126201356  gerberb at zenez.com       168.103.176.53  Denied attempted 
login with nonexistent (indirect from usernick) user name 
'gerberb at zenez.com'
20170126202409  usernick        168.103.176.53  Denied attempted login 
with nonexistent (indirect from usernick) user name 'U00031'

The username in the admin now works for creating a new customer, but the 
login with that customer then fails.

I enter my newly created account from the Admin
email address
password

Then I get this error.

Invalid user name or password.

The ID is 00003 when I look it up in the Admin Console.

Any ideas are greatly apperciated.

Thank You,

-- 
Boyd Gerber <gerberb at zenez.com> 801 849-0213
ZENEZ   1042 East Fort Union #135, Midvale Utah  84047