Unhandled Error!

MySQL error executing query: Error on delete of '/tmp/#sql_1f91_1.MYI' (Errcode: 2)

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
25 Db_MySQLDriver->execute(' SELECT r.id, g.id AS group_id, g.name AS group_name, r.from_url, r.to_url, r.redirect_code, r.match_type FROM flynsarmyredirects_groups g JOIN flynsarmyredirects_redirects r ON r.group_id=g.id WHERE g.is_enabled=1 AND r.is_enabled=1 AND CASE r.match_type WHEN 'Starts with' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' REGEXP REPLACE(r.from_url, '(?:', '(') ELSE 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' = r.from_url END ORDER BY g.sort_order, r.sort_order LIMIT 1 ') /phproad/modules/db/classes/db_sqlbase.php 603
24 Db_SqlBase->execute(' SELECT r.id, g.id AS group_id, g.name AS group_name, r.from_url, r.to_url, r.redirect_code, r.match_type FROM flynsarmyredirects_groups g JOIN flynsarmyredirects_redirects r ON r.group_id=g.id WHERE g.is_enabled=1 AND r.is_enabled=1 AND CASE r.match_type WHEN 'Starts with' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' REGEXP REPLACE(r.from_url, '(?:', '(') ELSE 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' = r.from_url END ORDER BY g.sort_order, r.sort_order LIMIT 1 ') /phproad/modules/db/classes/db_sqlbase.php 436
23 Db_SqlBase->query(' SELECT r.id, g.id AS group_id, g.name AS group_name, r.from_url, r.to_url, r.redirect_code, r.match_type FROM flynsarmyredirects_groups g JOIN flynsarmyredirects_redirects r ON r.group_id=g.id WHERE g.is_enabled=1 AND r.is_enabled=1 AND CASE r.match_type WHEN 'Starts with' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' REGEXP REPLACE(r.from_url, '(?:', '(') ELSE 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/' = r.from_url END ORDER BY g.sort_order, r.sort_order LIMIT 1 ') /phproad/modules/db/classes/db_sqlbase.php 498
22 Db_SqlBase->fetchAll(' SELECT r.id, g.id AS group_id, g.name AS group_name, r.from_url, r.to_url, r.redirect_code, r.match_type FROM flynsarmyredirects_groups g JOIN flynsarmyredirects_redirects r ON r.group_id=g.id WHERE g.is_enabled=1 AND r.is_enabled=1 AND CASE r.match_type WHEN 'Starts with' THEN :url LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN :url LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN :url REGEXP REPLACE(r.from_url, '(?:', '(') ELSE :url = r.from_url END ORDER BY g.sort_order, r.sort_order LIMIT 1 ', array(1) [url => 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/']) /phproad/modules/db/classes/db_dbhelper.php 71
21 Db_DbHelper::queryArray(' SELECT r.id, g.id AS group_id, g.name AS group_name, r.from_url, r.to_url, r.redirect_code, r.match_type FROM flynsarmyredirects_groups g JOIN flynsarmyredirects_redirects r ON r.group_id=g.id WHERE g.is_enabled=1 AND r.is_enabled=1 AND CASE r.match_type WHEN 'Starts with' THEN :url LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN :url LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN :url REGEXP REPLACE(r.from_url, '(?:', '(') ELSE :url = r.from_url END ORDER BY g.sort_order, r.sort_order LIMIT 1 ', array(1) [url => 'https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/']) /modules/flynsarmyredirects/models/flynsarmyredirects_redirect.php 125
20 FlynsarmyRedirects_Redirect::find_triggering_redirects('https://www.nationaltoolhireshops.co.uk:443/pressure-washer-hire/South-Shields/', 1) /modules/flynsarmyredirects/classes/flynsarmyredirects_module.php 83
19 FlynsarmyRedirects_Module->before_route('/pressure-washer-hire/south-shields')
18 call_user_func_array(array(2) [0 => object(FlynsarmyRedirects_Module), 1 => 'before_route'], array(1) [0 => '/pressure-washer-hire/south-shields']) /phproad/system/class_functions.php 18
17 callFunction(array(2) [0 => object(FlynsarmyRedirects_Module), 1 => 'before_route'], array(1) [0 => '/pressure-washer-hire/south-shields']) /phproad/modules/phpr/classes/phpr_events.php 79
16 Phpr_Events->fire_event(array(1) [name => 'cms:onBeforeRoute'], '/pressure-washer-hire/south-shields')
15 call_user_func_array(array(2) [0 => object(Phpr_Events), 1 => 'fire_event'], array(2) [0 => array(1), 1 => '/pressure-washer-hire/south-shields']) /phproad/system/class_functions.php 18
14 callFunction(array(2) [0 => object(Phpr_Events), 1 => 'fire_event'], array(2) [0 => array(1), 1 => '/pressure-washer-hire/south-shields']) /phproad/modules/phpr/classes/phpr_events.php 153
13 Phpr_Events->fireEvent('cms:onBeforeRoute', '/pressure-washer-hire/south-shields')
12 call_user_func_array(array(2) [0 => object(Phpr_Events), 1 => 'fireEvent'], array(2) [0 => 'cms:onBeforeRoute', 1 => '/pressure-washer-hire/south-shields']) /phproad/modules/phpr/classes/phpr_extensible.php 159
11 Phpr_Extensible->__call('fireEvent', array(2) [0 => 'cms:onBeforeRoute', 1 => '/pressure-washer-hire/south-shields']) /controllers/application.php 24
10 Backend_Events->fireEvent('cms:onBeforeRoute', '/pressure-washer-hire/south-shields') /controllers/application.php 24
9 Application->resolve_page(null) /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('/pressure-washer-hire/South-Shields') /phproad/system/phproad.php 31
2 include('/var/www/vhosts/nationaltoolhireshops.co.uk/httpdocs/phproad/system/phproad.php') /boot.php 114
1 require_once('/var/www/vhosts/nationaltoolhireshops.co.uk/httpdocs/boot.php') /index.php 3