Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Re: [Alex] Adding Moderators

Quote Reply
Re: [Alex] Adding Moderators In reply to
Here's a suggestion and a bug:

Administrators should have full modetor + privileges... I am the Administrator of my board so I should be able to delete posts, edit them, etc.

Here's the bug:

When trying to add a moderator to any of my forums I get this error:

GT::SQL::Table (8996): Failed to prepare query: 'SELECT COUNT(*) FROM gforum_ForumModerator WHERE user_id_fk = '3' AND forum_id = '5' ' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'forum_id'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) at <full directory path>/admin/GT/SQL/Base.pm line 173. GT::SQL::Table (8996): The column 'group_id_fk,user_id_fk' must be unique, and already has an entry '4,3'. at <full directory path>/admin/GForum/Table/Forum.pm line 268. GT::SQL::Table (8996): Failed to execute query: 'INSERT INTO gforum_ForumModerator (user_id_fk,forum_id_fk) VALUES ('3','5')' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'mod_time', table '******.******.gforum_ForumModerator'; column does not allow nulls. INSERT fails. (SQL-23000) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at <full directory path>/admin/GForum/Table/Forum.pm line 271.
Shannon Anderson
Babies Online.com

Last edited by:

BabiesOnline: Oct 14, 2001, 5:18 PM
Subject Author Views Date
Thread Adding Moderators herbalife 2716 Oct 12, 2001, 4:04 AM
Post Re: [Ian Conza] Adding Moderators
QooQ 2637 Oct 12, 2001, 7:16 AM
Thread Re: [Ian Conza] Adding Moderators
Alex 2625 Oct 12, 2001, 9:29 AM
Post Re: [Alex] Adding Moderators
herbalife 2613 Oct 12, 2001, 2:29 PM
Post Re: [Alex] Adding Moderators
BabiesOnline 2591 Oct 14, 2001, 5:15 PM