I am trying to upgrade my vbb2.33 to vb3.0RC4. I ran the database conflicts script and it came up clean.
When the upgrade gets to "Step 13) Update Attachments #1", I get the standard "Attachment: 91,92,93,94,95,96,97,98,99,100,101,102,103,104,105 ..." message and it tells me "There seems to have been a slight problem with the database." error.
Checking my email, I get the actual error message:
_______________________
Database error in vBulletin :
Invalid SQL:
UPDATE attachment
SET
postid = 96017,
filesize = LENGTH(filedata),
filehash = MD5(filedata)
WHERE attachmentid = 91,92,93,94,95,96,97,98,99,100,101,102,103,104,105
mysql error: You have an error in your SQL syntax near '92,93,94,95,96,97,98,99,100,101,102,103,104,105' at line 7
mysql error number: 1064
Date: Tuesday 17th of February 2004 12:36:19 PM
_______________________
Can somebody please explain this to me? If there is a problem with attachments in my posts, how do I easily find the offending posts and delete them?
When the upgrade gets to "Step 13) Update Attachments #1", I get the standard "Attachment: 91,92,93,94,95,96,97,98,99,100,101,102,103,104,105 ..." message and it tells me "There seems to have been a slight problem with the database." error.
Checking my email, I get the actual error message:
_______________________
Database error in vBulletin :
Invalid SQL:
UPDATE attachment
SET
postid = 96017,
filesize = LENGTH(filedata),
filehash = MD5(filedata)
WHERE attachmentid = 91,92,93,94,95,96,97,98,99,100,101,102,103,104,105
mysql error: You have an error in your SQL syntax near '92,93,94,95,96,97,98,99,100,101,102,103,104,105' at line 7
mysql error number: 1064
Date: Tuesday 17th of February 2004 12:36:19 PM
_______________________
Can somebody please explain this to me? If there is a problem with attachments in my posts, how do I easily find the offending posts and delete them?
Comment