Great offers not only for geeks!
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`
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!
hm... I think that some variable is replaced by the code which is written for WP.
what error do you get if you access the plugin-file via the browser?
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!
Ok, cool that it works now (will add this to the next version)
You must log in to post.