Cookies, Salt, User Database
-
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!
-
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
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
Can you try this once – http://blog.ashfame.com/2009/07/integrate-bbpress-10-with-wordpress-28/
Can you try this once – http://blog.ashfame.com/2009/07/integrate-bbpress-10-with-wordpress-28/
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!
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!
Try using a new set of zip archive
Try using a new set of zip archive
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.
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.
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.
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.
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.
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.
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
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
Original poster must be using MySQL 5.5. The TYPE = MYISAM syntax has been removed; https://trac.bbpress.org/ticket/1486/
Original poster must be using MySQL 5.5. The TYPE = MYISAM syntax has been removed; https://trac.bbpress.org/ticket/1486/
- You must be logged in to reply to this topic.