Unhandled Error!

MySQL error executing query: Can't create/write to file '/var/db/mysql_tmpdir/MLc1iiGa' (Errcode: 2 - No such file or directory)

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
18 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 = '2') 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) ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), in_stock desc') /phproad/modules/db/classes/db_sqlbase.php 604
17 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 = '2') 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) ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), in_stock desc') /phproad/modules/db/classes/db_sqlbase.php 437
16 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 = '2') 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) ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), in_stock desc') /phproad/modules/db/classes/db_sqlbase.php 499
15 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 = '2') 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) ORDER BY ifnull(shop_products_categories.product_category_sort_order+100000000, '_'), in_stock desc') /phproad/modules/db/classes/db_activerecord.php 512
14 Db_ActiveRecord->find_all_internal(null, array(0), null) /phproad/modules/db/classes/db_activerecord.php 532
13 Db_ActiveRecord->find_all(()) /modules/cms/classes/cms_controller.php(383) : eval()'d code 8
12 eval(()) /modules/cms/classes/cms_controller.php 383
11 Cms_Controller->evalWithException('?><? if (!$category): ?> <h2>We are sorry, the specified category not found.</h2> <? else: ?> <p><?= $category->short_description ?></p> <?= $category->description ?> <? $this->render_partial( 'shop:product_list', array('products' => $category->list_products( array( 'sorting'=>array('in_stock desc')))->find_all()), array( 'cache'=>true,// Enable caching 'cache_vary_by'=>array('url'), // We are going to reuse this partial on different pages, but its content can be different for different pages so we want to create different partial cache versions for different pages 'cache_versions'=>array('catalog'), // The partial should be recached then the catalog updates 'cache_ttl'=>1800 // Recache each 30 minutes ) ) ?> <? endif ?> ', 'CMS page', 'Knight's Armament') /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 => 'knights-armament']) /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/knights-armament') /phproad/system/phproad.php 31
2 include('/usr/local/www/www.boltcarrier.com/data/phproad/system/phproad.php') /boot.php 114
1 require_once('/usr/local/www/www.boltcarrier.com/data/boot.php') /index.php 3