131 Posts
layonill
2 years ago
16
Topic

hi, I have a user profile done, now I want in this profile to show a list of the categories that this user created, using a list module, but it does not work, something in the live value is wrong, I only get to show the current user categories, that means, it only shows me my own creations no matter what profile I see, and I want it to show the list based on the profile it has now, how do I do it?

Get a VIP membership
1279 Posts
Bucklash
2 years ago
1
Level 1

Need to post your ‘debug query’

131 Posts
layonill
2 years ago
0
Level 2

I don't have one, and don't know witch one works, I just used in the search the created by, but it does not work, so what do I do?

4229 Posts
Kadministrator
2 years ago
13
Level 1

You need to add id field to the profile (can be in hidden position), than you can pass this value to the list like described here (tutorial is about list in list, but the principle is the same)

131 Posts
layonill
2 years ago
0
Level 2

is not working, I put the user id in the search of the list and in the content type of the user profile, in link variable

 

and it shows me all categories, weird because I did this in other content and it worked, I don't know why it does not in here

131 Posts
layonill
2 years ago
0
Level 2

I am trying to do this https://www.seblod.com/community/forums/lists-search-types/displaying-dynamically-a-list-of-articles-of-a-user-in-a-user-profile-page  

but not sure where is the mistake

131 Posts
layonill
2 years ago
10
Level 2

any idea?

1279 Posts
Bucklash
2 years ago
9
Level 3

paste here the debug ... from the config option in your template

131 Posts
layonill
2 years ago
8
Level 4

where do I find it?

1279 Posts
Bucklash
2 years ago
7
Level 5

In your search templates config... 

configuration  | fields | template

then there is the option ‘debug’

131 Posts
layonill
2 years ago
6
Level 6

it just says "use global", and something else, the search form looks the info on the url of my user profile?

1279 Posts
Bucklash
2 years ago
5
Level 7

Yeah, set debug to everyone or superuser

then look at the sql query when load page

131 Posts
layonill
2 years ago
0
Level 8

so, if it looks the info in the url, that means I have to change the url of the user profile, so the id of the user appears in the url? how do I do that? and I did what you told me, this is what it showed me

0.000 seconds (0.000); 15.07 MB (15.071) - beforeSearch

SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.author_session AS author_session,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__users` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__content` AS t2 ON t2.id = t0.pkb
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1
AND t2.access IN (1,1,2)
AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2019-03-24 16:10' )
AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2019-03-24 16:10' )
AND t0.cck = 'user'
AND t1.id = 34
ORDER BY t1.name ASC
LIMIT 25

0.021 seconds (0.021); 15.17 MB (0.099) - afterSearch [Cache=OFF] = 0 result.

0.021 seconds (0.000); 15.23 MB (0.063) - afterRender

131 Posts
layonill
2 years ago
3
Level 8

now what?

1279 Posts
Bucklash
2 years ago
2
Level 9

Looks alright to me therfore:

is article published? i.e. 1

are users findable by cck? ie #..users.id in #..cck_core.pk

I found a while  ago to create a new user content type and work from that as it solved the dramas I was exper

131 Posts
layonill
2 years ago
0
Level 10

it does not work, I don't understand why

131 Posts
layonill
2 years ago
0
Level 10

any idea of what to do with this, because I know some people had the same issue and got to solve it, but I am not sure here what step did I missed?

Get a VIP membership