Hi,I hadn't seen that warning, but you can change so that field has blank as a default:
alter table confirm_address modify column address_extra varchar(255) not null default '' comment 'carrier ID, for SMS';
Or switch from not null to allow nulls of course.It's possible you'll only get this as an error if you've configured MySQL in a strict mode, or PEAR is more sensitive than MySQL itself. When I tried the query below directly in the mysql cli it inserted fine, but logged the warning as well.
MvH, cisnky wrote:
I get the following error when I try to register with my local dev instance."The database for Laconica isn't responding correctly, so the site won't work properly. The site admins probably know about the problem"I've checked the logs and it reports back a warning.2009-03-24 16:04:21 LOG_WARNING: PEAR error: DB Error: unknown error : INSERT INTO confirm_address (code , user_id , address , address_type ) VALUES ('VXEYCDZC6L8TV36W7S8DV4TJVC' , 1 , '[email protected] <mailto:[email protected]>' , 'email' ) [nativecode=1364 ** Field 'address_extra' doesn't have a default value]Data is being written to the profile table. I switched on debug and that returns; || DB_DataObject: ERROR: No Data return from get .... All the db permissions are correct.Server Setup: Windows XP, Apache/2.2.11 (Win32), PHP/5.2.9-1, MySQL client version: 5.0.51aHas anyone come across a similar problem or know of a solution? Thanks. Regards Cisnky. ------------------------------------------------------------------------ _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
