[Hippy]

Originally Posted by 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.



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?

lol.. glad I did not update PP yet..
I never ad the files and update .. I compare to see what was changed to see what else it will affect..
If PP started this .. you need to have good old chuck figure it out..

try to re import the downloads xml all over write .. DO NOT UN INSTALL IT
Just over write..
see if it corrects any thing..