vb.org Archive
Page 9 of 21 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Add Usergroup as Moderator (https://vborg.vbsupport.ru/showthread.php?t=93543)

Andreas 10-06-2005 08:31 AM
Hmm, this Query works just fine for me.
Which mySQL Version do you use?

diretur 10-06-2005 08:32 AM
3.23.58-log

diretur 10-06-2005 08:36 AM
wait, maybe I have it!
Table 'db32351_14.vb3_moderatorusergroup' doesn't exist

I did't create any table because I haven't seen it in the readme file!

diretur 10-06-2005 08:40 AM
sorry for the chaos: now I uninstalled the mod, so the table should have been deleted from the database. right?

Andreas 10-06-2005 08:40 AM
I think that 3.23 is too old.
The table should have been automatically created by the product install code.

trilljester 10-06-2005 03:09 PM
Kirby: Can you limit this usergroup's moderator functions, meaning, they can have the same limitations as moderators as a single user moderator, right? Like if I don't want them deleting posts or what not, I can restrict that, correct?

JohnBee 10-06-2005 06:55 PM
Okay I installed this mod and the first thing I noticed is when I try to edit any of the usergroups i get an SQL dB error. I tried to deactivate the hack and make the changes but it still does the same so I guess there have been changes made to the tables that cause the error.

I will try and uninstall then try to edit the usergroups to see if the same problem occurs. One thing for sure is once the hack is installed, it almost certainly leads us to edit or refine the usergroups to better fit the group system in forum home so the SQL error will almost definately take place.

Okay I uninstalled the hack and the error still occurs so I guess the MOD is noit cleaning up the tables after uninstallation.

Here is the error
Code:
Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Site moderator',
        `description` = '',
        `usertitle` = '',
        `opentag` = '<span style=\"color: #6A0000;\">',
        `closetag` = '</span>',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `forumpermissions` = '1048575',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '1',
        `pmsendmax` = '5',
        `calendarpermissions` = '63',
        `wolpermissions` = '15',
        `adminpermissions` = '0',
        `genericpermissions` = '204193695',
        `genericoptions` = '23',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '120',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '100',
        `avatarmaxheight` = '120',
        `avatarmaxsize` = '50000',
        `imghost` = '0'
WHERE usergroupid=7;

MySQL Error  : Unknown column 'imghost' in 'field list'
Error Number : 1054
Date        : Thursday, October 6th 2005 @ 03:57:34 PM
Script      : http://www.mysite.com/www/forum/admincp/usergroup.php
Referrer    : http://www.mysite.com/www/forum/admincp/usergroup.php?do=edit&usergroupid=7
IP Address  : ***.***.**.**
Username    : Xxxxxx
Classname    : vb_database
Looking forward to a fix.

Mephisteus 10-06-2005 07:43 PM
Its messing up at the imghost field. Its neither a defeault field nor is it part of this hack, Id be looking at another hack... (though I do not know which one, Im guessing one that hosts images on a usergroup basis or something :p)

@trilljester, yes it does :)

Andreas 10-06-2005 07:53 PM
@trilljester
The permissions are the same as for normal moderators.

@JohnBee
Field imghost definitely has nothing to do with this Hack, so this error is caused by another Hack.
=> Remove all Bitfield XMLs from Hacks you don't use (any longer) and rebuilt the bitfield cache.

trilljester 10-06-2005 09:07 PM
Awesome. Thanks for this, Kirby! I really wish this was a feature in VBulletin, I'm surprised it's not. It's actually a feature in most forum softwares.


All times are GMT. The time now is 04:57 AM.
Page 9 of 21 « First 78 9 101119 Last »
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.01157 seconds
  • Memory Usage 1,738KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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