<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Yep. Got into the data folder and could open the database using
isql.<br>
<br>
But I was unable to apply the necessary database updates, see below:<br>
------------------<br>
[mbergmann@www ]$ /opt/firebird/bin/isql -u mvnforums -p
<NotTheRealPassword> /opt/firebird/data/mvnforums.gdb<br>
Database: /opt/firebird/data/mvnforums.gdb, User: mvnforums<br>
SQL> show table;<br>
MVNFORUMATTACHMENT
MVNFORUMCATEGORY <br>
MVNFORUMFAVORITETHREAD
MVNFORUMFORUM <br>
MVNFORUMGROUPFORUM
MVNFORUMGROUPPERMISSION <br>
MVNFORUMGROUPS
MVNFORUMMEMBER <br>
MVNFORUMMEMBERFORUM
MVNFORUMMEMBERGROUP <br>
MVNFORUMMEMBERPERMISSION
MVNFORUMMESSAGE <br>
MVNFORUMMESSAGEFOLDER
MVNFORUMMESSAGESTATISTICS <br>
MVNFORUMPMATTACHMENT
MVNFORUMPMATTACHMESSAGE <br>
MVNFORUMPOST
MVNFORUMRANK <br>
MVNFORUMTHREAD
MVNFORUMWATCH <br>
<br>
SQL> ALTER TABLE MVNFORUMMEMBERGROUP ADD ExpiteDate TIMESTAMP NOT
NULL;<br>
Statement failed, SQLCODE = -607<br>
unsuccessful metadata update<br>
-STORE RDB$RELATION_FIELDS failed<br>
-no permission for control access to TABLE MVNFORUMMEMBERGROUP<br>
------------------<br>
<br>
Actually a pretty simple ALTER statement.<br>
Anyone experience with Firebird who can tell me what this error
message means?<br>
<br>
User mvnforums has the following grants:<br>
SQL> show grant;<br>
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON
MVNFORUMMEMBERGROUP TO USER MVNFORUMS<br>
<br>
It seems that FireBird wants to update some system tables
(RDB$RELATION_FIELDS) which seems to fail:<br>
SQL> show index RDB$RELATION_FIELDS;<br>
RDB$INDEX_15 UNIQUE INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_NAME,
RDB$RELATION_NAME) <br>
RDB$INDEX_3 INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_SOURCE) <br>
RDB$INDEX_4 INDEX ON RDB$RELATION_FIELDS(RDB$RELATION_NAME) <br>
<br>
<br>
<br>
<br>
<br>
Manfred<br>
<br>
<blockquote style="border: 0px none;"
cite="mid:134cea04-8e24-4310-bd53-f04372ed4429@email.android.com"
type="cite">
<div style="margin-left: 40px;">
<hr style="border-width: 1px 0pt 0pt; border-style: dotted none
none; border-color: rgb(181, 181, 181) -moz-use-text-color
-moz-use-text-color; height: 1px; margin: 0pt;"
class="__pbConvHr"><br>
</div>
<table style="padding-top: 5px;" class="__pbConvTable">
<tbody>
<tr>
<td valign="top"><img
src="cid:part1.08020504.00050308@me.com"
photoaddress="scribe@crosswire.org" photoname="Troy A.
Griffitts" name="compose-unknown-contact.jpg"
height="29px" width="29px"></td>
<td style="padding-left: 5px;" valign="top"><a
moz-do-not-send="true"
href="mailto:scribe@crosswire.org" style="color: rgb(0,
136, 204) ! important; text-decoration: none !
important;">Troy A. Griffitts</a><br>
<font color="#888888">13. Februar 2011 15:10</font></td>
</tr>
</tbody>
</table>
<div style="color: rgb(136, 136, 136); margin-left: 40px;"
__pbrmquotes="true" class="__pbConvBody"><br>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title></title>
Should be good now. Let me know.<br>
-- <br>
Sent from my Android phone with K-9 Mail. Please excuse my
brevity.<br>
<br>
<div>_______________________________________________<br>
server-admins mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:server-admins@crosswire.org">server-admins@crosswire.org</a><br>
<a class="moz-txt-link-freetext" href="http://www.crosswire.org/mailman/listinfo/server-admins">http://www.crosswire.org/mailman/listinfo/server-admins</a><br>
</div>
</div>
</blockquote>
</body>
</html>