vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Odd Admincp Error (https://vborg.vbsupport.ru/showthread.php?t=109249)

TMXS 03-01-2006 11:46 PM

Odd Admincp Error
 
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/.../usergroup.php
Referrer : http://www.guiltyparties.com/forums/...&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":

Quote:

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


All times are GMT. The time now is 07:12 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00973 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete