vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Uninstalling a plugin/product problem, help? (https://vborg.vbsupport.ru/showthread.php?t=110465)

makemedie 03-15-2006 04:51 PM
Uninstalling a plugin/product problem, help?
 
Hey all,

I uninstalled SOME plugin, dont know what it was called (was a while back), and only now did I realize that I can't edit usergroups. It gives me the error -

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Private Community Member',
        `description` = '',
        `usertitle` = 'Private Community Member',
        `opentag` = '<font color=FFFFFF><b>~',
        `closetag` = '</color>',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `ispublicgroup` = '0',
        `canoverride` = '0',
        `forumpermissions` = '782583',
        `attachlimit` = '1000000',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `calendarpermissions` = '17',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions` = '201899743',
        `genericoptions` = '15',
        `profilepicmaxwidth` = '200',
        `profilepicmaxheight` = '200',
        `profilepicmaxsize` = '25000',
        `avatarmaxwidth` = '200',
        `avatarmaxheight` = '200',
        `avatarmaxsize` = '999999999',
        `profileviewpermissions` = '0'
WHERE usergroupid=9;

MySQL Error  : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054
The obvious problem here is that "profileviewpermissions" either doesn't exist, or is screwed. Anyone know how I can delete that column or something? I mean, what am I supposed to do to fix this?

Sorry if I posted this in the wrong place.

Pickalo 03-16-2006 06:59 PM
Search for Advanced Product Manager.

Install it, then go to the Advanced Product Manager in your admincp.
Find the installed product, and click Advanced Product Edit
There should be something there that says Install Code / Uninstall Code - Make sure the box to the right is checked and go to delete. From there, just uninstall the product using the Advanced Product Manager.

Hope this helps :)

Yukino_AE 12-13-2006 08:34 PM
i'm gettign the same error, i've even cleared out my db and started from scratch with a fresh install. is that something i have to readd back? i don't know. grrr.

Ntfu2 12-13-2006 09:39 PM
If you've started from a fresh install with no hacks or modifications its obvisously not going to be a hacks fault.

@makemedie
Simply remove this row: `profileviewpermissions` from ther USERGROUP. Easiest way would be using phpMyAdmin


All times are GMT. The time now is 01: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.01063 seconds
  • Memory Usage 1,717KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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