[Tickets #5033] Current SQL scripts won't allow forum creation (invalid NOT NULL fields)

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5033
-----------------------------------------------------------------------
 Ticket             | 5033
 Created By         | nilskaiser at gmx.net
 Summary            | Current SQL scripts won't allow forum creation (invalid NOT NULL fields)
 Queue              | Agora
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Owners             | 
+New Attachment     | agora.sql.patch
-----------------------------------------------------------------------


nilskaiser at gmx.net (2007-02-24 10:14) wrote:

The forum creation process first inserts a forum setting only some of the
fields:

Messages.php - line 1903
        $sql = 'INSERT INTO agora_forums (forum_id, scope, forum_name,
active, author) VALUES (?, ?, ?, ?, ?)';

The other fields are set in a following update statement:

Messages.php - line 1937
        $sql = 'UPDATE agora_forums SET forum_name = ?, forum_parent_id =
?, '
            . 'forum_description = ?, forum_moderated = ?, '
            . 'forum_attachments = ? WHERE forum_id = ?';

The current sql scripts set all fields to NOT NULL, which causes a db
error on creation.

Patch submitted.