×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
List View not showing on front-end
Alfonce
New Member
Posts: 1
pred 8 rokmi 2 mesiacmi #1412
od Alfonce
List View not showing on front-end bolo vytvorené Alfonce
Hi al,
I am trying to view a list from a component I created, the sign up form and viewing the list from back-end is working fine, but when I try to view from front-end is showing error 0 with the following message:
Unknown column 'ordering' in 'order clause' SQL=SELECT DISTINCT a.*,uc.name AS editor FROM `#__signatories` AS a LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__users AS created_by ON created_by.id = a.created_by LEFT JOIN #__users AS modified_by ON modified_by.id = a.modified_by ORDER BY ordering asc LIMIT 0, 20
What could be the problem, please help
I am trying to view a list from a component I created, the sign up form and viewing the list from back-end is working fine, but when I try to view from front-end is showing error 0 with the following message:
Unknown column 'ordering' in 'order clause' SQL=SELECT DISTINCT a.*,uc.name AS editor FROM `#__signatories` AS a LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__users AS created_by ON created_by.id = a.created_by LEFT JOIN #__users AS modified_by ON modified_by.id = a.modified_by ORDER BY ordering asc LIMIT 0, 20
What could be the problem, please help
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Manav
New Member
Posts: 1
pred 8 rokmi 2 mesiacmi #1417
od Manav
Odpoveď od Manav na tému List View not showing on front-end
Try adjusting your SQL statement to use 'a.ordering' instead of just 'ordering'. Since you are using a JOIN in your SQL, you are using table aliases (such as 'a') and in that case field names should be prefixed with their table alias.
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Čas vytvorenia stránky: 0.050 sekúnd