Database error since 3.0.7

[matty0ung]

Issue created from discussion thread #778 - @Kalilovisky

Dear Matt,

I continue to experience issues with database imports since version 3.0.7.

To replicate this problem, simply create a recipe in version 3.0.7 and attempt to copy it to version 3.0.8 or 3.0.9 (changing the data or backup directory).

Is there any possibility of this issue being resolved in version 3.0.10?

Thank you.

[matty0ung]

Hi Kalil,
Sorry to hear you're having problems.
When you are copying the recipe, are you doing an export/import, or are you copying the whole database?
Either way, can you post the errors or any other messages you get in the log file?

[mathewcallaghan]

I have been experiencing issues like this for quite some time. I have reported it as well; the application tends to crash frequently. Even after starting with a new database, the problem persists.

The solution for me has been to use the version available at brewtarget.org or via Linux repositories. While my comment may not contribute to solving the issue, it aims to highlight the apparent instability that the software has developed, which is unfortunate.

[matty0ung]

@mathewcallaghan If you could provide more details and diagnostics, then we will gladly investigate problems.

[Kalilovisky]

Será Matt, Copying entire database or setting up database to another path in configuration Em ter, 21 de nov de 2023 00:29, Matt Young ***@***.***> escreveu:

…

Hi Kalil, Sorry to hear you're having problems. When you are copying the recipe, are you doing an export/import, or are you copying the whole database? Either way, can you post the errors or any other messages you get in the log file? — Reply to this email directly, view it on GitHub <#780 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ARUIGOJNFHINLLDNSJ56PTDYFQNYNAVCNFSM6AAAAAA7T35ZMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMRQGE2TMNBVGY> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[matty0ung]

Thanks @Kalilovisky. That helps narrow it down. Would you be able to upload one of the database files that causes the problem? That should make it pretty quick to reproduce on my machine so I can get full diagnostics.

[Kalilovisky]

Sure Em qua., 22 de nov. de 2023 às 08:19, Matt Young ***@***.***> escreveu:

…

Thanks @Kalilovisky <https://github.com/Kalilovisky>. That helps narrow it down. Would you be able to upload one of the database files that causes the problem? That should make it pretty quick to reproduce on my machine so I can get full diagnostics. — Reply to this email directly, view it on GitHub <#780 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ARUIGOK4TSF2JKCMIHIMI53YFXNVBAVCNFSM6AAAAAA7T35ZMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMRSGU4DANZTGU> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Kalil Araujo Bispo PhD in Computer Science Computing Department, UFS, Brazil

[Kalilovisky]

Did you received my attached file?

[matty0ung]

Did you received my attached file?

No, it didn't come through. I think the email integration in GitHub doesn't know what to do with attachments (assuming that's how you sent it?). If you could upload it via a web browser at #780, that would be great.

[Kalilovisky]

Github don't support sqlite files. So, chage it to sqlite again after download
database.sqlite.txt

[matty0ung]

Thanks @Kalilovisky. I had a look and I can see what the issue is. I know how to fix it. Watch this space.

[Kalilovisky]

Any news, @matty0ung ?

[matty0ung]

Any news, @matty0ung ?

Yes, I have the fix coded and working on Linux (see #781). But I'm just fighting with the build system on Mac before I can check it in. Hope to have it resolved in the next few days, and certainly by the end of the month!

(The package manager that we use on Mac for installing libraries and frameworks in the build environment stopped supplying one of the libraries we need. So I'm now trying a different package manager which still does supply it. Failing that I'll have to have the build tool download and compile the library from source. This sort of build stuff is needed from time to time but not one of the more fun bits of working on the project!)

[matty0ung]

This should be fixed in https://github.com/Brewtarget/brewtarget/releases/tag/v3.0.10, but please re-open if not.