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?
Need to post your ‘debug query’
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?
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)
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
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
any idea?
paste here the debug ... from the config option in your template
where do I find it?
In your search templates config...
configuration | fields | template
then there is the option ‘debug’
it just says "use global", and something else, the search form looks the info on the url of my user profile?
Yeah, set debug to everyone or superuser
then look at the sql query when load page
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
now what?
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
it does not work, I don't understand why
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?