vb.org Archive

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

lolzers 11-05-2007 08:33 PM
MySQL Error
 
Whenever I try to create usergroup or modify them, plus other things, I get an error like this. What do I do to fix this?

Code:
Database error in vBulletin 3.6.8:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
        (`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `hkc_competition_permissions`, `imghost`, `imghostset`, `imghost_width`, `imghost_height`, `imghost_files`, `advanced_bbcode_usergroup_on`, `advanced_bbcode_usergroup_permissions`, `advanced_bbcode_usergroup_permissions_custom`)
VALUES
        ('weee', '', '', '', '', '', '', '0', '0', '651271', '2626563', '1000000', '0', '0', '5', '0', '1', '0', '41', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '7', '', '0', '0', '', '', '', '', '0', '0', 'a0');

MySQL Error  : Unknown column 'imghost' in 'field list'
Error Number : 1054
Date        : Monday, November 5th 2007 @ 05:33:17 PM
Script      : http://habboboards.com/forum/admincp/usergroup.php?do=update
Referrer    : http://habboboards.com/forum/admincp/usergroup.php?do=add
IP Address  : 24.137.201.155
Username    : Will
Classname    : vb_database

snakes1100 11-05-2007 08:43 PM
Looks like you have a hack installed that is causing that error, disable all your hacks and see if it goes away.

lolzers 11-05-2007 08:48 PM
I disabled them all and its still there.

snakes1100 11-05-2007 09:44 PM
It appears at some point then you had a hack installed that used "imghost" as a column in the DB, i also see numerous other columns in there that arent default columns.

If the hack is removed from the site, you will need to remove those columns manually.

lolzers 11-05-2007 09:58 PM
How do I remove them?

snakes1100 11-05-2007 10:20 PM
You should probably first check and make sure what hack was using that column and make sure its no longer needed, then you can use phpmyadmin to remove them if they arent needed,

Paul M 11-05-2007 10:35 PM
You don't need to remove any columns - that error mesage is telling you that a column no longer exists, so you cannot possibly remove it (again).

Most likely you have an old bitfield xml file from a mod you have removed still in your includes/xml folder.


All times are GMT. The time now is 08:56 PM.

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.01588 seconds
  • Memory Usage 1,718KB
  • 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_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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