WARNING(512): "SQL Error" in /home/semtek_de/www/inc/xtc_db_error.inc.php:33 (
Details)
Backtrace:
#0 trigger_error called at [/home/semtek_de/www/inc/xtc_db_error.inc.php:33]
#1 xtc_db_error called at [/home/semtek_de/www/inc/xtc_db_query.inc.php:68]
#2 xtc_db_query called at [/home/semtek_de/www/includes/application_top.php:247]
#3 xtDBquery called at [/home/semtek_de/www/system/views/product_info/ProductNavigatorContentView.inc.php:82]
#4 (#ProductNavigatorContentView) get_html called at [/home/semtek_de/www/system/views/product_info/ProductInfoContentView.inc55.php:101]
#5 (#ProductInfoContentView) get_html called at [/home/semtek_de/www/product_info.php:54]
Context: Array
(
[query] => SELECT
pc.products_id,
pd.products_name
FROM products_to_categories pc,
products p,
products_description pd
WHERE categories_id='771'
and p.products_id=pc.products_id
and p.products_id = pd.products_id
and pd.language_id = '2'
and p.products_status=1
ORDER BY p.best_price ASC
[errno] => 1054
[error] => Unknown column 'p.best_price' in 'order clause'
[t_error_string] => ================================================================================
================================================================================
Query: SELECT
pc.products_id,
pd.products_name
FROM products_to_categories pc,
products p,
products_description pd
WHERE categories_id='771'
and p.products_id=pc.products_id
and p.products_id = pd.products_id
and pd.language_id = '2'
and p.products_status=1
ORDER BY p.best_price ASC
Error: Unknown column 'p.best_price' in 'order clause' (error 1054)
[coo_error_log] => FileLog Object
(
[v_log_active] => 1
[v_file_base] => errors
[v_file_suffix] => 3cc7a02ca422a43bcc968242ea5a00de
[v_max_filesize] => 1048576
)
)
Session: Array
(
[tracking] => Array
(
[http_referer] => Array
(
[path] =>
)
[ip] => 54.242.188.217
[date] => 2013-05-22 23:17:34
[browser] => CCBot/2.0
[pageview_history] => Array
(
)
)
[tracked] => 1
[language] => german
[languages_id] => 2
[language_charset] => iso-8859-15
[language_code] => de
[currency] => EUR
[customers_status] => Array
(
[customers_status_id] => 1
[customers_status_name] => Gast
[customers_status_image] => guest_status.gif
[customers_status_discount] => 0.00
[customers_status_public] => 0
[customers_status_min_order] => 49.99
[customers_status_max_order] => 0
[customers_status_ot_discount_flag] => 0
[customers_status_ot_discount] => 0.00
[customers_status_graduated_prices] => 1
[customers_status_show_price] => 1
[customers_status_show_price_tax] => 1
[customers_status_add_tax_ot] => 1
[customers_status_payment_unallowed] =>
[customers_status_shipping_unallowed] =>
[customers_status_discount_attributes] => 0
[customers_fsk18] => 0
[customers_fsk18_display] => 1
[customers_status_write_reviews] => 0
[customers_status_read_reviews] => 1
)
[cart] => shoppingCart Object
(
[contents] => Array
(
)
[total] => 0
[weight] => 0
[content_type] =>
)
[wishList] => wishList Object
(
[contents] => Array
(
)
[total] => 0
[weight] => 0
[content_type] =>
)
[lightbox] => GMLightboxControl Object
(
[previous] => false
[actual] => false
)
[coo_filter_manager] => FilterManager Object
(
[v_categories_id] =>
[v_feature_value_id_array] => Array
(
)
[v_feature_value_group_array] => Array
(
)
[v_price_range_start] =>
[v_price_range_end] =>
[v_filter_active] =>
)
[account_type] => 0
[actual_content] => Array
(
[] => Array
(
[qty] => 0
)
)
[magnaIsInstalled] => 1
)