catalog:images:resize command stops at 100/2115 images with Error sending QUERY packetMagento 2 SQLSTATE[42S22]: while create product?Magento installation on live server is throwing errorIntegrity constraint error referring to quote_item table while adding product to cartI faced the error while search any string Magento 2Magento update fails during backupMagento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)Getting error while adding category Magento2Existing Products not saving after upgrading to Magento 2.3Magento 2 Add Billing and Shipping Company Column on Sales Order GridMySQL server has gone away Zend/Db/Statement/Pdo.ph
Why were helmets and other body armour not commonplace in the 1800s?
My employer faked my resume to acquire projects
A steel cutting sword?
Adding spaces to string based on list
Website returning plaintext password
Count Even Digits In Number
Popcorn is the only acceptable snack to consume while watching a movie
Why do Ryanair allow me to book connecting itineraries through a third party, but not through their own website?
Which is the common name of Mind Flayers?
Is it unethical to use a published code in my PhD thesis work?
What does the view outside my ship traveling at light speed look like?
Is real public IP Address hidden when using a system wide proxy in Windows 10?
What does this symbol on the box of power supply mean?
What are the real benefits of using Salesforce DX?
Is "cool" appropriate or offensive to use in IMs?
Simple fuzz pedal using breadboard
Crossing US border with music files I'm legally allowed to possess
Boss wants me to falsify a report. How should I document this unethical demand?
Looking for a soft substance that doesn't dissolve underwater
Count rotary dial pulses in a phone number (including letters)
Installed Electric Tankless Water Heater - Internet loss when active
Employer asking for online access to bank account - Is this a scam?
Is the field of q-series 'dead'?
In general, would I need to season a meat when making a sauce?
catalog:images:resize command stops at 100/2115 images with Error sending QUERY packet
Magento 2 SQLSTATE[42S22]: while create product?Magento installation on live server is throwing errorIntegrity constraint error referring to quote_item table while adding product to cartI faced the error while search any string Magento 2Magento update fails during backupMagento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)Getting error while adding category Magento2Existing Products not saving after upgrading to Magento 2.3Magento 2 Add Billing and Shipping Company Column on Sales Order GridMySQL server has gone away Zend/Db/Statement/Pdo.ph
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I just migrated an inventory from one Ecommerce Platform to Magento and while running the image:resize command to re-scale the images for them to display, the command consistently fails when it reaches 100 images, this is 100/2115.
Error Message:
Warning: Error while sending QUERY packet. PID=11883 in /home/[server]/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228
Does anyone know if there is a work around for this or solution?
magento2 image-resizing
asked May 20 at 15:39
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I just migrated an inventory from one Ecommerce Platform to Magento and while running the image:resize command to re-scale the images for them to display, the command consistently fails when it reaches 100 images, this is 100/2115.
Error Message:
Warning: Error while sending QUERY packet. PID=11883 in /home/[server]/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228
Does anyone know if there is a work around for this or solution?
magento2 image-resizing
asked May 20 at 15:39
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please try to set max_allowed_packet using the following command :SET GLOBAL max_allowed_packet=524288000;Try again.
– Sudhanshu Bajaj
May 20 at 15:44
@SudhanshuBajaj Is this a change to the my.ini file? or is that a SSH command that can be run?
– Uncle Hank
May 20 at 16:18
This is MySql query. You can also set in my.ini likemax_allowed_packet=500M.
– Sudhanshu Bajaj
May 20 at 17:08
add a comment |
I just migrated an inventory from one Ecommerce Platform to Magento and while running the image:resize command to re-scale the images for them to display, the command consistently fails when it reaches 100 images, this is 100/2115.
Error Message:
Warning: Error while sending QUERY packet. PID=11883 in /home/[server]/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228
Does anyone know if there is a work around for this or solution?
magento2 image-resizing
asked May 20 at 15:39
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I just migrated an inventory from one Ecommerce Platform to Magento and while running the image:resize command to re-scale the images for them to display, the command consistently fails when it reaches 100 images, this is 100/2115.
Error Message:
Warning: Error while sending QUERY packet. PID=11883 in /home/[server]/public_html/magento/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228
Does anyone know if there is a work around for this or solution?
magento2 image-resizing
magento2 image-resizing
asked May 20 at 15:39
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked May 20 at 15:39
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked May 20 at 15:39
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked May 20 at 15:39
Uncle HankUncle Hank
11
asked May 20 at 15:39
Uncle HankUncle Hank
11
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please try to set max_allowed_packet using the following command :SET GLOBAL max_allowed_packet=524288000;Try again.
– Sudhanshu Bajaj
May 20 at 15:44
@SudhanshuBajaj Is this a change to the my.ini file? or is that a SSH command that can be run?
– Uncle Hank
May 20 at 16:18
This is MySql query. You can also set in my.ini likemax_allowed_packet=500M.
– Sudhanshu Bajaj
May 20 at 17:08
add a comment |
Please try to set max_allowed_packet using the following command :SET GLOBAL max_allowed_packet=524288000;Try again.
– Sudhanshu Bajaj
May 20 at 15:44
@SudhanshuBajaj Is this a change to the my.ini file? or is that a SSH command that can be run?
– Uncle Hank
May 20 at 16:18
This is MySql query. You can also set in my.ini likemax_allowed_packet=500M.
– Sudhanshu Bajaj
May 20 at 17:08
Please try to set max_allowed_packet using the following command :
SET GLOBAL max_allowed_packet=524288000; Try again.– Sudhanshu Bajaj
May 20 at 15:44
Please try to set max_allowed_packet using the following command :
SET GLOBAL max_allowed_packet=524288000; Try again.– Sudhanshu Bajaj
May 20 at 15:44
@SudhanshuBajaj Is this a change to the my.ini file? or is that a SSH command that can be run?
– Uncle Hank
May 20 at 16:18
@SudhanshuBajaj Is this a change to the my.ini file? or is that a SSH command that can be run?
– Uncle Hank
May 20 at 16:18
This is MySql query. You can also set in my.ini like
max_allowed_packet=500M.– Sudhanshu Bajaj
May 20 at 17:08
This is MySql query. You can also set in my.ini like
max_allowed_packet=500M.– Sudhanshu Bajaj
May 20 at 17:08
add a comment |
1 Answer
1
active
oldest
votes
The solution:
After discussing this with our current host, editing the my.ini file or adjusting the max allowed packet is not something that is possible on shared hosting, this is something that is only possible via dedicated or cloud hosting. Therefore the hosting package has to be changed for this error to be resolved.
answered May 22 at 18:13
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Uncle Hank is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f275322%2fcatalogimagesresize-command-stops-at-100-2115-images-with-error-sending-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The solution:
After discussing this with our current host, editing the my.ini file or adjusting the max allowed packet is not something that is possible on shared hosting, this is something that is only possible via dedicated or cloud hosting. Therefore the hosting package has to be changed for this error to be resolved.
answered May 22 at 18:13
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
The solution:
After discussing this with our current host, editing the my.ini file or adjusting the max allowed packet is not something that is possible on shared hosting, this is something that is only possible via dedicated or cloud hosting. Therefore the hosting package has to be changed for this error to be resolved.
answered May 22 at 18:13
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
The solution:
After discussing this with our current host, editing the my.ini file or adjusting the max allowed packet is not something that is possible on shared hosting, this is something that is only possible via dedicated or cloud hosting. Therefore the hosting package has to be changed for this error to be resolved.
answered May 22 at 18:13
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
The solution:
After discussing this with our current host, editing the my.ini file or adjusting the max allowed packet is not something that is possible on shared hosting, this is something that is only possible via dedicated or cloud hosting. Therefore the hosting package has to be changed for this error to be resolved.
answered May 22 at 18:13
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered May 22 at 18:13
Uncle HankUncle Hank
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered May 22 at 18:13
Uncle HankUncle Hank
11
answered May 22 at 18:13
Uncle HankUncle Hank
11
11
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Uncle Hank is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Uncle Hank is a new contributor. Be nice, and check out our Code of Conduct.
Uncle Hank is a new contributor. Be nice, and check out our Code of Conduct.
Uncle Hank is a new contributor. Be nice, and check out our Code of Conduct.
Uncle Hank is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f275322%2fcatalogimagesresize-command-stops-at-100-2115-images-with-error-sending-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please try to set max_allowed_packet using the following command :
SET GLOBAL max_allowed_packet=524288000;Try again.– Sudhanshu Bajaj
May 20 at 15:44
@SudhanshuBajaj Is this a change to the my.ini file? or is that a SSH command that can be run?
– Uncle Hank
May 20 at 16:18
This is MySql query. You can also set in my.ini like
max_allowed_packet=500M.– Sudhanshu Bajaj
May 20 at 17:08