Announcement

Collapse
No announcement yet.

Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error

    i get the following error when trying to access the index page:

    Database error in vBulletin 3.5.0 Release Candidate 3:
    Invalid SQL:
    SELECT username, userid, birthday
    FROM vb3_user
    WHERE (birthday LIKE '09-11-%' OR birthday LIKE '09-12-%')
    AND usergroupid IN (0, 6, 7, 2, 5)
    AND showbirthday = 2
    AND lastactivity >= 1123887946;
    MySQL Error : Unknown column 'showbirthday' in 'where clause'
    Error Number : 1054
    Date : Sunday, September 11th 2005 @ 06:05:46 PM
    Script : http://www.gamerskeep.co.uk/forums/index.php
    Referrer : http://www.gamerskeep.co.uk/forums/s...p=95&styleid=1
    IP Address : 195.93.21.34
    Username : Lucid
    Classname : vb_database

    this only started happening after i upgraded to rc3... can someone point me in the right direction as to what may be causing this?

  • #2
    http://www.vbulletin.com/forum/showthread.php?p=960003

    Except in your case the query is:

    ALTER TABLE vb3_user ADD showbirthday SMALLINT UNSIGNED DEFAULT '2' NOT NULL;
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      cheers... i didnt realise it had allready been asked sorry

      Comment

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