After upgrade it give this error Unknown column 'dateline' in 'field list' , this happens, when I go to some post to see It. I updated the vbulletin from 3.7.3 to 4.0.4 , beffor was perfect but now this error appear .. ? I have that field in my database but why is this error ?And how to fix it :?
Database error in vBulletin 4.0.0 Beta 4:
Invalid SQL:
SELECT COUNT(*) AS count, threadid, MAX(dateline) AS lastpost
FROM vb_post AS post
WHERE post.userid = 7361 AND
post.visible = 1 AND
post.threadid IN (0,34195,32289,32971,33095,33073,32934,33623,34040,33754,33977,33678,33299,33161,33119,328 02,32807,32755,32297,32296,32291)
GROUP BY threadid;
MySQL Error : Unknown column 'dateline' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 5th 2011 @ 12:21:52 PM
Error Date : Wednesday, January 5th 2011 @ 12:21:53 PM
Script :
Referrer :
IP Address : 77.236.164.19
Username : Don`Makaveli
Classname : vB_Database
MySQL Version : 5.0.83-log
Here is the whole of it, please help!!!!
Database error in vBulletin 4.0.0 Beta 4:
Invalid SQL:
SELECT COUNT(*) AS count, threadid, MAX(dateline) AS lastpost
FROM vb_post AS post
WHERE post.userid = 7361 AND
post.visible = 1 AND
post.threadid IN (0,34195,32289,32971,33095,33073,32934,33623,34040,33754,33977,33678,33299,33161,33119,328 02,32807,32755,32297,32296,32291)
GROUP BY threadid;
MySQL Error : Unknown column 'dateline' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 5th 2011 @ 12:21:52 PM
Error Date : Wednesday, January 5th 2011 @ 12:21:53 PM
Script :
Referrer :
IP Address : 77.236.164.19
Username : Don`Makaveli
Classname : vB_Database
MySQL Version : 5.0.83-log
Here is the whole of it, please help!!!!
Comment