× 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

9 năm 2 tháng trước #997 bởi 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.

 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'

on query:
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

Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.

9 năm 2 tháng trước #1000 bởi Andres Maeso
Replied by Andres Maeso on topic Bug order by on SQL field crashes admin list view
Hi Joris!

Thank you for taking the time to report this bug. I've created a ticket for our developers to check it. If you find anything else, please feel free to use our contact form: www.component-creator.com/en/help/contact We constantly monitor issues reported through e-mail and give them priority.

By the way, you live in a beautiful place, feel free to come by to Granada and pay us a visit in our office :)

Regards,

Andrés.

Andrés Maeso
Customer relations manager at Joomla Component Creator.

This email address is being protected from spambots. You need JavaScript enabled to view it.
Những thành viên sau(s) đã Cảm ơn: Joris Ceelen

Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.

Thời gian tải trang: 0.051 giây
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.