Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 41 guests, and 387 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Ruben
Ruben
Lutz,FL
Posts: 5,836
Joined: December 2003
Show All Member Profiles 
Top Posters(30 Days)
isaac 48
Gizmo 38
Geoff 32
Morgan 30
ECNet 17
Mark S 11
JAISP 10
Ruben 9
Bert 8
ehill 3
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
UBB 7.5.6 Bug- Advanced Search #245422
09/07/11 02:43 PM
09/07/11 02:43 PM
Joined: Dec 2003
Posts: 5,836
Lutz,FL
Ruben Offline OP

Ruben  Offline OP


Joined: Dec 2003
Posts: 5,836
Lutz,FL
I found this in the shout box by another user and tried this myself.
When selecting Keyword Search Terms and using in body only you get a database error.

Browser error:
Quote:
We encountered a problem. The reason reported was

Script: /home/blabla/public_html/forums/scripts/dosearch.inc.php
Line#: 577
SQL Error: 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 > '1314823080' ORDER BY p.POST_POSTED_TIME D' at line 8
SQL Error #: 1064
Query: SELECT p.POST_ID FROM ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID, ubbt_TOPICS t WHERE p.POST_IS_APPROVED = '1' AND t.TOPIC_STATUS <> 'M' AND t.FORUM_ID IN ('1','2','3','4','5','6','7','8','9','10','11','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32') AND p.TOPIC_ID = t.TOPIC_ID AND ( p.POST_DEFAULT_BODY LIKE '%nec%')) AND p.POST_POSTED_TIME > '1314823080' ORDER BY p.POST_POSTED_TIME DESC LIMIT 250

Ubb server log error:
Quote:
Script: /home/blabla/public_html/forums/scripts/dosearch.inc.php - Line: 577
SELECT p.POST_ID
FROM ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID,
ubbt_TOPICS t
WHERE p.POST_IS_APPROVED = '1'
AND t.TOPIC_STATUS <> 'M'
AND t.FORUM_ID IN ('1','2','3','4','5','6','7','8','9','10','11','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32')
AND p.TOPIC_ID = t.TOPIC_ID
AND ( p.POST_DEFAULT_BODY LIKE '%nec%'))

AND p.POST_POSTED_TIME > '1314823080'


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


ORDER BY p.POST_POSTED_TIME D' at line 8
View Admin Logs
View:
Date IP address Operation Username Nr. Status Extra Information

For fyi,
In my case the search engine is set to:
UBB Threads Internal
Keyword search term was nec and then tried email, then seminar
Settings are:
Maximum Search Date Range: 15 years
Minimum Searchable Word Length: 2
Maximum Results from Search: 250


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
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: UBB 7.5.6 Bug- Advanced Search [Re: Ruben] #245434
09/08/11 10:54 AM
09/08/11 10:54 AM
Joined: Aug 2011
Posts: 14
Indonesia
Alzea Offline
stranger
Alzea  Offline
stranger
Joined: Aug 2011
Posts: 14
Indonesia
So... This is security bug?

Re: UBB 7.5.6 Bug- Advanced Search [Re: Ruben] #245435
09/08/11 02:00 PM
09/08/11 02:00 PM
Joined: Dec 2006
Posts: 197
UK
Stephen G Offline

member
Stephen G  Offline

member
Joined: Dec 2006
Posts: 197
UK
Works fine on my forum, although there's not many posts to search

laugh

Re: UBB 7.5.6 Bug- Advanced Search [Re: Alzea] #245446
09/09/11 04:36 PM
09/09/11 04:36 PM
Joined: Dec 2003
Posts: 5,836
Lutz,FL
Ruben Offline OP

Ruben  Offline OP


Joined: Dec 2003
Posts: 5,836
Lutz,FL
Originally Posted by Alzea
So... This is security bug?

Not a security issue just a functional issue.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: UBB 7.5.6 Bug- Advanced Search [Re: Stephen G] #245453
09/10/11 04:03 PM
09/10/11 04:03 PM
Joined: Dec 2003
Posts: 5,836
Lutz,FL
Ruben Offline OP

Ruben  Offline OP


Joined: Dec 2003
Posts: 5,836
Lutz,FL
I don't recall hacking the dosearch.inc.php file. At least in version 7.5.6 So possibly it is a issue with the version of php or mysql.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: UBB 7.5.6 Bug- Advanced Search [Re: Ruben] #245455
09/11/11 02:19 PM
09/11/11 02:19 PM
Joined: Dec 2003
Posts: 5,836
Lutz,FL
Ruben Offline OP

Ruben  Offline OP


Joined: Dec 2003
Posts: 5,836
Lutz,FL
BTW,
I get a database error here also. using the same method. With a search term of island.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: UBB 7.5.6 Bug- Advanced Search [Re: Ruben] #246964
11/20/11 10:10 AM
11/20/11 10:10 AM
Joined: Feb 2007
Posts: 219
127.0.0.1
Cuervo Offline
enthusiast
Cuervo  Offline
enthusiast
Joined: Feb 2007
Posts: 219
127.0.0.1
Originally Posted by Ruben
BTW,
I get a database error here also. using the same method. With a search term of island.


Tried here and on my board and I too get the same error on both.


-Tim
Re: UBB 7.5.6 Bug- Advanced Search [Re: Ruben] #246967
11/20/11 05:02 PM
11/20/11 05:02 PM
Joined: Nov 2011
Posts: 6
J
Jerk Offline
stranger
Jerk  Offline
stranger
J
Joined: Nov 2011
Posts: 6
Seems to be okay now!


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Subscription Pending Auto Update to Active
by Geoff. 01/18/18 09:04 AM
7.6.1.1 Custom Tag Editor (YouTube)
by Mark S. 01/15/18 02:58 PM
Enable Spider Friendly Urls Issues
by Geoff. 01/15/18 11:32 AM
Restore 'member #' like UBB.classic
by mmkk. 01/14/18 09:18 AM
Icon Select (default icon)
by TGCsanderson. 01/13/18 09:20 PM
Forum Statistics
Forums36
Topics35,047
Posts190,760
Members12,050
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1.1