The sales tax report does not output any data, neither on-screen or Exported as CSV.

Store Admin > Reports > Sales Tax Report

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 ''(\'order_transmitted\')' AND ucoli.type = 'tax'' at line 1 query: SELECT ucoli.amount, ucoli.title, ucoli.data FROM uc_orders ucord LEFT JOIN uc_order_statuses ON order_status_id = order_status LEFT JOIN uc_order_line_items ucoli ON ucord.order_id = ucoli.order_id WHERE 1262325600 <= created AND created <= 1335851999 AND order_status IN '(\'order_transmitted\')' AND ucoli.type = 'tax' in /home/MYSITE/public_html/sites/all/modules/ubercart/uc_tax_report/uc_tax_report.admin.inc on line 52.
CommentFileSizeAuthor
#1 1555082.patch1.15 KBtr

Comments

tr’s picture

tr commented
Status: Active » Needs review
StatusFileSize
new 1555082.patch1.15 KB

Try this:

nelslynn’s picture

nelslynn commented

Patch works... thanks for the quick fix.

tr’s picture

tr commented
Status: Needs review » Fixed

Committed.

remco75’s picture

remco75 commented

Patch works.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

ambientdrup’s picture

ambientdrup commented

Just confirming - patch works for me as well.

-Trevor

odisey’s picture

odisey commented

I got to learn how to apply patches ..... =) Any input or where I can learn this .... Thanks all!

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented

See http://drupal.org/patch/apply or just download Ubercart 6.x-2.x-dev which includes this patch already.

odisey’s picture

odisey commented

THX longwave ..... I will do that!

SchwebDesign’s picture

SchwebDesign commented

this patched fixed the issue for us too, thanks!

SchwebDesign’s picture

SchwebDesign commented
Issue summary: View changes

Edit