×
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
Yeni Üye
Posts: 9
9 yıl 3 ay önce #997
Yazan: Joris Ceelen
Bug order by on SQL field crashes admin list view, Joris Ceelen tarafından oluşturuldu
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
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Sayfa oluşturma süresi: 0.054 saniye