SQL ERROR when updating usergroup information.

[colinberkley]

here is the error message i get. i get this when i am trying to update usergroup options, such as can use signatures etc. any ideas?

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Registered',
description = '',
usertitle = 'Registered User',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
attachlimit = '0',
avatarmaxwidth = '100',
avatarmaxheight = '100',
avatarmaxsize = '10024',
profileusergroup[title = 'Registered',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '10024',
pmquota = '150',
pmsendmax = '5',
forumpermissions = '127231',
pmpermissions = '3',
calendarpermissions = '0',
wolpermissions = '0',
adminpermissions = '0',
genericpermissions = '5767',
genericoptions = '6'
WHERE usergroupid=2
mysql error: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near '[title =
'Registered',
profilepicmaxwidth = '100',
profilepic

mysql error number: 1064

[Steve Machol]

What's the script info at the bottom of this error message?

[colinberkley]

good lord that was quick.

Script: http://www.steroidsupport.com/forum/.../usergroup.php

[Steve Machol]

Reupload the original usergroup.php file from the vB3 RC3 zip file. Make sure you upload in ASCII and overwrite the one on the server.

[colinberkley]

did that and got the same error. set it to ASCII when uploading.

[Steve Machol]

Hmmm...syntax errors are almost always file related. Did you upgrade from a previous version?

[colinberkley]

yes i did. i had quite some problems though with my database. i will post a dump of the structure of the usergroup table. maybe there is an error there?

[colinberkley]

phpMyAdmin MySQL-Dump
# version 2.5.1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jan 29, 2004 at 05:13 PM
# Server version: 4.0.17
# PHP Version: 4.3.3
# Database : `*`
# --------------------------------------------------------

#
# Table structure for table `usergroup`
#
# Creation: Jan 27, 2004 at 06:14 PM
# Last update: Jan 27, 2004 at 06:14 PM
#

CREATE TABLE `usergroup` (
`usergroupid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`usertitle` varchar(100) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`opentag` varchar(100) NOT NULL default '',
`closetag` varchar(100) NOT NULL default '',
`forumpermissions` int(10) unsigned NOT NULL default '0',
`pmpermissions` int(10) unsigned NOT NULL default '0',
`calendarpermissions` int(10) unsigned NOT NULL default '0',
`wolpermissions` int(10) unsigned NOT NULL default '0',
`adminpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions` int(10) unsigned NOT NULL default '0',
`passwordexpires` smallint(5) unsigned NOT NULL default '0',
`passwordhistory` smallint(5) unsigned NOT NULL default '0',
`pmquota` smallint(5) unsigned NOT NULL default '0',
`attachlimit` int(10) unsigned NOT NULL default '0',
`avatarmaxwidth` smallint(5) unsigned NOT NULL default '0',
`avatarmaxheight` smallint(5) unsigned NOT NULL default '0',
`avatarmaxsize` int(10) unsigned NOT NULL default '0',
`profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxheight` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxsize` int(10) unsigned NOT NULL default '0',
`pmsendmax` smallint(5) unsigned NOT NULL default '5',
`genericoptions` int(10) unsigned NOT NULL default '0',
`ispublicgroup` smallint(5) unsigned NOT NULL default '0',
`canoverride` smallint(5) unsigned NOT NULL default '0',
`pmforwardmax` smallint(5) unsigned NOT NULL default '5',
`pmpermissions_bak` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`usergroupid`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;

[Steve Machol]

The only thing I see that doesn't belong there is 'pmpermissions_bak'.