SMFHacks.com

SMF Classifieds => Support => Topic started by: dan4ever on June 23, 2016, 03:08:26 am

Title: getting error
Post by: dan4ever 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
Title: Re: getting error
Post by: SMFHacks on June 23, 2016, 08:21:51 am
Strange try updating it with this file
Title: Re: getting error
Post by: dan4ever on June 28, 2016, 06:53:57 am
Strange try updating it with this file

Can't see any file!!

/Dan
Title: Re: getting error
Post by: SMFHacks on June 28, 2016, 10:30:33 am
Sent pm