Unhandled Error!

MySQL error executing query: Got error 28 from storage engine

Hint

This problem could be caused by the LemonStand MySQL connection configuration errors. Please log into the LemonStand Configuration Tool and update the database connection parameters. Also please make sure that MySQL server is running.

Document /phproad/modules/db/classes/db_mysqldriver.php
Document type PHP document
Line 114
Exception class Phpr_DatabaseException

Code Highlight

 
			// execute the statement
			$handle = @mysql_query($sql, Db::$connection);
 
			// If error, generate exception
			if ($err = @mysql_errno(Db::$connection) != 0) {
				$exception = new Phpr_DatabaseException('MySQL error executing query: '.@mysql_error(Db::$connection));
				$exception->hint_message = 'This problem could be caused by the LemonStand MySQL connection configuration errors. Please log into the LemonStand Configuration Tool and update the database connection parameters. Also please make sure that MySQL server is running.';
				throw $exception;
			}
 
			return $handle;
		}
# Call Stack Code Document Line
20 Db_MySQLDriver->execute(' ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', attribute_values, '|', option_key, '|', sort_order) AS indexed, 'attributes' AS index_type FROM shop_custom_attributes WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', disk_name, '|', is_public, '|', NAME, '|', master_object_id) AS indexed, 'images' AS index_type FROM db_files WHERE master_object_id IN ('13735') AND ( master_object_class = 'Shop_Product' AND FIELD= 'images' ) ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', value, '|', IFNULL(sort_order,''), '|', properties_id, '|', groups_id) AS indexed, 'properties' AS index_type FROM shop_product_properties WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', customer_group_id, '|', quantity, '|', price) AS indexed, 'tier_prices' AS index_type FROM shop_tier_prices WHERE product_id IN ('13735') ) UNION ALL ( SELECT shop_category_id AS indexed, 'categories' AS index_type FROM shop_products_categories WHERE shop_product_id = '13735' ) ') /phproad/modules/db/classes/db_sqlbase.php 604
19 Db_SqlBase->execute(' ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', attribute_values, '|', option_key, '|', sort_order) AS indexed, 'attributes' AS index_type FROM shop_custom_attributes WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', disk_name, '|', is_public, '|', NAME, '|', master_object_id) AS indexed, 'images' AS index_type FROM db_files WHERE master_object_id IN ('13735') AND ( master_object_class = 'Shop_Product' AND FIELD= 'images' ) ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', value, '|', IFNULL(sort_order,''), '|', properties_id, '|', groups_id) AS indexed, 'properties' AS index_type FROM shop_product_properties WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', customer_group_id, '|', quantity, '|', price) AS indexed, 'tier_prices' AS index_type FROM shop_tier_prices WHERE product_id IN ('13735') ) UNION ALL ( SELECT shop_category_id AS indexed, 'categories' AS index_type FROM shop_products_categories WHERE shop_product_id = '13735' ) ') /phproad/modules/db/classes/db_sqlbase.php 437
18 Db_SqlBase->query(' ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', attribute_values, '|', option_key, '|', sort_order) AS indexed, 'attributes' AS index_type FROM shop_custom_attributes WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', disk_name, '|', is_public, '|', NAME, '|', master_object_id) AS indexed, 'images' AS index_type FROM db_files WHERE master_object_id IN ('13735') AND ( master_object_class = 'Shop_Product' AND FIELD= 'images' ) ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', value, '|', IFNULL(sort_order,''), '|', properties_id, '|', groups_id) AS indexed, 'properties' AS index_type FROM shop_product_properties WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', customer_group_id, '|', quantity, '|', price) AS indexed, 'tier_prices' AS index_type FROM shop_tier_prices WHERE product_id IN ('13735') ) UNION ALL ( SELECT shop_category_id AS indexed, 'categories' AS index_type FROM shop_products_categories WHERE shop_product_id = '13735' ) ') /phproad/modules/db/classes/db_sqlbase.php 499
17 Db_SqlBase->fetchAll(' ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', attribute_values, '|', option_key, '|', sort_order) AS indexed, 'attributes' AS index_type FROM shop_custom_attributes WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', disk_name, '|', is_public, '|', NAME, '|', master_object_id) AS indexed, 'images' AS index_type FROM db_files WHERE master_object_id IN ('13735') AND ( master_object_class = 'Shop_Product' AND FIELD= 'images' ) ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', value, '|', IFNULL(sort_order,''), '|', properties_id, '|', groups_id) AS indexed, 'properties' AS index_type FROM shop_product_properties WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', customer_group_id, '|', quantity, '|', price) AS indexed, 'tier_prices' AS index_type FROM shop_tier_prices WHERE product_id IN ('13735') ) UNION ALL ( SELECT shop_category_id AS indexed, 'categories' AS index_type FROM shop_products_categories WHERE shop_product_id = '13735' ) ', array(0)) /phproad/modules/db/classes/db_dbhelper.php 71
16 Db_DbHelper::queryArray(' ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', attribute_values, '|', option_key, '|', sort_order) AS indexed, 'attributes' AS index_type FROM shop_custom_attributes WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', disk_name, '|', is_public, '|', NAME, '|', master_object_id) AS indexed, 'images' AS index_type FROM db_files WHERE master_object_id IN ('13735') AND ( master_object_class = 'Shop_Product' AND FIELD= 'images' ) ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', value, '|', IFNULL(sort_order,''), '|', properties_id, '|', groups_id) AS indexed, 'properties' AS index_type FROM shop_product_properties WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', customer_group_id, '|', quantity, '|', price) AS indexed, 'tier_prices' AS index_type FROM shop_tier_prices WHERE product_id IN ('13735') ) UNION ALL ( SELECT shop_category_id AS indexed, 'categories' AS index_type FROM shop_products_categories WHERE shop_product_id = '13735' ) ', array(0)) /phproad/modules/db/classes/db_dbhelper.php 76
15 Db_DbHelper::objectArray(' ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', attribute_values, '|', option_key, '|', sort_order) AS indexed, 'attributes' AS index_type FROM shop_custom_attributes WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', disk_name, '|', is_public, '|', NAME, '|', master_object_id) AS indexed, 'images' AS index_type FROM db_files WHERE master_object_id IN ('13735') AND ( master_object_class = 'Shop_Product' AND FIELD= 'images' ) ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', NAME, '|', value, '|', IFNULL(sort_order,''), '|', properties_id, '|', groups_id) AS indexed, 'properties' AS index_type FROM shop_product_properties WHERE product_id IN ('13735') ) UNION ALL ( SELECT CONCAT(id, '|', product_id, '|', customer_group_id, '|', quantity, '|', price) AS indexed, 'tier_prices' AS index_type FROM shop_tier_prices WHERE product_id IN ('13735') ) UNION ALL ( SELECT shop_category_id AS indexed, 'categories' AS index_type FROM shop_products_categories WHERE shop_product_id = '13735' ) ') /modules/groupedview/classes/groupedview_class.php 396
14 GroupedView_Class::get_product(()) /modules/groupedview/classes/groupedview_class.php 30
13 GroupedView_Class::find_by_url_name('secura-moisturizing-lotion-8-ounce-bottle') /modules/groupedview/classes/groupedview_actions.php 24
12 GroupedView_Actions->product(()) /modules/cms/classes/cms_actionmanager.php 72
11 Cms_ActionManager::execAction('groupedview:product', object(Cms_Controller)) /modules/cms/classes/cms_controller.php 580
10 Cms_Controller->eval_page_content(()) /modules/cms/classes/cms_controller.php 198
9 Cms_Controller->open(object(Cms_Page), array(1) [0 => 'secura-moisturizing-lotion-8-ounce-bottle']) /controllers/application.php 72
8 Application->On404(())
7 call_user_func_array(array(2) [0 => object(Application), 1 => 'On404'], array(0)) /phproad/modules/phpr/classes/phpr_controller.php 170
6 Phpr_Controller->executeAction('On404', array(0)) /phproad/modules/phpr/classes/phpr_controller.php 84
5 Phpr_Controller->_run('On404', array(0)) /phproad/modules/phpr/classes/phpr_response.php 64
4 Phpr_Response->open404(()) /phproad/modules/phpr/classes/phpr_response.php 37
3 Phpr_Response->open('/product/secura-moisturizing-lotion-8-ounce-bottle') /phproad/system/phproad.php 31
2 include('/srv/www/activehealthsupply.com/public_html/phproad/system/phproad.php') /boot.php 114
1 require_once('/srv/www/activehealthsupply.com/public_html/boot.php') /index.php 3
Warning: mcrypt_enc_get_key_size(): 131 is not a valid MCrypt resource in /srv/www/activehealthsupply.com/public_html/phproad/modules/phpr/classes/phpr_securityframework.php on line 43 Warning: mcrypt_enc_get_iv_size(): 131 is not a valid MCrypt resource in /srv/www/activehealthsupply.com/public_html/phproad/modules/phpr/classes/phpr_securityframework.php on line 54 Warning: mcrypt_create_iv(): Cannot create an IV with a size of less than 1 or greater than 2147483647 in /srv/www/activehealthsupply.com/public_html/phproad/modules/phpr/classes/phpr_securityframework.php on line 54 Warning: mcrypt_generic_init(): 131 is not a valid MCrypt resource in /srv/www/activehealthsupply.com/public_html/phproad/modules/phpr/classes/phpr_securityframework.php on line 56 Warning: mcrypt_generic(): 131 is not a valid MCrypt resource in /srv/www/activehealthsupply.com/public_html/phproad/modules/phpr/classes/phpr_securityframework.php on line 57 Warning: mcrypt_generic_deinit(): 131 is not a valid MCrypt resource in /srv/www/activehealthsupply.com/public_html/phproad/modules/phpr/classes/phpr_securityframework.php on line 58 Fatal error: Exception thrown without a stack frame in Unknown on line 0