Private Messages Enhancements - Private Message Attachments

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

Changelog
1.0.0 Beta 2

• Added missing table prefix
• Removed hardcoded contenttypeid
• Improved performance

[rgreene1971]

damn it, this worked perfectly on my test server and now not working on my main site. Does anybody know the database entries I can remove by hand to remove this mod?

[rgreene1971]

Originally Posted by heugabel

works good

Not working on VB 4.2

[jakubsnm21]

Mod doesn't work!!!

Yay! now my database is inconsistent...

[BasilFawlty]

Originally Posted by Schoelle

Please all vote for this JIRA entry:

Cant use attachements in private messages
http://tracker.vbulletin.com/browse/VBIV-5750

As i appreciate your efforts Andreas, this should be a core function and not an addon!

Ding ding ding! I agree! Already lots of complains from my members about this lack of seemingly obviously functionality that is missing.

[boss22]

Have someone tips how to remove this product? Gives database error when try to remove.

regards

bosss

[Eric]

Originally Posted by SpaceStar

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.

Just noticed this post, but in the mod information:

Not Supported
Is in Beta Stage

Perhaps check this next time?

[metalguy639]

Originally Posted by Eric

Just noticed this post, but in the mod information:



Perhaps check this next time?

Not relevant IMO. The mod is listed as a mod for 4.2 yet it does NOT work in 4.2 for ANYONE. It should be pulled as it works for no one at all using vb 4.2. How can a mod be listed for 4.2 and NOT work for it? Whether its supported or not it should at least work for someone.

Quote from OP promising a beta 3 version, this was in June 2012 so many months ago. I'm guessing this has been abandoned now.

Originally Posted by Andreas

It's ready when it's ready, eg. when there are no more bugs being reported.

@Altari
Thanks for this bug report, it will be fixed in Beta 3.

I have a database error as well:

Database error in vBulletin 4.2.0:

Invalid SQL:

	UPDATE pm AS pm
	SET attach = (SELECT COUNT(*) FROM attachment WHERE contentid = pm.pmid AND attachment.contenttypeid = );

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
Error Number  : 1064
Request Date  : Friday, December 14th 2012 @ 03:27:40 AM
Error Date    : Friday, December 14th 2012 @ 03:27:41 AM
Script        : http://www.xxxxxxxxx.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.xxxxxxxxx.com/forum/admincp/plugin.php?do=productadd
IP Address    : xxxxx
Username      : DamienDarwick
Classname     : vB_Database
MySQL Version : 5.0.77

[rgreene1971]

Great, now I receive a database error any time I try to make any changes to the usergroups even if it has nothing to do with pm attachments.

Does anybody know what needs to be removed from the database to get rid of this mod?

[metalguy639]

SIGH.....When I try to uninstall I get this now...

Database error in vBulletin 4.2.0:

Invalid SQL:

				SELECT a.attachmentid, fd.userid, fd.filedataid, a.userid AS auserid, a.contenttypeid
				FROM attachment AS a
				LEFT JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
				WHERE contenttypeid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Error Number  : 1064
Request Date  : Wednesday, December 19th 2012 @ 11:43:27 PM
Error Date    : Wednesday, December 19th 2012 @ 11:43:27 PM
Script        : forum/admincp/plugin.php?do=productkill
Referrer      : forum/admincp/plugin.php?do=productdelete&productid=pmattachments&s=
IP Address    : xxxxx
Username      : DamienDarwick
Classname     : vB_Database
MySQL Version : 5.0.77

For those of you who have experienced problems sending or getting PM'S after installing this buggy hack the best thing I can suggest is to disable the hack in your products. I cannot uninstall the product to save my life I get the above error. I looked at the database tables and the fields that need to be taken out are not there so I can only assume that it was taken out in one of the uninstalls that I tried.

[kh99]

For people having problems uninstalling this mod:

1) If you can't get to the admincp, edit includes/config.php and insert this line, at the top just under the <?php line:

define('DISABLE_HOOKS', true);

2) Go to Manage Products and uninstall this product. If it won't uninstall because you get an error, edit your includes/config.php, find the $config['Misc']['debug'] line and change it to true (or if you can't find it, insert the line below):

$config['Misc']['debug'] = true;

Now go to the Manage Products and select "Edit" next to this product, and press "go". Find the section labeled "Existing Install/Uninstall Code" and check the delete box next to each code box, on the right. Then press save and try uninstalling the product again.

3) If you want to clean up the database, the columns added by this mod are 'attach' and 'attachmap' in the pm table, and 'advpmpermissions' in the usergroup table. There is also a row added in the package table with productid='pmattachments' and a row in the contenttype table with class='PrivateMessage'. I don't believe any of this will actually cause problems if you don't remove it (and in fact some of it may have been removed by the uninstall before the error), so if you don't know how, don't worry about it. Edit: But don't try to install this mod again unless you do clean things up.

4) Remove the DISABLE_HOOKS line if you added it in step 1, and change $config['Misc']['debug'] = false;