Kod:
1054 Unknown column 'a.image_id' in 'group statement' SQL=SELECT a.id, a.title, a.name, a.parent_id, a.owner_id, a.alias, a.access, a.ordering, a.count, a.params, a.accessuserid, a.uploaduserid, a.deleteuserid, a.userfolder, a.latitude, a.longitude, a.image, a.section, a.image_position, a.checked_out_time, a.checked_out, a.hits, a.approved, a.zoom, a.geotitle, a.description, a.published, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg,cc.countid AS countid FROM `#__phocagallery_categories` AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__viewlevels AS ag ON ag.id = a.access LEFT JOIN #__phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN #__users AS ua ON ua.id = a.owner_id LEFT JOIN #__phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(cc.id) AS countid FROM #__phocagallery_categories AS cc GROUP BY cc.parent_id, cc.id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id, a.parent_id, a.owner_id, a.image_id, a.title, a.name, l.title, uc.name, ag.title, c.id, c.title, ua.id, ua.username, ua.name, v.average, cc.countid, a.alias, a.access, a.ordering, a.count, a.params, a.accessuserid, a.uploaduserid, a.deleteuserid, a.userfolder, a.latitude, a.longitude, a.image, a.section, a.image_position, a.checked_out, a.checked_out_time, a.hits, a.approved, a.zoom, a.geotitle, a.description, a.published, a.language ORDER BY a.title asc
Co mogę zrobić, żeby to naprawić?
Aktualizacja PhocaGallery na Joomli 2.5 -> 3.6
Cytuj
