Register Members List Search Today's Posts Mark Forums Read

Mod Options
Private Message Attachments Details »
Private Message Attachments
Mod Version: 1.0.0b2, by Andreas (Coder) Andreas is offline
Developer Last Online: Mar 2019 I like it Show Printable Version Email this Page

vB Version: 4.2.0 Rating: (9 votes - 3.89 average) Installs: 70
Released: 08 Jun 2012 Last Update: 10 Jun 2012 Downloads: 574
Not Supported DB Changes Uses Plugins Template Edits Additional Files Is in Beta Stage  

This Add-on allows you to use attachments in private messages.

1.0.0 Beta 2
  • Added missing table prefix
  • Removed hardcoded contenttypeid
  • Improved performance

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Old 17 Jul 2012, 00:03
Lee Roberts's Avatar
Lee Roberts Lee Roberts is offline
Join Date: Jun 2008
Real name: Lee
Originally Posted by horusbird View Post
error in installation:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
Same here.
Reply With Quote
Old 17 Jul 2012, 16:09
thunderclap82 thunderclap82 is offline
Join Date: Dec 2008
Database error on installation for me as well. Running 4.2 PL1.
Reply With Quote
Old 22 Jul 2012, 04:01
djbaxter djbaxter is offline
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by Taurus1 View Post
I uninstalled it completely, and then when trying to install beta 1 again, I get this:

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO vbpackage
(productid, class)
('pmattachments', 'PMAttachments');

MySQL Error : Duplicate entry 'PMAttachments' for key 'class'
Error Number : 1062
Request Date : Sunday, June 10th 2012 @ 05:31:57 AM
Error Date : Sunday, June 10th 2012 @ 05:31:58 AM
Script :
Referrer :
IP Address : ++++++++++
Username : ++++++++
Classname : vB_Database
MySQL Version : 5.1.63-cll

I know you said that there will be no support, but I am really stuck now. Thanks.
Yep. Got exactly the same error and the installation would not complete.
Reply With Quote
Old 22 Jul 2012, 08:51
Akyeame Kwame Akyeame Kwame is offline
Join Date: May 2008
Are both beta 1 AND beta 2 only for 4.2? Is anyone running either of these on 4.1.X?
Reply With Quote
Old 27 Jul 2012, 18:22
Footman Footman is offline
Join Date: Mar 2010
Tagged for final version. Much anticipated.

Hopefully this will also allow attachments in the calendar editor as well. Seems like it's the same editor box. Or it may need a separate mod.

Reply With Quote
Old 28 Jul 2012, 02:55
hubba hubba is offline
Join Date: Dec 2003
>Duplicate entry 'PMAttachments' for key 'class'

Reply With Quote
Old 30 Jul 2012, 02:42
WolfWiz WolfWiz is offline
Join Date: Mar 2007
No Joy on install, great product if it worked something that has been lacking in VB for a long time. Wish it was working .
Reply With Quote
Old 13 Aug 2012, 08:51
wii's Avatar
wii wii is offline
Join Date: Oct 2005
So, it doesn't work ?
Reply With Quote
Old 06 Sep 2012, 14:58
nevbear666 nevbear666 is offline
Join Date: Nov 2011
yep, does not work, actual error:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

the problem is, that:


returns an empty value.

for everyone with that duplicate errors, thats because database fields get added to existing tables before the script breaks.

need to remove a few:
from table "pm" remove "attach" and "attachmap"
from usergroup remove "advpmpermissions"
from packages remove the entry "PMAttachments"
from contenttype remove the entry "PrivateMessage"

the productinstaller of vbulletin is unable the remove database entries when theyre duplicate, even if you choose overwrite as an option, plus the script actually breaks before putting the entry into the products manager...

ps: bitte koenntest du die titel fuer die plugins ins englische umbenennen, fuer unsere uebersee freunde;-)

