Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 64 guests, and 134 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Ruben
Ruben
Lutz,FL
Posts: 5,910
Joined: December 2003
Show All Member Profiles 
Top Posters(30 Days)
Ruben 7
Gizmo 5
isaac 4
GregK 3
Latest Photos
Previous Thread
Next Thread
Print Thread
You have an error in your SQL syntax; #253563
09/01/13 06:43 AM
09/01/13 06:43 AM
Joined: Jun 2006
Posts: 591
Sweden
Morgan Offline OP
addict
Morgan  Offline OP
addict
Joined: Jun 2006
Posts: 591
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 03:41 PM
09/01/13 03:41 PM
Joined: Dec 2003
Posts: 5,910
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,910
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 09:31 AM
09/02/13 09:31 AM
Joined: Jun 2006
Posts: 591
Sweden
Morgan Offline OP
addict
Morgan  Offline OP
addict
Joined: Jun 2006
Posts: 591
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
Facebook sharing
by GregK. 08/17/18 12:32 PM
Google Analytics code
by Conrad. 08/15/18 07:36 AM
Possible bug in counting posts
by Baldeagle. 08/11/18 02:28 PM
My Forum Stopped Working
by packlite. 07/30/18 03:35 PM
User uploaded attachment images not displaying
by Digitalgas. 07/30/18 01:59 AM
Forum Statistics
Forums36
Topics35,132
Posts191,398
Members12,098
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)