Unhandled Error!

MySQL error executing query: Disk full (/tmp/#sql-temptable-351-352763-23c779.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

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
29 Db_MySQLDriver->execute('DESCRIBE shop_currency_settings') /phproad/modules/db/classes/db_mysqldriver.php 217
28 Db_MySQLDriver->fetchAll('DESCRIBE shop_currency_settings') /phproad/modules/db/classes/db_mysqldriver.php 193
27 Db_MySQLDriver->describe_table('shop_currency_settings') /phproad/modules/db/classes/db_sqlbase.php 465
26 Db_SqlBase->describe_table('shop_currency_settings') /phproad/modules/db/classes/db_activerecord.php 1390
25 Db_ActiveRecord->fields(()) /phproad/modules/db/classes/db_activerecord.php 404
24 Db_ActiveRecord->initialize(()) /phproad/modules/db/classes/db_activerecord.php 358
23 Db_ActiveRecord->__construct(()) /modules/backend/classes/backend_settingsrecord.php 7
22 Backend_SettingsRecord::get('Shop_CurrencySettings') /modules/shop/models/shop_currencysettings.php 20
21 Shop_CurrencySettings::get(()) /modules/shop/models/shop_currencysettings.php 51
20 Shop_CurrencySettings::format_currency('31.4652', 2) /modules/shop/init/custom_helpers.php 20
19 format_currency('31.4652') /modules/cms/classes/cms_controller.php(383) : eval()'d code 123
18 eval(()) /modules/cms/classes/cms_controller.php 383
17 Cms_Controller->evalWithException('?><? if (isset($paginate) && $paginate) { $page_index = isset($page_index) ? $page_index-1 : 0; $records_per_page = isset($records_per_page) ? $records_per_page : 3; $pagination = $products->paginate($page_index, $records_per_page); } else $pagination = null; $products = $products instanceof Db_ActiveRecord ? $products->find_all() : $products; ?> <?php if (!isset($carousel)): ?> <script type="text/javascript" src="//widget.trustpilot.com/bootstrap/v5/tp.widget.bootstrap.min.js" async></script> <?php endif; ?> <div class="product-list-wrap"> <div class="<?php if (isset($carousel)): ?> jsProductsCarousel<?php endif; ?>"> <? $i=1; $showEvery = 3; foreach ($products as $product): ?> <div class="<?php if (!isset($carousel)): ?>small-12 medium-12 large-12<?php endif; ?> columns product-list | jsProductCard" data-url="<?php echo $product->page_url('/p') ?>/"> <? if(!isset($carousel) && $i == 1): ?> <div class="" style="display: inline-block; border: 1px solid #F63D1D; background: #F63D1D; color: #fff; padding: 5px 10px; font-size: 16px; text-transform: uppercase; font-weight: bold">Most Popular</div> <? endif; ?> <?php if (!isset($carousel)): ?> <?php if( is_int(($i-1) / $showEvery) && $i >1 ): ?> <!-- start promo --> <div class="category-promo"> <div style="height: 100%; background-color: #fff; margin-bottom: 2em; padding:1.5em 1.5em 0;"> <?php $this->render_partial('category_reviews_tp'); ?> </div> </div> <!-- end promo --> <?php endif ?> <?php endif ?> <div class="product-card-module--productCard--JJB1H<? if($i == 1): ?> most-popular<?php endif; ?>"> <div> <? if($image_url = $product->image_url(0, 400, 400)): ?> <picture> <img src="<?= $image_url ?>" alt="<?= h($product->name) ?> Hire" loading="eager" width="400" height="400"> </picture> <?php endif; ?> <?php if (!isset($carousel)): ?> <div class="same-day-tool-hire-desktop"> <?php $bookingDelay = $product->om('x_remote_booking_delay'); $sameDayCutoff = $product->om('x_same_day_booking_cutoff'); $extendedSameDayCutoff = $product->om('x_extended_same_day_booking_cutoff'); $getFields = Phpr::$request->get_fields; $displaySDH = isset($getFields['SDH']) ? 'block' : 'none'; $displaySDCC = isset($getFields['SDCC']) ? 'block' : 'none'; //$sameDayCutoff = '22:30'; //$extendedSameDayCutoff = '23:30'; echo "<a href='/same-day-tool-hire/' style='display:" . $displaySDCC . ";' class='same-day-tool-hire same-day-loading' data-booking-delay='" . $bookingDelay . "' data-cut-off-start='" . $sameDayCutoff . "' data-cut-off-end='" . $extendedSameDayCutoff . "'>Next Day Hire Available</a>"; echo "<a href='/same-day-tool-hire/' style='display:" . $displaySDH . ";' class='same-day-tool-hire same-day-loading' data-booking-delay='" . $bookingDelay . "' data-cut-off-start='00:00' data-cut-off-end='" . $sameDayCutoff . "'>Same Day Hire Available</a>"; ?> </div> <?php endif; ?> </div> <div> <h2 class="product-name"><a href="<?php echo $product->page_url('/p'); ?>/"><?= h($product->name) ?></a></h2> <?php if ($product->x_context): ?> <p class="context"><?= ($product->x_context) ?></p> <?php endif; ?> <?php if (!isset($carousel) && $product->x_features): ?> <ul class="product-features desktop"> <?php $features = explode("\n", $product->x_features); foreach ($features as $line): ?> <li><?php echo $line; ?></li> <?php endforeach; ?> </ul> <?php endif; ?> </div> <div> <?php if (!isset($carousel)): ?> <div class="same-day-tool-hire-mobile"> <?php echo "<a href='/same-day-tool-hire/' style='display:" . $displaySDCC . ";' class='same-day-tool-hire same-day-loading' data-booking-delay='" . $bookingDelay . "' data-cut-off-start='" . $sameDayCutoff . "' data-cut-off-end='" . $extendedSameDayCutoff . "'>Next Day Hire Available</a>"; echo "<a href='/same-day-tool-hire/' style='display:" . $displaySDH . ";' class='same-day-tool-hire same-day-loading' data-booking-delay='" . $bookingDelay . "' data-cut-off-start='00:00' data-cut-off-end='" . $sameDayCutoff . "'>Same Day Hire Available</a>"; ?> </div> <?php endif; ?> <?php if (!isset($carousel) && $product->x_features): ?> <ul class="product-features mobile"> <?php $features = explode("\n", $product->x_features); foreach ($features as $line): ?> <li><?php echo $line; ?></li> <?php endforeach; ?> </ul> <?php endif; ?> <?php $days1Multiplier = 0.6; $days7Multiplier = 1; $percentages = $product->om('x_remote_percentages'); if($percentages && !empty($percentages['days_1'])) { $days1Multiplier = $percentages['days_1']/100; } if($percentages && !empty($percentages['days_7'])) { $days7Multiplier = $percentages['days_7']/100; } ?> <div class="product-price"> <span class="from-price">from </span><span class="price"> <? if ($product->x_weekly_only != 1): ?> <?php echo format_currency($product->om('x_remote_sale_price')*$days1Multiplier); ?> <? else: ?> <?php echo format_currency($product->om('x_remote_sale_price')*$days7Multiplier); ?> <? endif; ?> </span> </div> <ul class="product-ticks"> <li>DIY &amp; Trade</li> <?php if($product->om('is_on_sale')): ?> <?php $sale_price_or_discount = $product->x_remote_discount !== null ? $product->x_remote_discount : $product->om('sale_price_or_discount'); if(strpos($sale_price_or_discount, '%')) { $saving = round($sale_price_or_discount) . "&#37;"; } else { $saving = format_currency(ltrim($sale_price_or_discount, '-')); } ?> <li class="price-saving">Save <?php echo $saving; ?></li> <?php endif; ?> <?php if($product->om('x_remote_booking_delay') >= 7): ?> <li>Low Availability</li> <?php else: ?> <li>Best Availability</li> <?php endif ?> </ul> <a href="<?= $product->page_url('/p') ?>/" title="<?= h($product->name) ?> Hire" class="btn"> Details & Booking </a> <?php if (!isset($carousel)): ?> <?php if($product->om('x_allow_delivery') > 0 && $product->om('x_min_delivery_charge') > 0): ?> <div class="product-delivery">National Delivery</div> <?php elseif ($product->om('x_allow_delivery') > 0 && $product->om('x_min_delivery_charge') < 1): ?> <div class="product-delivery"><strong>Free</strong> Delivery: Nationwide</div> <?php endif; ?> <?php $collectionSitesCount = $product->om('x_collection_available_from'); ?> <?php if($collectionSitesCount > 0) : ?> <div class="product-click-collect">Click &amp; Collect <strong>(<?php echo $collectionSitesCount; ?> locations)</strong></div> <?php endif; ?> <?php endif; ?> </div> </div> </div> <? $i++; endforeach ?> </div> </div> <?php if(!isset($hideCatProductSchema)): ?> <?php $this->render_partial('category_product_schema', array('products' => $products)); ?> <?php endif; ?> <? if ($pagination) $this->render_partial('pagination', array('pagination'=>$pagination, 'base_url'=>$pagination_base_url)); ?> <script> let productCardLinks = document.getElementsByClassName('jsProductCard'); for(let i = 0, len = productCardLinks.length; i < len; i++) { if (productCardLinks[i].hasAttribute("data-url")) { productCardLinks[i].onclick = function () { if (window.innerWidth < 690) { window.location.href = productCardLinks[i].getAttribute("data-url"); //console.log(productCardLinks[i].getAttribute("data-url")); } } } } </script> ', 'CMS partial', 'shop:product_list_mh', array(6) [products => object(Shop_Product), records_per_page => '30', paginate => '1', pagination_base_url => '/category/cement-mixer-hire', page_index => '0', column_size => '4']) /modules/cms/classes/cms_controller.php 1020
16 Cms_Controller->render_partial('shop:product_list_mh', array(6) [products => object(Shop_Product), records_per_page => '30', paginate => '1', pagination_base_url => '/category/cement-mixer-hire', page_index => '0', column_size => '4']) /modules/cms/classes/cms_controller.php(383) : eval()'d code 56
15 eval(()) /modules/cms/classes/cms_controller.php 383
14 Cms_Controller->evalWithException('?><div class="row"> <div class="small-12 medium-12 large-3 columns"> <div class="category-side" style="margin-bottom: 20px"> <div class="cat-side-banners"> <a href="/delivery-and-collection/"> <img src="/img/MH-free-delivery-side.webp" alt="Free Delivery & Collection - Nationwide" width="290" height="212" /> </a> </div> <? if ($has_subcategories): ?> <? $subcategories = $category->list_children('front_end_sort_order'); ?> <?php if($subcategories->count):?> <div class="sidebar"> <div class="featured-content-module--featuredContent--DhevT"> <div style="margin-top: 20px;"> <h2>Categories</h2> <ul> <? foreach ($subcategories as $subcategory):?> <li> <? if(!empty($subcategory->x_catfalse)): ?> <a href="<?= $subcategory->x_catfalse ?>"><?= $subcategory->name ?></a> <? else: ?> <a href="<?= $subcategory->page_url('/c') ?>/"><?= $subcategory->name ?></a> <? endif ?> <hr style="height: 1px; margin: 5px auto 10px 0; width: 50%;" /> </li> <?php endforeach; ?> </ul> </div> </div> </div> <?php endif; ?> <?php endif; ?> </div> </div> <?php if ($has_products): ?> <div class="small-12 medium-12 large-9 columns cat-product-columns"> <? $this->render_partial('shop:product_list_mh', array( 'products'=>$category->list_products(), 'records_per_page'=>30, 'paginate'=>true, 'pagination_base_url'=>$category->page_url('category'), 'page_index'=>$this->request_param(1, 0), 'column_size' => 4 )) ?> </div> <?php else: ?> <? $this->render_partial('category_sub_products', array('subcategories' => $subcategories)); ?> <?php endif; ?> </div>', 'CMS partial', 'category_page_with_products', array(2) [has_subcategories => '0', has_products => '8']) /modules/cms/classes/cms_controller.php 1020
13 Cms_Controller->render_partial('category_page_with_products', array(2) [has_subcategories => '0', has_products => '8']) /modules/cms/classes/cms_controller.php(383) : eval()'d code 44
12 eval(()) /modules/cms/classes/cms_controller.php 383
11 Cms_Controller->evalWithException('?><? if ($category): $subcategories = $category->list_children('front_end_sort_order'); $has_subcategories = $subcategories->count; $has_products = $category->eval_num_of_products(); ?> <meta name="description" content="<?php echo $this->page->description; ?>"> <meta name="keywords" content="<?php echo $this->page->keywords; ?>"> <link rel="canonical" href="https://<?php echo $_SERVER['HTTP_HOST']; ?><?php echo parse_url( $_SERVER['REQUEST_URI'], PHP_URL_PATH ); ?>" /> <title><?php echo $this->page->title; ?> | Mammoth Hire</title> </head> <body> <? $this->render_partial('global_header') ?> <section class="category_product" id="page_content"> <div class="row"> <div class="small-12 columns"> <? $this->render_partial('shop:category_breadcrumbs') ?> <h1 class="t1"><? if ($category->title): ?><?= $category->title ?><? else: ?><?= $category->name ?><? endif ?></h1> <p class="description"><?= h($category->short_description) ?></p> <?php if ($category->description): ?> <span class="cat-read-more"><a href="#category-footer-description" style="padding: 0" onclick="scrollToDescription();">Read More</a></span> <script>function scrollToDescription() { openTab('category-tab-1'); document.getElementById("category-footer-description").scrollIntoView();}</script> <?php endif; ?> </div> </div> <div class="hide-mobile"><?php $this->render_partial('free_delivery_cat'); ?><br/></div> <div class="row"> <div class="small-12 columns"> <? if ($has_products || $has_subcategories): ?> <? $this->render_partial('category_page_with_products', [ 'has_subcategories' => $has_subcategories, 'has_products' => $has_products, ]) ?> <?php elseif($has_subcategories): ?> <? $this->render_partial('category_page_without_products') ?> <? else: ?> <? $this->render_partial('shop:oops') ?> <? endif ?> </div> </div> <? if ($category->description): ?> <div id="category-footer-description" class="category-tabs"> <div role="tablist" aria-label="Category Information Tabs" class="category-tabs__buttons"> <button role="tab" type="button" onclick="openTab('category-tab-1')" aria-selected="false" aria-controls="category-tab-1" id="category-tab-1-button" class="btn category-tab-button" tabindex="1"> Description </button> </div> <div class="category-tabs__content"> <h2 class="category-tabs__heading" id="mobile-category-tab-1" onclick="openTab('category-tab-1')">Description</h2> <div tabindex="1" role="tabpanel" id="category-tab-1" class="category-tab active" aria-labelledby="Description tab"> <div style="background-color: #F1F1F1; padding-bottom: 20px"> <div class="featured-content-module--featuredContent--DhevT"> <div> <?= $category->description ?> <? $this->render_partial('category_qa') ?> </div> </div> </div> </div> </div> </div> <? endif; ?> <script> function openTab(tabName) { mobileTabs = (window.innerWidth < 800) ? true : false; var i; var x = document.getElementsByClassName("category-tab"); for (i = 0; i < x.length; i++) { if (!mobileTabs) { x[i].classList.remove('active'); } } var tabContent = document.getElementById(tabName); if (!mobileTabs) { tabContent.classList.add('active'); var tabButtons = document.getElementsByClassName('category-tab-button') for (i = 0; i < tabButtons.length; i++) { tabButtons[i].classList.remove('active'); } var button = document.getElementById(tabName + '-button'); button.classList.add('active'); } else { var button = document.getElementById('mobile-' + tabName); button.classList.toggle("active"); tabContent.classList.toggle("mobile-active"); } } </script> <?php endif; ?> </section>', 'CMS page', 'Cement Mixer 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 => 'cement-mixer-hire']) /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('/c/cement-mixer-hire') /phproad/system/phproad.php 31
2 include('/var/www/vhosts/mammoth-hire.co.uk/httpdocs/phproad/system/phproad.php') /boot.php 114
1 require_once('/var/www/vhosts/mammoth-hire.co.uk/httpdocs/boot.php') /index.php 3

( ! ) Fatal error: Uncaught PHP Warning: Unknown: write failed: No space left on device (28) thrown in Unknown on line 0
Call Stack
#TimeMemoryFunctionLocation
14.714121854304Phpr_SysExceptionHandler( ).../exceptions.php:0
24.714121854432Phpr_Response->openErrorPage( ).../exceptions.php:363
( ! ) Phpr_PhpException: Unknown: write failed: No space left on device (28) in Unknown on line 0
Call Stack
#TimeMemoryFunctionLocation
14.714121854304Phpr_SysExceptionHandler( ).../exceptions.php:0
24.714121854432Phpr_Response->openErrorPage( ).../exceptions.php:363
34.719121857192Phpr_SysErrorHandler( ).../exceptions.php:0