View Full Version : renew listing plan gives error ?

Pete Young
March 13, 2018, 06:16 AM
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 'LIMIT 1' at line 1
Query: SELECT * FROM `fl_listing_plans` WHERE `ID` = LIMIT 1
Function: getRow
Class: rlDatabase
File: /home/txxxxxx/public_html/plugins/monetize/rlMonetize.class.php (line# 360)

I have gone to renew a listing package and used a coupon code (which I have always done for this account) and I now get the following error and by looking at the code it looks like monitizer is to blame ?

any ideas on how to fix this ? I am using stripe as my payment gateway.


the listing did ? update in that it placed it as pending ? which it should have just renewed the listing package and listing without error or requiring a pending status.

March 14, 2018, 05:07 AM
Hello Pete,

I've checked it applying your coupon code 'pd**n' and it works fine for me

If the problem still persists create a ticket

Pete Young
March 14, 2018, 08:22 AM
Thanks Rudi, I seen your check just now, I will recreate a renewal / update and use screen-cast to capture the error and create a ticket.

Regards Pete

April 1, 2019, 04:16 PM
I can confirm there is a bug with coupon code when you try to renew a listing package from 'My Packages' page only!