boardom :: View topic - b2post error?

boardom
b2 message board

FAQ

Memberlist

Usergroups

Profile

b2post error?

boardom Forum Index -> Installation issues

View previous topic :: View next topic

Author

Message

noie

Joined: 02 Jan 2004
Posts: 5

Posted: Mon Aug 16, 2004 10:12 pm Post subject: b2post error?

I am reinstalling because of some problems I was having. When I went to run the install file, I got this error, and I've never seen this one before! Any ideas?

Quote:

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

Thanks in advance!

stevem

Joined: 15 Mar 2003
Posts: 241

Posted: Tue Aug 17, 2004 12:37 pm Post subject: Re: b2post error?

Quote:

error:
Table 'b2posts' already exists

That's not a problem. That table is already there so doesn't need recreating. But it also stops the installation process so you have 2 options:

1. If you want to keep all your old posts then in b2install.php comment out the line that stops the installation. Replace

Code:

function mysql_doh($msg,$sql,$error) {
echo "$msg";
echo "query: $sql";
echo "error: $error";
die();
}

Code:

function mysql_doh($msg,$sql,$error) {
echo "$msg";
echo "query: $sql";
echo "error: $error";
// die();
}

(just put // on the line saying die();
OR
2. If you want to clean out the old posts and recreate the tables in the database then remove all the // at the beginning of various lines (there are 10 of them)

Then re-run the installer

Display posts from previous:

	boardom Forum Index -> Installation issues	All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum