Unhandled Error!

MySQL error executing query: Incorrect key file for table '/tmp/#sql_559_1.MYI'; try to repair it

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
18 Db_MySQLDriver->execute('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id ORDER BY RAND() LIMIT 0, 10') /phproad/modules/db/classes/db_sqlbase.php 604
17 Db_SqlBase->execute('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id ORDER BY RAND() LIMIT 0, 10') /phproad/modules/db/classes/db_sqlbase.php 437
16 Db_SqlBase->query('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id ORDER BY RAND() LIMIT 0, 10') /phproad/modules/db/classes/db_sqlbase.php 499
15 Db_SqlBase->fetchAll('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id ORDER BY RAND() LIMIT 0, 10') /phproad/modules/db/classes/db_activerecord.php 512
14 Db_ActiveRecord->find_all_internal(null, array(0), null) /phproad/modules/db/classes/db_activerecord.php 532
13 Db_ActiveRecord->find_all(()) /modules/cms/classes/cms_controller.php(383) : eval()'d code 31
12 eval(()) /modules/cms/classes/cms_controller.php 383
11 Cms_Controller->evalWithException('?><? $string = $_SERVER["REQUEST_URI"] ; $patterns = array(); $patterns[0] = '/tripod-harness-winch-hire/'; $patterns[1] = '/Tripod-Harness-Winch-Hire-in-/'; $patterns[2] = '/-/'; $patterns[3] = '/\//'; $replacements = array(); $replacements[2] = ' '; $replacements[1] = ' '; $replacements[0] = ' '; $replacements[3] = ' '; $placename = htmlentities( preg_replace($patterns, $replacements, $string)); ?> <h1>Tripod, Harness &amp; Winch Hire in <? print $placename ?> </h1><p>Great news! We can deliver a tripod, harness &amp; winch on hire to <? print $placename ?>.<br/><br/>Whatever type of tripod, harness &amp; winch you require – or if you require extra ropes or harnesses – we deliver it all. Surveying Equipment .com is the UK’s largest survey equipment specialist with over 27 years experience in the sale and hire of surveying equipment.<br/><br/>See below for some of our most popular tripod, harness &amp; winch kits available for hire or call our Surveying Equipment Sales &amp; Hire Team on <b>0843 224 9670</b></p> <br/><br/> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <!-- NTHS_NEW_2 --> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-6614346790832762" data-ad-slot="1544097608" data-ad-format="auto"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> <br/><br/> <div class="side_by_side_products"><? $products = Shop_Product::create()->limit(10)->order('RAND()')->find_all(); $this->render_partial('shop:product_list', array('products'=>$products)); ?></div><br/><br/> <p>We also have a general <a href="http://www.nationaltoolhireshops.co.uk">tool hire</a> division which specialises in hire of DIY tools and plant equipment.</p>', 'CMS page', 'Tripod Harness Winch Hire') /modules/cms/classes/cms_controller.php 608
10 Cms_Controller->eval_page_content(()) /modules/cms/classes/cms_controller.php 198
9 Cms_Controller->open(object(Cms_Page), array(1) [0 => 'tripod-harness-winch-hire-in-abernethy']) /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('/tripod-harness-winch-hire/Tripod-Harness-Winch-Hire-in-Abernethy') /phproad/system/phproad.php 31
2 include('/var/www/vhosts/surveyingequipment.com/httpdocs/phproad/system/phproad.php') /boot.php 114
1 require_once('/var/www/vhosts/surveyingequipment.com/httpdocs/boot.php') /index.php 3

Warning: file_exists(): open_basedir restriction in effect. File(Unknown) is not within the allowed path(s): (/var/www/vhosts/surveyingequipment.com/:/tmp/) in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_errorlog.php on line 82

Warning: mcrypt_enc_get_key_size(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 43

Warning: mcrypt_enc_get_iv_size(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/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 /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 54

Warning: mcrypt_generic_init(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 56

Warning: mcrypt_generic(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 57

Warning: mcrypt_generic_deinit(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 58

Warning: mcrypt_enc_get_key_size(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 43

Warning: mcrypt_enc_get_iv_size(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/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 /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 54

Warning: mcrypt_generic_init(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 56

Warning: mcrypt_generic(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 57

Warning: mcrypt_generic_deinit(): 111 is not a valid MCrypt resource in /var/www/vhosts/surveyingequipment.com/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 58

Fatal error: Uncaught PHP Warning: Unknown: write failed: No space left on device (28) thrown in Unknown on line 0