[server-admins] Forum upgrade

[Manfred Bergmann]

Yep. Got into the data folder and could open the database using isql.

But I was unable to apply the necessary database updates, see below:
------------------
[mbergmann at www ]$ /opt/firebird/bin/isql -u mvnforums -p 
<NotTheRealPassword> /opt/firebird/data/mvnforums.gdb
Database:  /opt/firebird/data/mvnforums.gdb, User: mvnforums
SQL> show table;
        MVNFORUMATTACHMENT                     MVNFORUMCATEGORY
        MVNFORUMFAVORITETHREAD                 MVNFORUMFORUM
        MVNFORUMGROUPFORUM                     MVNFORUMGROUPPERMISSION
        MVNFORUMGROUPS                         MVNFORUMMEMBER
        MVNFORUMMEMBERFORUM                    MVNFORUMMEMBERGROUP
        MVNFORUMMEMBERPERMISSION               MVNFORUMMESSAGE
        MVNFORUMMESSAGEFOLDER                  MVNFORUMMESSAGESTATISTICS
        MVNFORUMPMATTACHMENT                   MVNFORUMPMATTACHMESSAGE
        MVNFORUMPOST                           MVNFORUMRANK
        MVNFORUMTHREAD                         MVNFORUMWATCH

SQL> ALTER TABLE MVNFORUMMEMBERGROUP ADD ExpiteDate TIMESTAMP NOT NULL;
Statement failed, SQLCODE = -607
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-no permission for control access to TABLE MVNFORUMMEMBERGROUP
------------------

Actually a pretty simple ALTER statement.
Anyone experience with Firebird who can tell me what this error message 
means?

User mvnforums has the following grants:
SQL> show grant;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON MVNFORUMMEMBERGROUP 
TO USER MVNFORUMS

It seems that FireBird wants to update some system tables 
(RDB$RELATION_FIELDS) which seems to fail:
SQL> show index RDB$RELATION_FIELDS;
RDB$INDEX_15 UNIQUE INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_NAME, 
RDB$RELATION_NAME)
RDB$INDEX_3 INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_SOURCE)
RDB$INDEX_4 INDEX ON RDB$RELATION_FIELDS(RDB$RELATION_NAME)





Manfred

> ------------------------------------------------------------------------
>
> 	Troy A. Griffitts <mailto:scribe at crosswire.org>
> 13. Februar 2011 15:10
>
>
> Should be good now. Let me know.
> -- 
> Sent from my Android phone with K-9 Mail. Please excuse my brevity.
>
> _______________________________________________
> server-admins mailing list
> server-admins at crosswire.org
> http://www.crosswire.org/mailman/listinfo/server-admins

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20110213/1142c7df/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: compose-unknown-contact.jpg
Type: image/jpeg
Size: 1421 bytes
Desc: not available
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20110213/1142c7df/attachment.jpg>