I installed fresh and when I try to checkout, I get this error:
DB ERROR 1064
We are very sorry, but an error has occurred while processing your request. Please try the operation again by either pressing the Refresh button on your browser, or by going back one page using the Back button. If the error persists, please contact our web development team.
The details of the error are shown below. Please quote this in any correspondance regarding this problem.
Page URL:
http://localhost/viart_shop-3.4.13/order_info.php
Referrer URL:
http://localhost/viart_shop-3.4.13/basket.php?rp=product_details.php%3Fitem_id%3D125
Database error: Invalid SQL: SELECT i.item_id, i.item_code, i.manufacturer_code, i.user_id, i.item_type_id, i.item_name, i.short_description, i.full_description, i.downloadable, i.download_period, i.download_path, i.generate_serial, i.serial_period, i.activations_number, st_in.availability_time AS in_stock_availability , st_out.availability_time AS out_stock_availability, i.weight, i.shipping_cost, i.is_shipping_free, it.is_gift_voucher, i.merchant_fee_type AS item_merchant_type, i.merchant_fee_amount AS item_merchant_amount, i.affiliate_commission_type AS item_affiliate_type, i.affiliate_commission_amount AS item_affiliate_amount, it.merchant_fee_type AS type_merchant_type, it.merchant_fee_amount AS type_merchant_amount, it.affiliate_commission_type AS type_affiliate_type, it.affiliate_commission_amount AS type_affiliate_amount, ipv.property_value AS component_name, ipv.additional_price AS component_price, i.buying_price, i.price, i.is_sales, i.sales_price, i.tax_free, i.is_points_price, i.points_price, i.reward_type, i.reward_amount, i.credit_reward_type, i.credit_reward_amount, i.stock_level, i.use_stock_level, i.hide_out_of_stock, i.disable_out_of_stock, i.shipping_rule_id, sr.is_country_restriction, i.is_recurring, i.recurring_period, i.recurring_interval, i.recurring_payments_total, i.recurring_start_date, i.recurring_end_date i.tiny_image, i.tiny_image_alt, i.small_image, i.small_image_alt, i.big_image, i.big_image_alt, i.super_image FROM ((((( va_items_properties_values ipv INNER JOIN va_items i ON ipv.sub_item_id=i.item_id) LEFT JOIN va_item_types it ON i.item_type_id=it.item_type_id) LEFT JOIN va_shipping_times st_in ON i.shipping_in_stock=st_in.shipping_time_id) LEFT JOIN va_shipping_times st_out ON i.shipping_out_stock=st_out.shipping_time_id) LEFT JOIN va_shipping_rules sr ON i.shipping_rule_id=sr.shipping_rule_id) ) LEFT JOIN va_items_user_types ut ON (ut.item_id=i.item_id AND i.user_types_all=0)) WHERE ipv.item_property_id=1 AND i.sites_all = 1 AND (i.user_types_all = 1 OR ut.user_type_id=1)
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.tiny_image, i.tiny_image_alt, i.small_image, i.small_image_alt, i.big_image, i.' at line 1
.
