error in Coupons Log

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

[Bar Nuthin]

when i try to view the Coupons Log i get the following error message

Unknown column 't.txn_type' in 'where clause'
File: /home/content/t/i/l/tiltbuster/html/Sources/Load.php(1746) : eval()'d code
Line: 4567

any ideas?

[SMFHacks]

I am guessing your running SMF 1.1.x with the latest store version.

Try running this query on your database of your forum and tell me what happens

Code:

SELECT
  t.ID_MEMBER, m.realName, t.coupon, t.txn_id, t.ipndate
  FROM smf_store_transactions as t
  LEFT JOIN smf_members AS m ON (t.ID_MEMBER = m.ID_MEMBER)
  WHERE t.coupon <> '' AND (t.txn_type = 'web_accept' OR t.txn_type = 'subscr_payment')
  ORDER BY t.ID_TRANS DESC LIMIT 0,10

Help Support the SMFHacks.com mod making.