Log in

View Full Version : MySQL help


X-Sector
12-05-2004, 06:22 AM
I get this MySQL database error when updating the usergroup.php for vBulletin 3.0.3

Database error in vBulletin 3.0.3:

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 = '100',
avatarmaxheight = '100',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '0',
canaddshout = '0',
candropshout = '0',
candropothershout = '0',
caneditshout = '0',
caneditothershout = '0',
canreadshouts = '0',
forumpermissions = '127487',
pmpermissions = '3',
calendarpermissions = '19',
wolpermissions = '1',
adminpermissions = '0',
genericpermissions = '2889415',
genericoptions = '30',
arcadepermissions = '19'
WHERE usergroupid=2
mysql error: Unknown column 'canaddshout' in 'field list'

mysql error number: 1054

Date: Sunday 05th of December 2004 12:15:44 AM
Script: http://www.xelation.net/forums/admincp/usergroup.php
Referer: http://www.xelation.net/forums/admi...t&usergroupid=2
Username: logica
IP Address:

I'm really not sure what to do..

X-Sector
12-06-2004, 11:21 AM
*bump*

Dean C
12-06-2004, 12:14 PM
You have incorrectly installed the shoutbox hack, please

X-Sector
12-06-2004, 05:39 PM
I really don't get it..

I just installed the shoutbox hack called BVShoutbox fulle

The following link is https://vborg.vbsupport.ru/showthread.php?p=579405#post579405

I just installed it very very carefully, and l kept getting this MySQL error when updating the undergroup.php..