Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12048
Latest: computerworks
New This Month: 7
New This Week: 0
New Today: 0
Stats
Total Posts: 38469
Total Topics: 6781
Most Online Today: 44
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 41
Total: 41

Author Topic: getting error  (Read 3391 times)

0 Members and 1 Guest are viewing this topic.

Offline dan4ever

  • Ad Seller Pro Customer
  • Jr. Member
  • *****
  • Posts: 94
    • View Profile
getting error
« on: June 23, 2016, 03:08:26 am »
Hi

I'm starting to get this error:

Code: [Select]
http://www.guldforum.se/forum/index.php?action=dlattach;attach=1924;type=avatar
Databasfel: 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 ' l.membergroups))

AND FIND_IN_SET(1, a.adlocations) AND l.removed = 0 AND' at line 11


SELECT
a.ID_AD, a.ID_MEMBER, a.adtype, a.customadcode, a.isphp, a.maximpressionsperday, a.countviews, a.align,
a.ad_title, a.ad_body, a.ad_link, a.ad_link_color, a.ad_body_color, a.ad_title_color, a.ad_bg_color, a.ad_bg_border_color,
a.ad_url, a.banner_filename, a.banner_url, l.showbuyadspacelink, l.membergroups, l.boards, l.removed, a.banner_imageurl
FROM smf_seller_ad AS a, smf_seller_ad_location AS l
WHERE l.ID_LOCATION = 1 AND a.approved = 1 AND a.removed = 0 AND (a.startdate = 0 OR a.startdate <= 1464680536)
AND (a.enddate = 0 OR a.enddate >= 1464680536) AND (a.impressionslimit = 0 OR (a.total_views < a.impressionslimit))
AND (a.maximpressionsperday = 0 OR (a.todayimpressions < a.maximpressionsperday))
AND (a.clickslimit = 0 OR (a.total_clicks < a.clickslimit)) and (a.geoip = 0 OR (a.geoip = 1 and FIND_IN_SET('SE', a.geocountries)))

AND (FIND_IN_SET(, l.membergroups))

AND FIND_IN_SET(1, a.adlocations) AND l.removed = 0 AND l.disabled = 0 AND a.isRevShare = 0
ORDER BY RAND() LIMIT 1
Fil: /storage/content/******/guldforum.se/public_html/forum/Sources/adseller2.php
Rad: 2574

/Dan

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14279
    • View Profile
Re: getting error
« Reply #1 on: June 23, 2016, 08:21:51 am »
Strange try updating it with this file
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others! Also contests/promotions for verified sites.

Offline dan4ever

  • Ad Seller Pro Customer
  • Jr. Member
  • *****
  • Posts: 94
    • View Profile
Re: getting error
« Reply #2 on: June 28, 2016, 06:53:57 am »
Strange try updating it with this file

Can't see any file!!

/Dan

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14279
    • View Profile
Re: getting error
« Reply #3 on: June 28, 2016, 10:30:33 am »
Sent pm
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others! Also contests/promotions for verified sites.

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
3859 Views
Last post August 23, 2007, 07:20:24 pm
by rumboogy
4 Replies
5715 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
2 Replies
5368 Views
Last post May 09, 2008, 02:33:12 pm
by RoFus
4 Replies
3291 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
5 Replies
3503 Views
Last post March 02, 2015, 11:36:29 am
by DenDen60

+- Recent Topics

Full size image resize for posts by SMFHacks
January 22, 2018, 08:03:37 pm

403 forbidden error by SMFHacks
January 20, 2018, 12:02:53 pm

Can't find version number for Gallery Pro by SMFHacks
January 17, 2018, 08:09:53 am

Problem with uninstall by SMFHacks
January 17, 2018, 08:08:47 am

Cannot select category by Dragon41673
January 15, 2018, 06:57:03 pm

Ayuda con SA_Facebook_Integration3.1.1 by plmmlp
January 09, 2018, 05:19:51 am

URLs by SMFHacks
January 03, 2018, 02:40:26 pm

SMF4Mobile 2.0 released for SMF 2.0.x by SMFHacks
January 02, 2018, 08:25:59 am

SMF Store 3.0 Released by SMFHacks
January 01, 2018, 08:26:57 am

Russian Rouble (RUB) by SMFHacks
December 23, 2017, 08:06:16 pm

Powered by EzPortal