47 Posts
zaliyanna
9 years ago
Topic

Hi, 

I add user-group field to the default Users form 

When I try to list users in frontend an error occures:

Unknown column 't1.groups' in 'where clause' SQL=SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias FROM `jos_cck_core` AS t0 LEFT JOIN `jos_users` AS t1 ON t1.id = t0.pk LEFT JOIN `jos_cck_core_types` AS tt ON tt.name = t0.cck WHERE t0.cck = 'candidat' AND t1.groups LIKE '%%' GROUP BY t0.pk ORDER BY t1.name ASC What's the pb

When I display all users without group it works ... 

The other pb is that I can't add a link to content to view the detail of users like I have in backend. How can I do that ?

Thanks for your help

Get a VIP membership
9 years ago
1
Level 1

Hello zaliyanna,

have you seen the tutorial listed below ?

regards.

Lionel

47 Posts
zaliyanna
9 years ago
0
Level 2

Hi Lionel, Tahnks for this link I didn't saw it before !

hanks it works fine,

;)

Get a Book for SEBLOD