Business Activity Report 1.5.0 Support Thread

[jcit]

1.
i'm probably not doing something right. i got the business activity to installed, and when i click on the 'details' button, i get this on the page :

Records Displayed Below are Stored in Database Table "dg_businessTS_detail"
1146 Table 'yabycosm_zc1.dg_businessTS_detail' doesn't exist
in:
[TRUNCATE dg_businessTS_detail]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


does that mean i didn't install the module correctly?

I had this happen when I installed BAR. The problem is that "zen" (default) gets suffixed in MySQL, making the call wrong.

Here's the fix for the basic (zen) install:

In the DG_BusActDetail.php change line 115 from:

$truncate = "TRUNCATE dg_businessTS_detail";

to

$truncate = "TRUNCATE zen_dg_businessTS_detail";

and also do the same on line 189:

$insert = "INSERT INTO zen_dg_businessTS_detail (order_date, orders_id, customers_name, payment_method, subtotal, coupon, discount, tax, shipping, order_total) VALUES ('" . $dataset->fields['orderdate'] . "', " . $dataset->fields['orders_id'] . ", '" . $dataset->fields['customers_name'] . "', '". $dataset->fields['payment_method'] . "', " . $dataset->fields['subtotal'] . ", " . $dataset->fields['coupons'] . ", " . $dataset->fields['discounts'] . ", " . $dataset->fields['tax'] . ", " . $dataset->fields['shipping'] . ", " . $dataset->fields['ordertotal'] . ")";

Cheers.