sales report / error message

the cart is coming together nicely. sweet !  you guys are awesome.


1)  a bug of  some sort in my sales report.

As soon as I initiate a query.

I get errors like t his....


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 'where order_status_id = '1' group by week(date_added)' at line 1
Error No: 1064
select count(*) as total from `order` where date_added between '2008-10-18' and '2008-11-19' where order_status_id = '1' group by week(date_added)

I'll try a few different queries.  but most of them give them error. ?

Search "Sales Reports"

The sales report bug was fixed in the more recent SVN versions

That worked great.

when you do a sales report and you see a row with a number of sales.

how do you drill down on that day to see the individual sales  and details.

Or would you go back to the orders on your home admin page ?