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 12-27-2007, 11:26 PM
silver surfer's Avatar
silver surfer silver surfer is offline
 
Join Date: Aug 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default HELP, please...cant edit any usergroup :(

I dont know what happened exactly...
But i cant edit any usergroup any more or even create new ones.I had once the MGC chatbox installed, but i uninstalled it 10 days ago and deleted all template and css modifications i made 4 that shout box.
Today i got now this error message as i tried to create and edit a usergroup :

PHP Code:
Database error in vBulletin 3.6.8:
 
Invalid SQL:
UPDATE vbusergroup SET
 
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    
`title` = 'Banned Users',
    `
description` = '',
    `
usertitle` = 'I did shit and got banned',
    `
opentag` = '<span style=\'color:black\'>',
    `
closetag` = '',
    `
passwordexpires` = '0',
    `
passwordhistory` = '0',
    `
ispublicgroup` = '0',
    `
canoverride` = '0',
    `
forumpermissions` = '0',
    `
attachlimit` = '1',
    `
pmquota` = '0',
    `
pmpermissions` = '0',
    `
pmsendmax` = '0',
    `
calendarpermissions` = '0',
    `
wolpermissions` = '0',
    `
adminpermissions` = '0',
    `
genericpermissions` = '0',
    `
genericoptions` = '0',
    `
profilepicmaxwidth` = '0',
    `
profilepicmaxheight` = '0',
    `
profilepicmaxsize` = '0',
    `
avatarmaxwidth` = '0',
    `
avatarmaxheight` = '0',
    `
avatarmaxsize` = '0',
    `
signaturepermissions` = '0',
    `
sigpicmaxwidth` = '0',
    `
sigpicmaxheight` = '0',
    `
sigpicmaxsize` = '0',
    `
sigmaxrawchars` = '0',
    `
sigmaxchars` = '0',
    `
sigmaxlines` = '0',
    `
sigmaxsizebbcode` = '1',
    `
sigmaximages` = '0',
    `
Xtvpermissions` = '0',
    `
mgccustomusergroupperms` = '0',
    `
nbmsgshowchatbox` = '',
    `
awardpermissions` = '1',
    `
radiotvpermissions` = '0',
    `
vbppermissions` = '0',
    `
vbp_discountrate` = '0.00000',
    `
vbp_paycheckamount` = '0.00000',
    `
vbp_secondarycost` = '0.00000',
    `
vbp_primarycost` = '0.00000',
    `
spoilt_repextra_perms` = '0'
WHERE usergroupid=8;
 
MySQL Error  Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number 1054
Date         
ThursdayDecember 27th 2007 06:21:27 PM
Script       
http://site.com/admincp/usergroup.php?do=update
Referrer     http://site.com/admincp/usergroup.php?do=edit&usergroupid=8
IP Address   xxx.xx.xxx.xx
Username     
silver surfer
Classname    
vb_database 
i attached my admincp / usergroup.php if some1 could help me out. I cant figure out why this happen :S

Thank you and a happy new year !

*** Attached file removed, please don't upload full copyrighted material. ***
Reply With Quote
  #2  
Old 12-28-2007, 02:31 AM
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
Posts: 423
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Disable all plugins by adding this to your config.

PHP Code:
<?php
define
('DISABLE_HOOKS'true);
?>
If the problem still happens, download vbulletin again but just upload usergroup.php in the admin CP.

Also makesure there is no MGC Chat product still in Plugin & Products -> Manage Products
Reply With Quote
  #3  
Old 12-28-2007, 07:34 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What is the URL to your board?
Reply With Quote
  #4  
Old 12-28-2007, 08:54 AM
silver surfer's Avatar
silver surfer silver surfer is offline
 
Join Date: Aug 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MoT3rror View Post
Disable all plugins by adding this to your config.

PHP Code:
<?php
define
('DISABLE_HOOKS'true);
?>
If the problem still happens, download vbulletin again but just upload usergroup.php in the admin CP.

Also makesure there is no MGC Chat product still in Plugin & Products -> Manage Products
thnx, but didnt work
i tried both...first i added the code you provided.still same.then i uploaded a new usergroup.php.with the same result. Mgc plugins, template modifications and product are already deleted or uninstalled.

Quote:
Originally Posted by Marco van Herwaarden View Post
What is the URL to your board?
sorry if i attached a copyright file..
i dont want to advertise it here, becuz you already closed a thread of mine
but u can see it in my signature

Any help is really appreciated.
Reply With Quote
  #5  
Old 12-28-2007, 09:11 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The file you posted was a nulled copy of vBulletin. As there is no need to run nulled files on your licensed board, i strongly suspect that you try to get support for a unlicensed different site.

PHP Code:
|| # vBulletin 3.6.8 - Licence Number DGT-SERIAL 
Reply With Quote
  #6  
Old 12-28-2007, 10:09 AM
silver surfer's Avatar
silver surfer silver surfer is offline
 
Join Date: Aug 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Marco van Herwaarden View Post
The file you posted was a nulled copy of vBulletin. As there is no need to run nulled files on your licensed board, i strongly suspect that you try to get support for a unlicensed different site.

PHP Code:
|| # vBulletin 3.6.8 - Licence Number DGT-SERIAL 
i dont know what you are on to, but i HAVE my license and its all about MY board.
What do you mean by "nulled" files ?
I buyed vbulletin license from vbulletin.com, i have my customer number and all support i want to get is to get my board running like it should.
i trust you and if you want me to, i will pm you my detailed vbulletin.com infos so you can prove anything you want.There is no need to offend me like that ...you DONT know me.
Reply With Quote
  #7  
Old 12-28-2007, 10:23 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sorry if i offended you (not sure why though).

You posted a nulled copy of a vBulletin file.
You are asking for support with that file.

If you are running a licensed board, then you should be using your licensed files, not a nulled copy. We can not provide support for nulled files.

PS No need to sent me any details, i already do know your details.
Reply With Quote
  #8  
Old 12-28-2007, 10:28 AM
Floris Floris is offline
 
Join Date: Jan 2002
Posts: 1,898
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

vBulletin.org staff and vBulletin.com staff simply can not condone piracy and have to protect the IP of Jelsoft. If you run pirated files but have a license we require you to change your pirated files (nulled copy) with your legally licensed files. We can't provide any support for them.

Simply get the latest stable version of vBulletin, currently 3.6.8 PL2 and replace the files you run. At which point you're liable for support again.

If you steal a Ferrari, and then buy one, but drive the stolen one. .. It doesn't magically turn it into a non-stolen one.
Reply With Quote
  #9  
Old 12-28-2007, 11:04 AM
silver surfer's Avatar
silver surfer silver surfer is offline
 
Join Date: Aug 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Marco van Herwaarden View Post
Sorry if i offended you (not sure why though).

You posted a nulled copy of a vBulletin file.
You are asking for support with that file.

If you are running a licensed board, then you should be using your licensed files, not a nulled copy. We can not provide support for nulled files.

PS No need to sent me any details, i already do know your details.
good to know you know my details
if you do, you should KNOW that my license and product are LEGAL and valid.
you still didnt reply to what this "nulled" files are...and how did i get them if i download the 3.6.8 patch 2 VBulletin version DIRECTLY from vbulletin.com ???

Quote:
Originally Posted by Floris View Post
vBulletin.org staff and vBulletin.com staff simply can not condone piracy and have to protect the IP of Jelsoft. If you run pirated files but have a license we require you to change your pirated files (nulled copy) with your legally licensed files. We can't provide any support for them.

Simply get the latest stable version of vBulletin, currently 3.6.8 PL2 and replace the files you run. At which point you're liable for support again.

If you steal a Ferrari, and then buy one, but drive the stolen one. .. It doesn't magically turn it into a non-stolen one.
LOL..."i stoled a ferrari, buyed another one and drive my stoled one" ? comon...

like i explained a few times already...i OWN A LEGAL VB LICENSE I BUYED !!!
and why should i ask 4 support for "pirated" license, EVEN if i would have a "pirated" version AND a legal one ?
Reply With Quote
  #10  
Old 12-28-2007, 11:39 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nulled files are ones which are edited (i.e. nulled) to allow people to use the software(/files) for free. vBulletin files, amongst other things, always have the license number displayed at the top of the PHP file. According to post #5 the License number is not there, as such it indicates that the file you added as an attachment was not downloaded from vBulletin.com and as such is not a legal vBulletin PHP File. (Basically your License may be legal but the file is not)

Maybe you uploaded the wrong file from the wrong folder or something, however what they are trying to say is that you need to ensure that you upload a fresh copy of vBulletin 3.6.8, from the vBulletin.com members area, to your server.
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 01:38 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.05299 seconds
  • Memory Usage 2,298KB
  • Queries Executed 13 (?)
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
  • (5)bbcode_php
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_postinfo_query
  • fetch_postinfo
  • 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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete