Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4253
Latest: Ineedsmfhelp
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43242
Total Topics: 7516
Most Online Today: 126
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 111
Total: 111

Author Topic: getting error  (Read 4417 times)

0 Members and 1 Guest are viewing this topic.

Offline dan4ever

  • Full Member
  • ***
  • Posts: 105
    • 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: 16428
    • 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

  • Full Member
  • ***
  • Posts: 105
    • 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: 16428
    • 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
6310 Views
Last post August 23, 2007, 07:20:24 pm
by rumboogy
4 Replies
11557 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
2 Replies
16510 Views
Last post May 09, 2008, 02:33:12 pm
by RoFus
4 Replies
6276 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
5 Replies
7487 Views
Last post March 02, 2015, 11:36:29 am
by DenDen60

+- Recent Topics

is it possible to add support for odysee.com by SMFHacks
March 13, 2024, 10:53:28 pm

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

User Gallery Feature: move / bulk move images by SMFHacks
January 30, 2024, 05:48:25 pm

In the future it may be for smf 2.1.x? by smithloo
January 30, 2024, 12:55:34 am

Powered by EzPortal