search

SemicolonAcademy / ci-cms

Automatically exported from code.google.com/p/ci-cms
Other
0 stars 0 forks source link

Error module Search #42

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi!

A Database Error Occurred
Error Number: 1052

Column 'uri' in field list is ambiguous

SELECT n.id result_order, c.title AS result_type, n.title AS result_title, 
CONCAT('http://hery.serasera.org/news/', uri) AS result_link, CONCAT
('... ', SUBSTRING(body, LOCATE('thu', body) - 50 , 200), '... ') AS 
result_text FROM ci_news n LEFT JOIN ci_news_cat c ON n.cat=c.id WHERE 
(body LIKE '%thu%') OR (n.title LIKE '%thu%') ORDER BY result_order

Can you help me?

Original issue reported on code.google.com by thanhson...@gmail.com on 31 Mar 2010 at 5:39

GoogleCodeExporter commented 9 years ago 
I said it is fixed in Rev 500

http://code.google.com/p/ci-cms/source/detail?r=500

Original comment by heriniai...@gmail.com on 1 Apr 2010 at 3:16

GoogleCodeExporter commented 9 years ago

Original comment by heriniai...@gmail.com on 1 Apr 2010 at 3:16