vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Usergroup Manager (https://vborg.vbsupport.ru/showthread.php?t=315650)

Phillip 11-26-2014 05:59 PM
Usergroup Manager
 
So I have tried to change settings for usergroups and they end up being errors for SQL and such...

Code:
Database error in vBulletin 3.8.8:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Administrators',
        `description` = '',
        `usertitle` = 'Administrator',
        `opentag` = '<b><i><span style=\"color: darkblue;\">',
        `closetag` = '</span></b></i>',
        `passwordexpires` = '180',
        `passwordhistory` = '360',
        `akvbghsfs_akismet_permissions` = '0',
        `forumpermissions` = '16777215',
        `genericpermissions` = '1581252543',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '7',
        `pmsendmax` = '5',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '31',
        `adminpermissions` = '3',
        `genericpermissions2` = '1',
        `genericoptions` = '55',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '237567',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '10000',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '0',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '63',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '65535',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, November 26th 2014 @ 07:54:43 PM
Error Date    : Wednesday, November 26th 2014 @ 07:54:43 PM
Script        : http://sitedomain/admincp/usergroup.php?do=update
Referrer      : http://sitedomain/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : -------------
Username      : Phillip
Classname    : vB_Database
MySQL Version : 5.5.40-cll
Is there anyway of fixing this?

HM666 11-26-2014 06:54 PM
Do you have this setting in your admin usergroup as the color & style of the word Administrators?

Code:
<b><i><span style=\"color: darkblue;\">
If so you cannot include the back slashes. You can use CSS in that area but it has to be done like this:

Code:
<span style="color: darkblue;font-weight:bold;font-style:italic;">
Then your closing tag in the second box would be

Code:
</span>
Not

Code:
</span></b></i>

Phillip 11-26-2014 07:02 PM
Quote:
Originally Posted by HM666 (Post 2524295)
Do you have this setting in your admin usergroup as the color & style of the word Administrators?

Code:
<b><i><span style=\"color: darkblue;\">
If so you cannot include the back slashes. You can use CSS in that area but it has to be done like this:

Code:
<span style="color: darkblue;font-weight:bold;font-style:italic;">
Then your closing tag in the second box would be

Code:
</span>
Not

Code:
</span></b></i>

I do have this set in my use admincp...

Code:
<span style="color: darkblue;font-weight:bold;font-style:italic;">
And I still get the same error after hitting update.

kh99 11-26-2014 07:15 PM
It looks like that's caused by a problem with your glowhost spam-o-matic installation. If you have it installed, then for some reason you have a column missing from the usergroup table. You can either try to add it back, or uninstall the product and reinstall it if you still want it.

If you have uninstalled it, then for some reason it seems that you still have a plugin from it. Maybe check the plugin manager and if you see it there you could try disabling or deleting it.

Phillip 11-26-2014 07:16 PM
Quote:
Originally Posted by kh99 (Post 2524299)
It looks like that's caused by a problem with your glowhost spam-o-matic installation. If you have it installed, then for some reason a column is missing form the usergroup table. You can either try to add it back, or uninstall the product and reinstall it if you still want it.

If you have uninstalled it, then for some reason it seems that you still have a plugin from it. Maybe check the plugin manager and if you see it there you could try disabling or deleting it.

I'll see what I can do with that. I'll try and see if I can get it work if not I will show what it comes up as after.

--------------- Added [DATE]1417037759[/DATE] at [TIME]1417037759[/TIME] ---------------

Still getting the same errors, is there a way like steps of removing Glowhost imported to phpmyadmin?

ozzy47 11-26-2014 09:45 PM
When you say," Glowhost imported to phpmyadmin " what is it you mean?

Phillip 11-26-2014 10:01 PM
Quote:
Originally Posted by ozzy47 (Post 2524329)
When you say," Glowhost imported to phpmyadmin " what is it you mean?
The table that was put into phpmyadmin...I'm really not sure how to explain it.

ozzy47 11-26-2014 10:03 PM
So your install of phpmyadmin randomly added this table to your database?

Phillip 11-26-2014 10:04 PM
Quote:
Originally Posted by ozzy47 (Post 2524339)
So your install of phpmyadmin randomly added this table to your database?
When I went in to install it...the table added itself after...but I can figure out how to remove that table cause it's not on the actually table set.

ozzy47 11-26-2014 10:07 PM
Ok lets do this, disable plugins via the includes/config.php file.

To do that open your includes/config.php file and below <?php add the following.

PHP Code:
define('DISABLE_HOOKS', true); 
So it looks like this:
PHP Code:
<?php
define('DISABLE_HOOKS', true);
/*=================================================  =====================*\
|| ##################################################  ################## ||
|| # vBulletin 4.2.2
Use a editor like notepad++ to edit any files, don't use Notepad or Wordpad.

Then navigate to the ACP, and un install the mod. Once that is done, remove or comment out that line in the config file, and see if you still have the same issue.


All times are GMT. The time now is 08:48 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01395 seconds
  • Memory Usage 1,755KB
  • 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
  • (10)bbcode_code_printable
  • (2)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete