UserGroup's. Help needed Badly(Resolved) Thank's Peterska2

[SpanishHarlem]

Hello, First of all I appoligize if this is in the wrong place. Everytime I try and modify my user group's I get this.

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Happy Host',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`adoptpermissions` = '0',
`maxadopted` = '5',
`hkc_competition_permissions` = '0',
`userpagepermissions` = '0',
`allowhtmlpermissions` = '0',
`forumpermissions` = '782463',
`attachlimit` = '1000000',
`pmquota` = '500',
`pmpermissions` = '1',
`pmsendmax` = '5',
`calendarpermissions` = '55',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '2733979',
`genericoptions` = '15',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000'
WHERE usergroupid=15;

MySQL Error : Unknown column 'hkc_competition_permissions' in 'field list'
Error Number : 1054
Date : Wednesday, June 14th 2006 @ 08:38:07 AM
Script : http://canadian-freebies-n-stuff.com/forum/admincp/usergroup.php
Referrer :
IP Address : 74.12.45.155
Username : CherBear
Classname : vb_database

I don't have competitions on my forum

I can't ask the person that used to help me he has gone and cancelled his isp service and didn't let me know. What can I do? I have a forum over just over 2,300 and don't want to lose it and don't know how to upgrade. Please, can someone help me fix this error.

Thank's in advance.

[Code Monkey]

That collumn name is from this hack I believe.

https://vborg.vbsupport.ru/showthread.php?t=100150

He must have played with it. Look through it's istall instructions for clues.

http://www.vbulletin.com/forum/showthread.php?t=166600

[SpanishHarlem]

Well I have no competion files at all so basically my forum is snafued.

I am getting this now.
MySQL Error : Unknown column 'userpagepermissions' in 'field list'
Error Number : 1054

I give up. Time to close the forum I guess as I have no one to do upgrades for me.

Second link is totally different then what I am getting.

[Paul M]

Closing it seems a litle extreme. Try turning off plugins/products for starters.

[SpanishHarlem]

Closing it seems a litle extreme. Try turning off plugins/products for starters.



peterska2 has offered to help me. Hopefully it can be figured out. I have a dang migraine due to this. :bunny: