bwldrd opened this issue on Oct 16, 2020 ยท 7 posts
bwldrd posted Fri, 16 October 2020 at 6:14 AM
When trying to use the coupon code from the - "Get new outfits and shoes from RPublishing with this 50% off coupon" newsletter I receive the following message.
"PDO Error: SQLSTATE[42000]: Syntax error or access violation: 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 ') and a.club = 'N' and b.coupon = 'Y' and a.ord_id = 0 and a.bundle_id = 0 and (' at line 1.
I am trying to use the coupon with the following 2 outfits. Rebel Her 02 for La Femme and Rebel Her 03 for La Femme.
Any help please?
--------------------------------------------------------------------------------
Consider me insane if you wish, but is your reality any better?
jennblake posted Fri, 16 October 2020 at 9:42 AM
Hi.
Please try using that coupon now. I had an error in it. I am so sorry for the trouble!
bwldrd posted Fri, 16 October 2020 at 11:38 AM
Good to go. Thank you very much :)
--------------------------------------------------------------------------------
Consider me insane if you wish, but is your reality any better?
jennblake posted Fri, 16 October 2020 at 12:32 PM
Happy to help! Have a wonderful weekend. 
speculoos posted Sat, 17 October 2020 at 4:00 AM
The newsletters says this:
Save 50% with this coupon!
Coupon code:
Good from Thursday, October 15th through Monday, October 19th.
Please note that these coupons are not valid toward the purchase of tutorials, gift certificates, prime, clearance, bundled items and software.
Some vendors may not participate in coupons
Coupon valid at the time of checkout only.
I am sorry but it doesn't seem to work whatever I put in my cart and I don't see any warning or explanation...I put different items from vendors who accept coupons but it doesn't apply..
Thank you for your help.
speculoos posted Sat, 17 October 2020 at 9:17 AM
Found the answer here:
https://www.renderosity.com/october-2020---rpublishing-store-coupon-cms-23370
So this coupon is only valid on RPublishing items (not obvious when reading the original coupon description above...).
jennblake posted Sat, 17 October 2020 at 10:05 AM
We sent the coupon to the RPublishing newsletter only. I'm sorry if it was confusing. This was a perk for those belonging to the RPublishing newsletter list, but once I noticed there was some confusion I asked the team to post an article here that was clear on the restrictions.