PDA

View Full Version : Quick SQL Help


Kaldes
02-04-2005, 02:31 AM
I'm getting this error from a mod I installed then remove, obviously a part is still there
Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Registered Users',
description = '',
usertitle = '',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
gtpcanreadcontent = '0',
attachlimit = '0',
avatarmaxwidth = '120',
avatarmaxheight = '120',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
forumpermissions = '53759',
pmpermissions = '3',
calendarpermissions = '19',
wolpermissions = '1',
adminpermissions = '0',
genericpermissions = '267843',
genericoptions = '31'
WHERE usergroupid=2
mysql error: Unknown column 'gtpcanreadcontent' in 'field list'

mysql error number: 1054

So obviously I have to "gtpcanreadcontent" and remove it, but for some reason I can not find it.

Zachery
02-04-2005, 02:51 AM
its in one of the cron files in /includes/cron

Kaldes
02-04-2005, 03:06 AM
Strange I looked, but no luck...

Dean C
02-04-2005, 09:48 AM
You obviously haven't removed all file changes on that modification. Go back and make sure that all the changes you made to each file are reversed.