BigL1 wrote:

Same problem here. Avatar thumbs work fine in lists and login, but not on the profile page and neither will an image be displayed when approving from the workerflow.
The only way to get it displayed is to fill the field "avatar" in the #__users table (jos_users in my case)

I copied the avatar field value from jos_comprofiler table that holds a filename like "67_455734faf390a.jpg" to the jos_users table and voila... it appears on the profile page. So I could run a query to update the jos_users table, but I don't think that's a permanent solution.

So should the avatar field in jos_users table be updated so that it can be displayed or is something else wrong?
The CB version I installed a couple of days ago is 1.0.1 and I have this problem from the start.
Joomla version is 1.0.11.

P.S. I also noticed that the jos_comprofiler table holds no values for first name, last name etc, but that could be something entirely different.

Post edited by: BigL1, at: 2006/11/15 01:48

what does it say when you use components->CB->tools->synchronize users ?

all green there ?

do you have first + last name setting ?

do you use CB login module and CB registration page ?

Looks like there is a comprofiler row missing with same id than in users table. and these are typically the configuration errors leading to this situation.

EDIT: you seem to have a user or comprofiler entry with id = 0 !

There is a bug which under very rare particular circumstances may lead to this. Fixed in upcoming 1.0.2.

For this you need to delete this entry in jos_users or jos_comprofiler with id = 0.

Post edited by: beat, at: 2006/11/20 02:10

I finally got SQL access to one of the sites this evening and took a look.

Somehow another component created an "avatar" column also in the jos_users table (as well as modified other things in joomla-system table jos_users). Therefore the CB requests for avatar were served sometimes by users sometimes by comprofiler table, making it inconsistent.

CB does not modify joomla-system tables.

Would love to know which component modifies these system tables. It's not CB.

Removed that "avatar" column in jos_users, and avatars started working again.

Hope this helps.

In just released CB 1.0.2 there is a DB check function in CB->tools, detecting some inconsistencies in CB tables, but it will not check joomla system tables !