Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 80 guests, and 241 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Mark J.Cairns
Mark J.Cairns
Northern Ireland, UK
Posts: 38
Joined: September 2009
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 23
Ruben 15
isaac 10
Morgan 8
Alento 4
SteveS 3
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
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
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 604
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
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,948
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
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 604
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
Repliers can change thread title
by Baldeagle. 11/12/18 08:49 PM
Tabs In Header
by AstroCat. 11/11/18 08:33 AM
Mindraven
by SteveS. 11/09/18 07:12 PM
Censor List
by Larry Miller. 11/08/18 02:53 PM
The table 'ubbt_topic_views' is full
by Metamatic. 11/01/18 07:12 PM
Forum Statistics
Forums36
Topics35,165
Posts191,596
Members12,112
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2