Skip to:
Content
Pages
Categories
Search
Top
Bottom

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!

Viewing 18 replies - 1 through 18 (of 18 total)
  • 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

    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/

Viewing 18 replies - 1 through 18 (of 18 total)
  • You must be logged in to reply to this topic.
Skip to toolbar