http://bbpress.org/forums/ bbPress Support Forums Tag: wp_ en Sat, 10 Jan 2009 00:54:17 +0000 http://bbpress.org/forums/topic/wpbb-integration-admin-problem#post-17138 Wed, 09 Jul 2008 02:57:19 +0000 sambauers 17138@http://bbpress.org/forums/ <p>chrishajer speaks truth.</p> <p>We should probably check for this and stop it on install/integration. </p> http://bbpress.org/forums/topic/wpbb-integration-admin-problem#post-17124 Tue, 08 Jul 2008 21:21:43 +0000 chrishajer 17124@http://bbpress.org/forums/ <p>To anyone reading in the future:</p> <p><strong>Please</strong> use different table prefixes for bbPress and WordPress. bb_ for bbPress and wp_ for WordPress are the defaults, for good reason. You can change them to something else if you like, but make sure they are different for WordPress, bbPress, and anything else you might install in that database.</p> <p>Integration does not require the same table prefix, and using the same table prefix means bbPress will try to use WordPress tables (of the same name) that have already been created. </p> http://bbpress.org/forums/topic/wpbb-integration-admin-problem#post-17113 Tue, 08 Jul 2008 16:12:49 +0000 laran 17113@http://bbpress.org/forums/ <p>I got my wordpress working again by making the following change.</p> <p>I changed this: a:1:{s:9:"keymaster";b:1;}</p> <p>to this: a:1:{s:13:"administrator";b:1;}</p> <p>Now I think I've got to figure out how to undo the bbpress installation and do it again properly. I too suppose I didn't read the instructions carefully enough.</p> <p>In my case, I want to integrate wordpress and bbpress. So I thought I was supposed to have the tables names be the same. </p> http://bbpress.org/forums/topic/unable-to-log-in-to-wp-after-installing-bbpress#post-12502 Sun, 09 Dec 2007 02:32:08 +0000 chrishajer 12502@http://bbpress.org/forums/ <p>If you overwrote the wp_ tables with the bbPress installation script, I think the best (only?) solution is to restore your WP database from a backup, then install bbPress with a proper table prefix, like bb_.</p> <p>Maybe the installation script should check for someone setting the table prefix in bbPress to wp_ and question it or warn that bad things can happen. Or possibly it could check for the existence of those wp_ tables already, and warn that they're going to be modified or overwritten? </p> http://bbpress.org/forums/topic/unable-to-log-in-to-wp-after-installing-bbpress#post-12495 Sat, 08 Dec 2007 16:54:06 +0000 tlmchris 12495@http://bbpress.org/forums/ <p>I also failed to read the instructions carefully... how did you resolve the problem? </p> http://bbpress.org/forums/topic/unable-to-log-in-to-wp-after-installing-bbpress#post-10096 Fri, 10 Aug 2007 07:38:59 +0000 SuFF 10096@http://bbpress.org/forums/ <p>Well...I've resolved my (and maybe also your) problem... the problem was that I've used the same db prefix for both bbpress and wordpress... I feel like an idiot :D I just didn't read the instructions too carefuly :D </p> http://bbpress.org/forums/topic/unable-to-log-in-to-wp-after-installing-bbpress#post-10095 Fri, 10 Aug 2007 07:24:06 +0000 SuFF 10095@http://bbpress.org/forums/ <p>I have the same problem... :( </p> http://bbpress.org/forums/topic/unable-to-log-in-to-wp-after-installing-bbpress#post-8741 Sat, 07 Jul 2007 15:49:13 +0000 Trent 8741@http://bbpress.org/forums/ <p>Did you get this working? If you have access to your database through myphpAdmin or something like that, we can make sure that your admin user has the correct privelages pretty easy by looking at wp_users and then browsing to the admin user. The install of bbPress should not have changed the admin capabilities of your WP admin backend access because it would have added a completely seperate 'role' entry to wp_usermeta and not touched the wp_user table at all.</p> <p>Trent </p> http://bbpress.org/forums/topic/unable-to-log-in-to-wp-after-installing-bbpress#post-8715 Thu, 05 Jul 2007 14:35:27 +0000 saucemaster 8715@http://bbpress.org/forums/ <p>I have had wordpress 2.2.1 up and running for a while. I just tried to install bbpress, using the table prefixes 'wp_', since I think that is necessary to have any authors registered on my wp site to be able to get on to bbpress, and vice versa. My bb's config.php has the same database info as my wp's config.</p> <p>When I ran the install.php file for bb, I recieved some errors:</p> <blockquote><p>Second Step</p> <p>Now we’re going to create the database tables and fill them with some default data.</p> <p>bbPress database error: [Incorrect table definition; there can be only one auto column and it must be defined as a key]<br /> ALTER TABLE wp_posts ADD COLUMN post_id bigint(20) NOT NULL auto_increment</p> <p>bbPress database error: [Key column 'post_id' doesn't exist in table]<br /> ALTER TABLE wp_posts ADD PRIMARY KEY (post_id)</p> <p>bbPress database error: [Multiple primary key defined]<br /> ALTER TABLE wp_tags ADD PRIMARY KEY (tag_id)</p> <p> 1. Created table wp_forums<br /> 2. Created table wp_topics<br /> 3. Created table wp_topicmeta<br /> 4. Created table wp_tagged<br /> 5. Changed default value of wp_posts.post_status from publish to 0<br /> 6. Added column wp_posts.post_id<br /> 7. Added column wp_posts.forum_id<br /> 8. Added column wp_posts.topic_id<br /> 9. Added column wp_posts.poster_id<br /> 10. Added column wp_posts.post_text<br /> 11. Added column wp_posts.post_time<br /> 12. Added column wp_posts.poster_ip<br /> 13. Added index wp_posts FULLTEXT KEY post_text (post_text)<br /> 14. Changed type of wp_tags.tag_ID from int(11) to bigint(20) unsigned<br /> 15. Changed type of wp_tags.tag from varchar(255) to varchar(200)<br /> 16. Added column wp_tags.raw_tag<br /> 17. Added index wp_tags KEY name (tag)</p> <p>bbPress database error: [Unknown column 'post_id' in 'field list']<br /> SELECT post_id, poster_id FROM wp_posts WHERE topic_id = 1 AND post_status = 0 ORDER BY post_time</p> <p>bbPress database error: [Unknown column 'post_id' in 'where clause']<br /> SELECT * FROM wp_posts WHERE post_id = 114</p> <p>Finished!<br /> -----</p> <p>Now you can log in with the username "admin" and password "*Your WordPress password*".</p> </blockquote> <p>However, when I try to log in to my wordpress admin area as the 'admin' now, I receive the error:<br /> "You do not have sufficient permissions to access this page."</p> <p>I am able to log into bb, but there are multiple errors on each page; this is repeated many times on the page:<br /> "bbPress database error: [Unknown column 'post_id' in 'where clause']<br /> SELECT * FROM wp_posts WHERE post_id = 0<br /> Anonymous."</p> <p>I would just remove the bbpress completely, just to get wordpress login working again, but bb seems to have altered my wp user data?</p> <p>thanks </p> http://bbpress.org/forums/topic/wpbb-integration-admin-problem#post-2607 Mon, 25 Dec 2006 23:06:50 +0000 Sewar 2607@http://bbpress.org/forums/ <p>Go to your database in phpMyAdmin, in table <code>wp_usermeta</code> you will see this row:<br /> <code><br /> user_id meta_key meta_value<br /> 1 bb_capabilities a:1:{s:6:&quot;member&quot;;b:1;}<br /> </code></p> <p>Change "meta_value" to: <code>a:1:{s:9:&quot;keymaster&quot;;b:1;}</code>, So it will look like:<br /> <code><br /> user_id meta_key meta_value<br /> 1 bb_capabilities a:1:{s:9:&quot;keymaster&quot;;b:1;}<br /> </code> </p> http://bbpress.org/forums/topic/wpbb-integration-admin-problem#post-2574 Fri, 22 Dec 2006 22:53:36 +0000 Trent 2574@http://bbpress.org/forums/ <p>With integration, you had to say during the installation what user you wanted to be the key master (adminstrator) in bbPress. Adminstrators in WP don't automatically get admin status in bbPress. What I would suggest is finding out who is the key master in bbPress, login as them and add the user you want as admin with key master or admin status.</p> <p>If you are unsure who is key master, I believe a search in the db should let you know, or just check out:</p> <p><a href="http://bbpress.org/forums/topic/185?replies=5#post-909" rel="nofollow">http://bbpress.org/forums/topic/185?replies=5#post-909</a></p> <p>Trent </p> http://bbpress.org/forums/topic/wpbb-integration-admin-problem#post-2543 Fri, 22 Dec 2006 00:39:15 +0000 chrishajer 2543@http://bbpress.org/forums/ <p>I have WP and bbPress integrated and have no problem logging in as admin in WP then also being admin in bbPress. I have the opposite problem (not really a problem): when I log into bbPress as a normal user, and I try to access wp-admin, it gives me an error about not having sufficient permissions. In wp-admin &gt; users, I edited the permissions for the "normal" bbPress user, and he can act as admin at WP now. Never tried to admin bbPress as that user...</p> <p>I think it's probably something else: I did not require the hack you are suggesting to make this work.</p> <p>In bbPress, does it say:<br /> <code>Welcome, admin! View your profile» (Admin | Logout)</code><br /> up top?</p> <p>If it does, clicking the Admin link there will take you to the bbPress dashboard. Is that not happening for you? </p> http://bbpress.org/forums/topic/wpbb-integration-admin-problem#post-2539 Thu, 21 Dec 2006 23:56:39 +0000 bakedlogdotcom 2539@http://bbpress.org/forums/ <p>I have successfully integrated Wordpress and BBPress (<a href='http://bbpress.org/forums/topic/12?replies=25#post-2502'>http://bbpress.org/forums/topic/12?replies=25#post-2502</a>) but I am having 1 problem..</p> <p>When I log in as admin in BBPress, it seems to be logging me in with the 'admin' account from Wordpress, and not giving it admin privileges on the BBPress system, (ie: i can't go to /bb-admin to edit anything).</p> <p>The only thing i can think of is somehow excluding the 'admin' account integration when you log into bbpress, something like</p> <p><code><br /> if ($user=='admin') { #skip integration }<br /> </code></p> <p>Or is there something I am missing..?</p> <p>Thanks,<br /> -BHensley.com<br /> -Bakedlog.com </p>