[ic] Problem after OS upgrade from 12.3 to 13.2 openSUSE

[Peter]

On 02/12/2015 01:09 PM, Boyd Lynn Gerber wrote:
> Everything seems to be working exept the userdb stuff.  There was a
> MySQL version update.
> 
> 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 '';

After that the error should go away.


Peter