vb.org Archive
Page 2 of 21 1 2 3412 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)

Asterik 08-04-2005 10:15 AM
Silly me, actually i have no prefix. :P. But it gives me the same error eventhough I did set a usergroup as moderator of a forum o_O.

Code:
Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

                DELETE FROM moderator AS moderator
                USING moderator AS moderator, moderatorusergroup AS moderatorusergroup
                WHERE moderator.userid = 11
                        AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
                        AND NOT (moderatorusergroup.usergroupid IN (2));

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS moderator
                USING moderator AS moderator, moderatorusergroup
Error Number : 1064
Date        : Thursday, August 4th 2005 @ 04:13:59 AM
Script      : admincp/user.php
Referrer    : admincp/user.php?do=edit&u=11
IP Address  : x.x.x.x
Username    : Union Jack
Classname    : vb_database

Andreas 08-04-2005 10:18 AM
That's what I thought.
Seems like your mySQL Version does not support this Query Syntax.

Can you try the following Query in phpMyAdmin if it generates errors?

[sql]
DELETE moderator FROM moderator AS moderator, moderatorusergroup AS moderatorusergroup
WHERE moderator.userid = 11
AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
AND NOT (moderatorusergroup.usergroupid IN (2));
[/sql]

Asterik 08-04-2005 10:33 AM
Code:
Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

                DELETE FROM moderator AS moderator
                USING moderator AS moderator, moderatorusergroup AS moderatorusergroup
                WHERE moderator.userid = 11
                        AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
                        AND NOT (moderatorusergroup.usergroupid IN (2));

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS moderator
                USING moderator AS moderator, moderatorusergroup
Error Number : 1064
hmm..... Ran ur query but it went through, but i still get this :(

:: EDIT :: Actually it didn't delete anything :I

Mephisteus 08-04-2005 10:57 AM
I have the same as Asterik. When editing a user it gives me that error.

Marco van Herwaarden 08-04-2005 03:03 PM
Quote:
Originally Posted by KirbyDE
That's what I thought.
Seems like your mySQL Version does not support this Query Syntax.

Can you try the following Query in phpMyAdmin if it generates errors?

[sql]
DELETE moderator FROM moderator AS moderator, moderatorusergroup AS moderatorusergroup
WHERE moderator.userid = 11
AND moderator.moderatorusergroupid = moderatorusergroup.moderatorusergroupid
AND NOT (moderatorusergroup.usergroupid IN (2));
[/sql]
That is a completly different query.

PS Not all MySQL versions support multi table deletes.

Mephisteus 08-04-2005 03:09 PM
The only place where I get that error is when editing a user. Also (the user already is a part of that group) the user doesnt have moderator rights.

Asterik 08-04-2005 06:27 PM
Quote:
Originally Posted by DarkSSJ3
The only place where I get that error is when editing a user. Also (the user already is a part of that group) the user doesnt have moderator rights.
Exactlly the same :).

Andreas 08-04-2005 07:45 PM
Hmpf. Ppl should use more up-to-date mySQL Versions ;)
OK, doing it the old-fashined way then - without multi-table DELETEs.

Mephisteus 08-04-2005 09:59 PM
Woho! Pretty please let us know when its updated :)

Andreas 08-04-2005 10:04 PM
Will do.
Btw: If you add a Usergroup that already has Members (be it primary or secondary) as Moderator, do these members get Moderators?


All times are GMT. The time now is 04:11 PM.
Page 2 of 21 1 2 3412 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.01177 seconds
  • Memory Usage 1,740KB
  • 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_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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