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)