Would be good to have phpMyAdmin access, or an SQL export of the comprofiler_fields table to check what's wrong (at least for those 2 fields and for username to compare). There should be no confidential info in there, so you can just attach or quote as [ code ] in post reply

Check for both email and name fields that the column pluginid is 1 in jos_comprofiler_fields, i'm suspecting that didn't happen.

Maybe that upgrade didn't get through for some reasons. I will make that requirement very strict in next release of database checker.

bertm wrote:

I wonder if this is the same problem that we are talking about in this post...

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/catid,50/id,64160/#64468

all of these fields are missing:
name
formatted name
first name
middle name
last name
email
user name
online status
last online
thumbnail
member since
last updated

I have captured a report of the SQL command script immediately after running the database repair (in the thread linked above) Dont know if there is anything unusual.

Beat- I also have a SQL export of most of the comprofiler tables, before and after the repair function. I can send if you like. To what address?

bertm,

Got your email with the database content, thanks. And it confirmed what i suspected

For an unknown reason you have for those fields in mysql table jos_comprofiler_fields:

tabid = 0
and
pluginid = 0

they all need to have:

pluginid = 1

and

a valid tabid, e.g.:

tabid = 11 for contact tab

tabid = 21 for status tab.

For now you will have to go into PhpMyAdmin and fix those values by hand.

We will on our side improve the upgrader to not only check for notnull values, but also for nonzero values.

Now I would be curious to know what made them 0 instead of NULL previous to upgrade.

Anyway, as such states exist we will improve the upgrader.

For now as quick fix (you would have to move the fields into the proper tab you could run following 2 SQL queries to quick-fix:

[code:1]UPDATE jos_comprofiler_fields SET pluginid = 1 WHERE pluginid = 0;
UPDATE jos_comprofiler_fields SET tabid = 21 WHERE tabid = 0;
[/code:1]

Post edited by: beat, at: 2008/06/04 14:20

Added to known issues here:

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,64606/catid,51/