bbPress.org

Can’t find any post about this error and my SQL is quite rusted.

Fresh install, no WP integration, MySQL 5.0.40

SQL ERROR!

>>> Database: forums (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_vj_usermeta (

umeta_id bigint(20) NOT NULL auto_increment,

user_id bigint(20) NOT NULL default 0,

meta_key default NULL,

meta_value default NULL,

PRIMARY KEY (umeta_id),

KEY user_id (user_id),

KEY meta_key (meta_key)

) DEFAULT CHARACTER SET ‘utf8’;

>>>>>> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘default NULL,

meta_value default NULL,

PRIMARY KEY (umeta_id),

KEY `user_’ at line 4

Forum could not be created!