Log in

View Full Version : Odd Admincp Error


TMXS
03-01-2006, 11:46 PM
Does this look familiar to anyone?

Database error in vBulletin 3.5.2:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Members',
`description` = '',
`usertitle` = 'Member',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`arcadepermissions` = '0',
`awardpermissions` = '0',
`imghost` = '0',
`imghostset` = '',
`imghost_width` = '',
`imghost_height` = '',
`imghost_files` = '',
`forumpermissions` = '0',
`attachlimit` = '0',
`pmquota` = '200',
`pmpermissions` = '0',
`pmsendmax` = '5',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '2621440',
`genericoptions` = '22',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '160',
`avatarmaxheight` = '160',
`avatarmaxsize` = '60000'
WHERE usergroupid=2;
MySQL Error : Unknown column 'imghost' in 'field list'
Error Number : 1054
Date : Wednesday, March 1st 2006 @ 07:36:25 PM
Script : http://www.guiltyparties.com/forums/admincp/usergroup.php
Referrer : http://www.guiltyparties.com/forums/admincp/usergroup.php?do=edit&usergroupid=2

Marco van Herwaarden
03-02-2006, 07:51 AM
You probably installed a product (image hosting?) and later uninstalled it, but left the includes/xml/bitfield_xxx.xml file for that product.

TMXS
03-02-2006, 03:29 PM
The only thing I've installed into the board, other than the arcade, was Drupal. But this is a very old database and its hard to pinpoint exactly who did what aside from me.

What I'd like to know is this, is there any way that this field is necessary for vBulletin? If not, I'll just get rid of it.

------

Update

After further investigation it was determined that there is no such field (imghost) anywhere. We did find the following in the "datastore" "bitfield":


...{s:10:"imghostset";i:1024;s:13:"imghost_width";i:100;s:14:
"imghost_height";i:100;s:13:"imghost_files";i:100;s:11:"attachlimit";i:1;s:7: ...

Any ideas?

Marco van Herwaarden
03-03-2006, 06:40 AM
See my previous post, remove the bitfield xml-file.

TMXS
03-03-2006, 02:23 PM
Thanks a lot. I was a bit cautious about dabbling with the xml files, always dealt with mysql and php in the past.