Jump to content


Photo

bbpress forum


This topic has been archived. This means that you cannot reply to this topic.
8 replies to this topic

#1 mrdarcytaylordarcycom

mrdarcytaylordarcycom

    Member

  • Members
  • PipPip
  • 28 posts

Posted 19 October 2010 - 10:32 PM

Okay I posted the following over at the bbpress forum and nothing so far, I thought just in case someone else had the same problem I would post it over here as well. This is the first time I have attempted to use a forum so please be patient with me. I followed the directions just as was instructed on both this website and the bbpress forum website to no avail. Here is the copy of the post: I am trying to install bbpress for my website and unfortunately it doesn't seem to matter what I put in the boxes I get the following error(s). Now I am not trying to integrate it with WordPress just yet so it should be fairly straight forward (however it apparently is not). Any help and suggestions would be greatly appreciated. Oh, and I have tried disabling all my security features and that didn't work either. Knowing my luck it is something stupid and it will work like a charm in two seconds but whatever it is, I'm not seeing an immediate solution to the problem. Here is the code: SQL ERROR! >>> Database: taylordarcy_com (mysql.taylordarcy.com) >>>>>> CREATE TABLE IF NOT EXISTS wp_7w6sfp_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 'DB_CHARSET' COLLATE 'DB_COLLATE'; >>>>>> Unknown character set: 'DB_CHARSET' SQL ERROR! >>> Database: taylordarcy_com (mysql.taylordarcy.com) >>>>>> CREATE TABLE IF NOT EXISTS wp_7w6sfp_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, 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 'DB_CHARSET' COLLATE 'DB_COLLATE'; >>>>>> Unknown character set: 'DB_CHARSET' SQL ERROR! >>> Database: taylordarcy_com (mysql.taylordarcy.com) >>>>>> CREATE TABLE IF NOT EXISTS wp_7w6sfp_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 'DB_CHARSET' COLLATE 'DB_COLLATE'; >>>>>> Unknown character set: 'DB_CHARSET' SQL ERROR! >>> Database: taylordarcy_com (mysql.taylordarcy.com) >>>>>> CREATE TABLE IF NOT EXISTS wp_7w6sfp_bb_terms ( term_id bigint(20) NOT NULL auto_increment, name varchar(55) NOT NULL default '', slug varchar(200) NOT NULL default '', term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), UNIQUE KEY slug (slug), KEY name (name) ) DEFAULT CHARACTER SET 'DB_CHARSET' COLLATE 'DB_COLLATE'; >>>>>> Unknown character set: 'DB_CHARSET' SQL ERROR! >>> Database: taylordarcy_com (mysql.taylordarcy.com) >>>>>> CREATE TABLE IF NOT EXISTS wp_7w6sfp_bb_term_relationships ( object_id bigint(20) NOT NULL default 0, term_taxonomy_id bigint(20) NOT NULL default 0, user_id bigint(20) NOT NULL default 0, term_order int(11) NOT NULL default 0, PRIMARY KEY (object_id, term_taxonomy_id), KEY term_taxonomy_id (term_taxonomy_id) ) DEFAULT CHARACTER SET 'DB_CHARSET' COLLATE 'DB_COLLATE'; >>>>>> Unknown character set: 'DB_CHARSET' SQL ERROR! >>> Database: taylordarcy_com (mysql.taylordarcy.com) >>>>>> CREATE TABLE IF NOT EXISTS wp_7w6sfp_bb_term_taxonomy ( term_taxonomy_id bigint(20) NOT NULL auto_increment, term_id bigint(20) NOT NULL default 0, taxonomy varchar(32) NOT NULL default '', description longtext NOT NULL, parent bigint(20) NOT NULL default 0, count bigint(20) NOT NULL default 0, PRIMARY KEY (term_taxonomy_id), UNIQUE KEY term_id_taxonomy (term_id, taxonomy), KEY taxonomy (taxonomy) ) DEFAULT CHARACTER SET 'DB_CHARSET' COLLATE 'DB_COLLATE'; >>>>>> Unknown character set: 'DB_CHARSET' SQL ERROR! >>> Database: taylordarcy_com (mysql.taylordarcy.com) >>>>>> CREATE TABLE IF NOT EXISTS wp_7w6sfp_bb_topics ( topic_id bigint(20) NOT NULL auto_increment, topic_title varchar(100) NOT NULL default '', topic_slug varchar(255) NOT NULL default '', topic_poster bigint(20) NOT NULL default 0, topic_poster_name varchar(40) NOT NULL default 'Anonymous', topic_last_poster bigint(20) NOT NULL default 0, topic_last_poster_name varchar(40) NOT NULL default '', topic_start_time datetime NOT NULL default '0000-00-00 00:00:00', topic_time datetime NOT NULL default '0000-00-00 00:00:00', forum_id int(10) NOT NULL default 1, topic_status tinyint(1) NOT NULL default 0, topic_open tinyint(1) NOT NULL default 1, topic_last_post_id bigint(20) NOT NULL default 1, topic_sticky tinyint(1) NOT NULL default 0, topic_posts bigint(20) NOT NULL default 0, tag_count bigint(20) NOT NULL default 0, PRIMARY KEY (topic_id), KEY topic_slug (topic_slug), KEY forum_time (forum_id, topic_time), KEY user_start_time (topic_poster, topic_start_time), KEY stickies (topic_status, topic_sticky, topic_time) ) DEFAULT CHARACTER SET 'DB_CHARSET' COLLATE 'DB_COLLATE'; >>>>>> Unknown character set: 'DB_CHARSET' Database installation failed!!!

