I am running JSN Corsa as my theme and by my mistake uninstalled easy profile, I have now re-insatlled the free version by setting up a new account and downloading it...
I have some functionality back - can get to registration page etc... but when I go to log in on the webpage front end I get 1054 Error... and no access to the website..
In the backend I have no access to any of the component options I get the same error I recived when I re-installed it
500 Unknown column 'a.accessview' in 'on clause' SQL=SELECT COUNT(*) FROM esw_jsn_fields AS a LEFT JOIN `esw_languages` AS l ON l.lang_code = a.language LEFT JOIN esw_users AS uc ON uc.id=a.checked_out LEFT JOIN esw_users AS ua ON ua.id = a.created_user_id LEFT JOIN esw_viewlevels AS ug on ug.id = a.access LEFT JOIN esw_viewlevels AS ugv on ugv.id = a.accessview WHERE a.alias <> 'root' AND (a.published IN (0, 1)) Unknown column 'a.accessview' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.accessview, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.type, a.core, a.required, a.edit, a.profile, a.register, a.search, a.language,l.title AS language_title,uc.name AS editor,ua.name AS author_name,ug.title AS access_title,ugv.title AS accessview_title FROM esw_jsn_fields AS a LEFT JOIN `esw_languages` AS l ON l.lang_code = a.language LEFT JOIN esw_users AS uc ON uc.id=a.checked_out LEFT JOIN esw_users AS ua ON ua.id = a.created_user_id LEFT JOIN esw_viewlevels AS ug on ug.id = a.access LEFT JOIN esw_viewlevels AS ugv on ugv.id = a.accessview WHERE a.alias <> 'root' AND (a.published IN (0, 1)) ORDER BY a.lft asc LIMIT 0, 20 Unknown column 'a.accessview' in 'on clause' SQL=SELECT COUNT(*) FROM esw_jsn_fields AS a LEFT JOIN `esw_languages` AS l ON l.lang_code = a.language LEFT JOIN esw_users AS uc ON uc.id=a.checked_out LEFT JOIN esw_users AS ua ON ua.id = a.created_user_id LEFT JOIN esw_viewlevels AS ug on ug.id = a.access LEFT JOIN esw_viewlevels AS ugv on ugv.id = a.accessview WHERE a.alias <> 'root' AND (a.published IN (0, 1))
HELP!!!
...Thanks
Nick
