[LNTT]

Originally Posted by Sovereign

SQL error, help!

 
Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
update vb3_vbr_config set
active='1',
forumid='71',
typem='1'
where oid='1';
MySQL Error : Unknown column 'active' in 'field list'
Error Number : 1054
Date		 : Thursday, September 22nd 2005 @ 09:31:47 PM
Script	 : *****
Referrer	 : *****
IP Address : *****
Username	 : Sovereign
Classname	: vb_database

EDIT: Fixed with Nova2k's file...
New error, attempted to move post to recycle, got this:

Parse error: parse error, unexpected T_CASE in /home/alliance/public_html/vb/postings.php(204) : eval()'d code on line 2391

Uhm - i think you need reinstall vbrecycle 3.0.2 or run 3 queries bellow(go to admincp >> Maintenance >> Execute SQL Query or using phpmyadmin)

DROP TABLE IF EXISTS vbr_config

CREATE TABLE vbr_config (oid int(11) NOT NULL default 1, active int(11) NOT NULL default 1, forumid int(11) NOT NULL default 0, linkamfd int(11) NOT NULL default 2, linkamst int(11) NOT NULL default 1, typem int(11) NOT NULL default 1) ENGINE=MyISAM COMMENT='vBRecycle Config'

INSERT INTO vbr_config VALUES(1, 1, '', 2, 1, 1)

Note: run query in turn