Post by GraemeH » Sun Aug 07, 2022 4:43 am

I am currently getting the following error in my logs and the site is refusing to load (error 500 message)

Can anyone tell me what the actual issue is? I get that it can't connect, but am not sure why.

Code: Select all

[06-Aug-2022 20:33:45 UTC] PHP Fatal error:  Uncaught Exception: Error: Lost connection to MySQL server during query<br />Error No: 2013<br />
			SELECT 
				p.product_id, 
				(
					SELECT AVG(rating) total 
					FROM `oc_review` r1 
					WHERE 
						r1.product_id = p.product_id 
						AND r1.status = '1' 
					GROUP BY r1.product_id
				) rating, 
				(
					SELECT price 
					FROM `oc_product_discount` pd2 
					WHERE 
						pd2.product_id = p.product_id 
						AND pd2.customer_group_id = '1' 
						AND pd2.quantity = '1' 
						AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) 
						AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) 
					ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
				) discount, 
				(
					SELECT price 
					FROM `oc_product_special` ps 
					WHERE 
						ps.product_id = p.product_id 
						AND ps.customer_group_id = '1' 
						AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) 
						AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) 
					ORDER BY ps.priority ASC, ps.price ASC LIMIT  in /home/XXX/public_html/XXX/system/library/db/mysqli.php on line 48

New member

Posts

Joined
Fri Apr 20, 2012 4:56 pm

Post by thekrotek » Sun Aug 07, 2022 4:38 pm

It actually tells you right in the beginning:

"Lost connection to MySQL server during query"

This is a generic MySQL issue, not OpenCart specific. Try to search in Google for solution by the phrase I provided.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: Adminas99999, Google [Bot], Semrush [Bot] and 89 guests