mORMot Open Source

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 506

Database Error

Hi ab,

everything runs fine, but since Yesterday we get a database error i can not identify / don't know what to do with

The Errormessage is this:

SynDBZeos.TSQLDBZEOSStatement(061AE280) update BinaerdatenRecord set CreationDate=0,LastEditDate=135469259944,GUID='{90944806-B92D-C7C9-1CFE-99CF08C3C3AA}',Binaerdaten=*BLOB*,Datenformat='image/jpeg',GroesseInByte=90112 where ID=80358
EZSQLException ("SQL Error: Can't send long data for non-string/non-binary data types (parameter: 3)")

SynDBZeos.TSQLDBZEOSStatement(062D0AB0) update BinaerdatenRecord set LastEditDate=135469259945,Binaerdaten=*BLOB*,GroesseInByte=122880 where ID=80359
EZSQLException ("SQL Error: Can't send long data for non-string/non-binary data types (parameter: 1)")

Our Environment ist libZEOS - 7.3 V5275
mORMot latest Version
Our Database is a MySQL 5.7.19

We have a simple TSQLRecord with 1 TSQLRawBlob called "Binaerdaten"

Does you or anybody have a clue for us ?

---

Rad Studio 12.1 Santorini

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,205

Website

Re: Database Error

Sounds like if there is a problem with BLOB parameters on both requests.

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 506

Re: Database Error

I think so too, but the Query is generated by mORMot on Server after Update Request from REST Client.
And as Hint the Query works after the Transfer is restarted on the client.
The field binaerdaten is a mediumblob on MySQL Server

Can there be Problem with the ZEOS Lib ?

---

Rad Studio 12.1 Santorini

hnb

Member

Registered: 2015-06-15

Posts: 291

Re: Database Error

AFAIK usage of ZEOS 7.3 is risky (in one of my bugreport (ZEOS bugtracker at sourceforge) some time ago I was warned that I should use 7.2). The recommended version is https://sourceforge.net/p/zeoslib/code- … .2-patches

Anyway whatever was said I was using selected 7.3 with important fixes for me ( PostgreSQL ). You can try to isolate minimal test case and use ZEOS bugtracker at sourceforge to report the problem.

Last edited by hnb (2018-11-13 21:55:54)

---

best regards,
Maciej Izak

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 506

Re: Database Error

Thank you we already changed the zeos version but not the branch - I'll try it with the one you said.

---

Rad Studio 12.1 Santorini

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 506

Re: Database Error

We tested the 7.2-patches branch and the error has gone.

---

Rad Studio 12.1 Santorini

EgonHugeist

Member

From: Germany

Registered: 2013-02-15

Posts: 190

Re: Database Error

Resolved in SVN (Trunk/testing-7.3)

TestCase added, sorry for the inconsistency..

Everything *new* might be risky but without a testcase/ticket on the bugtracker or a post in the zeos forum you shouldn't expect help immidiately.
Have fun

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 506

Re: Database Error

ty egonhugeist

next time i'll create login for zeos bug tracker an post it there

---

Rad Studio 12.1 Santorini