hi all, my joomla has suddenly developled a prety much fatal problem.

every frontend login (i.e. including admin) is reporting "Your account has not yet been approved!"

and attempts to enter the user management section of CB returns a page with:

DB function failed with error number 1054
Unknown column 'ue.approved' in 'field list' SQL=SELECT DISTINCT a.*, g.name AS groupname, ue.approved,ue.confirmed FROM jos_users AS a LEFT JOIN jos_comprofiler AS ue ON a.id = ue.id INNER JOIN jos_core_acl_aro AS aro ON aro.value = a.id INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id INNER JOIN jos_core_acl_aro_groups AS g ON g.group_id = gm.group_id WHERE aro.section_value = 'users' LIMIT 0, 50

i am fairly new to the whole web dev thing, but it appears to be trying to read from the 'approved' field in the table 'ue', but not finding it.
which is correct as there is no ue table (also, why isnt it looking for jos_ue? (which also doesnt exist))
CB login/user managment were working perfeclty for weeks and im fairly sure i didnt touch anything that would have broken it (tho it is hard to be certain as im still building the site)

anyone have any idea how to go about fixing this (or even just what broke)?

incase its helpful,
Joomla: 1.0.12 Stable [ Sunfire [eCommerce Edition] ]
CB: 1.1
server: Apache
OS: FreeBSD
PHP: 5.1.4
MySQL: 4.1.18-log

I have had a quick search looking for related issues but didnt see anything with a reply, appologies if this is a duplicate thread.

Post edited by: OOPz, at: 2007/08/15 20:09

Post edited by: OOPz, at: 2007/08/15 20:11

Post edited by: OOPz, at: 2007/08/15 22:02

my friendly local server guy found an alias to jos_comprofiler where he added (re-added) the missing approved field.

site works now so the thread is solved, but i would still like to know what caused it incase it happens again, so if anyone has any ideas that would be appreciated.

yeah, i think your right, at least i hope so.. dont really want to have to be manually fixing it every few months... fingers crossed eh