This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
119 Posts
layonill
3 months 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 Book for SEBLOD
1182 Posts
Bucklash
3 months ago
1
Level 1

Need to post your ‘debug query’

119 Posts
layonill
3 months 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?

4228 Posts
Kadministrator
3 months 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)

119 Posts
layonill
3 months 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

119 Posts
layonill
3 months 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

119 Posts
layonill
3 months ago
10
Level 2

any idea?

1182 Posts
Bucklash
3 months ago
9
Level 3

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

119 Posts
layonill
3 months ago
8
Level 4

where do I find it?

1182 Posts
Bucklash
3 months ago
7
Level 5

In your search templates config... 

configuration  | fields | template

then there is the option ‘debug’

119 Posts
layonill
3 months 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?

1182 Posts
Bucklash
3 months ago
5
Level 7

Yeah, set debug to everyone or superuser

then look at the sql query when load page

119 Posts
layonill
3 months 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

119 Posts
layonill
3 months ago
3
Level 8

now what?

1182 Posts
Bucklash
3 months 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

119 Posts
layonill
3 months ago
0
Level 10

it does not work, I don't understand why

119 Posts
layonill
3 months 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