SQL Exception: Error in script file line

[Ameisenfutter]

Hi!

A few days ago, I started playing star-made again. Everything worked out fine. However, today, even before downloading the new build, a strange error occured as I was trying to launch my server:

http://i.imgur.com/4r6yqrT.png

Yesterday I stopped playing and today this came out of nowhere. I searched the internet and found a thread on oldsite.starmade recarding a similar error:

http://oldsite.star-made.org/content/error-script-file-line

Of course, I tried that out. The server worked again, but as written in that thread, all my stuff was gone.

I also tried:

- Reinstalling starmade
- taking index files from other backups


So... does anyone have any suggestions?

 

[zGh05T]

Hmm...
my only guess is that the problem occurs because you're using dropbox(online stuff), so if it had to load something, it actually has to go to the dropbox servers first to get the file it's looking for, which can cause problems for as far as i can guess, it'd be better if you wouldn't be saving it onto your dropbox account but in your HDD
Not..quite sure how to do that tho xD...
it's just a guess of mine

 

[Megacrafter127]

Hmm...
my only guess is that the problem occurs because you're using dropbox(online stuff), so if it had to load something, it actually has to go to the dropbox servers first to get the file it's looking for, which can cause problems for as far as i can guess, it'd be better if you wouldn't be saving it onto your dropbox account but in your HDD
Not..quite sure how to do that tho xD...
it's just a guess of mine

Dropbox just keeps a folder on the drive in synch with the cloud. It isn't the cause, since you can still access all the contents of the folder on your drive even if you crash dropbox.

The error probably is mistake in the SQL-interface, which sometimes screws itself over[especially if a file-lock is involved]. The only known way to solve this issue is to delete the server-database folder, which is the equivalent to resetting the universe.

 

[Ameisenfutter]

Okay, that doesn't sound cool at all.

Well, I'm willing to do that, however, I'd like to migrate a few ships and a planet to the new universe, but I don't have the latest blueprint of every ship and no export file of the planet sector. Is there any way to get that stuff without starting the server, by using the entity-files from the database or something?

 

[Megacrafter127]

Okay, that doesn't sound cool at all.

Well, I'm willing to do that, however, I'd like to migrate a few ships and a planet to the new universe, but I don't have the latest blueprint of every ship and no export file of the planet sector. Is there any way to get that stuff without starting the server, by using the entity-files from the database or something?

Yes, there is, provided you don't want to get the turrets too.
This is how you do it:

1. Choose any existing blueprint(it shouldn't contain plexstorages, linked blocks, or docks)[I recommend making a copy of it first, as the following procedure destroys the previously existing blueprint][To load them, you also need to disable the modified blueprint checks]
   
2. Delete everything in the "DATA" folder within the blueprint's folder
3. Copy all *.smd2 files of the entity you want to save from the "DATA" folder of the universe to the "DATA" folder of the blueprint
   • since each *.smd2 file only stores a 16x16x16 block of chunks, their name is <entityName>.<x>.<y>.<z>.smd2, with x, y and z telling which 16x16x16 cube of chunks is stored.