Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2005, 08:24 PM
Prodigal Prodigal is offline
 
Join Date: Jan 2005
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default mysql is messed up

when editting my usergroup permissions, i get this error. i've tried to figure this out, but im getting no where. the jbjukebox, i thought that got deleted completely. i want it out. any ideas?
heres my error msg.
and no where in the the usergroup.php is anything about a jukebox...

________

Database error in vBulletin 3.0.5:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = '',
usertitle = 'Administrator',
opentag = '',
closetag = '',
passwordexpires = '180',
passwordhistory = '360',
attachlimit = '0',
avatarmaxwidth = '500',
avatarmaxheight = '500',
avatarmaxsize = '999999999',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '100%',
forumpermissions = '4063231',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '4194239',
genericoptions = '31',
jbjukebox = '0',
arcadepermissions = '0'
WHERE usergroupid=6
mysql error: Unknown column 'jbjukebox' in 'field list'

mysql error number: 1054

Date: Monday 31st of January 2005 04:31:10 PM
Script: http://www.dyna-micz.com/forums/admincp/usergroup.php
Referer: http://www.dyna-micz.com/forums/adm...t&usergroupid=6
Username: Prodigal
Reply With Quote
  #2  
Old 01-31-2005, 08:28 PM
miz miz is offline
 
Join Date: Mar 2003
Posts: 416
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

jbjukebox does not exsit in your database

are you sure its there ? shouldnt it be vbjukebox ?
Reply With Quote
  #3  
Old 01-31-2005, 09:20 PM
Prodigal Prodigal is offline
 
Join Date: Jan 2005
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

straight copied and pasted that.

someone was trying to install a jukebox on my system...and messed up. and i gotta be the one to fix it.
Reply With Quote
  #4  
Old 01-31-2005, 11:42 PM
AnhTuanCool's Avatar
AnhTuanCool AnhTuanCool is offline
 
Join Date: Jul 2004
Location: Albuquerque
Posts: 263
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's in forumroot/includes/init.php
Reply With Quote
  #5  
Old 02-01-2005, 01:32 AM
Prodigal Prodigal is offline
 
Join Date: Jan 2005
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

awesome. dont know you knew that. but maybe you can figure out this error also....
and i dont see this no where init.php

Database error in vBulletin 3.0.5:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = '',
usertitle = 'Administrator',
opentag = '',
closetag = '',
passwordexpires = '180',
passwordhistory = '360',
attachlimit = '0',
avatarmaxwidth = '500',
avatarmaxheight = '500',
avatarmaxsize = '999999999',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '100%',
jbcanlisten = '0',
jbcanrate = '0',
jbcanupload = '0',
forumpermissions = '4063231',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '4194239',
genericoptions = '31',
arcadepermissions = '0'
WHERE usergroupid=6
mysql error: Unknown column 'jbcanlisten' in 'field list'

mysql error number: 1054

Date: Tuesday 01st of February 2005 03:26:09 AM
Script: http://www.dyna-micz.com/forums/admincp/usergroup.php
Referer: http://www.dyna-micz.com/forums/admi...&usergroupid=6
Username: Prodigal
Reply With Quote
  #6  
Old 02-01-2005, 04:48 AM
AnhTuanCool's Avatar
AnhTuanCool AnhTuanCool is offline
 
Join Date: Jul 2004
Location: Albuquerque
Posts: 263
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

https://vborg.vbsupport.ru/showthread.php?t=74170
The link above leads to the support thread of this hack, as you might want to ask the author
Reply With Quote
Reply


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 09:49 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.03787 seconds
  • Memory Usage 2,204KB
  • 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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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