bbPress

Info

• 5 posts
• 3 voices
• Started 3 years ago by csseur3
• Latest reply from csseur3
• This topic is resolved

Tags

• alpha
• collation
• trunk

• Posts in this topic

Impossible to install bbpress revision 1595

1. • 
   • csseur3
   • Member

   • Posted 3 years ago #

   Hello,

   with the last installation of bbpress revision 1595, i have sql errors:

   SQL ERROR!
   >>> Database: forum_bbpress (localhost)
   >>>>>> CREATE TABLE IF NOT EXISTS bb_forums (
   forum_id int(10) NOT NULL auto_increment,
   forum_name varchar(150) NOT NULL default '',
   forum_slug varchar(255) NOT NULL default '',
   forum_desc text NOT NULL,
   forum_parent int(10) NOT NULL default 0,
   forum_order int(10) NOT NULL default 0,
   topics bigint(20) NOT NULL default 0,
   posts bigint(20) NOT NULL default 0,
   PRIMARY KEY (forum_id),
   KEY forum_slug (forum_slug)
   ) DEFAULT CHARACTER SET 'utf8' COLLATE '';
   >>>>>> Unknown collation: ''
   SQL ERROR!
   >>> Database: forum_bbpress (localhost)
   >>>>>> CREATE TABLE IF NOT EXISTS bb_meta (
   meta_id bigint(20) NOT NULL auto_increment,
   object_type varchar(16) NOT NULL default 'bb_option',
   object_id bigint(20) NOT NULL default 0,
   meta_key varchar(255) default NULL,
   meta_value longtext default NULL,
   PRIMARY KEY (meta_id),
   KEY object_type__meta_key (object_type, meta_key),
   KEY object_type__object_id__meta_key (object_type, object_id, meta_key)
   ) DEFAULT CHARACTER SET 'utf8' COLLATE '';
   >>>>>> Unknown collation: ''
   SQL ERROR!

   etc, etc...

   why?

   bye
2. • 
   • _ck_
   • Moderator

   • Posted 3 years ago #

   Er that's the trunk and subject to being broken at times.

   I don't recommend you go beyond the 0.9 branch:
   http://trac.bbpress.org/browser/branches/0.9
   or if you are using svn
   http://svn.automattic.com/bbpress/branches/0.9/
3. • 
   • Sam Bauers
   • Key Master

   • Posted 3 years ago #

   My guess is that you didn't specify a charset collation for the database on install.

   I've just made a change that should fix your problem (if that was it).
4. • 
   • _ck_
   • Moderator

   • Posted 3 years ago #

   I've confirmed the newest trunk build now fixes this problem (at least for me)

   build # 1598
5. • 
   • csseur3
   • Member

   • Posted 3 years ago #

   yes, it works now, but the adress of the site is not show at the end of install :)

   bye

6. You must log in to post.