[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
Wed Jan 25 02:28:26 UTC 2017

On Monday 2017-01-23 23:23, Boyd Lynn Gerber wrote:

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

I was wrong it is not b_state but usernick being ''

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

The is when placing an order in the logs shows usernick as being '' and 
it is not allowed.

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