Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 01-03-2006, 07:40 AM
lanc3lot's Avatar
lanc3lot lanc3lot is offline
 
Join Date: Sep 2004
Location: Athens, Greece
Posts: 454
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How can i fix this?

Please click on the attached image, i removed some plugins lately and then i saw this...apparently its from that plugins but is there any other way to "remove" this from admincp rather than search the plugins and see what i have add when i put them in my forum ?



What i want to fix, is as u see in the image, the fields that dont have any entries at all and although that, they have yes/no next to them...!!(in the center of the page)


I ask that here, as it "happened" after a modification and i believe that in the how-to forums of Vb, they will tell me to come here:P

Ok i have did a little more research on this, and tryed to "fix" something in the usergroup (to alter a setting i mean) and i had the following problem:

Code:
Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb3new_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Content Editors',
	`description` = 'Περιλαμβάνει τους συντάκτες για Reviews, Previews, News και γενικότερα περιεχόμενο για το gamers.gr',
	`usertitle` = '',
	`opentag` = '<img src=\"images/icons/editors/editors.png\" alt=\"content editors\"/>',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`ispublicgroup` = '0',
	`canoverride` = '0',
	`forumpermissions` = '782591',
	`attachlimit` = '1000000',
	`pmquota` = '300',
	`pmpermissions` = '3',
	`pmsendmax` = '5',
	`calendarpermissions` = '23',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions` = '203955843',
	`genericoptions` = '31',
	`profilepicmaxwidth` = '150',
	`profilepicmaxheight` = '150',
	`profilepicmaxsize` = '30000',
	`avatarmaxwidth` = '150',
	`avatarmaxheight` = '150',
	`avatarmaxsize` = '30000',
	`arcadepermissions` = '15',
	`journalpermissions` = '34015',
	`ecdownloadpermissions` = '0',
	`supportpermissions` = '0'
WHERE usergroupid=41;

MySQL Error  : Unknown column 'ecdownloadpermissions' in 'field list'
Error Number : 1054
Date         : Tuesday, January 3rd 2006 @ 11:45:06 AM
Script       : http://www.gamers.gr/forums/admincp/usergroup.php
Referrer     : http://www.gamers.gr/forums/admincp/usergroup.php?do=edit&usergroupid=41
IP Address   : 62.1.106.241
Username     : lancelot
Classname    : vb_database
So i assume, its a problem of ecdownloads hack, maybe this gives u a hint so u can help me better

Update


Ok i searched a bit more, as the error was more helping, and i found that after i did a rebuild in bitfields everything were fixed

So sorry for this thread, prob solved

Ps

For ppl that had similar probs with ecdownloads there is a post here that helps a lot so how u can remove them
Reply With Quote
  #2  
Old 01-03-2006, 10:54 PM
MR-2ZZ MR-2ZZ is offline
 
Join Date: Nov 2004
Location: Belmont Shore, CA
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Good job on the troubleshooting there bro.

A lot of people overlook the MySQL Error: XXXXX, it can be a valueable source for finding a problem!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03217 seconds
  • Memory Usage 2,163KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete