I am new to this and I am trying to integrate WordPress and bbPress, but I am having a few issues. How do I find out what the WordPress “auth” cookie key is, along with the WordPress “secure auth” cookie key, and WordPress “logged in” cookie key, including all of the “cookie salt.” Also, what should the user database table prefix be (right now it is wp_) and what is the WordPress MU primary blog ID? If someone could explain all of this to me, I would greatly appreciate it. Thank you in advance!

[@mwdewitt Member 13 years, 10 months ago]

Okay, I figured out I had to go to my wp-config file where I installed WordPress to find all that stuff. Okay, now I have a new problem. Now that I have bbPress installed, it is giving me this error:

SQL ERROR!

>>> Database: acidhouse-forums (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts

(

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

And when I try to go to bb-login it gives me a 404 error, saying that the page was not found. Okay, what did I do wrong?

I am running…

Windows XP SP3

Apache 2.2.17

PHP 5.3.5

MySQL 5.5.8

[@mwdewitt Member 13 years, 10 months ago]

Okay, I figured out I had to go to my wp-config file where I installed WordPress to find all that stuff. Okay, now I have a new problem. Now that I have bbPress installed, it is giving me this error:

SQL ERROR!

>>> Database: acidhouse-forums (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts

(

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

And when I try to go to bb-login it gives me a 404 error, saying that the page was not found. Okay, what did I do wrong?

I am running…

Windows XP SP3

Apache 2.2.17

PHP 5.3.5

MySQL 5.5.8

[@ashfame Participant 13 years, 10 months ago]

Can you try this once – http://blog.ashfame.com/2009/07/integrate-bbpress-10-with-wordpress-28/

[@ashfame Participant 13 years, 10 months ago]

Can you try this once – http://blog.ashfame.com/2009/07/integrate-bbpress-10-with-wordpress-28/

[@mwdewitt Member 13 years, 10 months ago]

I followed the directions to a “T” on your website. The install went fine until I wanted to finish everything up. Then it spits out this error message:

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts (

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

I checked both the wp-config and bb-config file and the keys match up perfectly. I do not know what I am doing wrong here!

[@mwdewitt Member 13 years, 10 months ago]

I followed the directions to a “T” on your website. The install went fine until I wanted to finish everything up. Then it spits out this error message:

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts (

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_users ADD PRIMARY KEY (ID);

>>>>>> Multiple primary key defined

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta DROP PRIMARY KEY;

>>>>>> Incorrect table definition; there can be only one auto column and it must be defined as a key

SQL ERROR!

>>> Database: acidhouse (localhost)

>>>>>> ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id);

>>>>>> Multiple primary key defined

Key master email not sent!

I checked both the wp-config and bb-config file and the keys match up perfectly. I do not know what I am doing wrong here!

[@ashfame Participant 13 years, 10 months ago]

Try using a new set of zip archive

[@ashfame Participant 13 years, 10 months ago]

Try using a new set of zip archive

[@mwdewitt Member 13 years, 10 months ago]

Nothing is zipped. It is all unzipped into a directory called “acidhouse” and ready to rock. Or maybe I am not understanding what you are saying. But at least I can get to the forum now, along with simultaneously being signed into my WordPress Admin and my bbPress Admin. The only difference is, this time it lets me see my forum where as before it would give me an error. So there is a little bit of progress, but I would still like to know how to get rid of the SQL errors.

[@mwdewitt Member 13 years, 10 months ago]

Nothing is zipped. It is all unzipped into a directory called “acidhouse” and ready to rock. Or maybe I am not understanding what you are saying. But at least I can get to the forum now, along with simultaneously being signed into my WordPress Admin and my bbPress Admin. The only difference is, this time it lets me see my forum where as before it would give me an error. So there is a little bit of progress, but I would still like to know how to get rid of the SQL errors.

[@ashfame Participant 13 years, 10 months ago]

I meant a new copy of bbPress files. I am not sure about the SQL errors, “ALTER TABLE wp_users DROP PRIMARY KEY;”

AFAIK, this shouldn’t happen.

[@ashfame Participant 13 years, 10 months ago]

I meant a new copy of bbPress files. I am not sure about the SQL errors, “ALTER TABLE wp_users DROP PRIMARY KEY;”

AFAIK, this shouldn’t happen.

[@mwdewitt Member 13 years, 10 months ago]

I think I am going to uninstall bbPress for now and wait until they make it into a plug-in for WordPress, which they said might happen as early as next month. So, hopefully the whole process will be a lot simpler.

[@mwdewitt Member 13 years, 10 months ago]

I think I am going to uninstall bbPress for now and wait until they make it into a plug-in for WordPress, which they said might happen as early as next month. So, hopefully the whole process will be a lot simpler.

[@ashfame Participant 13 years, 10 months ago]

And I can see how much time it will take to have some plugins to extend the slim barebones functionality it have right now. Cmon get on with it again and try

[@ashfame Participant 13 years, 10 months ago]

And I can see how much time it will take to have some plugins to extend the slim barebones functionality it have right now. Cmon get on with it again and try

[@djpaul Participant 13 years, 9 months ago]

Original poster must be using MySQL 5.5. The TYPE = MYISAM syntax has been removed; https://trac.bbpress.org/ticket/1486/

[@djpaul Participant 13 years, 9 months ago]

Original poster must be using MySQL 5.5. The TYPE = MYISAM syntax has been removed; https://trac.bbpress.org/ticket/1486/