Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (isaac), 59 guests, and 313 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Mark S
Mark S
Liverpool : England : UK
Posts: 4,704
Joined: July 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
FREAK 11
M4TT 10
Ruben 5
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
You have an error in your SQL syntax; #253563
09/01/13 05:43 AM
09/01/13 05:43 AM
Joined: Jun 2006
Posts: 518
Sweden
Morgan Offline OP
addict
Morgan  Offline OP
addict
Joined: Jun 2006
Posts: 518
Sweden
Hi,

It seems at the moment I have managed to get rid of most forum errors, however there is one that I don't know how important it is but I wish to get rid of it too.
Can you explain and maybe advice how to fix it. Is it the forum or the MYSQL that needs adjustments?
/Thanks

Search word seems to be "Air" in this case

Quote:
Script: /xxxxxx/xxxxx/xxxxx/forums/scripts/dosearch.inc.php - Line: 577
SELECT p.POST_ID
FROM ubbt_bbfPOSTS p LEFT JOIN ubbt_bbfPOSTS pp on p.POST_ID=pp.POST_ID,
ubbt_bbfTOPICS t
WHERE p.POST_IS_APPROVED = '1'
AND t.TOPIC_STATUS <> 'M'
AND t.FORUM_ID IN ('1','2','4','31')
AND p.TOPIC_ID = t.TOPIC_ID
AND ( p.POST_DEFAULT_BODY LIKE '%Air%'))

AND p.POST_POSTED_TIME > '1375285983'
AND p.POST_POSTED_TIME < '1375285983'

ORDER BY p.POST_POSTED_TIME DESC
LIMIT 200 - 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 ')

AND p.POST_POSTED_TIME > '1375285983'
AND p.POST_POSTED_TIME < '1375285' at line 8


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: You have an error in your SQL syntax; [Re: Morgan] #253565
09/01/13 02:41 PM
09/01/13 02:41 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,824
Lutz,FL
As I recall there is or was some type of bug if you use advanced search and opt for "in body"
"in subject and body "
"in subject"
work fine

Take a look at my old post:
https://www.ubbcentral.com/forums/ub...UBB_7_5_6_Bug_Advanced_Search#Post245422


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: You have an error in your SQL syntax; [Re: Morgan] #253566
09/02/13 08:31 AM
09/02/13 08:31 AM
Joined: Jun 2006
Posts: 518
Sweden
Morgan Offline OP
addict
Morgan  Offline OP
addict
Joined: Jun 2006
Posts: 518
Sweden
Ok I forgot about that post.. well then I need not to worry about that one, thanks Ruben!


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,533
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)