Strange message in Admin at Coupons area

[ozstar]

Hi, I have the latest OSCdox.

For some reason I am now getting these messages when accessing Coupons in Admin and am not sure why.

Any ideas please?

I was actually trying to turn off the coupon facility.

Thanks

Oz


Discount Coupons
Status :
1064 - 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 '-12, 12' at line 1

select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user ,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified from coupons where coupon_active='Y' and coupon_type != 'G' limit -12, 12

------------

Gift Voucher Release Queue
1064 - 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 '-12, 12' at line 1

select c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id from customers c, coupon_gv_queue gv where (gv.customer_id = c.customers_id and gv.release_flag = 'N') limit -12, 12Hi,

[michael_s]

This is because your server is now running MySQL 4.1.x . The problem is the 4.1 fixes a bug in earlier versions that used to allow negative values. No longer. So, you need to check against this and set it to zero if negative.

Here is the solution:

http://oscdox.com/PNphpBB2-viewtopic...ght-mysql.html

[ozstar]

Thanks - It worked...of course!

BTW the catalog/includes/classes/split_page_results.php code was actually this before I changed it..

$offset = ($this->number_of_rows_per_page * ($this->current_page_number - 1));

$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;


The admin version was as stated in the fix.

Thanks

Oz