Search Hits Not Displaying
Thread Starter
Burning Brakes
Joined: Jan 2001
Posts: 1,004
Likes: 16
From: Gainesville, Florida
Search Hits Not Displaying
All I get is a SQL statement when it locates matching thread records ....
SELECT post.pagetext AS preview, thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid, user.userid AS postuserid , 1 AS RecType FROM thread AS thread LEFT JOIN user AS user ON(user.userid = thread.postuserid) LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid IN (1082276, 1115022, 1109481, 1108244, 1108243, 1112246, 1113430, 1113298, 1113002, 1112604, 1113347, 1113117, 1108247, 1107720, 1110666, 1108634)
SELECT post.pagetext AS preview, thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid, user.userid AS postuserid , 1 AS RecType FROM thread AS thread LEFT JOIN user AS user ON(user.userid = thread.postuserid) LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid IN (1082276, 1115022, 1109481, 1108244, 1108243, 1112246, 1113430, 1113298, 1113002, 1112604, 1113347, 1113117, 1108247, 1107720, 1110666, 1108634)
Le Mans Master
Joined: Nov 1999
Posts: 9,506
Likes: 6
From: Out East L.I. NY
St. Jude Donor '03, '04 & '05
Quote from Troy:
The problem is on one server only. That's why it doesn't show up all the time.
I haven't checked with the guy working on it to see if it's taken care of yet this morning or not. It was being worked on yesterday.
I haven't checked with the guy working on it to see if it's taken care of yet this morning or not. It was being worked on yesterday.
