Fresh install of IC 5.10.0 from git clone and other adding new users failure in Admin an other locations
Boyd Lynn Gerber <[email protected]>
| Newsgroups | gmane.comp.web.interchange.users |
|---|---|
| Message-ID | <[email protected]> |
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','','','','','','','[email protected]','','','','','','','','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 <[email protected]> 801 849-0213 ZENEZ 1042 East Fort Union #135, Midvale Utah 84047