MySQL error executing query: Error on delete of '/tmp/#sql_1f91_2.MYI' (Errcode: 2)
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 |
// 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/portable-toilet-hire/Dulverton/' LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' REGEXP REPLACE(r.from_url, '(?:', '(') ELSE 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' = 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/portable-toilet-hire/Dulverton/' LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' REGEXP REPLACE(r.from_url, '(?:', '(') ELSE 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' = 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/portable-toilet-hire/Dulverton/' LIKE CONCAT(r.from_url,'%') WHEN 'Ends with' THEN 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' LIKE CONCAT('%', r.from_url) WHEN 'Regex' THEN 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' REGEXP REPLACE(r.from_url, '(?:', '(') ELSE 'https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/' = 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/portable-toilet-hire/Dulverton/']) | /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/portable-toilet-hire/Dulverton/']) | /modules/flynsarmyredirects/models/flynsarmyredirects_redirect.php | 125 |
| 20 | FlynsarmyRedirects_Redirect::find_triggering_redirects('https://www.nationaltoolhireshops.co.uk:443/portable-toilet-hire/Dulverton/', 1) | /modules/flynsarmyredirects/classes/flynsarmyredirects_module.php | 83 |
| 19 | FlynsarmyRedirects_Module->before_route('/portable-toilet-hire/dulverton') | ||
| 18 | call_user_func_array(array(2) [0 => object(FlynsarmyRedirects_Module), 1 => 'before_route'], array(1) [0 => '/portable-toilet-hire/dulverton']) | /phproad/system/class_functions.php | 18 |
| 17 | callFunction(array(2) [0 => object(FlynsarmyRedirects_Module), 1 => 'before_route'], array(1) [0 => '/portable-toilet-hire/dulverton']) | /phproad/modules/phpr/classes/phpr_events.php | 79 |
| 16 | Phpr_Events->fire_event(array(1) [name => 'cms:onBeforeRoute'], '/portable-toilet-hire/dulverton') | ||
| 15 | call_user_func_array(array(2) [0 => object(Phpr_Events), 1 => 'fire_event'], array(2) [0 => array(1), 1 => '/portable-toilet-hire/dulverton']) | /phproad/system/class_functions.php | 18 |
| 14 | callFunction(array(2) [0 => object(Phpr_Events), 1 => 'fire_event'], array(2) [0 => array(1), 1 => '/portable-toilet-hire/dulverton']) | /phproad/modules/phpr/classes/phpr_events.php | 153 |
| 13 | Phpr_Events->fireEvent('cms:onBeforeRoute', '/portable-toilet-hire/dulverton') | ||
| 12 | call_user_func_array(array(2) [0 => object(Phpr_Events), 1 => 'fireEvent'], array(2) [0 => 'cms:onBeforeRoute', 1 => '/portable-toilet-hire/dulverton']) | /phproad/modules/phpr/classes/phpr_extensible.php | 159 |
| 11 | Phpr_Extensible->__call('fireEvent', array(2) [0 => 'cms:onBeforeRoute', 1 => '/portable-toilet-hire/dulverton']) | /controllers/application.php | 24 |
| 10 | Backend_Events->fireEvent('cms:onBeforeRoute', '/portable-toilet-hire/dulverton') | /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('/portable-toilet-hire/Dulverton') | /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 |