Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12086
Latest: thestuart
New This Month: 8
New This Week: 2
New Today: 2
Stats
Total Posts: 38721
Total Topics: 6821
Most Online Today: 91
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 91
Total: 91

Author Topic: getting error  (Read 3494 times)

0 Members and 1 Guest are viewing this topic.

Offline dan4ever

  • Ad Seller Pro Customer
  • Full Member
  • *****
  • Posts: 100
    • 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: 14392
    • 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
  • Full Member
  • *****
  • Posts: 100
    • 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: 14392
    • 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
3910 Views
Last post August 23, 2007, 07:20:24 pm
by rumboogy
4 Replies
5780 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
2 Replies
5465 Views
Last post May 09, 2008, 02:33:12 pm
by RoFus
4 Replies
3353 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
5 Replies
3789 Views
Last post March 02, 2015, 11:36:29 am
by DenDen60

+- Recent Topics

SMF Store - Installed, but where is everything? by SMFHacks
April 22, 2018, 08:11:39 pm

Time offset by SMFHacks
April 21, 2018, 12:04:45 pm

Questions about by emilyturner
April 20, 2018, 04:34:17 am

Mass Change for Permissions by Dragon41673
April 17, 2018, 08:42:33 am

not previously loaded by loadMemberData.... by dan4ever
April 17, 2018, 01:53:00 am

Download title by SMFHacks
April 14, 2018, 06:57:02 pm

Responsive theme problems by SMFHacks
March 28, 2018, 12:40:58 pm

Image Scrolling by SMFHacks
March 26, 2018, 01:55:50 pm

error uninstalling contact page 3.2 by SMFHacks
March 26, 2018, 08:11:44 am

Search Tags by SMFHacks
March 25, 2018, 04:29:58 pm

Powered by EzPortal