Announcement

Collapse
No announcement yet.

SQL Error in 3.6.3?

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

  • SQL Error in 3.6.3?

    Upgraded to try and solve a banning problem, looks like I have the same problem but can't solve it, any ideas?

    Database error in vBulletin 3.6.3:

    Invalid SQL:

    SELECT user.*,
    userban.usergroupid AS banusergroupid, userban.displaygroupid AS bandisplaygroupid, userban.customtitle AS bancustomtitle, userban.usertitle AS banusertitle
    FROM userban AS userban
    LEFT JOIN user AS user USING(userid)
    WHERE liftdate <> 0 AND liftdate < 1163569673
    ### SELECTING BANNED USERS WHO ARE DUE TO BE RESTORED ###;

    MySQL Error : Table 'rburns_rugbyrefs_forums.userban' doesn't exist
    Error Number : 1146
    Date : Tuesday, November 14th 2006 @ 11:47:54 PM
    Script : http://www.rugbyrefs.com/forums/cron.php?&rand=989390
    Referrer : http://www.rugbyrefs.com/forums/
    IP Address : 86.144.11.60
    Username : Unregistered
    Classname : vb_database

    The userban table does exist, I checked it.

  • #2
    Are you sure that table exists? Make sure it uses the appropriate table prefix as defined in your includes/config.php file.

    Try running a repair / optimize to make sure everything is OK:

    Admin CP -> Maintenance -> Repair / Optimize Tables

    You can also run this query to create the table if it's not there:

    Code:
    CREATE TABLE userban (
    	userid INT UNSIGNED NOT NULL DEFAULT '0',
    	usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    	displaygroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    	usertitle VARCHAR(250) NOT NULL DEFAULT '',
    	customtitle SMALLINT NOT NULL DEFAULT '0',
    	adminid INT UNSIGNED NOT NULL DEFAULT '0',
    	bandate INT UNSIGNED NOT NULL DEFAULT '0',
    	liftdate INT UNSIGNED NOT NULL DEFAULT '0',
    	reason VARCHAR(250) NOT NULL DEFAULT '',
    	PRIMARY KEY (userid),
    	KEY liftdate (liftdate)
    )

    Comment


    • #3
      Thanks for that.

      Comment

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