×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Bug order by on SQL field crashes admin list view
Joris Ceelen
New Member
Posts: 9
pred 9 rokmi 1 mesiacom #997
od Joris Ceelen
Bug order by on SQL field crashes admin list view bolo vytvorené Joris Ceelen
Hello and thanks for the good work,
I found a small bug where when you use an "SQL Field" as Field Type and your query includes an order by the admin list view produces the following error:
An error has occurred.
select id,title from jml_categories where extension='com_form_nutrient_facts' and published=1 order by title
the workaround I found is to encapsulate the query in a subquery:
select * from (select id,title from jml_categories where extension='com_form_nutrient_facts' and published=1 order by title) as t1.
note that the DB storage field is a text field, and amazingly I can just change it to INT directly in the database and everything seems to hold together, thanks!
best wishes Joris
I found a small bug where when you use an "SQL Field" as Field Type and your query includes an order by the admin list view produces the following error:
An error has occurred.
on query:1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING id LIKE '24'' at line 1 SQL=select id,title from jml_categories where extension='com_form_nutrient_facts' and published=1 order by title HAVING id LIKE '24'
select id,title from jml_categories where extension='com_form_nutrient_facts' and published=1 order by title
the workaround I found is to encapsulate the query in a subquery:
select * from (select id,title from jml_categories where extension='com_form_nutrient_facts' and published=1 order by title) as t1.
note that the DB storage field is a text field, and amazingly I can just change it to INT directly in the database and everything seems to hold together, thanks!
best wishes Joris
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Čas vytvorenia stránky: 0.047 sekúnd