Travis McArthur wrote:
Creating tables...Query "CREATE TABLE user ( user_id int(5) unsigned NOT NULL auto_increment, user_name varchar(255) binary NOT NULL default '''', user_real_name varchar(255) binary NOT NULL default '''', user_rights tinyblob NOT NULL default '''', user_password tinyblob NOT NULL default '''', user_newpassword tinyblob NOT NULL default '''', user_email tinytext NOT NULL default '''', user_options blob NOT NULL default '''', user_touched char(14) binary NOT NULL default '''', UNIQUE KEY user_id (user_id) ) PACK_KEYS=1" failed with error code "BLOB/TEXT column 'user_rights' can't have a default value".
Sorry this took a while, Travis, but it's one of those insidious PHP configuration problems that's hard to track down unless you already know the secret. :P
It looks like your PHP configuration has the magic_quotes_runtime and magic_quotes_sybase options turned on. These corrupt data input in hard to predict ways and should probably never be used; any application that relies upon them is probably flawed, and any application that doesn't will have its corrupted unexpectedly.
Turn them both off in your php.ini and it should clear things up.
-- brion vibber (brion @ pobox.com)