Business Activity Report 1.5.0 Support Thread

[seancon1]

i was having a problem with "[INSERT INTO dg_businessTS_detail" and found a customer had an apostrophe in his name,
i corrected it by adding mysql_real_escape_string() to the customers name in the insert query.

changed line 189

$insert = "INSERT INTO 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'] . ")";

to

$insert = "INSERT INTO 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'] . ", '" . mysql_real_escape_string($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'] . ")";

probably should correct this elsewhere so it gets properly inserted, but that's for another post!

hope this helps someone,

Sean

[IceBox Coolers]

Hi,

When I run the SQL patch I receive the following errors
Warning: file() [function.file]: open_basedir restriction in effect. File(/tmp/php_upload/phpDnOeA3) is not within the allowed path(s): (VIRTUAL_DOCUMENT_ROOT:/usr/local/lib/php:/usr/local/lib/ph:/home/chroot_lib/phplib/:/usr/local/bin/) in /home/c-web/cf/fb/ iceboxcoolers.com.au / public / www / admin / sqlpatch.php on line 693

Warning: file(/tmp/php_upload/phpDnOeA3) [function.file]: failed to open stream: Operation not permitted in /home/c-web/cf/fb/ iceboxcoolers.com.au / public / www / admin/sqlpatch.php on line 693

Anyone have any idas on how to fix this ?
Alan