PHP related forum, discuss snippets, classes and tutorials
twincascos
Member
Hello, I've just been trying your plugin Moderator New Post Notification with a wordpress - bbpress Integrated install and I get the following error `database error:
[Table 'bbpress.bb_users' doesn't exist]
SELECT um.meta_value AS role FROM bb_users AS u, bb_usermeta AS um WHERE u.ID = um.user_id AND um.meta_key = 'bb_capabilities' AND u.user_status = 0 AND u.ID = 2`
Olaf
PHP Coder
Yes right, the plugin needs an update if the prefix is different from "bb_".
replace the SQL statement within the function "is_moderator":
$row = $bbdb->get_row("SELECT um.meta_value AS role
FROM $bbdb->users AS u, $bbdb->usermeta AS um
WHERE u.ID = um.user_id
AND um.meta_key = 'bb_capabilities'
AND u.user_status = 0
AND u.ID = $user_id
");
facelikebambi
Member
Hiya,
I'm trying to use the plugin with Wordpress and BBPress 0.9.0.2 integrated. I had the same error, and the fix mentioned above does indeed remove the SQL error.
However, I'm still not getting the activate checkbox when I edit my (keymaster) profile.
As a test, I installed a local, non-WP-integrated version of 0.9.0.2 to see if it was a problem with the latest BBpress... and the plugin works fine!
Any suggestions welcomed - thanks!
facelikebambi
Member
Ah I fixed it!
Just had to change the two references to bb_capabilities to bbpress_capabilities
Also, the notification emails had no sender, so I just changed the $header = 'From: '.bb_get_option('admin_email')."\n"; line to hard code the from address.
Thanks!
paulikro
Member
Quote from: facelikebambi
"Ah I fixed it!
Just had to change the two references tobb_capabilitiestobbpress_capabilities
Also, the notification emails had no sender, so I just changed the$header = 'From: '.bb_get_option('admin_email')."\n";line to hard code the from address.
Thanks!"
that is great tipp! i have to replace bb_capabilities to bbpressforumcapabilities .. maybe somewhen will help this..
You must log in to post.