InMotion Hosting Support Center

Product Import/export form dashboard error

Category: Opencart

2015-08-05 12:13 pm EST

Hits: 442
I an having trouble for the first time uploading the spreadsheet from admin. Attached is the spreadsheet.
It is also giving trouble to export from admin.
This is the Import or uploading error message.
Fatal error: Uncaught exception 'ErrorException' with message 'Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_store ORDER BY url' in /home/bohoti5/public_html/store/system/database/mysqli.php:41 Stack trace: #0 /home/bohoti5/public_html/store/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('SELECT * FROM o...') #1 /home/bohoti5/public_html/store/admin/model/setting/store.php(33): DB->query('SELECT * FROM o...') #2 /home/bohoti5/public_html/store/vqmod/vqcache/vq2-admin_controller_common_header.php(230): ModelSettingStore->getStores() #3 /home/bohoti5/public_html/store/vqmod/vqcache/vq2-system_engine_controller.php(43): ControllerCommonHeader->index(Array) #4 /home/bohoti5/public_html/store/vqmod/vqcache/vq2-system_engine_controller.php(74): Controller->getChild('common/header') #5 /home/bohoti5/public_html/store/admin/controller/tool/export.php(81): Controller->render() #6 [internal function]: ControllerToolExport->index() #7 /home/bohoti5/public_html/store/vqmod/vqcache/vq2-syste in /home/bohoti5/public_html/store/system/database/mysqli.php on line 41

This is the export or downloading error
mysqli::query(): send of 129 bytes failed with errno=32 Broken pipe
See also 'System > Error Logs' for more details

You must login before you can ask a follow up question.

You must login before you can submit an answer.



42,247 Points
2015-08-05 12:38 pm EST
Hello Boohootique,

Sorry for the problem you're having with the "MySQL server has gone away" error. This generally is either the result of an interruption in connection to the server when the script is running, or a possible problem at the server level that is occurring during the running of the script. We advise that you submit a ticket that includes the error message you've provided and also specific information on your account. The steps you're taking should also be listed so that the we can attempt to duplicate the error. The live support team would be able to run scripts on the server to help troubleshoot the issue if it's necessary. Make sure to provide necessary login information if it is required to get into the OpenCart admin.

I hope this helps to answer your question, please let us know if you require any further assistance.

Arnel C.

You must login before you can post a comment about this answer.

Like this Question?

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!