MYSQL Error--Help Please...
--------------------------------------------------------------------------------
I am trying to allow users to use Avatares and when I run a querry from Usergroups I get the following error..I know it has something to do with the fact that I semiinstalled shout box...
Database error in vBulletin 3.0.0:
Invalid SQL: UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Registered Users',
description = '',
usertitle = '',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
attachlimit = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
forumpermissions = '127487',
pmpermissions = '3',
calendarpermissions = '19',
wolpermissions = '1',
adminpermissions = '0',
genericpermissions = '5831',
genericoptions = '30',
shoutboxpermissions = '0',
arcadepermissions = '19'
WHERE usergroupid=2
mysql error: Unknown column 'shoutboxpermissions' in 'field list'
mysql error number: 1054
How can I fix this??
Thanks ahead...
I have tried and tried to install the shoutbox correctly..I just tried editing all the php files again a minute ago to no avail..I ended up re uploading my includes/functions_online file because I kep getting a parse error......
Now I cannot reinstall using the admincp/shout_install unless I delte tables from MYSQL and I am scared to do that....
What do you reccomend??? Is there any way someone can edit the php files with the correct shoutbox edits?? I'm messing up somewhere along the line...
|