Uninstalling a plugin/product problem, help?

[makemedie]

Hey all,

I uninstalled SOME plugin, dont know what it was called (was a while back), and only now did I realize that I can't edit usergroups. It gives me the error -

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Private Community Member',
	`description` = '',
	`usertitle` = 'Private Community Member',
	`opentag` = '<font color=FFFFFF><b>~',
	`closetag` = '</color>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`ispublicgroup` = '0',
	`canoverride` = '0',
	`forumpermissions` = '782583',
	`attachlimit` = '1000000',
	`pmquota` = '50',
	`pmpermissions` = '3',
	`pmsendmax` = '5',
	`calendarpermissions` = '17',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions` = '201899743',
	`genericoptions` = '15',
	`profilepicmaxwidth` = '200',
	`profilepicmaxheight` = '200',
	`profilepicmaxsize` = '25000',
	`avatarmaxwidth` = '200',
	`avatarmaxheight` = '200',
	`avatarmaxsize` = '999999999',
	`profileviewpermissions` = '0'
WHERE usergroupid=9;

MySQL Error  : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054

The obvious problem here is that "profileviewpermissions" either doesn't exist, or is screwed. Anyone know how I can delete that column or something? I mean, what am I supposed to do to fix this?

Sorry if I posted this in the wrong place.

[Pickalo]

Search for Advanced Product Manager.

Install it, then go to the Advanced Product Manager in your admincp.
Find the installed product, and click Advanced Product Edit
There should be something there that says Install Code / Uninstall Code - Make sure the box to the right is checked and go to delete. From there, just uninstall the product using the Advanced Product Manager.

Hope this helps

[Yukino_AE]

i'm gettign the same error, i've even cleared out my db and started from scratch with a fresh install. is that something i have to readd back? i don't know. grrr.

[Ntfu2]

If you've started from a fresh install with no hacks or modifications its obvisously not going to be a hacks fault.

@makemedie
Simply remove this row: `profileviewpermissions` from ther USERGROUP. Easiest way would be using phpMyAdmin