Unanswered topics are not included in search results

Leechael / project-babel

Automatically exported from code.google.com/p/project-babel

0 stars 0 forks source link

Unanswered topics are not included in search results #4

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. 发表一篇主题
2. 在他未被回复前使用搜索功能搜索
3. 没有被回复的这篇主题不会出现在搜索结果内。

未被回复的主题应该也能被搜索的。看了下代码似乎是因为��
�询是使用的搜索条件中包括
tpc_id = 
pst_tid，导致在babel_post表里没有记录（没有回复）的topic不能�
��搜索出来。
改了下语句使用left join连接babel_post表后此问题解决。

Original issue reported on code.google.com by dou...@gmail.com on 8 Mar 2007 at 7:13

GoogleCodeExporter commented 9 years ago

确实是 SQL 方面的缺陷。

近期内修复。

Original comment by v2ex.livid on 9 Mar 2007 at 3:04

Changed state: Accepted
Added labels: Component-Logic

GoogleCodeExporter commented 9 years ago

Fixed in R61.

现在的搜索解决方案总体说来很不理想。

而这就是 PHP 的极限么？

Original comment by v2ex.livid on 16 Mar 2007 at 9:13

Changed title: 没有被回复的 topic 不能够被搜索到

GoogleCodeExporter commented 9 years ago

R61 is rolled to the production server.

Original comment by v2ex.livid on 16 Mar 2007 at 9:16

Changed state: Fixed

GoogleCodeExporter commented 9 years ago

R61 brought a compatibility problem on MySQL 4.1.

MySQL 5.0 and later is not affected.

R62 will fix it.

It's dirty.

Original comment by v2ex.livid on 16 Mar 2007 at 9:38

Changed title: Unanswered topics are not included in search results
Changed state: Started

GoogleCodeExporter commented 9 years ago

R62 is rolled to the production.

Original comment by v2ex.livid on 16 Mar 2007 at 9:42

Changed state: Fixed