PDA

View Full Version : vButtetin Database Error 1054


conexn
Thu 6th Mar '08, 10:35am
Hello all, I come to you all again with another problem with vBulletin. When ever I try to add another forum to the site I get a database error, here is the latest one:

Invalid SQL:
INSERT INTO forum
(title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, password, css)
VALUES
('Test', 'Test', 'Test', 'Test', '', 120, -1, -1, 'lastpost', 'desc', 0, '', '', 97991, 0, '', '');
MySQL Error : Unknown column 'css' in 'field list'
Error Number : 1054
Date : Thursday, March 6th 2008 @ 02:21:21 PM
Script :


Running 3.6.8 patch 2

Lynne
Thu 6th Mar '08, 12:08pm
There is no column called "css" in the default vbulletin forum table, so this error is caused by a modification you have added. To get rid of the error, disable the modification. Then, go to the modification thread and see if someone can help you fix it.

conexn
Thu 6th Mar '08, 1:37pm
I removed it from the plugins and site went back to working correctly. Thanks for the pointer...

007
Thu 6th Mar '08, 2:10pm
I have this same error number but mine shows a column that actually is in the database. I just checked..

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 0;

MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054

I've had this error a few times and it's been a different userid each time.

Zachery
Thu 6th Mar '08, 2:11pm
Please start a new thread, your errror is unrelated to the original issue.