MYSQL Error--Help Please...

[RichieBoy67]

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

[Xenon]

mysql error: Unknown column 'shoutboxpermissions' in 'field list'

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

[RichieBoy67]

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

[Xenon]

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.

[RichieBoy67]

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