Previous Thread
Next Thread
Print Thread
Hop To
#257379 10/15/2015 10:12 AM
Joined: Jun 2008
Posts: 48
Likes: 1
A
Newbie
Newbie
A Offline
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

Quote
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
UBB.threads Developer
UBB.threads Developer
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:
Quote
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.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)