[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 

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 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.


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