News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

2.9.9.a error in revenue reports

Started by derekk, September 17, 2014, 20:12:06 PM

Previous topic - Next topic

derekk

I get this error we upgrade to 2.9.9.a from 2.0.8c
Using Joomla 2.5.7

vmError: exeSortSearchListQuery Unknown column 'product_discountedPriceWithoutTax' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DATE( o.created_on ) AS intervals, CAST( o.`created_on` AS DATE ) AS created_on, SUM(product_discountedPriceWithoutTax * product_quantity) as order_subtotal_netto, SUM(product_subtotal_with_tax) as order_subtotal_brutto, COUNT(DISTINCT o.virtuemart_order_id) as count_order_id, SUM(product_quantity) as product_quantity FROM `on9uo_virtuemart_order_items` as i LEFT JOIN `on9uo_virtuemart_orders` as o ON o.virtuemart_order_id=i.virtuemart_order_id WHERE (`i`.`order_status` = "C" OR `i`.`order_status` = "S") AND DATE( o.created_on ) BETWEEN "2014-01-01 00:00:00" AND "2014-12-31 00:00:00" GROUP BY intervals ORDER BY created_on DESC LIMIT 0, 30

jenkinhill

We are now at 2.9.9b - and 2.9.9c will soon be released. 2.9.9b files are on http://dev.virtuemart.net/projects/virtuemart/files

Please test using the latest versions of Joomla - 2.5.24 or 3.3.3
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum