mwdewitt (@mwdewitt)

Forum Replies Created

Viewing 8 replies - 1 through 8 (of 8 total)
  • In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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.

    In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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.

    In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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.

    In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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.

    In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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!

    In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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!

    In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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

    In reply to: Cookies, Salt, User Database

    mwdewitt
    Member

    @mwdewitt

    13 years, 9 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

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