Good catch d3x7ro.
And I didn't see all that back and forth between spencer and nitallica til now (sorry). I have to fix the PM plugin for better WPMU support like I did memberlist. That's next on my list, I just haven't had a chance yet. Hopefully soon though.
Looking forward to your update. :)
Hi Everyone.
I'm trying to install this on my forum but getting the following message when I try and run the /pm.php file:
bbPress database error: [Table 'db189779439.p2tbb_privatemessages' doesn't exist]
SELECT * FROM p2tbb_privatemessages WHERE id_receiver = 1 ORDER BY created_on DESC
bbPress database error: [Table 'db189779439.p2tbb_privatemessages' doesn't exist]
SELECT * FROM p2tbb_privatemessages WHERE id_sender = 1 ORDER BY created_on DESC
Fatal error: Call to undefined function: bb_load_template() in /homepages/34/d139864185/htdocs/pig2twig.lineindustries.net/forums/pm.php on line 19
I'm sure all files are in the correct locations. Is this due to the WP integration issue discussed above? Does anyone know how to fix? I'm guessing I could create the tables manually but suspect I'll still get the Fatal Error to the undefined function.
Thanks for any help. Tim
Sorry man, I updated the plugin 2 days ago to be compatible with the new .80 release of bbpress. You'll have to get the most recent .73 version. If you can't figure out how to get it from /plugins, you can go to http://faq.rayd.org/bbpress_private_message/
PS. Or you can install the trac version of bbpress... or just wait for when .80 comes out (I wouldn't suggest this since it was supposed to come out 2 days ago and, well... here we are)
Thanks guys - I've installed .73 and we appear to be closer. It now at least renders the page but still doesn't create the database table and hence gives the follwoing error...
bbPress database error: [Table 'db189779439.p2tbb_privatemessages' doesn't exist]
SELECT * FROM p2tbb_privatemessages WHERE id_receiver = 1 ORDER BY created_on DESC
bbPress database error: [Table 'db189779439.p2tbb_privatemessages' doesn't exist]
SELECT * FROM p2tbb_privatemessages WHERE id_sender = 1 ORDER BY created_on DESC
Can I just manually add the table to the database? I have bbpress integrated with Word Press if that makes any difference. Your help is much appreciated.
Looks like the table is there and you're running into the WPMU bug that I believe Trent and/or spencer talk about in this thread.
Actually, spencer posted a fix for it here :
http://bbpress.org/forums/topic/401/page/2?replies=66#post-2733
Sorry about the bug. I highly suggest upgrading to .80 as soon as that version of bbpress is released. It addresses that issue.
PS. oh, on second thought, maybe your tables aren't created? Open up your mysql and check if _privatemessages is there. If not, you can open bb-privatemessages.php and look at the first function in that file. It gives the layout of the tables.
Cheers. I'll try this first thing tommorrow. No problems - will be great to have private messaging. Thanks for the plugin and the help!
A big cheers to ardentfrost. I've upgraded to 0.8 and now have private messages working. Thank you!
I upgraded to .80, and used the .80 version of the plugin, but unfortunately I am still having the same erorrs with wpmu integration.
At the top of my pm page it displays:
bbPress database error: [Table 'suleiman_bbpress.bb_users' doesn't exist]
SELECT * FROM bb_users WHERE ID = 1
In addition, when I send a message it gives me the following error in the table displaying "Sent Messages" under the "To" column:
bb_get_user needs a numeric ID
Interestingly enough, if I go into phpMyAdmin and browse the bb_privatemessages table, I can see that my posts have values for pm_id, and id_sender, but id_receiver has a 0 value. So too, predictably does "seen"
Tried installing this plugin on our forums and having problems. First had problem with db errors and now when you click on the private message link and it goes to pm.php it is just a blank screen. any ideas what went wrong? url for forums is www.netsleds.com/netsleds_forums
Sorry, I just saw these 2 posts.
Suleiman, the "seen" is just a boolean value that tells whether or not the receiver of the PM has opened the message or not. It should be expected for it to have some zeros on there if no one can see their PMs. As for id_receiver, do you have someone with an id of zero? Or all they all zeros, even those to multiple people?
Sometimes the best way to work through the problems is to do it through IMs, so if you'd like to do that, just let me know. We can get it working for you.
Netsleds, there should be DB errors the first time you install the plugin, but that's just for when the tables are being created. Upon refresh, they should go away (I assume they did?). As for your problem of it being a blank page, that is certainly strange. It's not showing anything in the source, even the header or footer, which makes me think you might not have the template files in the correct place. Do you have them in the directory of the template you're using?
I do have the template files in /my-template/ folder (I even put them in the default template directory too), I am using mod-rewrite, and when I initially set up the pm plugin, the database did not install, so I grabbed the query from the bb-privatemessage.php file to create the bb_privatemessage table and when I ran the query it gave me an error with the "message" column saying
"#1074 - Too big column length for column 'message' (max = 255). Use BLOB instead"
So I set it to BLOB and Even tried LONGTEXT. I don't see if it would make a difference or not, but maybe that is why?
it should really only care about the name of the column. Even if you set it to int, it would get some values (they wouldn't make any sense however).
I'm pretty sure in .80 of bbpress you have to have the template folder inside my-templates. So those files should be in my-templates/[your template here]. The function that gets the location only returns the location of the template folder.
Plus when you load /pm.php you don't get any errors, just nothing is displayed in the source. I bet if you added an echo to say "hello" in pm.php it would be displayed. I bet if you added an echo below the file call for privatemessages.php you wouldn't get jack. If that's the case, that means the function is unable to find privatemessages.php and is halting.
I should have come up with some way to display something if it can't find the file. I'll release that in the next version... but for now it seems most likely to me either the files aren't in the correct place or something affecting it's ability to find the files has occurred.
ardent, i'd love to get this fixed over IM.
Add me to gchat, msuleimankhan is my handle.
added
I might not be able to help you tonight, but just shoot me an IM when you see me on.
ardentfrost.....thanks I didn't have my-template folder as a subfolder of the bb-template directory so it was having a hard time with that. I moved my-template folder under the bb-template directory and it worked. Thanks for the input.
I had problems too. The table was not created. I had to do it manualy. I have all of the latest updates for both WP and bbPress so I dont know what went wrong. To fix the data base issue go to you myphp admin (data base) and give the following command.
CREATE TABLE bb_privatemessages (
pm_id BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
id_sender INT( 11 ) NOT NULL ,
id_receiver INT( 11 ) NOT NULL ,
seen INT( 2 ) NOT NULL ,
pmtitle VARCHAR( 64 ) NOT NULL ,
message VARCHAR( 255 ) NOT NULL ,
created_on DATETIME NOT NULL ,
PRIMARY KEY ( pm_id )
) TYPE = MYISAM ;
This solved my problems for now.
Since that only has to happen once, if you added the tables that should be the end of it. I tested the process on my own server and had 2 others test it on theirs. A lot of people have downloaded and installed the plugin, and a minority have had problems. Unfortunately, I am unsure how to fix this problem for that minority, but the commands you posted should work or people can copy the commands directly from the plugin themselves... it's the first subroutine in the main plugin file (bb-privatemessages.php)
ardentfrost, I dont know what happened but all PM's that went out yesterday have seemed to vanish without a trace??? They were in the data base cuz I checked and seen them there. Today they are gone. I am wondering if the table was copied over after I had manualy installed the table, with your call function in bb-privatemessages.php. Maybe I did not give it enough time to do it on it's own. I will see what happens today.
The function checks to see if it exists, and if it doesn't it creates the tables. If you created the tables as they are setup in that function, it shouldn't do anything again. If it happens again, I suggest you comment out the table creation code in the plugin. I don't know why it would do that.
By the way, Online List works the same way as mine with table creation if you use that one.
Several people have asked for additional capabilities to be added to this plugin:
1. That an e-mail alert would be sent out every time a member received a new private message, and
2. That a "PM this user" link could be added to the profile page.
I know ardentfrost is busy, so I have posted instructions on how to modify the plugin files so you can do these two things.
You can view the instructions here:
http://www.wittmania.com/bb-privatemessage-upgrades.txt
Please e-mail me if you have any questions (mike at wittmania dot com). Thanks again to ardentfrost for this exceptional plugin!
Update: Somebody asked me how to add a name (instead of just the e-mail address) to the new message received e-mail notification. To do this, just use this format:
$admin_email = "Your Name <you@yourdomain.com>";
When the e-mail is delivered, it will show up as being from "Your Name" and not "you@yourdomain.com". I'm not sure that this will work on all PHP configurations, but it works on mine.
great plugin. :-)
one question: can Bozos pm?
Note private messages are cut off at 2048 characters (1965 in practice, from my testing) because the db field is varchar(2048).
That's not that much to wordy writers.
I might try to change this to longtext. If I do I'll post back on the results, and if good, the method.
You must log in to post.