×
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
Nouveau membre
Posts: 9
il y a 9 ans 2 mois #997
par Joris Ceelen
Bug order by on SQL field crashes admin list view a été créé par 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
Connexion ou Créer un compte pour participer à la conversation.
Temps de génération de la page : 0.046 secondes