Hey guys, I just installed bbPress and everything to go fine but no matter what user i use to make a post or a topic I end up with the same results:

I can create forums, and topics but no posts, including the initial post for a topic, are showing up. You see the list of topics but when you click them it only shows the title of the topic with no posts. What’s odd is that on the forum itself it keeps track of the number of posts you supposedly posted… they just don’t show up. Even stranger is that even though on the forums the number of missing posts are still counted, when you go to the admin panel and go to posts it shows no posts (forums and topics show up in the admin panel fine).

Any help would be gladly appreciated.

[@yunglion Member 13 years, 9 months ago]

hey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:

SQL ERROR!

>>> Database: xxxxxxxx (127.0.0.1)

>>>>>> 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

[@yunglion Member 13 years, 9 months ago]

hey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:

SQL ERROR!

>>> Database: xxxxxxxx (127.0.0.1)

>>>>>> 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

[@asboyd Member 13 years, 8 months ago]

I am having the same issue and have checked the MySQL database it seems there is no table for the posts, so the titles get saved but not the contents.

Could someone from the BBPress team help out here?

Cheers,

AlexB

[@asboyd Member 13 years, 8 months ago]

I am having the same issue and have checked the MySQL database it seems there is no table for the posts, so the titles get saved but not the contents.

Could someone from the BBPress team help out here?

Cheers,

AlexB

[@yunglion Member 13 years, 8 months ago]

hey asboyd do you have phpmyadmin or any other database management? if so select the database and go to execute and execute the same exact code that gave u the error… should be the same as mine. Only this time change the last line to:

ENGINE = MYISAM DEFAULT CHARACTER SET 'utf8';

basically changing TYPE to ENGINE. That will correct everything. good luck.

PS thanks to Super Artsy in the topic below for posting the solution.

https://bbpress.org/forums/topic/db-posts-table-not-installing?replies=4#post-86225

[@yunglion Member 13 years, 8 months ago]

hey asboyd do you have phpmyadmin or any other database management? if so select the database and go to execute and execute the same exact code that gave u the error… should be the same as mine. Only this time change the last line to:

ENGINE = MYISAM DEFAULT CHARACTER SET 'utf8';

basically changing TYPE to ENGINE. That will correct everything. good luck.

PS thanks to Super Artsy in the topic below for posting the solution.

https://bbpress.org/forums/topic/db-posts-table-not-installing?replies=4#post-86225

[@asboyd Member 13 years, 8 months ago]

YungLion,

I ended up creating the table manually. Using the error information.

So now I can use the bbpress forum but I have raised a new problem regarding navigation links…

Cheers,

AlexB

[@asboyd Member 13 years, 8 months ago]

YungLion,

I ended up creating the table manually. Using the error information.

So now I can use the bbpress forum but I have raised a new problem regarding navigation links…

Cheers,

AlexB