search

vl4dimr / ci-cms

Other
1 stars 0 forks source link

Module Search #41

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 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://localhost/ci/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 4:19

GoogleCodeExporter commented 8 years ago 
Fixed

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

Original comment by heriniai...@gmail.com on 31 Mar 2010 at 4:27