Phoca Forum

Code: Select all

1054
Unknown column 'a.created' in 'order clause' SQL=SELECT a.id, a.title AS title, a.alias, a.date AS created, a.access, a.accessuserid, t.id as tagid, t.title as tagtitle, t.alias as tagalias, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, a.description AS text, CONCAT_WS( " / ", 'Phoca Gallery', a.title ) AS section, "2" AS browsernav FROM bsgq4_phocagallery_categories AS a LEFT JOIN bsgq4_phocagallery_tags_ref AS tr ON tr.imgid = a.id LEFT JOIN bsgq4_phocagallery_tags AS t ON t.id = tr.tagid WHERE ((a.title LIKE '%ragazza%' OR a.alias LIKE '%ragazza%' OR a.metakey LIKE '%ragazza%' OR a.metadesc LIKE '%ragazza%' OR a.description LIKE '%ragazza%' OR t.title LIKE '%ragazza%' OR t.alias LIKE '%ragazza%')) AND a.published = 1 AND a.approved = 1 AND a.access IN (1,1,5) GROUP BY a.id ORDER BY a.created ASC LIMIT 0, 200