mORMot Open Source

erick

Member

Registered: 2015-09-09

Posts: 155

Delphi 10.4, Zeos 7.2.8 Stable and MySQL with Mormot 2020-11-09

I recently upgraded to the latest Delphi, Zeos 7.2.8 stable and the nightly snapshot of Mormot 2020-11-09

My version of MariaDB has not changed, but the behaviour of the Momot app did.

I can no longer connect correctly to MariaDB/MySQL based Databases. 

ERROR: leaving 2 on Error SQLITE_ERROR (1) [Step] using 3.33.0 - TSQLRestStorageExternal.Create: TSQLAuthGroup: unable to create external missing field AuthGroup.Ident - SQL="ALTER TABLE AuthGroup ADD Ident varchar(50) character set UTF8 NOT NULL UNIQUE"ID)), extended_errcode=1

This is after Mormot already creates the AuthGroup table on MariaDB and Ident is perfectly good.  I tried deleting the table and it recreates but gives the same error.

I suspect the Zeos library. I was wondering if anyone had any recommendations for a known-good working Zeos library revision for Mormot with MySQL/Maria DB.

Thanks
Erick

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Delphi 10.4, Zeos 7.2.8 Stable and MySQL with Mormot 2020-11-09

NOT NULL UNIQUE"ID seems weird.
Is it really the generated statement?

erick

Member

Registered: 2015-09-09

Posts: 155

Re: Delphi 10.4, Zeos 7.2.8 Stable and MySQL with Mormot 2020-11-09

Yes, I cut and pasted it exactly, and noted that it looked weird on the screen with the ' "ID ' part.

Erick

erick

Member

Registered: 2015-09-09

Posts: 155

Re: Delphi 10.4, Zeos 7.2.8 Stable and MySQL with Mormot 2020-11-09

I've gone back to Delphi 10.3.3 and all works correctly now. 

I was trying 10.4.x with all the software updates offered by Embarcadero.  I thought by now they would have worked out the kinks.  That assumption may have been wrong, because I've never seen a Mormot error like that, and it sounds like you hadn't either.

Erick

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Delphi 10.4, Zeos 7.2.8 Stable and MySQL with Mormot 2020-11-09

I have included some fixes a few days ago IIRC, but your version tested includes them...
Perhaps the problem is in Zeos/ZDBC.

EgonHugeist

Member

From: Germany

Registered: 2013-02-15

Posts: 190

Re: Delphi 10.4, Zeos 7.2.8 Stable and MySQL with Mormot 2020-11-09

@Erick
Note i don't have a XE10.4 by hand because of the missing community edition. As you pointed out: It's compiler related. Yet i can't help.
But i propose you switch to Zeos8 on https://sourceforge.net/p/zeoslib/code- … ree/trunk/
7.2 is old, some in the team hang on 7.2, i don't do..
ps: It can't be sooooo complicated to catch the little bugga with the debugger. I would be happy if you could resolve it and raise an ticket against https://sourceforge.net/p/zeoslib/tickets/

erick

Member

Registered: 2015-09-09

Posts: 155

Re: Delphi 10.4, Zeos 7.2.8 Stable and MySQL with Mormot 2020-11-09

Hi, Thanks for the comments.

I've downloaded the 8 version at your suggestion.  I hope to play with it in the next few months, but for production purposes I think I'll stick with what works - using 10.3 + libraries which appears much more solid at this time and is still quite recent.  There is no compelling reason to upgrade.

Erick