vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Unable to edit Usergroups & Unable to Remove Plugin (https://vborg.vbsupport.ru/showthread.php?t=313400)

iNate19 08-01-2014 10:16 PM
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?

kh99 08-01-2014 10:38 PM
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.

iNate19 08-01-2014 10:41 PM
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.

ForceHSS 08-01-2014 10:54 PM
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

iNate19 08-01-2014 10:57 PM
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...

Lynne 08-02-2014 02:15 AM
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.

iNate19 08-02-2014 03:24 AM
I could't find the Modification Thread for that specific Modification

Lynne 08-02-2014 03:15 PM
What is the name of the modification? Perhaps you got it from another site?


All times are GMT. The time now is 07:59 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.01053 seconds
  • Memory Usage 1,731KB
  • 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
  • (2)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