Last week I bought this module "Questions & Answers PRO" (https://www.opencart.com/index.php?rout ... n_id=12158), install and setup, got no problem, then I made first Q&A and press save, I got a "Freeze" in the module, the "save-button" just spin and not possible to do anything.
After that some functions in the module is not working, I gets this error;
The module is working in the rest, but it's not possible to use the "save-button" in the module; is't just spinn, but the "apply-button" works.Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT SQL_CALC_FOUND_ROWS q.*, qt.*, q.question_id, COUNT(DISTINCT a.answer_id) AS answers, IF(q.status, 'Enabled','Disabled') AS status_text, GROUP_CONCAT(DISTINCT IF(q2s.store_id = 0, 'Rubank Verktygs No 1 AB', s.name) SEPARATOR '<br/>') AS store_text, GROUP_CONCAT(DISTINCT q2s.store_id SEPARATOR '_') AS store, COUNT(DISTINCT q2s.store_id) AS store_count, GROUP_CONCAT(DISTINCT pd.name ORDER BY pd.name SEPARATOR '<br/>') AS related_products_text, GROUP_CONCAT(DISTINCT pd.product_id ORDER BY pd.name SEPARATOR '_') AS related_products, COUNT(DISTINCT q2p.product_id) AS related_products_count FROM oca2_question q LEFT JOIN oca2_question_text qt ON (q.question_id = qt.question_id AND qt.language_id = q.customer_language_id) LEFT JOIN oca2_question_answer a ON (q.question_id = a.question_id) LEFT JOIN oca2_question_to_store q2s ON (q.question_id = q2s.question_id) LEFT JOIN oca2_store s ON (s.store_id = q2s.store_id) LEFT JOIN oca2_question_to_store q2s2 ON (q.question_id = q2s2.question_id) LEFT JOIN oca2_question_to_product q2p ON (q.question_id = q2p.question_id) LEFT JOIN oca2_product_description pd ON (q2p.product_id = pd.product_id AND pd.language_id = '1') LEFT JOIN oca2_question_to_product q2p2 ON (q.question_id = q2p2.question_id) LEFT JOIN oca2_product_description pd2 ON (q2p2.product_id = pd2.product_id AND pd2.language_id = '1') GROUP BY q.question_id ORDER BY q.date_added DESC LIMIT 0,20 in /home/rubankve/ocartdata/storage/modification/system/library/db/mysqli.php:52 Stack trace: #0 /home/rubankve/public_html/system/library/db.php(45): DB\MySQLi->query() #1 /home/rubankve/public_html/admin/model/extension/module/questions_and_answers.php(712): DB->query() #2 /home/rubankve/ocartdata/storage/modification/system/engine/loader.php(272): ModelExtensionModuleQuestionsAndAnswers->getQuestions() #3 /home/rubankve/public_html/system/engine/proxy.php(47): Loader->{closure}() #4 /home/rubankve/public_html/admin/controller/extension/module/qap/questions_and_answers.php(547): Proxy->__call() #5 /home/rubankve/public_html/admin/controller/extension/module/qap/questions_and_answers.php(68): ControllerExtensionModuleQapQuestionsAndAnswers->getList() #6 /home/rubankve/ocartdata/storage/modification/system/engine/action.php(79): ControllerExtensionModuleQapQuestionsAndAnswers->index() #7 /home/rubankve/ocartdata/storage/modification/system/engine/loader.php(66): Action->execute() #8 /home/rubankve/public_html/admin/controller/extension/module/questions_and_answers.php(834): Loader->controller() #9 /home/rubankve/ocartdata/storage/modification/system/engine/action.php(79): ControllerExtensionModuleQuestionsAndAnswers->view() #10 /home/rubankve/public_html/admin/controller/startup/router.php(26): Action->execute() #11 /home/rubankve/ocartdata/storage/modification/system/engine/action.php(79): ControllerStartupRouter->index() #12 /home/rubankve/public_html/system/engine/router.php(67): Action->execute() #13 /home/rubankve/public_html/system/engine/router.php(56): Router->execute() #14 /home/rubankve/public_html/system/framework.php(169): Router->dispatch() #15 /home/rubankve/public_html/system/startup.php(104): require_once('/home/rubankve/...') #16 /home/rubankve/public_html/admin/index.php(19): start() #17 {main} thrown in /home/rubankve/ocartdata/storage/modification/system/library/db/mysqli.php on line 52
Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />REPLACE INTO `oca2_session` SET `session_id` = '961e9c1e44121a787962c50356', `data` = '{\"user_id\":\"5\",\"user_token\":\"5k1McDKIzZRudpVSLslP1p6iB9GImqSY\",\"owc_euvat\":true,\"language\":\"sv-se\",\"currency\":\"SEK\",\"owc_euvat_customer_shipping_country_id\":\"203\",\"owc_euvat_customer_shipping_zone_id\":\"3084\",\"block_products\":{\"time\":1707599515,\"category\":{\"2269\":\"Be a member.\",\"2268\":\"Be a member.\"},\"product\":[],\"url\":[]},\"mailchimp_lists\":{\"5fb961d375\":\"Rubank Verktygs AB\"},\"mailchimp_subscribed_lists\":[],\"country_id\":\"203\",\"zone_id\":\"3084\",\"postcode\":\"702 34\",\"city\":\"\\u00d6rebro\",\"shipping_country_id\":\"203\",\"shipping_zone_id\":\"3084\",\"shipping_postcode\":\"702 34\",\"shipping_city\":\"\\u00d6rebro\",\"guest\":{\"shipping\":{\"city\":\"\\u00d6rebro\",\"iso_code_2\":\"SE\",\"postcode\":\"702 34\",\"zone_code\":\"T\",\"country_id\":\"203\",\"zone_id\":\"3084\"},\"shipping_address\":{\"city\":\"\\u00d6rebro\",\"iso_code_2\":\"SE\",\"postcode\":\"702 34\",\"zone_code\":\"T\",\"country_id\":\"203\",\"zone_id\":\"3084\"},\"customer_group_id\":\"8\",\"payment\":{\"city\":\"\\u00d6rebro\",\"iso_code_2\":\"SE\",\"postcode\":\"702 34\",\"zone_code\":\"T\",\"country_id\":\"203\",\"zone_id\":\"3084\"},\"payment_address\":{\"city\":\"\\u00d6rebro\",\"iso_code_2\":\"SE\",\"postcode\":\"702 34\",\"zone_code\":\"T\",\"country_id\":\"203\",\"zone_id\":\"3084\"}},\"shipping_address\":{\"city\":\"\\u00d6rebro\",\"iso_code_2\":\"SE\",\"postcode\":\"702 34\",\"zone_code\":\"T\",\"country_id\":\"203\",\"zone_id\":\"3084\"},\"payment_country_id\":\"203\",\"payment_zone_id\":\"3084\",\"payment_postcode\":\"702 34\",\"payment_city\":\"\\u00d6rebro\",\"payment_address\":{\"city\":\"\\u00d6rebro\",\"iso_code_2\":\"SE\",\"postcode\":\"702 34\",\"zone_code\":\"T\",\"country_id\":\"203\",\"zone_id\":\"3084\"},\"geoip_data\":{\"ip\":\"217.208.126.249\",\"time\":1707599403,\"location\":{\"city\":\"\\u00d6rebro\",\"iso_code_2\":\"SE\",\"postcode\":\"702 34\",\"zone_code\":\"T\",\"country_id\":\"203\",\"zone_id\":\"3084\"},\"blocked_urls\":[],\"blocked_message\":\"\"},\"owc_productpageenhancedshortdescription\":true,\"clear_filters\":\"\\/index.php?route=product\\/category&path=_2981_2999\",\"relevant_values\":{\"attribute\":[],\"category\":[\"2999\"],\"filter\":[],\"manufacturer\":[\"110\"],\"option\":[],\"max_price\":1427.5},\"auto_add_products_pro\":true,\"abandonedCart_ID\":\"961e9c1e44121a787962c50356\",\"auto_added_free_pro\":[],\"coupon\":\"ViHarKlantatTillDet\"}', `expire` = '2024-02-10 22:51:23' in /home/rubankve/ocartdata/storage/modification/system/library/db/mysqli.php:52 Stack trace: #0 /home/rubankve/public_html/system/library/db.php(45): DB\MySQLi->query() #1 /home/rubankve/public_html/system/library/session/db.php(28): DB->query() #2 /home/rubankve/public_html/system/library/session.php(81): Session\DB->write() #3 [internal function]: Session->close() #4 {main} thrown in /home/rubankve/ocartdata/storage/modification/system/library/db/mysqli.php on line 52
I reached out to the developer with a support question on the mail that is in the module. Module info say answer within next 36h. After 48h I resend mail and asked again if there are any solution? Now it is 6 days without answer. So I get the feeling the dev is not interested to answer or have abandoned it's modules.
The store is working as it should. Can there be some problem with the database but it don't show it in the error log.
So I now ask here if any can see in the error what is wrong? I don't have any other problem with the database, it's very quick, so a "time out/MySQL server has gone away" feels not correct. So I guess there is some other problem or error.
OpenCart version using: 3.0.3.9
PHP version using: 8.1.27
All suggestions for solutions are appreciated. If the question is in the wrong forum, I apologise for that and it can be moved to the right place.