Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2014, 10:16 PM
iNate19 iNate19 is offline
 
Join Date: Mar 2012
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Unable to edit Usergroups & Unable to Remove Plugin

When I try to edit a Usergroup's Permissions, I receive the following Database Error
Quote:
Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`pbusernamelimit` = '',
`ms_imageshack_upload_permissions` = '0',
`ms_megaupload_upload_permissions` = '0',
`ms_photobucket_upload_permissions` = '0',
`forumpermissions` = '10211583',
`genericpermissions` = '1275076227',
`attachlimit` = '1',
`pmquota` = '5',
`pmpermissions` = '0',
`pmsendmax` = '1',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions2` = '5',
`genericoptions` = '58',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`signaturepermissions` = '400511',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '200',
`sigmaxchars` = '300',
`sigmaxlines` = '8',
`sigmaxsizebbcode` = '4',
`sigmaximages` = '1',
`sigmaxvideos` = '1',
`albumpermissions` = '239',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '20',
`albummaxsize` = '0',
`usercsspermissions` = '160',
`visitormessagepermissions` = '55',
`socialgrouppermissions` = '247671',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '100000',
`dbtech_usertagpermissions` = '0',
`vbblog_general_permissions` = '519166',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '40959',
`vbblog_comment_permissions` = '3022',
`dbtech_vbactivitypermissions` = '2',
`dbtech_vbactivitymodpermissions` = '0',
`creditspermissions` = '0',
`dbtech_vbshoppermissions` = '32',
`vfc_hide_hack_perm` = '1'
WHERE usergroupid=2;

MySQL Error : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number : 1054
Request Date : Friday, August 1st 2014 @ 07:16:01 PM
Error Date : Friday, August 1st 2014 @ 07:16:01 PM
Script : http://rapbattles.com/forum/admincp/....php?do=update
Referrer : http://rapbattles.com/forum/admincp/...&usergroupid=2
IP Address : xxx.x.xx.xx
Username : ILLunatic
Classname : vB_Database
MySQL Version : 5.6.19-log
When I try to delete the "PB All Pictures" Plugin, I receive the following Database Error
Quote:
Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE picture DROP pblastcomment;

MySQL Error : Table 'rapbattles.picture' doesn't exist
Error Number : 1146
Request Date : Friday, August 1st 2014 @ 07:15:05 PM
Error Date : Friday, August 1st 2014 @ 07:15:06 PM
Script : http://rapbattles.com/forum/admincp/...do=productkill
Referrer : http://rapbattles.com/forum/admincp/...allpictures&s=
IP Address : xxx.x.xx.xx
Username : ILLunatic
Classname : vB_Database
MySQL Version : 5.6.19-log

Any ideas?
Reply With Quote
  #2  
Old 08-01-2014, 10:38 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It looks like you have mods installed that are supposed to have database changes, but the changes aren't there. Did you restore an old database or something?

You should probably ask for help where you got the mod. But if you know how to put you site into debug mode then you could edit th product and remove the uninstall code.
Reply With Quote
  #3  
Old 08-01-2014, 10:41 PM
iNate19 iNate19 is offline
 
Join Date: Mar 2012
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This website has been around for nearly 15 years, many people have had access over the years.

The specific mod that I'm trying to uninstall has been there for who knows how long, hence why I'm trying to get rid of it.
Reply With Quote
  #4  
Old 08-01-2014, 10:54 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

When removing a mod first, remove xml then all files in the FTP doing it any other way can cause database errors same as leaving files in the FTP after removing the xml. The above error can also be caused by a badly made xml that won't install some fields in your database. The best thing you can do is talk to the coder for support of the mod in question
Reply With Quote
  #5  
Old 08-01-2014, 10:57 PM
iNate19 iNate19 is offline
 
Join Date: Mar 2012
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't know what other files are in the FTP from that mod as I'm not the one who installed it. I removed the xml files but now I'm stuck...
Reply With Quote
  #6  
Old 08-02-2014, 02:15 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I suggest you go post in the modification thread and ask what other files had needed to be uploaded so that you know what files to remove.
Reply With Quote
  #7  
Old 08-02-2014, 03:24 AM
iNate19 iNate19 is offline
 
Join Date: Mar 2012
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I could't find the Modification Thread for that specific Modification
Reply With Quote
  #8  
Old 08-02-2014, 03:15 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What is the name of the modification? Perhaps you got it from another site?
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 06:19 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.03762 seconds
  • Memory Usage 2,239KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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