[ic] Fresh install of IC 5.10.0 from git clone and other adding new users failure in Admin an other locations
Boyd Lynn Gerber
gerberb at zenez.com
Tue Jan 24 06:23:53 UTC 2017
I am having issues on a fresh install of IC from git using the strap
demo.
I do the install, everything installs no errors. Then I get an error
from the Admin on create a new user.
The error message on the admin page is
table userdb: set_slice error as called by Vend::Data: DBD::mysql::st
execute failed: Field 'usernick' doesn't have a default value at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1448. query was:insert
into userdb (`username`,`b_state`,`s_nickname`,`phone_night`,`mv_shipmode`,`preferences`,`price_level`,`zip`,`fname`,`p_nickname`,`b_address1`,`mail_list`,`address3`,`address1`,`password`,`carts`,`lname`,`b_lname`,`address_book`,`file_acl`,`credit_limit`,`email`,`state`,`b_address3`,`accounts`,`b_address2`,`city`,`company`,`dealer`,`phone_day`,`country`,`b_company`,`b_zip`,`address2`,`acl`,`b_nickname`,`inactive`,`b_country`,`mod_time`,`b_phone`,`b_city`,`db_acl`,`fax`,`b_fname`,`owner`)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
values were:'00002','','','801-295-5022','','','','','','','','offer newsletter alert upgrade','','','sh8835','','','','','','','sales at lyndist.com','','','','','','','','801-295-5022','','','','','','','','','','','','','','',''
So the problem is on second '', which should be the email not '' null if
`b_state` were email there would not be a failure
the strap userdb txt has usernick with email I think the problem is
usernick 198.144.111.124 Denied attempted login with nonexistent
(indirect from usernick) user name 'U00014'
This issue also happens on checkout of the strap demo. The logs always
show '' which needs to have a value and be Unique.
Thanks,
--
Boyd Gerber <gerberb at zenez.com> 801 849-0213
ZENEZ 1042 East Fort Union #135, Midvale Utah 84047
More information about the interchange-users
mailing list