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

TOPIC: error message : Select SQL_CALC_FOUND_ROWS

error message : Select SQL_CALC_FOUND_ROWS 9 years 8 months ago #24332

  • prestimion
  • prestimion's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 10
  • Thank you received: 0
Hello,
Following the last update ( 3.1.0a ), an error appears when I click on the link " attendees " this message and no longer lists the participants:

Select SQL_CALC_FOUND_ROWS u.*, f.* , ju.* , ju.id as user_id ,e.title, f.paid_amount,f.fee , f.status as feestatus , u.status , (f.fee - f.paid_amount) as amount_due from #__dtregister_user u left join #__dtregister_group_event e on u.eventId = e.slabId left join #__dtregister_fee f on f.user_id = u.userId left join #__dtregister_codes d on d.id = u.discount_code_id left join #__users ju on ju.id = u.user_id left join ( select value as firstname , user_id from #__dtregister_user_field_values where field_id=2 ) orderByJoin2 on u.userId = orderByJoin2.user_id left join ( select value as lastname , user_id from #__dtregister_user_field_values where field_id=3 ) orderByJoin3 on u.userId = orderByJoin3.user_id where e.slabId=67 and u.status in(0,1) group by u.userId order by orderByJoin2.firstname asc, orderByJoin3.lastname asc

Thank you for your answers

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

Last Edit: by prestimion.
  • Page:
  • 1
Time to create page: 0.359 seconds