Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (driv, Morgan), 71 guests, and 418 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Outdoorking
Outdoorking
Sydney, Australia
Posts: 317
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
isaac 45
Gizmo 31
Ruben 10
Morgan 10
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
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: 558
Sweden
Morgan Online content OP
addict
Morgan  Online Content OP
addict
Joined: Jun 2006
Posts: 558
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,852
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,852
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: 558
Sweden
Morgan Online content OP
addict
Morgan  Online Content OP
addict
Joined: Jun 2006
Posts: 558
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
PHP 7.0
by Jake. 02/20/18 01:20 PM
Anyway to Reset a Members password in ControlPanel
by peter gariepy. 02/16/18 12:11 AM
My forums will not send emails
by peter gariepy. 02/16/18 12:08 AM
error when trying to email everyone
by . 02/11/18 06:02 AM
Forum Statistics
Forums36
Topics35,077
Posts190,975
Members12,058
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1.1