Search Results for '+.+default+.+'
-
Search Results
-
Topic: Step Two Database Error
Hi,
I just installed bbPress and on STEP TWO I got a screen with the error below. I’m not a programmer or anything, I just know basic HTML and that’s it, so I don’t know where to look for a way to fix this. Can anyone give me some pointers on how to fix this? Or is there a service where I can pay to have this fixed and running smoothly? Thanks!
bbPress database error
Second Step
Now we’re going to create the database tables and fill them with some default data.
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE bb_forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default '', forum_desc text NOT NULL, 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) )
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE 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_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time), FULLTEXT KEY post_text (post_text) ) TYPE = MYISAM
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE bb_topics ( topic_id bigint(20) NOT NULL auto_increment, topic_title varchar(100) 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 forum_id (forum_id), KEY topic_time (topic_time), KEY topic_start_time (topic_start_time) )
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE bb_topicmeta ( meta_id bigint(20) NOT NULL auto_increment, topic_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY user_id (topic_id), KEY meta_key (meta_key) )
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE bb_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default '', user_pass varchar(64) NOT NULL default '', user_nicename varchar(50) NOT NULL default '', user_email varchar(100) NOT NULL default '', user_url varchar(100) NOT NULL default '', user_registered datetime NOT NULL default '0000-00-00 00:00:00', user_status int(11) NOT NULL default '0', display_name varchar(250) NOT NULL default '', PRIMARY KEY (ID), UNIQUE KEY user_login (user_login) )
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE bb_usermeta ( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) )
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE bb_tags ( tag_id bigint(20) unsigned NOT NULL auto_increment, tag varchar(200) NOT NULL default '', raw_tag varchar(50) NOT NULL default '', tag_count bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (tag_id) )
bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
CREATE TABLE bb_tagged ( tag_id bigint(20) unsigned NOT NULL default '0', user_id bigint(20) unsigned NOT NULL default '0', topic_id bigint(20) unsigned NOT NULL default '0', tagged_on datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (tag_id,user_id,topic_id), KEY tag_id_index (tag_id), KEY user_id_index (user_id), KEY topic_id_index (topic_id) )
1. Created table bb_forums
2. Created table bb_posts
3. Created table bb_topics
4. Created table bb_topicmeta
5. Created table bb_users
6. Created table bb_usermeta
7. Created table bb_tags
8. Created table bb_tagged
bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist]
SELECT * FROM bb_topicmeta WHERE topic_id = '0' AND meta_key = 'bb_db_version'
bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist]
INSERT INTO bb_topicmeta ( topic_id, meta_key, meta_value ) VALUES ( '0', 'bb_db_version', '688' )
bbPress database error: [Table 'mysql.bb_users' doesn't exist]
INSERT INTO bb_users (user_login, user_pass, user_email, user_url, user_registered) VALUES ('daniel', 'fae46cfefe5fb87eedf6f8801e497d06', 'daniel@boomanfloral.com', 'http://boomanfloral.com', '2007-03-14 22:01:31')
bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'from'
bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'from', 'Vista, CA' )
bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'interest'
bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'interest', 'Unusual Plants & Internet' )
bbPress database error: [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 ' '', , '', '2007]
INSERT INTO bb_topics (topic_title, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id) VALUES ('Your first topic', , '', , '', '2007-03-14 22:01:31', '2007-03-14 22:01:31', 1)
bbPress database error: [Table 'mysql.bb_topics' doesn't exist]
SELECT * FROM bb_topics WHERE topic_id = 0 AND topic_status = 0
bbPress database error: [Table 'mysql.bb_forums' doesn't exist]
UPDATE bb_forums SET topics = topics + 1 WHERE forum_id = 1
bbPress database error: [Table 'mysql.bb_topics' doesn't exist]
SELECT * FROM bb_topics WHERE topic_id = 1 AND topic_status = 0
Finished!Topic: User ID = 999999999?
I have recently integrated a bbpress install with an existing wordpress blog/site. The WP blog had three users prior to the integration, and all three made it over to the bbpress install with no problems. However, today a new user registered on the WP side and her ID defaulted to 999999999.
I proceeded to register a “dummy” user, just to see what happened. The next registration ticked up to user ID #1000000000. While I doubt that this will lead to any serious problems, it seems silly to me to have user IDs starting around ONE BILLION, when even 1,000 would be plenty high enough for my lil’ ol’ site. Having McDonald’s-esque “XX billions served” sized numbers seems to fly in the face of the “Code is poetry” mantra.
Any ideas as to what’s going on here?
Very simple way to softly resize your images: go to your theme’s folder, open
style.css, and copy in this code at the bottom:img {
max-width: 600px;
max-height: 800px;
}You can change this to any values you like, but I think 600px width works with the default theme at least. Make sure there are no spaces between the number and the
px. If you don’t care about height you can just take that line out. Any bigger images will be scaled down automatically – they will still load at full resolution/size, but they will display smaller.
Judging by the wordpress system (the documentation is quite good), 10 is default priority and plugins are executed in order of descending priority (so a plugin of 1 comes before 2). In WP the last two arguments are optional.
Preview sounds good – but better yet would be an AJAX thing that means you don’t even have to reload the page when you post.
Topic: Can’t Switch Themes in 0.8.1
I can’t use a custom these after upgrading to 0.8.1.
Under the presentation tab it lists my custom theme, but with this URL:
http:// forum.mybbpress.com/bb-admin/themes.php? theme=C:\WWW\PUBLIC\forums.mybbpress.com/ bb-templates/mytheme/&_wpnonce=36ec0251eb
How can I eliminate the extra slashes and the reference to the absolute path?
The default theme is working, and it works great, but I’d like to be able to use my custom theme again!
