Post by lombert » Sun Feb 11, 2024 6:00 am

Hi

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;
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&amp;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
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.

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.
Last edited by lombert on Mon Feb 12, 2024 4:11 am, edited 1 time in total.

New member

Posts

Joined
Tue Aug 08, 2017 3:24 am

Post by OSWorX » Sun Feb 11, 2024 2:59 pm

First: this message indicates that your SQL-Server has too much load: MySQL server has gone away
Talk with your provider.

Second: use the Marketplace Support and open a ticket there if the developer is not responding: https://www.opencart.com/index.php?rout ... rt/support or
Third: use the button Get Support on the right side at the extension page itself.

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by lombert » Mon Feb 12, 2024 3:44 am

Thanks for your reply. It's takes about 35 seconds before the error is show after pressing the button, so I don't think the MySQL is slow is the problem. It's very quick in all other module and in the store. This button should show a list with 5-6 rows of questions. It can't take 35 seconds to calculate that..

If I use some of the links, is not they also sends the dev a mail? Or are there some other how get the mail? If dev not answer on the mail write inside module, why should dev answer on a mail from OC support?

I will try to delete the module and database and reinstall it, and see if that gets any error in the database to go away.

New member

Posts

Joined
Tue Aug 08, 2017 3:24 am

Post by lombert » Mon Feb 12, 2024 4:15 am

Deleted the database table and it takes picosec to open the page after that.. So the problem was inside one of the table. Now add in old value in the new table without the "product" there I get the error the first time. And it takes a blink of the eye to open the pages now with the rest of the values in the databas.. So not the MySQL being slow.

New member

Posts

Joined
Tue Aug 08, 2017 3:24 am

Post by straightlight » Mon Feb 12, 2024 4:34 am

lombert wrote:
Mon Feb 12, 2024 4:15 am
Deleted the database table and it takes picosec to open the page after that.. So the problem was inside one of the table. Now add in old value in the new table without the "product" there I get the error the first time. And it takes a blink of the eye to open the pages now with the rest of the values in the databas.. So not the MySQL being slow.
Server sensibility based on the mount of transactions.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by OSWorX » Mon Feb 12, 2024 6:15 pm

lombert wrote:
Mon Feb 12, 2024 3:44 am
.. so I don't think the MySQL is slow is the problem ..
Never said that your SQL-Server is slow, wrote that he is gone away!

Reason could be that your tables contain several million entries (as we had this issue in 3.x releases!).
Or that your dabase query/ies is not correct or should eb optimized.

Many reasons could be, so better to contact a real developer to solve that - or try it by yourself if you are able to do so ..

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria
Who is online

Users browsing this forum: No registered users and 5 guests