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

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.../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.

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

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.

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: