vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   MAJOR problem please check this and help if possible (https://vborg.vbsupport.ru/showthread.php?t=107952)

Injektilo 02-14-2006 10:54 AM
MAJOR problem please check this and help if possible
 
when trying to change settings for any of my usergroups i get this error msg

Quote:
Database error in vBulletin 3.5.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Banned',
`description` = '',
`usertitle` = 'Banned',
`opentag` = '<strike><font color=\"#000000\">',
`closetag` = '</font></strike>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`buddiequota` = '0',
`buddiepermissions` = '0',
`awardpermissions` = '1',
`forumpermissions` = '0',
`attachlimit` = '1000000',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '5',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '1024',
`genericoptions` = '40',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`vbspacecomments` = '0',
`custompermissions` = '0',
`maxsiglines` = '',
`maxsigfontsize` = '',
`maxsigimgsize` = '',
`maxsigimgwidth` = '',
`maxsigimgheight` = '',
`maxsigimages` = '',
`sigforbiddencodes` = ''
WHERE usergroupid=18;

MySQL Error : Unknown column 'custompermissions' in 'field list'
Error Number : 1054
Date : Tuesday, February 14th 2006 @ 06:48:02 AM
Script : http://www.xxx.com/forum/xxx/usergroup.php
Referrer : http://www.xxx.com/forum/xxx/usergro...usergroupid=18
IP Address : xxxxxxxx
Username : xxxxxxxx
Classname : vb_database
what do i need to do to fix this?

Rich 02-14-2006 11:20 AM
You need to add the column 'custompermissions' in field list. You can add the column via phpmyadmin.

Injektilo 02-14-2006 11:29 AM
Quote:
Originally Posted by iguanairs
You need to add the column 'custompermissions' in field list. You can add the column via phpmyadmin.

what would be the command?

Marco van Herwaarden 02-14-2006 11:48 AM
This is probably caused by a hack you hae uninstalled, but have left the includes/xml/bitfield_<hackname>.xml file. Remove the file of the uninstalled ahck, and the problem will be gone.

Injektilo 02-14-2006 11:54 AM
Quote:
Originally Posted by MarcoH64
This is probably caused by a hack you hae uninstalled, but have left the includes/xml/bitfield_<hackname>.xml file. Remove the file of the uninstalled ahck, and the problem will be gone.

not sure which one is that :) any other solutions maybe?

Marco van Herwaarden 02-14-2006 12:01 PM
Which bitfield_XXXX.xml you have in your includes/xml directory?

Injektilo 02-14-2006 12:10 PM
1 Attachment(s)
Quote:
Originally Posted by MarcoH64
Which bitfield_XXXX.xml you have in your includes/xml directory?
these

Marco van Herwaarden 02-14-2006 12:57 PM
This is probably caused by one of the following hacks which you have probably uninstalled:
- Awards
- Buddies
- Comments
- Siglimits

Check if you have still installed the above hacks, if not remove the bitfield xml-file for that hack.


All times are GMT. The time now is 08:42 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.01194 seconds
  • Memory Usage 1,726KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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