Error Code:-78

[LSemmens]

SQL Status: S1000 Error code: -78

error in script file line: 1
Unexpected token UNIQUE, requires
COLLATION in statement [SET DATABASE
UNIQUE]

I get this whenever I attempt to open a database that I created some time back. I have since re-installed Linux on my laptop and have not attempted to open this database since then. Given that it was some months back I cannot be certain as to what path was used to create the linked images, I suspect that this might be an issue. The database consists of multiple related tables. Can anyone please point me to an area that I might look into. Given the size of the database and related tables it is not a small process. The main database itself is only 1.6mb but the linked images are currently sitting at around 12Gb.

[Ratslinger]

Hello,

One issue is the lack of knowing what database you are using.

For HSQLDB here is a link to error codes → HSQLDB sql-error-messages

Based upon your error number:

078=S1000 error in script file

Your given error is:

error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]

Now looking at the Script file in an HSQLDB embedded file in Base, here is my first line:

SET DATABASE COLLATION “Latin1_General”

Which kind of makes sense if your first line is different. However, and again not knowing the database you used, if I look at the first line of the Script file is an HSQLDB split database, here is what I have:

SET DATABASE UNIQUE NAME HSQLDB5680B187CF

or

SET DATABASE UNIQUE NAME HSQLDB62DEA4C20C

Which seems to be a generated unique name. This also makes sense as to the error description presented.

So this may provide you with some direction. Don’t think your problem has anything to do with image links.

[LSemmens]

Thank you! I am, indeed, using HSQLDB I can find no lines in any of my macros (I presume that is what Libre Office calls scripts) that even remotely resemble SET DATABASE UNIQUE or COLLATION.

As it was all working last time I used the database and have certainly not done any mods to it since then, I am at a loss.

Should I add those lines as part of the macro header or where?

[Ratslinger]

The Script file is one of the necessary files for the database. The others include the data and properties files. In an HSQLDB embedded database this in enfolded in the Base file. This can be unzipped and the files found in the database folder. These file are also present if you use an HSQLDB split database. The are, however, located outside of the Base file.

This has nothing to do with macros. Unfortunately, without access to the Base file it is extremely difficult to debug this type of problem.