HELP, please...cant edit any usergroup :(

[silver surfer]

I dont know what happened exactly...
But i cant edit any usergroup any more or even create new ones.I had once the MGC chatbox installed, but i uninstalled it 10 days ago and deleted all template and css modifications i made 4 that shout box.
Today i got now this error message as i tried to create and edit a usergroup :

PHP Code:

Database error in vBulletin 3.6.8:
 
Invalid SQL:
UPDATE vbusergroup SET
 
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Banned Users',
    `description` = '',
    `usertitle` = 'I did shit and got banned',
    `opentag` = '<span style=\'color:black\'>',
    `closetag` = '',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `ispublicgroup` = '0',
    `canoverride` = '0',
    `forumpermissions` = '0',
    `attachlimit` = '1',
    `pmquota` = '0',
    `pmpermissions` = '0',
    `pmsendmax` = '0',
    `calendarpermissions` = '0',
    `wolpermissions` = '0',
    `adminpermissions` = '0',
    `genericpermissions` = '0',
    `genericoptions` = '0',
    `profilepicmaxwidth` = '0',
    `profilepicmaxheight` = '0',
    `profilepicmaxsize` = '0',
    `avatarmaxwidth` = '0',
    `avatarmaxheight` = '0',
    `avatarmaxsize` = '0',
    `signaturepermissions` = '0',
    `sigpicmaxwidth` = '0',
    `sigpicmaxheight` = '0',
    `sigpicmaxsize` = '0',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '1',
    `sigmaximages` = '0',
    `Xtvpermissions` = '0',
    `mgccustomusergroupperms` = '0',
    `nbmsgshowchatbox` = '',
    `awardpermissions` = '1',
    `radiotvpermissions` = '0',
    `vbppermissions` = '0',
    `vbp_discountrate` = '0.00000',
    `vbp_paycheckamount` = '0.00000',
    `vbp_secondarycost` = '0.00000',
    `vbp_primarycost` = '0.00000',
    `spoilt_repextra_perms` = '0'
WHERE usergroupid=8;
 
MySQL Error  : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date         : Thursday, December 27th 2007 @ 06:21:27 PM
Script       : http://site.com/admincp/usergroup.php?do=update
Referrer     : http://site.com/admincp/usergroup.php?do=edit&usergroupid=8
IP Address   : xxx.xx.xxx.xx
Username     : silver surfer
Classname    : vb_database 


i attached my admincp / usergroup.php if some1 could help me out. I cant figure out why this happen :S

Thank you and a happy new year !

*** Attached file removed, please don't upload full copyrighted material. ***

[MoT3rror]

Disable all plugins by adding this to your config.

PHP Code:

<?php
define('DISABLE_HOOKS', true);
?>

If the problem still happens, download vbulletin again but just upload usergroup.php in the admin CP.

Also makesure there is no MGC Chat product still in Plugin & Products -> Manage Products

[Marco van Herwaarden]

What is the URL to your board?

[silver surfer]

Originally Posted by MoT3rror

Disable all plugins by adding this to your config.

PHP Code:

<?php
define('DISABLE_HOOKS', true);
?>

If the problem still happens, download vbulletin again but just upload usergroup.php in the admin CP.

Also makesure there is no MGC Chat product still in Plugin & Products -> Manage Products

thnx, but didnt work
i tried both...first i added the code you provided.still same.then i uploaded a new usergroup.php.with the same result. Mgc plugins, template modifications and product are already deleted or uninstalled.

Originally Posted by Marco van Herwaarden

What is the URL to your board?

sorry if i attached a copyright file..
i dont want to advertise it here, becuz you already closed a thread of mine
but u can see it in my signature

Any help is really appreciated.

[Marco van Herwaarden]

The file you posted was a nulled copy of vBulletin. As there is no need to run nulled files on your licensed board, i strongly suspect that you try to get support for a unlicensed different site.

PHP Code:

|| # vBulletin 3.6.8 - Licence Number DGT-SERIAL 


[silver surfer]

Originally Posted by Marco van Herwaarden

The file you posted was a nulled copy of vBulletin. As there is no need to run nulled files on your licensed board, i strongly suspect that you try to get support for a unlicensed different site.

PHP Code:

|| # vBulletin 3.6.8 - Licence Number DGT-SERIAL 


i dont know what you are on to, but i HAVE my license and its all about MY board.
What do you mean by "nulled" files ?
I buyed vbulletin license from vbulletin.com, i have my customer number and all support i want to get is to get my board running like it should.
i trust you and if you want me to, i will pm you my detailed vbulletin.com infos so you can prove anything you want.There is no need to offend me like that ...you DONT know me.

[Marco van Herwaarden]

Sorry if i offended you (not sure why though).

You posted a nulled copy of a vBulletin file.
You are asking for support with that file.

If you are running a licensed board, then you should be using your licensed files, not a nulled copy. We can not provide support for nulled files.

PS No need to sent me any details, i already do know your details.

[Floris]

vBulletin.org staff and vBulletin.com staff simply can not condone piracy and have to protect the IP of Jelsoft. If you run pirated files but have a license we require you to change your pirated files (nulled copy) with your legally licensed files. We can't provide any support for them.

Simply get the latest stable version of vBulletin, currently 3.6.8 PL2 and replace the files you run. At which point you're liable for support again.

If you steal a Ferrari, and then buy one, but drive the stolen one. .. It doesn't magically turn it into a non-stolen one.

[silver surfer]

Originally Posted by Marco van Herwaarden

Sorry if i offended you (not sure why though).

You posted a nulled copy of a vBulletin file.
You are asking for support with that file.

If you are running a licensed board, then you should be using your licensed files, not a nulled copy. We can not provide support for nulled files.

PS No need to sent me any details, i already do know your details.

good to know you know my details
if you do, you should KNOW that my license and product are LEGAL and valid.
you still didnt reply to what this "nulled" files are...and how did i get them if i download the 3.6.8 patch 2 VBulletin version DIRECTLY from vbulletin.com ???

Originally Posted by Floris

vBulletin.org staff and vBulletin.com staff simply can not condone piracy and have to protect the IP of Jelsoft. If you run pirated files but have a license we require you to change your pirated files (nulled copy) with your legally licensed files. We can't provide any support for them.

Simply get the latest stable version of vBulletin, currently 3.6.8 PL2 and replace the files you run. At which point you're liable for support again.

If you steal a Ferrari, and then buy one, but drive the stolen one. .. It doesn't magically turn it into a non-stolen one.

LOL..."i stoled a ferrari, buyed another one and drive my stoled one" ? comon...

like i explained a few times already...i OWN A LEGAL VB LICENSE I BUYED !!!
and why should i ask 4 support for "pirated" license, EVEN if i would have a "pirated" version AND a legal one ?

[Opserty]

Nulled files are ones which are edited (i.e. nulled) to allow people to use the software(/files) for free. vBulletin files, amongst other things, always have the license number displayed at the top of the PHP file. According to post #5 the License number is not there, as such it indicates that the file you added as an attachment was not downloaded from vBulletin.com and as such is not a legal vBulletin PHP File. (Basically your License may be legal but the file is not)

Maybe you uploaded the wrong file from the wrong folder or something, however what they are trying to say is that you need to ensure that you upload a fresh copy of vBulletin 3.6.8, from the vBulletin.com members area, to your server.