Question about mySQL and Maria-db not returning all data

[Ton Kuypers]

Hi Rick,

I can’t switch, it is an OpenCart webshow i’ve integrated with a cash-register & invoice system, so I’m stuck with MySQL or Maria-DB…


Met vriendelijke groeten,
Warm Regards,



Ton Kuypers
+32 (0) 477 739 530

Steenweg op Leopoldsburg 100 • B-2490 • Balen • Belgium
www.publishingtools4u.com





> On 15 Oct 2025, at 06:57, harrison--- via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> You could try using PostgreSQL instead of Maria-DB. I have used it, it is free, and it works great with LiveCode!
> 
> Good luck!
> 
> Rick
> 
>> On Oct 14, 2025, at 3:00 PM, Ton Kuypers via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> Hi all,
>> 
>> I have a problem I can't seem to solve...
>> 
>> I'm running a mySQL server locally on my Mac, version 5.7.23. When I try to retrieve using a direct link from LiveCode Community 9.6.3, everything works perfectly.
>> Remote my provider switched to version Maria-db 10.6.23 and there's a "small" issue.
>> 
>> When using a php page to extract the data, everything comes in, a little slow, but all data is there.
>> But when using the same direct option from LiveCode, only a part of the data comes in. Blazing fast, but the data stops after a "random" amount of chars...
>> The first query direct gives 5.523 chars, php returns 5.472 chars
>> The second query via a direct livecode query retrieves 419.530 chars, the PHP pages returns 2.664.296 chars 
>> And a third query returns 1355 characters direct and 10.231 through php...
>> 
>> So I upgraded to Maria-DB on my Mac: same problem as remote
>> Removed this installation and installed the latest version of MySQL: cannot use this version, because the mysql_native_password does no longer exist, so I can’t login anymore.
>> So I removed that version as well and went back to MySql 8.0.42. Login works again, but als the problem with the chopped off data is back, same as the remote Maria-DB version.
>> 
>> I need a working remote database, preferably the latest Maria-DB version as installed, but I need to be able to get all the data, using the direct connection commands in LiveCode… PHP work fine, but is is slowwwwwwwwww
>> 
>> Anybody a suggestion?
>> 
>> 
>> Met vriendelijke groeten,
>> Warm Regards,
>> 
>> 
>> 
>> Ton Kuypers
>> +32 (0) 477 739 530
>> 
>> Steenweg op Leopoldsburg 100 • B-2490 • Balen • Belgium
>> www.publishingtools4u.com
>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode