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

[Taurus1]

I ran it on my test site first. No problems. How was I to know that following his instructions on uninstalling would cause this?

[Andreas]

I ran it on my test site first. No problems.

Did you test that uninstalling Beta 1 (and afterwards installing Beta 2) on a test installation works without problems?

Anyway, manually fixing the DB is quite a bit complicated - you can look at the installation/uninstallation code (which has been updated to fix the bugs you came across) to get an idea what needs to be done.

[kevius]

Any idear about the final version date ?

[Altari]

Not working for me, errors during the installation :
Database error in vBulletin 4.2.0:

Invalid SQL:

       UPDATE vb_pm AS pm
       SET attach = (SELECT COUNT(*) FROM vb_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

Moroever, after a lot of try, i can see

[Tue Jun 12 12:29:32 2012] [warn] [client XXX] mod_fcgid: stderr: PHP Warning:  Invalid argument supplied for foreach() in /var/www/packages/navmanenhancements/admin.php on line 43, referer: http://website/admincp/plugin.php?do=productadd

in my apache error log. Don't know what your other addon is doing here...


Thank you Andreas for this mod, would be great.

[Andreas]

Originally Posted by kevius

Any idear about the final version date ?

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.

[betterthanyours]

Another one

Database error in vBulletin 4.1.12:

Invalid SQL:

	INSERT INTO package
	(productid, class)
	VALUES
	('pmattachments', 'PMAttachments');

MySQL Error   : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 16th 2012 @ 11:10:43 AM
Error Date    : Saturday, June 16th 2012 @ 11:10:43 AM
Script        : http://www.unrealkillers.com/admincp/plugin.php?do=productimport
Referrer      : http://www.unrealkillers.com/admincp/plugin.php?do=productadd
IP Address    : 86.19.247.18
Username      : $carface
Classname     : vB_Database
MySQL Version : 5.5.24-cll

[Syxguns]

I am awaiting this mod! I've got it tagged. Thanks for this Andreas

[qpurser]

Andreas,
just wanted to give you some feedback regarding your once again excellent mod.

Running vb 4.2.0 on a test server
Upgraded from your Beta1 to Beta2. (for those reading this I did NOT uninstall Beta1 and then installed Beta2 but did a regular update)

I didn't get any error messages at all
Sending and receiving the attachments worked just fine

On a side note I am using also DBTech "vb optimize" which moves the attachments from the database to a folder as files.
Your plugin works fine with or without this add-on.

[horusbird]

error in installation:

Database error in vBulletin 4.2.0:

Invalid SQL:

	INSERT INTO package
	(productid, class)
	VALUES
	('pmattachments', 'PMAttachments');

MySQL Error   : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 30th 2012 @ 09:18:19 PM
Error Date    : Saturday, June 30th 2012 @ 09:18:19 PM
Script        : http://www.vesparesources.com/adminc...=productimport
Referrer      : http://www.vesparesources.com/adminc...?do=productadd
IP Address    : 79.13.184.169
Username      : horusbird
Classname     : vB_Database
MySQL Version : 5.1.33-community

[betterthanyours]

Originally Posted by betterthanyours

Another one

Database error in vBulletin 4.1.12:

Invalid SQL:

	INSERT INTO package
	(productid, class)
	VALUES
	('pmattachments', 'PMAttachments');

MySQL Error   : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 16th 2012 @ 11:10:43 AM
Error Date    : Saturday, June 16th 2012 @ 11:10:43 AM
Script        : http://www.unrealkillers.com/admincp/plugin.php?do=productimport
Referrer      : http://www.unrealkillers.com/admincp/plugin.php?do=productadd
IP Address    : 86.19.247.18
Username      : $carface
Classname     : vB_Database
MySQL Version : 5.5.24-cll

Originally Posted by horusbird

error in installation:

Database error in vBulletin 4.2.0:

Invalid SQL:

	INSERT INTO package
	(productid, class)
	VALUES
	('pmattachments', 'PMAttachments');

MySQL Error   : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 30th 2012 @ 09:18:19 PM
Error Date    : Saturday, June 30th 2012 @ 09:18:19 PM
Script        : http://www.vesparesources.com/adminc...=productimport
Referrer      : http://www.vesparesources.com/adminc...?do=productadd
IP Address    : 79.13.184.169
Username      : horusbird
Classname     : vB_Database
MySQL Version : 5.1.33-community

Any news on this error?