#2 mrdarcytaylordarcycom

mrdarcytaylordarcycom

    Member

  • Members
  • PipPip
  • 28 posts

Posted 21 October 2010 - 09:04 PM

bump

#3 cmunns

cmunns

    Advocate

  • Members

  • 6537 posts

Posted 21 October 2010 - 10:18 PM

Are you trying to integrate during install? Try a fresh install first. then integrate after

#4 mrdarcytaylordarcycom

mrdarcytaylordarcycom

    Member

  • Members
  • PipPip
  • 28 posts

Posted 22 October 2010 - 03:35 PM

Nope, I was just trying to install without integration. I figured I wanted to kick the tires a bit and see how it went before I did the integration and I can't even get past the initial set up. Oh and bbpress.org is less than helpful. I've posted over there and they haven't responded and I searched for a similar situation and couldn't find one that mirrors my own.

#5 mrdarcytaylordarcycom

mrdarcytaylordarcycom

    Member

  • Members
  • PipPip
  • 28 posts

Posted 22 October 2010 - 03:53 PM

It would appear that the following is the problem, once it reaches this point it stops on an error >>>>>> Unknown character set: 'DB_CHARSET' Any suggestions on what this could be or mean? I've installed a new bbpress and I still get the same error.

#6 arpowers

arpowers

    Founder

  • Administrators
  • 3270 posts

Posted 22 October 2010 - 08:21 PM

I guess an interesting question would be which host you're on? it appears to be a server/DB related issue.

#7 mrdarcytaylordarcycom

mrdarcytaylordarcycom

    Member

  • Members
  • PipPip
  • 28 posts

Posted 22 October 2010 - 09:02 PM

I'm on Dreamhost (ironic isn't it). If that is the case I'll give them a call.

#8 mrdarcytaylordarcycom

mrdarcytaylordarcycom

    Member

  • Members
  • PipPip
  • 28 posts

Posted 23 October 2010 - 06:52 AM

So after all is said and done, I had to pay someone to fix it for me as no one could come up with a solution. It would have taken me weeks to figure out what was wrong. In case someone else needs help with this, this is what the repairman said: The problem you encountered was actually two issues. Your current wp-config.php file did not have various definitions for keys and salts that are part of WordPress, I forced the system to regenerate the config and those were created. Second, I had to remove the current bb-config.php file and save all the settings in order to fix the SQL error. I hope this helps someone else if they have the same error. If anyone needs the place let me know and I'll give you the information.

#9 onlinetracker

onlinetracker

    Super Member

  • Members

  • 154 posts

Posted 24 October 2010 - 01:53 AM

Sounds like a hiccup during the installation because those keys/salts aren't created by default to begin with, they are created if you want them, or if you are doing deep integration but in either case, you have to go to a WP site to generate those keys. Glad you got it fixed, but all they have to do is look in the wp-config.php file to see the location of the key generator. It isn't a big secret. ' * Authentication Unique Keys. * * Change these to different unique phrases! * You can generate these using the {@link https://api.wordpres...secret-key/1.1/ WordPress.org secret-key service} * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.'