 |
 |
 |
 |
Registered: 06/07/07
Posts: 4
|
|
|
 |
 |
 |
 |
|
|
|
|
|
#245422 - 09/07/11 03:43 PM
UBB 7.5.6 Bug- Advanced Search
|
 
|
Registered: 12/20/03
Posts: 4424
Loc: 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: 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: 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
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
|
|
|
|
|
|
|
|
|
|
|
|
#246967 - 11/20/11 05:02 PM
Re: UBB 7.5.6 Bug- Advanced Search
[Re: Ruben]
|
stranger
|
Registered: 11/20/11
Posts: 6
|
|
|
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
Previous Topic
Index
