Unhandled Error!

MySQL error executing query: Got error -1 from storage engine

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
21 Db_MySQLDriver->execute('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN shop_products_categories ON shop_products.id = shop_products_categories.shop_product_id LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id WHERE (shop_products_categories.shop_category_id = '104') AND (((shop_products.enabled=1 and not ( shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0)) )) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1 and not ( grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0)) ))) and (shop_products.disable_completely is null or shop_products.disable_completely = 0) and (shop_products.grouped is null or shop_products.grouped=0)) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or ( shop_products.enable_customer_group_filter = 1 and exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1') ))) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (shop_products.id != '425') ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), rand() LIMIT 0, 4') /phproad/modules/db/classes/db_sqlbase.php 604
20 Db_SqlBase->execute('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN shop_products_categories ON shop_products.id = shop_products_categories.shop_product_id LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id WHERE (shop_products_categories.shop_category_id = '104') AND (((shop_products.enabled=1 and not ( shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0)) )) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1 and not ( grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0)) ))) and (shop_products.disable_completely is null or shop_products.disable_completely = 0) and (shop_products.grouped is null or shop_products.grouped=0)) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or ( shop_products.enable_customer_group_filter = 1 and exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1') ))) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (shop_products.id != '425') ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), rand() LIMIT 0, 4') /phproad/modules/db/classes/db_sqlbase.php 437
19 Db_SqlBase->query('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN shop_products_categories ON shop_products.id = shop_products_categories.shop_product_id LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id WHERE (shop_products_categories.shop_category_id = '104') AND (((shop_products.enabled=1 and not ( shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0)) )) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1 and not ( grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0)) ))) and (shop_products.disable_completely is null or shop_products.disable_completely = 0) and (shop_products.grouped is null or shop_products.grouped=0)) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or ( shop_products.enable_customer_group_filter = 1 and exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1') ))) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (shop_products.id != '425') ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), rand() LIMIT 0, 4') /phproad/modules/db/classes/db_sqlbase.php 499
18 Db_SqlBase->fetchAll('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where categories_relation_table.id=shop_products_categories.shop_category_id and shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where related_products_all_relation_table.id=shop_related_products.related_product_id and shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN shop_products_categories ON shop_products.id = shop_products_categories.shop_product_id LEFT JOIN pages ON shop_products.page_id=pages.id LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id WHERE (shop_products_categories.shop_category_id = '104') AND (((shop_products.enabled=1 and not ( shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0)) )) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1 and not ( grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0)) ))) and (shop_products.disable_completely is null or shop_products.disable_completely = 0) and (shop_products.grouped is null or shop_products.grouped=0)) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or ( shop_products.enable_customer_group_filter = 1 and exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1') ))) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (shop_products.id != '425') ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), rand() LIMIT 0, 4') /phproad/modules/db/classes/db_activerecord.php 512
17 Db_ActiveRecord->find_all_internal(null, array(0), null) /phproad/modules/db/classes/db_activerecord.php 532
16 Db_ActiveRecord->find_all(()) /modules/cms/classes/cms_controller.php(383) : eval()'d code 27
15 eval(()) /modules/cms/classes/cms_controller.php 383
14 Cms_Controller->evalWithException('?><?php /** * * Variables: * $auto = Activates automatic related products for a product without related products set. * $limit = Limits the list length. Default is unlimited, 0 will set unlimited. * $levels = Limits the parent category levels to get products from. Default is unlimited, 0 will set unlimited. * * To use this, just render the partial on a page or partial that creates a product page, $product is required. * Example: $this->render_partial('shop:related_products', array('auto'=>true,'limit'=>4)); * */ $related_products = $product->list_related_products()->find_all(); if (!isset($auto) || !is_bool($auto)) $auto = true; if (!isset($limit) || !is_int($limit) || $limit < 1) $limit = 4; if (!isset($levels) || !is_int($levels)) $levels = 1; if (!count($related_products) && $auto) { $categories = $product->category_list->get_parents(true); // Find all parent categories. foreach (array_reverse($categories) as $key=>$category) { $related_products = $category->list_products(array('sorting'=>array('rand()')))->where('id != ?', $product->id)->limit($limit)->find_all(); if (count($related_products)) { $display_products = $related_products; if ($key + 1 == $levels) break; // Break the loop at chosen level. } } } elseif (count($related_products)) { foreach ($related_products as $key=>$product) { if ($key < $limit) $display_products = $related_products; } } ?> <?php if (isset($display_products)): ?> <section class="related-products my-5"> <div class="row"> <div class="col-md-12 pb-3"> <h3> Some of our other favourites&hellip;</h3> </div> </div> <div class="row"> <div class="col-md-12"> <?php $this->render_partial('shop:product_list_2', array( 'products' => $display_products, 'class' => 'four-item' )); ?> </div> </div> </section> <?php endif; ?> ', 'CMS partial', 'shop:automatic_related_products', array(0)) /modules/cms/classes/cms_controller.php 1020
13 Cms_Controller->render_partial('shop:automatic_related_products') /modules/cms/classes/cms_controller.php(383) : eval()'d code 196
12 eval(()) /modules/cms/classes/cms_controller.php 383
11 Cms_Controller->evalWithException('?><nav class="breadcrumb"> <ul class="items"> <li> <a href="<?php echo root_url('/'); ?>">Home</a> </li> <li> <a href="<? echo $product->category_list[0]->page_url('/category'); ?>" title="<?php echo $product->category_list[0]->name; ?>"><?php echo $product->category_list[0]->name;?></a> </li> <li> <a href="<?php echo $product->page_url('/product'); ?>"><?php echo $product->name; ?></a> </li> </ul> </nav> <div class="page-main"> <div class="row"> <div class="col-md-12"> <section id="product" class="product"> <?php $this->render_partial('shop:product', array( 'product' => $product )); ?> </section> <section class="offer"><br/> <?php $this->render_partial('shop:offerbox'); ?> </section> <section class="product-info"> <div class="product-info-tabs" role="tablist"> <ul class="nav nav-tabs" id="productTab" role="tablist"> <?php if ($product->x_featuresbenefits): ?> <li class="nav-item"> <a class="nav-link active" id="features-tab" data-toggle="tab" href="#features" role="tab" aria-controls="features" aria-selected="true">Features &amp; Benefits</a> </li> <li class="nav-item"> <a class="nav-link" id="description-tab" data-toggle="tab" href="#description" role="tab" aria-controls="description" aria-selected="false">Description</a> </li> <?php else: ?> <li class="nav-item"> <a class="nav-link active" id="description-tab" data-toggle="tab" href="#description" role="tab" aria-controls="description" aria-selected="true">Description</a> </li> <?php endif; ?> <?php if ($product->x_specs): ?> <li class="nav-item"> <a class="nav-link" id="specification-tab" data-toggle="tab" href="#specification" role="tab" aria-controls="contact" aria-selected="false">Specification</a> </li> <?php endif; ?> <?php if ($product->x_witb): ?> <li class="nav-item"> <a class="nav-link" id="in-the-box-tab" data-toggle="tab" href="#inthebox" role="tab" aria-controls="contact" aria-selected="false">What's In The Box</a> </li> <?php endif; ?> <li class="nav-item"> <a class="nav-link" id="reviews-tab" data-toggle="tab" href="#reviews" role="tab" aria-controls="contact" aria-selected="false">Reviews</a> </li> </ul> <div class="tab-content" id="productTabContent"> <?php if ($product->x_featuresbenefits): ?> <div class="tab-pane fade show active" id="features" role="tabpanel" aria-labelledby="features"> <div class="product-features"> <?php echo $product->x_featuresbenefits; ?> <?php if (!empty($product->video)): ?> <section class="product-property d-lg-block" style="margin-top: 2em;"> <div class="product-detail__box"> <div class="row"> <div class="col-md-12" style="min-height:600px"> <iframe width="100%" height="100%" src="<?php echo $product->video; ?>?modestbranding=1&rel=0&showinfo=0showinfo=0" frameborder="0" allowfullscreen></iframe> </div> </div> </div> </section> <?php endif; ?> </div> </div> <div class="tab-pane fade" id="description" role="tabpanel" aria-labelledby="description-tab"> <div class="product-description"> <?php echo $product->description; ?> </div> </div> <?php else: ?> <div class="tab-pane fade show active" id="description" role="tabpanel" aria-labelledby="description-tab"> <div class="product-description"> <?php echo $product->description; ?> </div> </div> <?php endif; ?> <div class="tab-pane fade" id="specification" role="tabpanel" aria-labelledby="specification"> <div class="product-specification"> <?php echo $product->x_specs; ?> </div> </div> <div class="tab-pane fade" id="inthebox" role="tabpanel" aria-labelledby="in-the-box-tab"> <div class="product-witb"> <?php echo $product->x_witb; ?> </div> </div> <div class="tab-pane fade" id="reviews" role="tabpanel" aria-labelledby="reviews-tab"> <section class="reviews block" id="reviews"> <div class="row"> <div class="col-md-12"> <h5 class="display">Customer Product Reviews</h5> </div> </div> <div class="row"> <div class="col-md-12"> <?php if($product->list_reviews()->count): ?> <ul id="review-list" class="reviews-list"> <?php $i = 0; ?> <?php foreach($product->list_reviews() as $review): ?> <?php $i++; ?> <li> <div class="review-title"><?php echo $review->title; ?></div> <div class="row"> <div class="col-md-3"> <div class="d-flex"> <!--<span>Quality</span>--> <span class="product-rating stars-<?php echo $review->rating; ?> d-inline-block"> </span> </div> </div> <div class="col-md-9"> <p><?php echo nl2br(h($review->review_text)) ?></p> <div class="d-flex user-info"> <span class="user"> Review by <strong><?php echo $review->author; ?> <!--<?php echo $review->created_at->format('%x'); ?>--></strong> </span> </div> </div> </div> </li> <?php if($i == 20) { break; } ?> <?php endforeach; ?> </ul> <?php else: ?> <?php endif; ?> </div> </div> <div class="row"> <div class="col-md-12"> <a name="write-review"></a> <div class="reviews-box"> You're reviewing: <h3 class="mb-3">"<?php echo $product->name; ?>"</h3> <?php echo open_form(array('class' => 'custom')); ?> <div class="review-form"> <div class="input-group"> <label for="rating">Rating</label> <select name="rating" id="rating"> <option value="0">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div> <?php if(!$this->customer): ?> <div class="input-group"> <label for="review_author_name">Your name</label> <input id="review_author_name" name="review_author_name" type="text" /> </div> <div class="input-group"> <label for="review_author_email">Email</label> <input id="review_author_email" type="text" name="review_author_email" /> </div> <?php endif; ?> <div class="input-group"> <label for="review_title">Title</label> <input id="review_title" name="review_title" type="text" /> </div> <div class="input-group"> <label for="review_text">Review</label> <textarea rows="5" id="review_text" name="review_text" placeholder="I really love this product because&hellip;"></textarea> </div> <div class="mt-4 input-group justify-content-end"> <button type="submit" class="button" onclick="return $(this).getForm().sendRequest('shop:on_addProductReview', { extraFields: { no_flash: true, }, onSuccess: function() { document.location.reload(true); } })"> Submit review</button> </div> </div> <?php echo close_form(); ?> </div> </div> </div> </section> </div> </div> </div> </section> <?php $this->render_partial('shop:automatic_related_products'); ?> <div id="addToBasket" class="b-modal modal fade" id="addToBasket" tabindex="-1" role="dialog" aria-labelledby="addToBasket" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5>Your product has been added to the basket</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">&times;</span> </button> </div> <div class="modal-body"> <div class="row"> <div class="col-md-4"> <img src="<?php echo $product->image_url(0, 320, 240); ?>" alt="" /> </div> <div class="col-md-8"> <h5><?php echo $product->name; ?></h5> <br> <div class="product-rating stars-<?php echo $product->rating_approved; ?>"> <a href="<?php echo $product->page_url('/product'); ?>/#reviews"><?php echo !empty($product->rating_review_num) ? "{$product->rating_review_num} review(s)" : "0 review(s)"; ?></a> </div> <p><?php echo $product->short_description; ?></p> </div> </div> <div class="row"> <div class="col-md-6 order-2 order-md-1"> <br> <a href="#" data-dismiss="modal" class="btn btn-inverse" aria-label="Close">&larr; Continue shopping</a> </div> <div class="col-md-6 order-1 order-md-2"> <br> <a class="btn" href="<?php echo root_url('/cart'); ?>">View my basket</a> </div> </div> </div> </div> </div> </div> </div> </div> </div>', 'CMS page', 'Product') /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 => 'grassline-titan-30l-sports-pitch-spray-marker']) /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('/product/grassline-titan-30l-sports-pitch-spray-marker') /phproad/system/phproad.php 31
2 include('/var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/system/phproad.php') /boot.php 114
1 require_once('/var/www/vhosts/linemarkerpaint.co.uk/httpdocs/boot.php') /index.php 3

Warning: file_exists(): open_basedir restriction in effect. File(Unknown) is not within the allowed path(s): (/var/www/vhosts/linemarkerpaint.co.uk/:/tmp/) in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_errorlog.php on line 82

Warning: mcrypt_enc_get_key_size(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 43

Warning: mcrypt_enc_get_iv_size(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 54

Warning: mcrypt_create_iv(): Cannot create an IV with a size of less than 1 or greater than 2147483647 in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 54

Warning: mcrypt_generic_init(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 56

Warning: mcrypt_generic(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 57

Warning: mcrypt_generic_deinit(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 58

Warning: mcrypt_enc_get_key_size(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 43

Warning: mcrypt_enc_get_iv_size(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 54

Warning: mcrypt_create_iv(): Cannot create an IV with a size of less than 1 or greater than 2147483647 in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 54

Warning: mcrypt_generic_init(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 56

Warning: mcrypt_generic(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 57

Warning: mcrypt_generic_deinit(): 129 is not a valid MCrypt resource in /var/www/vhosts/linemarkerpaint.co.uk/httpdocs/phproad/modules/phpr/classes/phpr_securityframework.php on line 58

Fatal error: Uncaught PHP Warning: Unknown: write failed: No space left on device (28) thrown in Unknown on line 0