MySQL error executing query: Not unique table/alias: 'pages'
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 |
|---|---|---|---|
| 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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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.*, (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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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 FROM shop_products 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 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.id<>shop_products.id)') | /phproad/modules/db/classes/db_sqlbase.php | 603 |
| 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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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.*, (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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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 FROM shop_products 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 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.id<>shop_products.id)') | /phproad/modules/db/classes/db_sqlbase.php | 436 |
| 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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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.*, (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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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 FROM shop_products 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 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.id<>shop_products.id)') | /phproad/modules/db/classes/db_sqlbase.php | 498 |
| 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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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.*, (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 group_concat(nhqanda_questions.question ORDER BY 1 SEPARATOR ', ') from nhqanda_questions where nhqanda_questions.product_id = shop_products.id and (moderation_status='approved')) as questions_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='spec_sheets')) as spec_sheets_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 FROM shop_products 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 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.id<>shop_products.id)') | /phproad/modules/db/classes/db_activerecord.php | 539 |
| 17 | Db_ActiveRecord->find_all_internal(null, array(0), null) | /phproad/modules/db/classes/db_activerecord.php | 559 |
| 16 | Db_ActiveRecord->find_all(()) | /modules/cms/classes/cms_controller.php(383) : eval()'d code | 11 |
| 15 | eval(()) | /modules/cms/classes/cms_controller.php | 383 |
| 14 | Cms_Controller->evalWithException('?><!-- <?php if( isset($paginate) && $paginate ) { $page_index = isset($page_index) ? $page_index-1 : 0; $records_per_page = isset($records_per_page) ? $records_per_page : 48; $pagination = $products->paginate($page_index, $records_per_page); } else { $pagination = null; } $products = $products instanceof Db_ActiveRecord ? $products->find_all() : $products; ?> --> <?php $foundit = 0 ; foreach ($products as $product){ if($product->x_bookpay > 1 && $product->x_bookpay < 10){ $foundit = 1 ; } } if(empty($foundit)) return ; ?> <?php foreach ($products as $product): ?> <?php if($product->x_bookpay > 1 && $product->x_bookpay < 10): ?> <div style="margin-bottom: 2em;" class="product-list-item"> <div class="twelve columns" style="height: 100%; margin-bottom: 2em; padding:1.5em 1.5em 0; min-height: 320px;"> <?php $this->render_partial('product_card_image', array('product' => $product)); ?> <?php $this->render_partial('product_card_header', array('product' => $product)); ?> <div class="four mobile-four columns"> <div class="product-mobile"> <?php $this->render_partial('product_card_banners', array('product' => $product)); ?> <div class="catbul"><?php echo $product->x_bullets; ?></div> </div> <div class="row desc"> <div class="twelve mobile-four columns product-price-wrap"> <span class="price">Our Price From: </span><span class="price"> POA</span> </div> </div> <div class="twelve mobile-four columns ticks"> <p style="font-size: 1.1em; margin: 1em 0;"> <i class="fas fa-check" style="color: #00b67A;"></i> DIY & Trade<br class="hide-for-small"/> <?php if($product->om('is_on_sale')): ?> <i class="fas fa-check" style="color: #00b67A;"></i> <span style="color: #c8102e">Save <?php $sale_price_or_discount = $product->om('x_remote_discount') ?: $product->om('sale_price_or_discount'); if(strpos($sale_price_or_discount, '%')) { echo round($sale_price_or_discount); echo "%"; } else { echo format_currency(ltrim($sale_price_or_discount, '-')); } ?></span><br/> <?php endif; ?> <?php if(Phpr::$config->get('TEST_EXTRA_API_FIELDS', false) && $product->om('x_remote_booking_delay') >= 7): ?> <span class="hide-for-small"> <i class="fas fa-arrow-trend-down" style="color: #00b67A;"></i> Low Availability</span> <?php else: ?> <span class="hide-for-small"> <i class="fas fa-check" style="color: #00b67A;"></i> Best Availability</span> <?php endif ?> <?php if(Phpr::$config->get('TEST_EXTRA_API_FIELDS', false) && $product->om('x_has_insurance')): ?> <span class="hide-for-small"> <i class="fas fa-shield" style="color: #00b67A;"></i> Insurance Available</span> <?php endif ?> <?php if(Phpr::$config->get('TEST_EXTRA_API_FIELDS', false) && $product->om('x_deposit_amount')): ?> <span class="hide-for-small"> <i class="fas fa-money-bill-transfer" style="color: #00b67A;"></i> Deposit <?= format_currency($product->om('x_deposit_amount')) ?> (Refundable)</span> <?php endif ?> <?php if(Phpr::$config->get('TEST_EXTRA_API_FIELDS', false) && $product->om('x_requires_id')): ?> <span class="hide-for-small"> <i class="fas fa-id-card" style="color: #00b67A;"></i> Online ID Verification Required</span> <?php endif ?> </p> </div> <? $productUrl = $product->page_url('/product') . '/'; if(!$product->has_om_records()) { $productUrl .= (strpos($productUrl, '?') ? '&' : '?') . 'booking_modal_show=1'; } ?> <div class="row"> <!--<div class="twelve mobile-four columns"> <a href="<?php echo $productUrl ?>" data-gtm="Button: Book & Pay Online (C)" title="Book & Pay Online" class="button expand quotebutton" style="background-color: #00b67A; margin-bottom: 0.5em; border-radius: 0.5em; font-size: 1.1em; "><i class="fas fa-calendar-alt"></i> Book & Pay Online</a> </div>--> <div class="twelve mobile-four columns"> <a href="<?php echo $product->page_url('/product'); ?>/" data-gtm="Button: Product Detail (C)" title="More Information" class="button expand quotebutton">Product Detail</a> </div> </div> <div class="row"> <div class="twelve columns" style="text-align: center; padding-top: 1em; color: #808080;"> <p><i class="fas fa-truck"></i> FREE Delivery: Nationwide</br> <!-- <?php $collectionSitesCount = $product->om('x_collection_available_from'); if($collectionSitesCount > 0) { echo "<i class='fas fa-map-marker-alt'></i> Click & Collect: <span style='font-weight: 700;'>$collectionSitesCount</span> Locations"; } ?> --> </p> </div> </div> </div> </div> </div> <?php endif; ?> <?php endforeach; ?> ', 'CMS partial', 'shop:product_list_trade_only_21_2_row', array(4) [products => object(Shop_Product), class => 'three', records_per_page => '80', paginate => '']) | /modules/cms/classes/cms_controller.php | 1020 |
| 13 | Cms_Controller->render_partial('shop:product_list_trade_only_21_2_row', array(4) [products => object(Shop_Product), class => 'three', records_per_page => '80', paginate => '']) | /modules/cms/classes/cms_controller.php(383) : eval()'d code | 59 |
| 12 | eval(()) | /modules/cms/classes/cms_controller.php | 383 |
| 11 | Cms_Controller->evalWithException('?><!--<nav class="breadcrumb"> <div class="row"> <div class="twelve columns"> <ul> <li> <a href="<?php echo root_url('/'); ?>">Home</a> </li> <li> <a href="<?php echo root_url('/search/?query='.$query); ?>">Search rsults for "<?php echo $query; ?>"</a> </li> </ul> </div> </div> </nav>--> <section class="free-delivery-cat"> <!--<div class="row"> <div class="twelve columns">--> <div class="hide-for-small"> <div class="hide-for-medium-up"> <a href="/free-delivery/"><img src="/themes/nthsv3/resources/images/d_headers/NTH-banners-delivery-thin.jpg" alt="FREE Delivery & Collection" ></a> </div> </div> <div class="show-for-small"> <div class="show-for-medium-down"> <a href="/free-delivery/"><img src="/themes/nthsv3/resources/images/d_headers/NTH-banner-delivery-small_2.png" alt="FREE Delivery & Collection" ></a> </div> </div> </section> <section class="content" style="padding:0px;"> <section class="category sale"> <div class="row"> <div class="nine columns"> <?php if($products->count < 1): ?> <?php $this->render_partial('shop:no_result'); ?> <?php endif; ?> <div id="product_list"> <?php $this->render_partial('shop:product_list_diy_trade_21_2_row', array( 'products' => $products, 'class' => 'four', 'records_per_page' => 80, 'paginate'=> false )); ?> </div> <div id="product_list"> <?php $this->render_partial('shop:product_list_trade_only_21_2_row', array( 'products' => $products, 'class' => 'three', 'records_per_page' => 80, 'paginate'=> false )); ?> </div> <div id="product_list"> <?php $this->render_partial('shop:product_list_training_21_2_row', array( 'products' => $products, 'class' => 'three', 'records_per_page' => 80, 'paginate'=> false )); ?> </div> <div id="product_list"> <?php $this->render_partial('shop:product_list_for_sale', array( 'products' => $products, 'class' => 'three', 'records_per_page' => 80, 'paginate'=> false )); ?> </div> </div> <div class="three columns" style="position: -webkit-sticky; /* Safari */ position: sticky; top: 1rem;"> <?php $this->render_partial('call_free') ?> <div class="twelve columns random-usp"> <?php $this->render_partial('random_usp') ?> </div> <div class="twelve columns random-blog"> <?php $this->render_partial('random_blog') ?> </div> </div> </div> </section> </section>', 'CMS page', 'Search') | /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 => 'buggy']) | /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('/search/buggy') | /phproad/system/phproad.php | 31 |
| 2 | include('/var/www/vhosts/nationaltoolhireshops.co.uk/httpdocs/phproad/system/phproad.php') | /boot.php | 114 |
| 1 | require_once('/var/www/vhosts/nationaltoolhireshops.co.uk/httpdocs/boot.php') | /index.php | 3 |