[SOLVED] Error - Field Rules

[urbanus]

Database Error: 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 'order by sort_order, name' at line 1
Query: select * from app_forms_tabs where parent_id=0 and entities_id= order by sort_order, name
Page: /index.php?module=forms_fields_rules/rules&action=get_fields_choices&entities_id=29&id=&token=9pXizU5DOI&fields_id=null
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'select * from a...')
#1 includes/classes/model/forms_tabs.php(59): db_query('select * from a...')
#2 includes/classes/model/forms_fields_rules.php(132): forms_tabs::get_tree('')
#3 modules/forms_fields_rules/actions/rules.php(168): forms_fields_rules::fields_by_form_tab_helper('', 'visible_fields')
#4 index.php(20): require('/home1/urbanu55...')
#5 {main}

[support]

Can't reproduce this issue.

[urbanus]

Hello Sergey ;
I already found out why the error happened, I was wanting to create a rule in a field that is read-only, that is, it does not appear in the form only in the listing.

[Didou12]

Yes,

Same here, when no field is available, I think this error pops up.

[yaoying]

I also ran into it, should prompt that no fields are available, instead of an error code

[support]

Can someone reproduce this issue on personal demo https://www.rukovoditel.net/demo.php and give me the link to the demo. I will check.

[yaoying]

Import the template Job Tracking Template
https://www.rukovoditel.net/database_te ... .php?id=29

Application Structure >> Entities List >> Stock >> View Configuration >> Display Fields Rules >> Add a new rule


Error

Code: Select all

Database Error: 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 'order by sort_order, name' at line 1
Query: select * from app_forms_tabs where parent_id=0 and entities_id= order by sort_order, name
Page: /3.3/index.php?module=forms_fields_rules/rules&action=get_fields_choices&entities_id=27&id=&demo_id=2146&token=AE1eR81sKd&fields_id=null
#0 includes/functions/database.php(87): mysqli_query()
#1 includes/classes/model/forms_tabs.php(59): db_query()
#2 includes/classes/model/forms_fields_rules.php(132): forms_tabs::get_tree()
#3 modules/forms_fields_rules/actions/rules.php(168): forms_fields_rules::fields_by_form_tab_helper()
#4 index.php(20): require('/home/admin/web...')
#5 {main}

https://pdemo.rukovoditel.pro/3.3/index ... mo_id=2146

[support]

Found issue. It happens because no fields available to setup rules.
File from archive replace to modules\forms_fields_rules\actions\
Now there is no error.

[yaoying]

Thank you, the error has been resolved.

[Didou12]

Thank you Sergey