Product Import/export form dashboard error

  • Answered
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
Error No: 2006
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
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. Regards, Arnel C.