PDA

View Full Version : Error 1054 when open New Thread


Rolll
09-14-2012, 07:39 AM
Hi,
when I (administrator id:1) open a new thread (only with text) vB gives me this error:

Why?

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT dateline, filename, attachmentid
FROM vb_attachment
WHERE postid = 78076
ORDER BY attachmentid;

MySQL Error : Unknown column 'postid' in 'where clause'
Error Number : 1054
Request Date : Friday, September 14th 2012 @ 10:28:17 AM
Error Date : Friday, September 14th 2012 @ 10:28:17 AM
Script : http://www.******.it/forum/newthread.php?do=postthread&f=146
Referrer : http://www.******.it/forum/newthread.php?do=newthread&f=146
IP Address :
Username : Proid
Classname : vB_Database
MySQL Version : 5.1.63-0+squeeze1

kh99
09-14-2012, 10:55 AM
In vb4, there is no postid column in the attachment table, but there was in vb3. Also, I don't find a query exactly like that in the vb3 code. So my guess is that you have a modification that was for vb3 that needs to be updated. Do you have any modifications or plugins that have to do with attachments?