Latest Announcemnent
New thread

MYSQL ERROR no. 1054 in my vbulletin plz help

Status
Not open for further replies.
S

saman.j.l33t

Active Member
43
2009
0
0
Hi.
I got a problem regarding this error. When i try to create new usergroup. this error shows up.
Anyone knows how to troubleshoot it?

i m using:
vbulletin: 4.0.2 patch level 4
MYSQL version: 5.0.91
PHP version: 5.2.9
heres the full error its shows:

Code: 
Database error in vBulletin 4.0.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO haxorusergroup
    (`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `vbbotspidershieldviewpermissions`, `vbbotspidershieldsubmitpermissions`)
VALUES
    ('S-F V.I.P', '', '', '', '', '0', '0', '0', '0', '12317183', '1579685063', '0', '50', '3', '5', '0', '63', '1', '0', '1', '62', '100', '100', '65535', '80', '80', '20000', '137215', '500', '100', '10000', '1000', '500', '0', '7', '4', '255', '600', '600', '100', '0', '63', '63', '251767', '5', '65535', '0', '0');

MySQL Error   : Unknown column 'vbbotspidershieldviewpermissions' in 'field list'
Error Number  : 1054
Request Date  : Friday, July 16th 2010 @ 12:04:29 PM
Error Date    : Friday, July 16th 2010 @ 12:04:30 PM
Script        : http://student-freaks.com/admincp/usergroup.php?do=update
Referrer      : http://student-freaks.com/admincp/usergroup.php?do=add
IP Address    : 117.197.115.201
Username      : SaMaN "ThE EthiCal HaCkeR"
Classname     : vB_Database
MySQL Version : 5.0.91-community


CAN ANYONE HELP..??

thnx :)
 
7 comments
a quick fix would be

ALTER TABLE haxorusergroup ADD vbbotspidershieldviewpermissions VARCHAR(60);
ALTER TABLE haxorusergroup ADD vbbotspidershieldsubmitpermissions VARCHAR(60);

but you may have to set a default value.
find the mod that uses vbbotspidershieldviewpermissions and see whats wrong.
 
you have installed "vBulletin Bots & Spiders Shield" version 1.02 read this post and you have what you are looking for.
Code: 
http://www.vbteam.info/vb-3-8-x-addons-and-template-modifications/37296-vbteam-exclusive-vbulletin-bots-and-spiders-shield.html
 
Thnx GaV0 and dermechove....
i just uninstalled this vBulletin Bots & Spiders Shield"
and everything's fine now. actually the version of this mod created problem i think..and GaV0 that quickfix will also make it work..

Thnx Again :)
 
Status
Not open for further replies.
Back
Top