No announcement yet.

Database error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error

    figured out nevermind

    i got this error. I used vb4 but didn't like it, added vb3.8.5 and almost everything works but when i hit new posts i get this. what is happening?

    Invalid SQL:
    SELECT searchid FROM search AS search WHERE userid = 218 AND searchhash = 'f0bb363c4ac0c70173b8b78b81d9d3a0' AND orderedids = '2790,2792,2814,2805,2803' AND announceids = '' AND completed = 1;

    and this in my admin

    Database error in vBulletin 4.0.3:

    Invalid SQL:

    SELECT COUNT(*) AS count
    FROM attachment AS attachment
    INNER JOIN post AS post USING (postid)
    WHERE attachment.visible = 0;

    MySQL Error : Unknown column 'postid' in 'from clause'
    Error Number : 1054
    Request Date : Tuesday, April 27th 2010 @ 05:04:47 PM
    Last edited by silentranks; Tue 27 Apr '10, 2:35pm.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.