bbPress

Info

• 6 posts
• 3 voices
• Started 9 months ago by pmcdonald
• Latest reply from pmcdonald
• This topic is resolved

Tags

• Posts in this topic

Installation problem

1. • 
   • pmcdonald
   • Member

   • Posted 9 months ago #

   I followed the instructions to install and got this error that I need help interpreting and resolving:
   SQL ERROR!
   >>> Database: wildfelid (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

   The setup did not create the necessary tables in my database for some reason even though the access details are correct.
2. • 
   • Ashfame
   • Moderator

   • Posted 9 months ago #

   Not sure but I doubt it has something to do with the database collation. Try installing with a database which has its collation set to utf8_unicode_ci
3. • 
   • pmcdonald
   • Member

   • Posted 9 months ago #

   Thanks. When I returned this evening the database was magically populated with the bbPress tables. Any idea why I would get that kind of error during installation, then somehow it fixes itself? I'm assume it's fixed anyway, I haven't yet taken it for a test run but should be OK. Very strange.
4. • 
   • singaporeinterior
   • Member

   • Posted 9 months ago #

   Singapore Interior Design & Furniture Hub,
   provides One stop interior design,
   renovation contractors,
   carpet and production of office furniture leader in offices,
   factories & retail interior design and renovation …..

   [url=http://www.singaporeinterior.com/Carpet/Carpet.htm]renovation contractors[/url] | [url=http://www.singaporeinterior.com/Carpet/Carpet.htm]interior design[/url] | [url=http://www.singaporeinterior.com/Carpet/Carpet.htm]interior designers[/url]
5. • 
   • pmcdonald
   • Member

   • Posted 9 months ago #

   Uh-oh I thought one of the strong points of bbPress was supposed to be its security. Looks like a bit of a breach here.
6. • 
   • pmcdonald
   • Member

   • Posted 9 months ago #

   Actually after reading something else, it would probably be good for me to validate if all of the tables installed. The ones that did are:
   bb_forums
   bb_meta
   bb_terms
   bb_term_relationships
   bb_term_taxonomy
   bb_topics
   bb_usermeta
   bb_users

   Can someone tell me if these are all of the tables that should have installed to my database. I read in another forum (a bit dated) that there should be a bb_post table and wondered if that were correct for the current bbPress or are any other tables missing? Thank you.

7. You must log in to post.