Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

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

[SOLVED] 1054 - Unknown column 'orderByJoin2.firstname' in 'order clause' 6 years 6 months ago #27837

  • thefbi
  • thefbi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
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

Please Log in or Create an account to join the conversation.

Last Edit: by nathan.dth.

1054 - Unknown column 'orderByJoin2.firstname' in 'order clause' 6 years 6 months ago #27838

  • nathan.dth
  • nathan.dth's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 1857
  • Karma: 19
  • Thank you received: 218
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.

Please Log in or Create an account to join the conversation.

Nathan is no longer affiliated with DTH since the recent acquisition. You can connect with him and get any type of Joomla website help at www.JoomlaEmployee.com .

1054 - Unknown column 'orderByJoin2.firstname' in 'order clause' 6 years 6 months ago #27840

  • thefbi
  • thefbi's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
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.

Please Log in or Create an account to join the conversation.

1054 - Unknown column 'orderByJoin2.firstname' in 'order clause' 6 years 6 months ago #27848

  • waynejb
  • waynejb's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 131
  • Thank you received: 4
I have followed the same process and getting: Error: 1054
Unknown column 'orderByJoin2.firstname' in 'order clause'

Please Log in or Create an account to join the conversation.

1054 - Unknown column 'orderByJoin2.firstname' in 'order clause' 6 years 6 months ago #27854

  • jalgarra
  • jalgarra's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Yup, I get the same error. Not sure why this says solved? Saving the config did nothing.

Please Log in or Create an account to join the conversation.

Last Edit: by jalgarra.

1054 - Unknown column 'orderByJoin2.firstname' in 'order clause' 6 years 6 months ago #27867

  • waynejb
  • waynejb's Avatar
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 131
  • Thank you received: 4
I agree, its not solved. Saving does not correct the issue. Have you found a work around?

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.127 seconds