Keep getting error 1064 when acssesing copouns


  • Default avatar
    Ross    
     6 years ago
    0

    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
  • Your avatar
    seyi    
     6 years ago
    0

    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?
  • Default avatar
    Ross    
     6 years ago
    0

    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
  • Your avatar
    seyi    
     6 years ago
    0

    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.


  • Default avatar
    Ross    
     6 years ago
    0

    Ok i'm not sure what to do from here.
  • Your avatar
    seyi    
     6 years ago
    0

    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.
  • Default avatar
    Ross    
     6 years ago
    0

    Ok, I can provide you login detials, how can I inform you of these?
  • Your avatar
    seyi    
     6 years ago  last edited 6 years ago
    0

    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.
  • Default avatar
    Ross    
     6 years ago
    0

    Thanks for your help,

    Much appriciated