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@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@zenez.com 168.103.176.53 Denied attempted
login with nonexistent (indirect from usernick) user name
'gerberb@zenez.com'
20170126201356 gerberb@zenez.com 168.103.176.53 Denied attempted
login with nonexistent (indirect from usernick) user name
'gerberb@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@zenez.com> 801 849-0213
ZENEZ 1042 East Fort Union #135, Midvale Utah 84047
_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
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@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@zenez.com 168.103.176.53 Denied attempted
login with nonexistent (indirect from usernick) user name
'gerberb@zenez.com'
20170126201356 gerberb@zenez.com 168.103.176.53 Denied attempted
login with nonexistent (indirect from usernick) user name
'gerberb@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@zenez.com> 801 849-0213
ZENEZ 1042 East Fort Union #135, Midvale Utah 84047
_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users