user warning: Column 'created'
szczym - June 16, 2009 - 21:04
| Project: | Indymedia IMC Alba |
| Version: | 6.x-1.5 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
On the http://example.org/newswire we get error:
user warning: Column 'created' in order clause is ambiguous query: SELECT n.nid FROM node n LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'en' WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL OR n.language = 'pl' AND i18n.nid IS NULL) AND ( n.type = "article" AND n.promote = 0 AND n.status = 1 AND NOT EXISTS (SELECT * FROM term_node t WHERE n.nid = t.nid AND n.vid = t.vid AND t.tid = 24) )ORDER BY created DESC LIMIT 0, 20 in /home/indykant/public_html/sites/all/modules/imc_alba/imcviews/imcviews.module on line 529.