lanc3lot
01-03-2006, 07:40 AM
Please click on the attached image, i removed some plugins lately and then i saw this...apparently its from that plugins but is there any other way to "remove" this from admincp rather than search the plugins and see what i have add when i put them in my forum ?
http://img394.imageshack.us/img394/2789/example1admincp2bx.th.gif (http://img394.imageshack.us/my.php?image=example1admincp2bx.gif)
What i want to fix, is as u see in the image, the fields that dont have any entries at all and although that, they have yes/no next to them...!!(in the center of the page)
I ask that here, as it "happened" after a modification and i believe that in the how-to forums of Vb, they will tell me to come here:P
Ok i have did a little more research on this, and tryed to "fix" something in the usergroup (to alter a setting i mean) and i had the following problem:
Database error in vBulletin 3.5.0:
Invalid SQL:
UPDATE vb3new_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Content Editors',
`description` = 'Περιλαμβάνει τους συντάκτες για Reviews, Previews, News και γενικότερα περιεχόμενο για το gamers.gr',
`usertitle` = '',
`opentag` = '<img src=\"images/icons/editors/editors.png\" alt=\"content editors\"/>',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '782591',
`attachlimit` = '1000000',
`pmquota` = '300',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '23',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '203955843',
`genericoptions` = '31',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '30000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`arcadepermissions` = '15',
`journalpermissions` = '34015',
`ecdownloadpermissions` = '0',
`supportpermissions` = '0'
WHERE usergroupid=41;
MySQL Error : Unknown column 'ecdownloadpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, January 3rd 2006 @ 11:45:06 AM
Script : http://www.gamers.gr/forums/admincp/usergroup.php
Referrer : http://www.gamers.gr/forums/admincp/usergroup.php?do=edit&usergroupid=41
IP Address : 62.1.106.241
Username : lancelot
Classname : vb_database
So i assume, its a problem of ecdownloads hack, maybe this gives u a hint so u can help me better :)
Update
Ok i searched a bit more, as the error was more helping, and i found that after i did a rebuild in bitfields everything were fixed:)
So sorry for this thread, prob solved :)
Ps
For ppl that had similar probs with ecdownloads there is a post here (https://vborg.vbsupport.ru/showpost.php?p=771247&postcount=315) that helps a lot so how u can remove them:)
http://img394.imageshack.us/img394/2789/example1admincp2bx.th.gif (http://img394.imageshack.us/my.php?image=example1admincp2bx.gif)
What i want to fix, is as u see in the image, the fields that dont have any entries at all and although that, they have yes/no next to them...!!(in the center of the page)
I ask that here, as it "happened" after a modification and i believe that in the how-to forums of Vb, they will tell me to come here:P
Ok i have did a little more research on this, and tryed to "fix" something in the usergroup (to alter a setting i mean) and i had the following problem:
Database error in vBulletin 3.5.0:
Invalid SQL:
UPDATE vb3new_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Content Editors',
`description` = 'Περιλαμβάνει τους συντάκτες για Reviews, Previews, News και γενικότερα περιεχόμενο για το gamers.gr',
`usertitle` = '',
`opentag` = '<img src=\"images/icons/editors/editors.png\" alt=\"content editors\"/>',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '782591',
`attachlimit` = '1000000',
`pmquota` = '300',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '23',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '203955843',
`genericoptions` = '31',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '30000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`arcadepermissions` = '15',
`journalpermissions` = '34015',
`ecdownloadpermissions` = '0',
`supportpermissions` = '0'
WHERE usergroupid=41;
MySQL Error : Unknown column 'ecdownloadpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, January 3rd 2006 @ 11:45:06 AM
Script : http://www.gamers.gr/forums/admincp/usergroup.php
Referrer : http://www.gamers.gr/forums/admincp/usergroup.php?do=edit&usergroupid=41
IP Address : 62.1.106.241
Username : lancelot
Classname : vb_database
So i assume, its a problem of ecdownloads hack, maybe this gives u a hint so u can help me better :)
Update
Ok i searched a bit more, as the error was more helping, and i found that after i did a rebuild in bitfields everything were fixed:)
So sorry for this thread, prob solved :)
Ps
For ppl that had similar probs with ecdownloads there is a post here (https://vborg.vbsupport.ru/showpost.php?p=771247&postcount=315) that helps a lot so how u can remove them:)