mORMot Open Source

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 135

Help with SQLite static files

Hi everyone,

I've been away from mORMot for a while, there's a project I'm still maintaining that generally doesn't have many changes, I want to upgrade it to mORMot version 2, but before taking that step I decided to upgrade mORMot 1 to its latest version on the github repository, so I did a git pull, but it seems I have some kind of file mixup ?

This is the summary after running TestSQL3:

Windows 10 64bit (10.0.19045) (cp1252)
4 x AMD Ryzen 9 7900 12-Core Processor (x64)
Using mORMot 1.18.7657
TSQLite3LibraryStatic 3.44.2 with internal MM
Generated with: Delphi 10.3 Rio 64 bit compiler

Time elapsed for all tests: 4m16
Performed 2024-12-03 13:05:28 by Admin on PC

Total assertions failed for all test suits: 1 / 46,030,737
! Some tests FAILED: please correct the code.

Failures are from mustache tests which I don't care, after cleaning and building the project I'm getting this message when running it:

Static SQLite3 library as included within MyProjectName is outdated!
Linked version is 3.44.2 whereas the current/expected is 3.46.1.

Please download supported latest SQLite3 3.46.1 revision
from https://synopse.info/files/sqlite3obj.7z

I should note that I have a version of mORMot 2 in my Library path, however it was like that before I did the pull and it didn't cause me any problems.

What am I overlooking?

Regards

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,736

Website

Re: Help with SQLite static files

Did you

download supported latest SQLite3 3.46.1 revision
from https://synopse.info/files/sqlite3obj.7z

?

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 135

Re: Help with SQLite static files

Thanks Arnaud, my brain is full of dust ;-) and yes, that's what the message says; I remember that I already downloaded the files and had no luck, I believe I used files from an old zip instead of the new ones, I'll try again, unfortunately I won't have access to the test computer until tomorrow

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 135

Re: Help with SQLite static files

Ok, deleted previous files, downloaded again, extracted en replaced the files on SQLite3 folder, then ran TestSQL3 ( 32 bits ):

Windows 10 64bit (10.0.19045) (cp1252)
    4 x AMD Ryzen 9 7900 12-Core Processor (x86)
Using mORMot 1.18.7657
    TSQLite3LibraryStatic 3.46.1 with internal MM
Generated with: Delphi 10.3 Rio 32 bit compiler

Time elapsed for all tests: 2m14
Performed 2024-12-04 08:37:20 by Admin on PC

Total assertions failed for all test suits:  1 / 46,061,948
! Some tests FAILED: please correct the code.

TestSQL3 is reporting SQLite version 3.46.1 - Check, now onto the 64 bits test:

[dcc64 Error] SynSQLite3Static.pas(1337): E2065 Unsatisfied forward or external declaration: 'memchr'

I guess that's why I was messing with the files earlier, I searched the forum to see if anyone else had encountered and solved this problem, I didn't find anything that helped me in particular.

Do you have any additional recommendations in this case?

Last edited by moctes (2024-12-04 15:21:24)

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 135

Re: Help with SQLite static files

Finally, this thread may not be worth it, I think I'll bite the bullet and migrate to mORMot 2. I ran the tests in mORMot 2 without problems with the static files.

Software version tested: 2.3.9065 (2024-12-04 10:19:24)

Windows 10 64bit 22H2 (10.0.19045.5131) [WinAnsi 5GB 4A651701]
    4 x AMD Ryzen 9 7900 12-Core Processor [32MB] (x64)
    on VMware, Inc. VMware20,1 None
Using mORMot 2.3.9065 4 Dec 2024
    TSqlite3LibraryStatic 3.46.1 with internal MM
Generated with: Delphi 10.3 Rio 64 bit Win compiler

Time elapsed for all tests: 1m18
Performed 2024-12-04 10:21:00 by Admin on PC

Total assertions failed for all test suits:  1 / 127,659,539
! Some tests FAILED: please correct the code.

If I have any doubts, I think the time would be better spent on actual development.

Regards