Unhandled Error!

MySQL error executing query: Table 'LS_compsol.cache_manufacturer_count' doesn't exist

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 115
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
22 Db_MySQLDriver->execute(' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=2') /phproad/modules/db/classes/db_sqlbase.php 604
21 Db_SqlBase->execute(' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=2') /phproad/modules/db/classes/db_sqlbase.php 437
20 Db_SqlBase->query(' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=2') /phproad/modules/db/classes/db_sqlbase.php 499
19 Db_SqlBase->fetchAll(' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=2', array(0)) /phproad/modules/db/classes/db_dbhelper.php 71
18 Db_DbHelper::queryArray(' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=2') /modules/cms/classes/cms_controller.php(383) : eval()'d code 27
17 eval(()) /modules/cms/classes/cms_controller.php 383
16 Cms_Controller->evalWithException('?><? $categories = isset($parent_category) ? $parent_category->list_children('front_end_sort_order') : Shop_Category::create()->list_root_children('front_end_sort_order'); $category_url_name = isset($category_url_name) ? $category_url_name : null; $pageURL = 'http://'.$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]; ?> <? $navArray = array( 'Home' => '', //'Laptops' => 'category/laptops/', //'Gaming Laptops' => 'category/gaming-laptops/', 'Tablets' => 'category/tablets/', //'Desktop PCs' => 'category/desktop-pcs/', 'Custom PCs' => 'product/custom-pc/' ); $navArray1 = array( 'Special Offers' => 'category/laptop-deals/' ); $navArrayDesktopPC = array(); $sql = ' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=2'; $queryResult = Db_DbHelper::queryArray($sql); foreach($queryResult as $v) { $navArrayDesktopPC[$v["id"]] = $v["c"]; } $navArrayLaptops = array(); $sql = ' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=3'; $queryResult = Db_DbHelper::queryArray($sql); foreach($queryResult as $v) { $navArrayLaptops[$v["id"]] = $v["c"]; } $navArrayGamingLaptops = array(); $sql = ' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=11'; $queryResult = Db_DbHelper::queryArray($sql); foreach($queryResult as $v) { $navArrayGamingLaptops[$v["id"]] = $v["c"]; } $navArrayMonitors2 = array(); $sql = ' SELECT manufacturer_id as id, concat(name," (",product_count,")") as c FROM cache_manufacturer_count WHERE category_id=6'; $sql = 'SELECT k.category_id as id, concat(name," (",product_count,")") as c FROM cache_product_count k LEFT JOIN shop_categories c ON c.id = k.category_id WHERE parent_category_id=6'; $queryResult = Db_DbHelper::queryArray($sql); foreach($queryResult as $v) { $navArrayMonitors2[$v["id"]] = $v["c"]; } $navArrayComponents = array( 'Motherboards' => 'category/components-components-motherboards/', 'Processors' => 'category/components-components-processors/', 'Memory' => 'category/components-components-memory/', 'Power Supplies' => 'category/components-components-power-supplies//', 'Hard Drives' => 'category/components-hard-drives/', 'Optical Drives' => 'category/components-components-optical-drives/', 'Graphics Card (Nvidia)' => 'category/components-components-graphics-cards-nvidia/', 'Graphics Card (AMD)' => 'category/components-components-graphics-cards-amd/', 'Cases' => 'category/components-components-cases/', 'Heatsink & Fans' => 'category/components-components-heatsinks-fans/', 'Card Readers' => 'category/components-components-card-readers/', 'Internal Cards' => 'category/components-components-internal-cards/', 'Sound Cards' => 'category/components-components-sound-cards/', 'External Storage' => 'category/components-external-storage/', 'Keyboards & Mice' => 'category/accessories-peripherals-keyboards-mice/', 'KVM Switches' => 'category/accessories-peripherals-kvm-switches/', 'Wireless Antenna' => 'category/accessories-networking-wireless-antenna/', 'Network Cards' => 'category/accessories-networking-network-cards/', 'Peripherals' => 'category/accessories-peripherals/', 'Monitors' => 'category/monitors/', 'Servers / Software' => 'category/computing/', 'Printers' => 'category/printers/', 'Inks & Toners' => 'category/inks-toners/', 'Clearance' => 'category/clearance-offers/', 'Custom Built PC' => 'product/custom-pc/', 'Pre Built PC' => 'category/csl-trading-pcs/' ); $navArrayMonitors = array( 'Motherboards' => 'category/components-components-motherboards/', 'Pre Built PC' => 'category/csl-trading-pcs/' ); $screenSizes = array("17","19","21.5","22","23","24","27"); ?> <nav id="menu" class="menu hide-mobile"> <ul> <? foreach($navArray as $key => $value){ echo '<a href="'.site_url().$value.'"><li'; if($pageURL == site_url().$value){ echo ' class="active"'; } echo '>'.$key.'</li></a>'; } ?> <!-- Desktop PCs --> <li class="has-submenu <?php if($pageURL == 'http://www.compsoluk.co.uk/category/desktop-pcs/'){ echo 'main-active';} ?>"><a href="<?php echo site_url(); ?>category/desktop-pcs/">Desktop PCs</a> <ul class="sub-menu"> <li class="navbox-title">Desktop PCs:</li> <?php foreach ($navArrayDesktopPC as $manuf=>$value) { ?> <li><a href="/search/?sorting=price&manufacturers%255B%255D=<?php echo $manuf; ?>&categories%255B%255D=2"><?php echo $value; ?></a></li> <?php } ?> </ul> </li> <!-- Laptops --> <li class="has-submenu <?php if($pageURL == 'http://www.compsoluk.co.uk/category/laptops/'){ echo 'main-active';} ?>"><a href="<?php echo site_url(); ?>category/laptops/">Laptops</a> <ul class="sub-menu"> <li class="navbox-title">Laptops:</li> <?php foreach ($navArrayLaptops as $manuf=>$value) { ?> <li><a href="/search/?sorting=price&manufacturers%255B%255D=<?php echo $manuf; ?>&categories%255B%255D=3"><?php echo $value; ?></a></li> <?php } ?> </ul> </li> <li class="has-submenu <?php if($pageURL == 'http://www.compsoluk.co.uk/category/gaming-laptops/'){ echo 'main-active';} ?>"><a href="<?php echo site_url(); ?>category/gaming-laptops/">Gaming Laptops</a> <ul class="sub-menu"> <li class="navbox-title" style="display:block;">Gaming Laptops:</li> <?php foreach ($navArrayGamingLaptops as $manuf=>$value) { ?> <li><a href="/search/?sorting=price&manufacturers%255B%255D=<?php echo $manuf; ?>&categories%255B%255D=11"><?php echo $value; ?></a></li> <?php } ?> </ul> </li> <!-- Monitors --> <li class="has-submenu <?php if($pageURL == 'http://www.compsoluk.co.uk/category/monitors/'){ echo 'main-active';} ?>"><a href="<?php echo site_url(); ?>category/monitors/">Monitors</a> <ul class="sub-menu"> <li class="navbox-title">Monitors:</li> <?php foreach ($navArrayMonitors2 as $manuf=>$value) { ?> <li><a href="/search/?sorting=price&categories%255B%255D=<?= $manuf ?>"><?php echo $value; ?></a></li> <?php } ?> <!-- <?php foreach ($screenSizes as $value) { ?> <?php $sql = ' SELECT count(id) FROM shop_products p, shop_products_categories c WHERE name LIKE \'%'.$value.'%\' AND p.id = c.shop_product_id AND c.shop_category_id = 6 AND p.enabled = 1'; $queryResult = Db_DbHelper::queryArray($sql); if(!empty($queryResult[0]['count(id)'])) {; ?> <li><a href="/search/?sorting=price&query=<?php echo $value; ?>%2522&categories%255B%255D=6&manufacturers%255B%255D=+&sorting=price&searchcat=monitors"><?php echo $value; ?>" (<?php echo $queryResult[0]['count(id)']; ?>)</a></li> <?php } } ?> --> </ul> </li> <!-- PC COMPONENTS --> <li class="has-submenu <?php if($pageURL == 'http://www.compsoluk.co.uk/category/components/'){ echo 'main-active';} ?>"><a href="<?php echo site_url(); ?>category/components/">PC Components</a> <ul class="sub-menu"> <li class="navbox-title">PC Components:</li> <?php foreach($navArrayComponents as $key => $value){ echo '<li'; if($pageURL == site_url().$value){ echo ' class="sub-active"'; } echo '><a href="'.site_url().$value.'">'.$key.'</a></li>'; ?> <?php } ?> </ul> </li> <? foreach($navArray1 as $key => $value){ echo '<a href="'.site_url().$value.'"><li'; if($pageURL == site_url().$value){ echo ' class="active"'; } echo '>'.$key.'</li></a>'; } ?> </ul> </nav> ', 'CMS partial', 'shop:header_categories_new', array(0)) /modules/cms/classes/cms_controller.php 1020
15 Cms_Controller->render_partial('shop:header_categories_new') /modules/cms/classes/cms_controller.php(383) : eval()'d code 86
14 eval(()) /modules/cms/classes/cms_controller.php 383
13 Cms_Controller->evalWithException('?><div id="fb-root"></div> <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_GB/all.js#xfbml=1&appId=230744797005869"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk')); </script> <div id="header"> <div id="header-top"> <div class="full-inner"> <a href="<?= site_url() ?>"><div class="logo-large"></div></a> <div id="header-actions"> <ul id="top-nav"> <li><a href="<?= site_url() ?>">Home</a></li> <li><a href="<?= root_url('about') ?>">About</a></li> <!--<li><a href="<?= root_url('shop') ?>">Products</a></li>--> <li><a href="<?= root_url('blog') ?>">Blog</a></li> <li><a href="http://www.amazon.co.uk/gp/aag/main?ie=UTF8&asin=&isAmazonFulfilled=&isCBA=&marketplaceID=A1F83G8C2ARO7P&orderID=&seller=A2QV0D9Q5FBCED" target="_amazon">Amazon Store</a></li> <!--<li><a href="http://www.ebay.co.uk/sch/csltrading/m.html" target="_ebay">Ebay Store</a></li>--> <li><a href="<?= root_url('terms-and-conditions') ?>">Terms &amp; Conditions</a></li> <li><a href="<?= root_url('payment-and-delivery') ?>">Payment &amp; Delivery</a></li> <li><a href="<?= root_url('contact') ?>">Contact</a></li> <? if ($this->customer): ?> <li><a href="<?= root_url('logout') ?>">Log out &nbsp; <span class="entypo-logout"></span></a></li> <? endif ?> </ul> <br class="clrboth" /> <div class="header-actions-row"> <? if ($this->customer): ?> <?//= h($this->customer->first_name) ?> <a href="<?= root_url('profile') ?>"> <div class="header-btn"> My Account <span class="entypo-user"></span> </div> </a> <? else: ?> <a href="<?= root_url('login') ?>"> <div class="header-btn"> Log in <span class="entypo-login"></span> </div> </a> <? endif ?> <a href="<?= root_url('cart') ?>"> <div class="header-btn header-btn-wide"> <i id="cart-ajax-target"><?= $this->render_partial('shop:mini_cart') ?></i> <span class="entypo-bag"></span> </div> </a> <a href="<?= root_url('checkout-start') ?>"> <div class="header-btn"> Checkout <span class="entypo-basket"></span> </div> </a> </div> <div class="header-actions-row"> <?= open_form(array('id'=>'top-search-form','class'=>'search', 'method'=>'get', 'action'=>root_url('search'))) ?> <div class="search-button" style="text-align:right !important;" onClick="if($('#top-search-input').val()!='' && /\S/.test($('#top-search-input').val())){$('#top-search-form').submit();}"> <span class="entypo-search"></span> </div> <input type="hidden" name="sorting" value="price" /> <input id="top-search-input" class="header-btn header-search" type="text" name="query" value="<?= isset($query) ? $query : null ?>" placeholder="Search store&hellip;" on /> <?= close_form() ?> <script type="text/javascript"> $("#top-search-input").keypress(function(event) { if (event.which == 13) { event.preventDefault(); $("#top-search-form").submit(); }else{ console.log($('#top-search-input').val()); } }); </script> </div> </div> <br class="clrboth" /> </div> </div> <div id="navigation" class="nav-menu-hidden"> <div class="full-inner"> <? $this->render_partial('shop:header_categories_new') ?> <ul class="hide-desktop"> <li id="menu-toggle">Menu</li> <? $this->render_partial('shop:header_categories') ?> </ul> <a href="<?= root_url('orders') ?>"><div class="nav-btn call-to-action">Track My Order</div></a> <br class="clrboth" /> </div> </div> </div> <div id="body-content-bg"> <div id="body-wrap"> <? $this->render_partial('shop:laptop_chooser') ?> <? /* <header> <div class="row topline"> <div class="six columns login"> <? if ($this->customer): ?> Welcome, <?= h($this->customer->first_name) ?>! <a href="<?= root_url('logout') ?>">Logout</a> <? else: ?> <a href="<?= root_url('login') ?>">Login or Register</a> <? endif ?> </div> <div class="six columns"> <div class="row"> <div class="seven columns"> <?= open_form(array('class'=>'search', 'method'=>'get', 'action'=>root_url('search'))) ?> <input type="text" name="query" value="<?= isset($query) ? $query : null ?>" placeholder="Search store&hellip;"/> <?= close_form() ?> </div> <div class="five columns" id="mini-cart"><?= $this->render_partial('shop:mini_cart') ?></div> </div> </div> </div> <div class="row"> <h1 class="four columns"><?= Shop_CompanyInformation::get()->name ? Shop_CompanyInformation::get()->name : 'Zest' ?></h1> <div class="eight columns"> <ul class="nav-bar"> <? $active_page = isset($active_page) ? $active_page : 'home' ?> <li class="<?= $active_page == 'home' ? 'active' : null ?>"><a href="<?= root_url('/') ?>">Home</a></li> <li class="has-flyout <?= $active_page == 'shop' ? 'active' : null ?>"> <a href="<?= root_url('shop') ?>">Shop</a> <a class="flyout-toggle" href="<?= site_url('shop') ?>"><span> </span></a> <ul class="flyout" style="display: none;"> <? foreach (Shop_Category::create()->list_root_children() as $category): ?> <li><a href="<?= $category->page_url('/category') ?>"><?= h($category->name) ?></a></li> <? endforeach ?> </ul> </li> <? if ($this->customer): ?> <li class="<?= $active_page == 'orders' ? 'active' : null ?>"><a href="<?= root_url('orders') ?>">My Orders</a></li> <li class="<?= $active_page == 'profile' ? 'active' : null ?>"><a href="<?= root_url('profile') ?>">My Profile</a></li> <? endif ?> <li class="<?= $active_page == 'about' ? 'active' : null ?>"><a href="<?= root_url('about') ?>">About</a></li> <li class="<?= $active_page == 'contact' ? 'active' : null ?>"><a href="<?= root_url('contact') ?>">Contact</a></li> <li class="<?= $active_page == 'blog' ? 'active' : null ?>"><a href="<?= root_url('blog') ?>">Blog</a></li> </ul> </div> </div> <? if (isset($title_area) && $title_area): ?> <div class="row secondhead"> <div class="twelve columns omega"> <? $this->render_block('title', '<h2 class="left">'.h($this->page->title).'</h2>') ?> <div class="right"> <? $this->render_block('breadcrumbs') ?> </div> <div class="clear"></div> </div> </div> <? endif ?> </header> */ ?> ', 'CMS partial', 'layout:header', array(1) [title_area => '1']) /modules/cms/classes/cms_controller.php 1020
12 Cms_Controller->render_partial('layout:header', array(1) [title_area => '1']) /modules/cms/classes/cms_controller.php(383) : eval()'d code 19
11 eval(()) /modules/cms/classes/cms_controller.php 383
10 Cms_Controller->evalWithException('?><!DOCTYPE html> <!-- paulirish.com/2008/conditional-stylesheets-vs-css-hacks-answer-neither/ --> <!--[if IE 8]> <html class="no-js lt-ie9" lang="en"> <![endif]--> <!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]--> <head> <? $this->render_partial('layout:head') ?> <script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-1847904-16', 'compsoluk.co.uk'); ga('send', 'pageview'); </script> </head> <body class="<?= isset($body_class) ? $body_class : null ?>"> <? $this->render_partial('layout:header', array('title_area'=>true)) ?> <? $this->render_page() ?> <? $this->render_partial('layout:footer') ?> </body> </html>', 'CMS template', 'inner') /modules/cms/classes/cms_controller.php 211
9 Cms_Controller->open(object(Cms_Page), array(1) [0 => 'accessories-networking-network-cards']) /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('/category/accessories-networking-network-cards') /phproad/system/phproad.php 31
2 include('/var/www/vhosts/compsoluk/www.compsoluk.co.uk/httpdocs/phproad/system/phproad.php') /boot.php 114
1 require_once('/var/www/vhosts/compsoluk/www.compsoluk.co.uk/httpdocs/boot.php') /index.php 3