Announcement

Collapse
No announcement yet.

Database error when trying to use "currently active users"?

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

  • Database error when trying to use "currently active users"?

    The error message:
    Database error in vBulletin 3.5.1:
    Invalid SQL:
    SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM session AS session
    LEFT JOIN user AS user USING (userid)
    WHERE session.lastactivity > 1137022288

    ORDER BY user.username asc;
    MySQL Error : Unknown column 'user.skype' in 'field list'
    Error Number : 1054
    Date : Wednesday, January 11th 2006 @ 05:46:28 PM
    Script : http://freeadvertisingzone.com/online.php
    Referrer : http://freeadvertisingzone.com/index.php
    IP Address : 66.91.79.184
    Username : Jeff Smith
    Classname : vb_database

    How do I fix this?

  • #2
    I believe skype was introduced later.. Either this is from a plugin/hack or you are using 3.5.1 files on an 3.5.2 or 3.5.3 forum.

    Comment

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