boardom

[Amberina]

I had this error message when installing B2...

Now creating the necessary tables in the database...


doh, can't create the table "b2posts" in the database.

query:
CREATE TABLE b2posts ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) DEFAULT '0' NOT NULL, post_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, post_content text NOT NULL, post_title text NOT NULL, post_category int(4) DEFAULT '0' NOT NULL, post_karma int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (ID), UNIQUE ID (ID) )

error:
Table 'b2posts' already exists
[/i]

[lolita]

try changing the config file, where it says

# database tables' names (change them if you want to have multiple b2's in a single database)
$tableposts = 'b2posts';
$tableusers = 'b2users';
$tablesettings = 'b2settings';
$tablecategories = 'b2categories';
$tablecomments = 'b2comments';

change the names (or do what I do and add an extra 's' to each name) ie. # database tables' names (change them if you want to have multiple b2's in a single database)
$tableposts = 'b2postss';
$tableusers = 'b2userss';
$tablesettings = 'b2settingss';
$tablecategories = 'b2categoriess';
$tablecomments = 'b2commentss';

Hope that helps..
do you already have b2 on your website somewhere?