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")
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 |
---|---|---|---|
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 & 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) . "%"; } 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 & 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 |