Page 1 of 1

Data corruption on bit columns in the database

PostPosted: 01. August 2017 13:26
by ale5000
XAMPP for Windows 7.1.7 (probably also 7.0.21) contains a version of PHP that corrupt data in the database for fields of type bit.

Can you please include this fix? https://github.com/php/php-src/commit/e15c418c4c765d3a0c65a5ff15dcf37b1e556a66
It is important to prevent data corruption.

Re: Data corruption on bit columns in the database

PostPosted: 01. August 2017 14:30
by Altrea
Hi,

This php source commit is from Dec 2016, which was way way before the release of PHP 7.1.7.
What makes you sure that this bug still exists in PHP 7.1.7? It was fixed for PHP 7.0.15+.

And: We cannot provide any PHP source code fixed for already released PHP versions, because we only include the binaries provided by php.net.
So the only way would be to wait for a new PHP release which gets included in a new XAMPP version.

best wishes,
Altrea

Re: Data corruption on bit columns in the database

PostPosted: 01. August 2017 14:35
by ale5000
Well then, maybe is in a different part of the code but the bug exist, I tested it personally.

The problem is possibly Windows specific but I'm not sure.

Re: Data corruption on bit columns in the database

PostPosted: 01. August 2017 14:37
by Altrea
Feel free to open a PHP Bug report https://bugs.php.net/
Maybe it is still unknown

Re: Data corruption on bit columns in the database

PostPosted: 01. August 2017 15:06
by ale5000
Reported here: https://bugs.php.net/bug.php?id=75018

Re: Data corruption on bit columns in the database

PostPosted: 13. September 2017 18:20
by ale5000
They have fixed it.

Re: Data corruption on bit columns in the database

PostPosted: 13. September 2017 18:54
by Altrea
That are great news :D
Thanks for this update.