No announcement yet.

Unknown column 'dateline' in 'field list'. After upgrade

This topic is closed.
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unknown column 'dateline' in 'field list'. After upgrade

    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 :
    Username : Don`Makaveli
    Classname : vB_Database
    MySQL Version : 5.0.83-log

    Here is the whole of it, please help!!!!

  • #2
    To quote staff memebers

    To get vB support on these forums you first need to be a licensed customer and register for Priority Forum Support. To do this, please go here:

    ...and enter your email address in one of the boxes. You'll need to have your customer number and password to access the page.

    Once you've done this, please post in the appropriate support forum for your version.
    After that post in the support forum pre-sale is for sales questions.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.