TOPIC: [SOLVED] 1054 - Unknown column 'orderByJoin2.firstname' in 'order clause'

Hello,

i am testing the version 3.3.0 of DTRegister, in local mode before live, with Joomla 3.8.8.
I have the same error like in this post : www.dthdevelopment.com/support/forum/539...isting-in-fe?start=6

Unable to see registrant list. Thanks to help on this problem.

I have too a strange layout in the bottom of page (see attachment)

... Unable to join attachment : "Unknown column protected in field list"... Problem with your site

I have the code in bottom of event frontend page :

Joomla\Registry\Registry Object
(
[data:protected] => stdClass Object
(
[__default] => stdClass Object
(
[session] => stdClass Object
(
[counter] => 29
[timer] => stdClass Object
(
[start] => 1527401362
[last] => 1527402026
[now] => 1527402029
)

[token] => QwajoojYlbfgP4Sl5VF4ktrpf0WWw1Ud
)

[registry] => Joomla\Registry\Registry Object
(
[data:protected] => stdClass Object
(
)

[initialized:protected] =>
[separator] => .
)

[user] => Joomla\CMS\User\User Object
(
[isRoot:protected] =>
[id] => 494

Etc

First, you need to download DT Register again and reinstall. The debug showing on screen is something that wasn't meant to be included in the package. So, easy fix.

Second, for the unknown column item... you need to re-save DT Register configuration. There is a new parameter on the first tab for "Record Name Display". Set that as desired and save.

Hello,

OK, i have download and reinstall, and now the debug is OK.

But for the record name display, i have saved the config but the error still here when try to show registrant list.

I have followed the same process and getting: Error: 1054
Unknown column 'orderByJoin2.firstname' in 'order clause'

Yup, I get the same error. Not sure why this says solved? Saving the config did nothing.

I agree, its not solved. Saving does not correct the issue. Have you found a work around?