|
Joined: Jun 2008
Posts: 48 Likes: 1
Newbie
|
Newbie
Joined: Jun 2008
Posts: 48 Likes: 1 |
Ver 7.5.9 Search in Subject and Body works Search in Subject works Search in Body produces SQL Error Script: /home/username/public_html/forums/scripts/dosearch.inc.php
Line#: 557 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 > '1413393046' AND p.POST_POSTED_TIME < '1444842' 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','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','39','37','38','40','41','42','43','44','45','46','47','49','50','51','52','53','54','55','56','57','58','59','60') AND p.TOPIC_ID = t.TOPIC_ID AND ( p.POST_DEFAULT_BODY LIKE '%ADS%')) AND p.POST_POSTED_TIME > '1413393046' AND p.POST_POSTED_TIME < '1444842646' ORDER BY p.POST_POSTED_TIME DESC LIMIT 200 No other search parms changed. Searched here and did not find a prior report. Abbott
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
The search itself has been rewritten for 7.6.0, which is the upcoming release; this particular item was fixed in this progress report. A release date is still not known at this time as there are still several items that need to be tackled before a full release is pushed out, and we only have one active tester other than id242 and myself, at this time. As for your particular issue, the supplied post date seems off: 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 > '1413393046' AND p.POST_POSTED_TIME < '1444842' at line 8 I'm not sure why, but "1444842" isn't a valid unix epoch date.
Last edited by Gizmo; 10/15/2015 10:23 AM.
|
|
|
1 members (Ruben),
476
guests, and
111
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|