DEar all,
I am updating my eventlist to Jem and I get this error below:
Joomla!
500 - An error has occurred.
Unknown column 'a.note' in 'field list' SQL=SELECT a.id, a.catname, a.color, a.alias, a.note, a.published, a.access, a.checked_out, a.groupid, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,gr.name AS catgroup FROM pyzw3_jem_categories AS a LEFT JOIN `pyzw3_languages` AS l ON l.lang_code = a.language LEFT JOIN pyzw3_users AS uc ON uc.id=a.checked_out LEFT JOIN pyzw3_viewlevels AS ag ON ag.id = a.access LEFT JOIN pyzw3_users AS ua ON ua.id = a.created_user_id LEFT JOIN pyzw3_jem_groups AS gr ON gr.id = a.groupid WHERE (a.published IN (0, 1)) AND (a.alias NOT LIKE "root") ORDER BY a.lft asc Unknown column 'a.note' in 'field list' SQL=SELECT a.id, a.catname, a.color, a.alias, a.note, a.published, a.access, a.checked_out, a.groupid, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,gr.name AS catgroup FROM pyzw3_jem_categories AS a LEFT JOIN `pyzw3_languages` AS l ON l.lang_code = a.language LEFT JOIN pyzw3_users AS uc ON uc.id=a.checked_out LEFT JOIN pyzw3_viewlevels AS ag ON ag.id = a.access LEFT JOIN pyzw3_users AS ua ON ua.id = a.created_user_id LEFT JOIN pyzw3_jem_groups AS gr ON gr.id = a.groupid WHERE (a.published IN (0, 1)) AND (a.alias NOT LIKE "root") ORDER BY a.lft asc LIMIT 0, 20 Unknown column 'a.note' in 'field list' SQL=SELECT a.id, a.catname, a.color, a.alias, a.note, a.published, a.access, a.checked_out, a.groupid, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,gr.name AS catgroup FROM pyzw3_jem_categories AS a LEFT JOIN `pyzw3_languages` AS l ON l.lang_code = a.language LEFT JOIN pyzw3_users AS uc ON uc.id=a.checked_out LEFT JOIN pyzw3_viewlevels AS ag ON ag.id = a.access LEFT JOIN pyzw3_users AS ua ON ua.id = a.created_user_id LEFT JOIN pyzw3_jem_groups AS gr ON gr.id = a.groupid WHERE (a.published IN (0, 1)) AND (a.alias NOT LIKE "root") ORDER BY a.lft asc
Also on VEnue:
500 - An error has occurred.
Unknown column 'a.publish_up' in 'field list' SQL=SELECT a.id, a.venue, a.alias, a.url, a.street, a.postalCode, a.city, a.state, a.country,a.latitude, a.longitude, a.locdescription, a.meta_keywords, a.meta_description,a.locimage, a.map, a.created_by, a.author_ip, a.created, a.modified,a.modified_by, a.version, a.published, a.checked_out, a.checked_out_time,a.ordering, a.publish_up, a.publish_down,uc.name AS editor,um.name AS modified_by,u.email, u.name AS author,COUNT(e.locid) AS assignedevents FROM `pyzw3_jem_venues` AS a LEFT JOIN pyzw3_users AS uc ON uc.id = a.checked_out LEFT JOIN pyzw3_users AS um ON um.id = a.modified_by LEFT JOIN pyzw3_users AS u ON u.id = a.created_by LEFT OUTER JOIN pyzw3_jem_events AS e ON e.locid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.venue asc Unknown column 'a.publish_up' in 'field list' SQL=SELECT a.id, a.venue, a.alias, a.url, a.street, a.postalCode, a.city, a.state, a.country,a.latitude, a.longitude, a.locdescription, a.meta_keywords, a.meta_description,a.locimage, a.map, a.created_by, a.author_ip, a.created, a.modified,a.modified_by, a.version, a.published, a.checked_out, a.checked_out_time,a.ordering, a.publish_up, a.publish_down,uc.name AS editor,um.name AS modified_by,u.email, u.name AS author,COUNT(e.locid) AS assignedevents FROM `pyzw3_jem_venues` AS a LEFT JOIN pyzw3_users AS uc ON uc.id = a.checked_out LEFT JOIN pyzw3_users AS um ON um.id = a.modified_by LEFT JOIN pyzw3_users AS u ON u.id = a.created_by LEFT OUTER JOIN pyzw3_jem_events AS e ON e.locid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.venue asc LIMIT 0, 20 Unknown column 'a.publish_up' in 'field list' SQL=SELECT a.id, a.venue, a.alias, a.url, a.street, a.postalCode, a.city, a.state, a.country,a.latitude, a.longitude, a.locdescription, a.meta_keywords, a.meta_description,a.locimage, a.map, a.created_by, a.author_ip, a.created, a.modified,a.modified_by, a.version, a.published, a.checked_out, a.checked_out_time,a.ordering, a.publish_up, a.publish_down,uc.name AS editor,um.name AS modified_by,u.email, u.name AS author,COUNT(e.locid) AS assignedevents FROM `pyzw3_jem_venues` AS a LEFT JOIN pyzw3_users AS uc ON uc.id = a.checked_out LEFT JOIN pyzw3_users AS um ON um.id = a.modified_by LEFT JOIN pyzw3_users AS u ON u.id = a.created_by LEFT OUTER JOIN pyzw3_jem_events AS e ON e.locid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.venue asc
Please help
