Bug #74021 [Com]: fetch_array broken data. Data more then MEDIUMBLOB

Edit report at https://bugs.php.net/bug.php?id=74021&edit=1 ID: 74021 Comment by: spam2 at rhsoft dot net Reported by: mavgust at radaris dot com Summary: fetch_array broken data. Data more then MEDIUMBLOB Status: Closed Type: Bug Package: MySQLi related Operating System: Linux(Centos) PHP Version: 7.1.1 Block user comment: N Private report: N New Comment: i have similar issues on 7.0.15 with a 15 MB base64 data column and fetch_assoc(), hopefully this will be fixed too soon [16-Feb-2017 10:33:15 Europe/Vienna] PHP Warning: mysqli_fetch_assoc() [<a href='http://at.php.net/manual/de/function.mysqli-fetch-assoc.php'>function.mysqli-fetch-assoc.php</a>]: Malformed server packet. Field length pointing 22 bytes after end of packet in /phpincludes/global_mysql_class.inc.php on line 639 [16-Feb-2017 10:33:15 Europe/Vienna] PHP Warning: mysqli_fetch_assoc() [<a href='http://at.php.net/manual/de/function.mysqli-fetch-assoc.php'>function.mysqli-fetch-assoc.php</a>]: Error while reading a row in /phpincludes/global_mysql_class.inc.php on line 639 Previous Comments: ------------------------------------------------------------------------ [2017-02-12 11:55:33] nikic@php.net Related To: Bug #74086 ------------------------------------------------------------------------ [2017-02-12 11:52:04] nikic@php.net Automatic comment on behalf of andrew.nester.dev@gmail.com Revision: http://git.php.net/?p=php-src.git;a=commit;h=01c1afa79f614fe8376e73f4e73f392160923745 Log: Fixed bug #74021 ------------------------------------------------------------------------ [2017-02-01 10:48:26] andrew dot nester dot dev at gmail dot com Just added PR on GitHub with fix for this issue. ------------------------------------------------------------------------ [2017-02-01 08:43:46] mavgust at radaris dot com max_allowed_packet | 67108864 I try $res = $m->query("SELECT RPAD('1',9000000,'1') as a,RPAD('1',9000000,'1') as b") $r = $res->fetch_array() md5($r['a']) = 42ca0fd16ab6b6d4b9d47dc0a4a8b12a md5($r['b']) = 6344f4429e683a9d37bef06feecbfe87 BUT REQUEST $m->query("SELECT RPAD('1',9000000,'1') as a,RPAD('1',9000000,'1') as b,'test' as c") Return ERROR mysqli_result::fetch_array(): Malformed server packet. Field length pointing 44 bytes after end of packet I downgrade php package from php.x86_64 0:7.1.1-2.el7.remi to php.x86_64 0:7.1.0-1.el7.remi and all work fine ------------------------------------------------------------------------ [2017-02-01 07:46:34] andrew dot nester dot dev at gmail dot com I was unable to reproduce this on latest PHP version. what is you MySQL configuration, for example, max_allowed_packet? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=74021 -- Edit this bug report at https://bugs.php.net/bug.php?id=74021&edit=1