[Ophelia]

We just upgraded to the newest version of Photopost. In doing so, after importing their xml plugin, whenever we try to edit files in the downloads, we receive the following database error.

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE vb_dl2_files SET
`title` = 'March 13 in 13 Inspiration',
`description` = 'The attached is a PDF document with 13 things to inspire you on the 13th. You can read more about this challenge here:\nhttp://myurl/forum/forumdisplay.php?...-in-13-Project\n\nThis list contains suggestions and are not mandatory! If something else inspires you we would love to hear and see it in the challenge forum and gallery!',
`author` = 'My Name',
`_author` = '<a href=\"member.php?u=19504\">My Name</a>',
`url` = 'http://',
`extension` = '',
`category` = 8,
`size` = 0,
`pin` = 0,
`modqueue` = 0,
`link` = Resource id #20,
`lastedit` = 1363183147,
`lasteditor` = 'My Name',
`lasteditorid` = 19504
WHERE id = 1110;

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 'id #20,
`lastedit` = 1363183147,
`lasteditor` = 'My Name',
' at line 12
Error Number : 1064
Request Date : Wednesday, March 13th 2013 @ 08:59:07 AM
Error Date : Wednesday, March 13th 2013 @ 08:59:07 AM
Script : [url]http://myurl/forum/downloads.php?do=edit&id=1110[/url]
Referrer : [url]http://myurl/forum/downloads.php?do=edit&id=1110[/url]
IP Address : xxxxxxxx
Username : My Name
Classname : vB_Database
MySQL Version : 5.1.68-cll

I posted in Photopost and their response was as follows.

The proper thing would be to contact your hack author and correct his hack. You need to diagnose from that end.

We integrate with vBulletin we do not claim intergration with hacks or mods you may download and install from vbulletin.org

Your error is in whatever this part of the guys hack query is as a reference

Code:

`link` = Resource id #20,

There are no errors with your vbulletin photopost integration and install this issue is with the hack which has the error.

Your hack author probally needs to define his mysql resource and then restructure his query.

Obviously I do not use that hack so I can only point out where the issue is in his query.

Just for your reference except for a couple style class additions the 8.12 and 8.23 xml plugins are exactly the same. There are no changes that I can see.

He had us add

PHP Code:

mysql_close( $result ); 


to the end of their plugin code, but it just crashed vBulletin.

Is there something that can be done to fix this?