Skip to:
Content
Pages
Categories
Search
Top
Bottom

Cookies, Salt, User Database


  • mwdewitt
    Member

    @mwdewitt

    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)

  • mwdewitt
    Member

    @mwdewitt

    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

    @mwdewitt

    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

    @ashfame


    Ashfame
    Participant

    @ashfame


    mwdewitt
    Member

    @mwdewitt

    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

    @mwdewitt

    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

    @ashfame

    Try using a new set of zip archive


    Ashfame
    Participant

    @ashfame

    Try using a new set of zip archive


    mwdewitt
    Member

    @mwdewitt

    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

    @mwdewitt

    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

    @ashfame

    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

    @ashfame

    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

    @mwdewitt

    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

    @mwdewitt

    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

    @ashfame

    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

    @ashfame

    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


    Paul Gibbs
    Participant

    @djpaul

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


    Paul Gibbs
    Participant

    @djpaul

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

Viewing 18 replies - 1 through 18 (of 18 total)

You must be logged in to reply to this topic.