[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
> (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
> 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 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.
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