[ic] Problem after OS ... New Error after doing your suggestion.

[Boyd Lynn Gerber]

On Thu, 12 Feb 2015, Peter wrote:
> On 02/12/2015 01:09 PM, Boyd Lynn Gerber wrote:
>> 208.110.143.17 MHe5oMoH:208 - [11/February/2015:14:54:57 -0700]
>> lyndistributing /cgi-bin/lyndistributing/ord/finalize.html set_row error
>> as called by Vend::Table::DBI: DBD::mysql::db do failed: Field
>> 'password' doesn't have a default value at
>> /usr/local/interchange/lib/Vend/Table/DBI.pm line 1399.
>
> By the looks of it, either (1) the newer version of MySQL has a minor
> incompatibility with the older version where you now have to have a
> default value when a field is left blank instead of just assuming it's
> NULL, or (2) when you transferred teh db over the default setting for
> the field didn't transfer with it.
>
> I would try this in the mysql shell:
> ALTER TABLE userdb ALTER password SET DEFAULT '';

Thanks, no I am getting this error

Failed to record timestamp in UserDB: DBD::mysql::st execute failed:
Incorrect datetime value: '1423715746' for column 'mod_time' at row 1 at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1741.


-- 
Boyd Gerber <gerberb at zenez.com> 801 849-0213
ZENEZ   1042 East Fort Union #135, Midvale Utah  84047