Bug in 10.4.1 with batch updates

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
TobiasHo
Posts: 30
Joined: Thu 11 Jul 2019 09:12

Bug in 10.4.1 with batch updates

Post by TobiasHo » Thu 04 Mar 2021 12:14

Since I updated from 10.3.2 to the latest release, my batch update fails with an
"prepared statement contains too many placeholders " error.

I submit about 9500 stock items to my online shop with that query.

Tested under : Ver 10.4.14-MariaDB-1:10.4.14

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Bug in 10.4.1 with batch updates

Post by ViktorV » Thu 04 Mar 2021 15:48

Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.

TobiasHo
Posts: 30
Joined: Thu 11 Jul 2019 09:12

Re: Bug in 10.4.1 with batch updates

Post by TobiasHo » Thu 18 Mar 2021 10:19

When will this issue be fixed?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Bug in 10.4.1 with batch updates

Post by ViktorV » Fri 19 Mar 2021 14:44

Thank you for the information.
We've already fixed the issue, the fix will be included in the next version MyDAC, which we're planning to release next week.

TobiasHo
Posts: 30
Joined: Thu 11 Jul 2019 09:12

Re: Bug in 10.4.1 with batch updates

Post by TobiasHo » Tue 13 Jul 2021 10:22

I have problems with the batch updates again ...
From time to time I get EAccess Errors when I send the Execute command to start the batch update to my remote servers.

I am using the latest version 10.4.3 !

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Bug in 10.4.1 with batch updates

Post by ViktorV » Wed 14 Jul 2021 15:06

Hi Tobias,

Unfortunately, we could not reproduce described error on our environment- our tests do not locate any errors and no one reported this issue before.
In order to investigate described behavior, we need to reproduce it on our side. Please compose a sample which demonstrates this behavior including scripts to create and fill in database objects and send it to us using contact form from our website:
https://www.devart.com/company/contactform.html
As soon as we get this sample and if the reason is in the code of our product, we will try fixing it asap.

Regards,
Viktor

TobiasHo
Posts: 30
Joined: Thu 11 Jul 2019 09:12

Re: Bug in 10.4.1 with batch updates

Post by TobiasHo » Wed 10 Nov 2021 07:14

The problem started, when you released the speed fix for the batch updates... Any help? I get this error every single day...

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Bug in 10.4.1 with batch updates

Post by ViktorV » Thu 11 Nov 2021 16:45

Dear Tobias,

Thank you for contacting us!
The reply for your question was provided in your duplicate request in this forum topic:
viewtopic.php?t=47280

Kindly let us know if any questions!

Post Reply