[ic] Problem after OS upgrade from 12.3 to 13.2 openSUSE
peter at pajamian.dhs.org
Thu Feb 12 02:34:21 UTC 2015
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.
> 220.127.116.11 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.
More information about the interchange-users