Database error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • a661993
    New Member
    • Jan 2010
    • 1

    Database error

    hi i have update my forum form vb3.8.4 to vb4.0.1
    and i have error when i try tp post a new thread :

    Code:
    Database error in vBulletin 4.0.1:
    Invalid SQL:
        SELECT
         fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
         a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings,
         at.contenttypes
        FROM attachment AS a
        INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
        LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
        WHERE
         a.posthash = 'fd7a91e6146cc436ed8afcbbf6454e15'
          AND
         a.userid = 3
          AND
         a.contenttypeid = 1
       
    ORDER BY a.contentid, a.attachmentid;
    MySQL Error   : Unknown column 'a.filedataid' in 'on clause'
    Error Number  : 1054
    please help me !
  • Mike Anime
    Senior Member
    • Oct 2004
    • 1841
    • 3.7.x

    #2
    please note that to be able to post in the support forums you first need to be a licensed customer and register for Priority Forum Support. To do this, please go here:

    http://members.vbulletin.com/membersupport_priority.php

    ...and enter your email address (the one you used to register on the forums) in one of the boxes. You'll need to have your customer number and password to access that page.

    NOTE: The most common problem is that people are registered with a different email address than they think they are.

    Also please make sure you have activated your forum account by clicking on the link in the activation email after registering or changing your email address. You will not be able to post until you activate your account. You can use this link to get the activation email again:

    http://www.vbulletin.com/forum/regis...o=requestemail

    And finally, when you make these changes the effect is not immediate. It take up to an hour for the system to update your status.

    If you have done all this and still have problems, then please send an email to [email protected] with this info:

    - your forum user name
    - the email address you registered with
    - your customer number

    Comment

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