Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12149
Latest: MarcoLehrer
New This Month: 19
New This Week: 0
New Today: 0
Stats
Total Posts: 38969
Total Topics: 6858
Most Online Today: 49
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 35
Total: 35

Author Topic: getting error  (Read 3540 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: 14511
    • 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!

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

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: 14511
    • 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!

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

 

Related Topics

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

+- Recent Topics

Paypal has stopped interacting with my site since 06/29/18 by diegolyanky
July 19, 2018, 08:52:08 am

Pretty Urls SEO Pro Released by SMFHacks
July 15, 2018, 04:14:19 pm

Display next image with scrolling down instead on clicking next page by SMFHacks
July 15, 2018, 02:34:53 pm

Store translated into spanish by SMFHacks
July 14, 2018, 09:41:52 pm

prettyurls - TroubleShooting.wiki by SMFHacks
July 13, 2018, 04:24:23 pm

prettyurls - DatabaseChanges.wiki by SMFHacks
July 13, 2018, 04:23:01 pm

prettyurls - Filters.wiki by SMFHacks
July 13, 2018, 04:22:02 pm

SQL Query Slow (Suggestions) by SMFHacks
July 09, 2018, 01:08:59 pm

How can I hide Board Categories From Showing on Homepage Just Like SMF hacks by mattizzy
June 28, 2018, 11:22:06 am

Pretty URL Topic Number by mattizzy
June 28, 2018, 11:04:20 am

Powered by EzPortal