PHP / MySQL Insert with ~400,000 characters failing as cron job

Asked Aug 24 '20 at 05:56

Active Aug 24 '20 at 05:56

Viewed 75 times

I have a long insert statement with 400,000 characters that does not work when I run it from a script as

$result = $conn->query($sqlfinal);

I echo the sql statement onto the page, it only takes about 20 seconds so it's not a script timeout issue. I copy and paste that result into PhpMyAdmin and it works fine there.

The logs say Error while sending QUERY packet and it works fine when I reduce it to a smaller query with the same syntax of around 25,000 characters. I'm using Hostinger for my hosting provider, I'm trying to figure out if I'm hitting a Hostinger restriction, or a PHP restriction?

asked Aug 24 '20 at 05:56

hoppiness

1

Check this post https://stackoverflow.com/questions/30753674/error-while-sending-query-packet – Chilarai Aug 24 '20 at 06:02
1

See the answer about setting `max_allowed_packet`. – Markus Zeller Aug 24 '20 at 07:56
I tried to write a record with 600,000 characters in my localhost and it works fine. – Majid Hajibaba Aug 24 '20 at 10:19

PHP / MySQL Insert with ~400,000 characters failing as cron job

0 Answers0