Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 289
Total: 290

Author Topic: Database error using coupon code  (Read 4062 times)

0 Members and 1 Guest are viewing this topic.

Offline elbeer

  • Downloads Pro Customer
  • Full Member
  • *****
  • Posts: 111
    • View Profile
Database error using coupon code
« on: March 17, 2016, 04:36:30 am »
I had a transaction this morning that encountered the following error:

Code: [Select]
Database 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 'AND l.couponused = 0 AND c.code = 'easter2discount' LIMIT 1' at line 5


SELECT
l.date, c.expiredate, c.amount, c.percent, c.ID_ITEM, c.ID_COUPON
FROM (`forum_forum`.smf_store_coupons as c, `forum_forum`.smf_store_coupon_log as l)
WHERE l.ID_COUPON = c.ID_COUPON
AND l.ID_MEMBER = AND l.couponused = 0 AND c.code = 'easterdiscount' LIMIT 1

Any way to fix this please

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database error using coupon code
« Reply #1 on: March 17, 2016, 07:06:05 am »
Do you know the file and line number?
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline elbeer

  • Downloads Pro Customer
  • Full Member
  • *****
  • Posts: 111
    • View Profile
Re: Database error using coupon code
« Reply #2 on: March 17, 2016, 10:44:18 am »
Apply Filter: Only show the errors from this file
File: /home/forum/public_html/forum/storeipn2.php
Line: 278

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database error using coupon code
« Reply #3 on: March 17, 2016, 10:52:24 am »
Was it made as a guest?
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline elbeer

  • Downloads Pro Customer
  • Full Member
  • *****
  • Posts: 111
    • View Profile
Re: Database error using coupon code
« Reply #4 on: March 17, 2016, 11:19:43 am »
No it was a registered user who was logged in

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database error using coupon code
« Reply #5 on: March 17, 2016, 11:22:01 am »
odd somehow the cart had no member id for that user...
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline elbeer

  • Downloads Pro Customer
  • Full Member
  • *****
  • Posts: 111
    • View Profile
Re: Database error using coupon code
« Reply #6 on: March 17, 2016, 11:40:16 am »
I have just done a test purchase and it worked without issue.

I suspect the guys session might have timed out while he has in the store which could have created the zero user.

Thanks for your assistance.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database error using coupon code
« Reply #7 on: March 17, 2016, 01:24:24 pm »
Odd ok yeah very strange.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
11571 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
10 Replies
10485 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
2 Replies
3966 Views
Last post November 29, 2009, 12:34:51 pm
by Vincent Volmer
2 Replies
5547 Views
Last post September 17, 2010, 09:15:25 am
by Vincent Volmer
4 Replies
6289 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal