Discount Coupon - 1064 - You have an error in your SQL syntax

[OpusVista]

I am getting the following error when i try to use Discount Coupon

 

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 '-10, 10' at line 1

 

select * from discount_coupons cd order by cd.coupons_date_end, coupons_date_start limit -10, 10

[Jan Zonjee]

I am getting the following error when i try to use Discount Coupon

Nothing to blame Discount Coupons for. It is your own fault because you work with a version of osC that is not updated.

[Ausgirl]

I got this from another thread here.

 

Try this:

 

In the file admin/includes/classes/split_page_results.php

 

Insert:

 

if ($offset < 0)

{

$offset = 0 ;

}

 

Just before this line:

 

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

}

 

 

 

If you see the errors displayed on your store pages (not in the admin), you might also need to make this change in /includes/classes/split_page_results.php

 

Insert:

 

if ($offset < 0)

{

$offset = 0 ;

}

 

Just before this line:

 

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