MYSQL Error--Help Please...
 

:ninja: 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...

you haven't installed the shoutbox correctly.
Please always read instructions carefully, as the DB changes in them are important!

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

you'd better ask in the shoutbox support thread.

the permission field is missing, so you have to add the field via phpmyadmin for example. i think it's just a tiny int field, but as said you should ask in the shoutbox support for detailed infos.

I didn't thing there was support.. I am just asking whoever might know---