This site uses cookies and similar technologies.

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

I understand
129 Posts
layonill
6 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
1214 Posts
Bucklash
6 months ago
1
Level 1

Need to post your ‘debug query’

129 Posts
layonill
6 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?

4229 Posts
Kadministrator
6 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)

129 Posts
layonill
6 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

129 Posts
layonill
6 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

129 Posts
layonill
6 months ago
10
Level 2

any idea?

1214 Posts
Bucklash
6 months ago
9
Level 3

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

129 Posts
layonill
6 months ago
8
Level 4

where do I find it?

1214 Posts
Bucklash
6 months ago
7
Level 5

In your search templates config... 

configuration  | fields | template

then there is the option ‘debug’

129 Posts
layonill
6 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?

1214 Posts
Bucklash
6 months ago
5
Level 7

Yeah, set debug to everyone or superuser

then look at the sql query when load page

129 Posts
layonill
6 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

129 Posts
layonill
6 months ago
3
Level 8

now what?

1214 Posts
Bucklash
6 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

129 Posts
layonill
6 months ago
0
Level 10

it does not work, I don't understand why

129 Posts
layonill
6 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 Book for SEBLOD