Unknown column 'a.viewaccesslevel' in 'on clause' SQL=SELECT a.*, p.name AS pluginname, p.published AS pluginpublished, al.title AS viewaccesslevelname FROM FOC_comprofiler_tabs AS a LEFT JOIN FOC_comprofiler_plugin AS p ON p.id = a.pluginid LEFT JOIN FOC_viewlevels AS al ON al.id = a.viewaccesslevel ORDER BY position, ordering LIMIT 0, 20
Unknown column 'tablecolumns' in 'field list' SQL=UPDATE FOC_comprofiler_fields SET tablecolumns = name, pluginid = 1 WHERE pluginid = 0
1054 Unknown column 'a.viewaccesslevel' in 'field list' SQL=SELECT a.listid, a.title, a.description, a.published, a.`default`, a.ordering, a.viewaccesslevel, al.title AS viewaccesslevelname, a.useraccessgroupid FROM FOC_comprofiler_lists a LEFT JOIN FOC_viewlevels AS al ON al.id = a.viewaccesslevel ORDER BY ordering LIMIT 0, 20
Please Log in to join the conversation.
Please Log in to join the conversation.
If you receive the error: Save failed with the following error: You cannot remove your own Super Admin permissions when trying to change the password or user name of the SuperAdmin on your Joomla 2.5 system, do the following:
You need to change a setting in the database.
1. Locate the _assets table in your database.
2. The first entry should be id # 1 and have a name of root.1 and a title of Root Asset.
2. Edit this entry and change the lft column from a 1 to a zero.
2. Save the change.
3.You should now be able to modify your superpadmin id and passwords.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.