Answered ClassExtender 2.0

101 Posts

mintnl Reply #1, 12 years, 1 month ago

Hi, i upgraded ClassExtender from 1.1.1 to 2.0 but have a few problems, who can help me here?

 [[!GetExtUsers?
    &groups=`Partners`
    &where=`{"sectora:=":"A"}`
    &extUserInnerTpl=`pTopInnerTpl`
    &extUserOuterTpl=`pTopOuterTpl`
    &sortBy=`Profile.fullname`
    &sortDir=`ASC`
    &limit=`0`
]]

This give me some rows for output. The chunk pTopInnerTpl looks like this

<li><a href="[[~34? &p=`[[+id]]`]]">[[+username]] - [[+fullname]] - [[+nrbtw]]</a></li>

This partly outputs the items i want, [ [ +username ] ] and [ [ +nrbtw ] ](extended field) are playing along nicely. But [ [ +fullname ] ] doesn't do anything; tried +Profile.fullname +User.fullname etc as placeholder.
in Bob's documentation i can't find what to use as prefix for items in the User profile (e.g. email, fullname, phone, gender, address etc.)
In the previous version the placeholder +fullname worked.

Can anybody help me?

*** UPDATE ***
This is the error-log; makes me believe no join is done.... But not sure what and where to change to make it fetch the profile.

[2014-08-28 17:51:25] (ERROR @ /index.php) Error 42S22 executing query: SELECT `userData`.`id` AS `userData_id`, `userData`.`userdata_id` AS `userData_userdata_id`, `userData`.`nrkvk` AS `userData_nrkvk`, `userData`.`nrbtw` AS `userData_nrbtw`, `userData`.`nriban` AS `userData_nriban`, `userData`.`omschr` AS `userData_omschr`, `userData`.`fb` AS `userData_fb`, `userData`.`li` AS `userData_li`, `userData`.`twit` AS `userData_twit`, `userData`.`googlep` AS `userData_googlep`, `userData`.`afblogo` AS `userData_afblogo`, `userData`.`afb1` AS `userData_afb1`, `userData`.`afb2` AS `userData_afb2`, `userData`.`afb3` AS `userData_afb3`, `userData`.`sectori` AS `userData_sectori`, `userData`.`sectora` AS `userData_sectora`, `userData`.`sectorc` AS `userData_sectorc`, `userData`.`sectore` AS `userData_sectore`, `User`.`id` AS `User_id`, `User`.`username` AS `User_username`, `User`.`password` AS `User_password`, `User`.`cachepwd` AS `User_cachepwd`, `User`.`class_key` AS `User_class_key`, `User`.`active` AS `User_active`, `User`.`remote_key` AS `User_remote_key`, `User`.`remote_data` AS `User_remote_data`, `User`.`hash_class` AS `User_hash_class`, `User`.`salt` AS `User_salt`, `User`.`primary_group` AS `User_primary_group`, `User`.`session_stale` AS `User_session_stale`, `User`.`sudo` AS `User_sudo` FROM `ext_user_data` AS `userData` LEFT JOIN `modx_users` `User` ON `userData`.`userdata_id` = `User`.`id` WHERE `userData`.`sectore` = ? ORDER BY Profile.fullname ASC, `userData`.`id` ASC  - Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'Profile.fullname' in 'order clause'
)

[2014-08-28 20:33:53] (ERROR @ /index.php) No foreign key definition for parentClass: userData using relation alias: Profile

This question has been answered by mintnl. See the first response.

[ed. note: mintnl last edited this post 12 years, 1 month ago.]

Addict since 2012....

discuss.answer
- 101 Posts
mintnl Reply #2, 12 years, 1 month ago

I solved my problem.
Since i upgraded i assumed it was not necessary to visit and re-submit the ext-moduser resource.
In the end.... it was necessary.
Thanx.

I hope someone is able to answer this question though:
https://forums.modx.com/thread/91263/classextender-problem?page=2#dis-post-507515
Addict since 2012....