Keep getting error 1064 when acssesing copouns

Hello,


I recently perchased the rfural plugin, but I seem to be getting an error every thime I accses the copupon section.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHEN "awocoupon" THEN "" END as coupon_code FROM #__aworewards_pay' at line 4

any help would be much appriciated

I do not recognize that code.  Do you have customization that might be causing this?  Any more info, what file is that error coming from?

I have all customisation disabled and still returns the same error, however according to the logs it seems to coming from the data base FROM #__aworewards_pay' at line 4

AwoRewards does not have the table #__aworewards_pay

It does however have these tables:
 - #__aworewards_payment
 - #__aworewards_payment_coupon
 - #__aworewards_payment_coupon_asset
 - #__aworewards_payment_detail

This is why I believe you are dealing with custom code.

Ok i'm not sure what to do from here.

Is there any more debug information, showing what file the error is coming from?

If you like, I can have a quick look if you can send a private message with temp admin access and directions of how to produce the error.

Ok, I can provide you login detials, how can I inform you of these?

Please send me a private message (click the envelope next to my name)

---

Thanks for the access.  Found the issue, An estore was not yet selected within AwoRewards, so I went to AwoRewards > Configuration and set the estore.  It now displays properly.

Thanks for your help,

Much appriciated