Last edited by nevbear666; 06 Sep 2012 at 15:03.
Reply With Quote
Old 06 Sep 2012, 17:04
nevbear666 nevbear666 is offline
Join Date: Nov 2011
ps: even after fixing the obvious errors (VBForum_PrivateMessage instead of PMAttachment_PrivateMessage...), opening the newattachment.php link causes an error

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

looking at the link i see a major difference between a working and non working url for calling newattachment.php:

doesnt work:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

does work:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

just a first glimpse...
Reply With Quote
Old 02 Oct 2012, 06:17
tbworld tbworld is offline
Join Date: Oct 2008
Thanks Andreas!

I have completed a similar hack for my company (in the core files, not a plugin). Your code examples helped me tremendously. Very, very grateful! Let me know if I can reciprocate.
Reply With Quote
Old 04 Oct 2012, 19:53
ehpoole's Avatar
ehpoole ehpoole is offline
Join Date: Feb 2012
Issues with 1.0.0.beta2 Install

Aside from the headaches of cleaning up our database tables from a previous failed Product XML Upload failure due to "Database Error" so as to return all the table entries and fields to a virgin state, I also ran into the following faults in the original XML file:
  1. Very Minor - Descriptions alternate between German and English in both the XML file and portions of the instructions files -- all the Plugin titles are in German for instance. I don't want to harp (or even really complain for that matter) on this one because language is inherently relative to the observer, but I figured I should probably mention it for consistency's sake.
  2. On Lines 160 and 261 of the XML file, the SQL Query does not properly reference tables that have a vBulletin TABLE_PREFIX attached to them... The initial FROM statement is correct, but the "as attachment" portion of the Query is missing, so the query fails a bit further in when the table.fieldid "attachment.contenttypeid" is called. This will only fail for sites that have defined a TABLE_PREFIX value, but should be corrected.
  3. The more troublesome one (for me) was on Line 160 (again) where "attachment.contenttypeid" is set:

    Block Disabled:      (Update License Status)  
    Suspended or Unlicensed Members Cannot View Code.

    It appears that the call to getContentTypeId is coming too early in the process, as the value returned is an empty string rather than the intended value. However, this same code works later on come line 261, so clearly it is an order-of-execution issue. This suggests that this query should be moved until after the "pmattachments" row has been added to the "packages" table so that the call does not fail.

    I temporarily worked around this issue by hard coding the next Auto Increment value to be assigned to the next record ID for the "packages" table so that I could at least get the Product installed ("13" in my case, after some earlier failed attempts and cleanups).
I apologize for having to submit these changes rather than a corrected XML Product File. I am comfortable enough to make minor tweaks to the XML files, but I am not comfortable enough with my knowledge of the XML file's layout to make wholesale changes so that I can change the order of execution of the "contenttype" table's record insertion. Especially not comfortable enough to submit something that others will run on their servers!

Despite my concerns, I do greatly appreciate your sharing this plugin with us as our users genuinely want the functionality without having to wait for vBulletin to get around to releasing such. I hope my suggested amendments will help both yourself and other users trying to install the product. The instructions user nevbear666 provided for backing out the database changes were most valuable to eventually getting the product installed (after making my above changes), they certainly saved me some time.
Reply With Quote
Old 16 Oct 2012, 16:41
heugabel heugabel is offline
Join Date: May 2006
works good
Attached Files
File Type: xml product-pmattachments.xml (14.8 KB, 47 views)
Reply With Quote
Old 18 Oct 2012, 13:53
mat8861 mat8861 is offline
Join Date: Sep 2011
Originally Posted by heugabel View Post
works good
on which vb version ?
Reply With Quote
Old 09 Nov 2012, 22:44
SpaceStar SpaceStar is offline
Join Date: Apr 2005
I too got an SQL error. Amazing some people put their unfinished and error-prone product to public use and then not willing to help. Bad product.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 20:08.

Layout Options | Width: Wide Color: