[solved] SQL 'ue.approved' error on user manager

14 years 9 months ago #43047 by OOPz
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
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

Please Log in to join the conversation.

14 years 9 months ago #43056 by OOPz
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.

Please Log in to join the conversation.

14 years 9 months ago #43312 by beat
wierd, first time i hear this one, looks very much as a database corruption, or column delete by mistake in db management.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

14 years 9 months ago #43448 by OOPz
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 :)

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.214 seconds

Facebook Twitter LinkedIn