On 16-2-2013 20:57, Craig Cox wrote: > Firebird 1.5 Database on Linux > > I have a database that appears to be running fine; however, when I try to > restore a backup from FB 1.5 (Linux) to FB 2.5 (Windows), none of the tables > show up in the restored database. I have completed similar restores with > other databases. The first error message occurs when it tries to restore the > first table. That error is: > > gbak:committing metadata for table ORDERS > gbak:error committing metadata for table ORDERS > gbak: ERROR:unsuccessful metadata update > gbak: ERROR: ORDERS > gbak: ERROR: Implementation of text subtype 65280 not located.
See this message: http://tech.groups.yahoo.com/group/firebird-support/message/85457: "The problem is caused by some RDB$RELATION_FIELDS records that have RDB$COLLATION_ID = -1. I have no idea what engine version or GUI tool could generate it. It wasn't a problem previously, but text blobs support collations in v2.0 and an attempt to find a collation with ID = 255 (-1) fails in your database. The issue should go away after setting RDB$COLLATION_ID to zero for all records containing a value of -1 there." > After that the errors associated with remaining tables all look like: > > gbak:committing metadata for table PARTS > gbak:error committing metadata for table PARTS > gbak: ERROR:unsuccessful metadata update > gbak: ERROR: TABLE PARTS > gbak: ERROR: Can't have relation with only computed fields or constraints > > This leads to a cascading set of errors concerning indexes etc. Might be a result of the first error. Try the proposed fix (on a copy!) and try again. Mark -- Mark Rotteveel
