Home : Products : Gossamer Forum : Discussion :

Products: Gossamer Forum: Discussion: Re: [Alex] Adding Moderators: Edit Log

Here is the list of edits for this post
Re: [Alex] Adding Moderators
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

Edit Log: