Ошибка 1064 в сортировке
Добавлено: 19 ноя 2021, 19:50
Столкнулся с какими-то странными ошибками в сортировке:
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 ') and f.entities_id='73' and f.forms_tabs_id=t.id order by field(f.id,524,525,4' at line 1
Query: select f.*, t.name as tab_name from app_fields f, app_forms_tabs t where f.id in (524,525,4377,1806,543,540,539,545,2333,544,2433,2546,) and f.entities_id='73' and f.forms_tabs_id=t.id order by field(f.id,524,525,4377,1806,543,540,539,545,2333,544,2433,2546,)
Page: /index.php?module=reports/configure&reports_id=838&redirect_to=listing&path=73
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 ') and type='fieldtype_text_pattern'' at line 1
Query: select configuration from app_fields where entities_id='73' and id in (524,525,4377,1806,543,540,539,545,2333,544,2433,2546,) and type='fieldtype_text_pattern'
Page: /index.php?module=items/listing
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 t.sort_order, t.name, f.sort_order, f.name' at line 1
Query: select f.*, t.name as tab_name from app_fields f, app_forms_tabs t where f.id not in (4377) and f.type not in ('fieldtype_action','fieldtype_text_pattern','fieldtype_qrcode','fieldtype_mapbbcode','fieldtype_parent_value','fieldtype_google_map','fieldtype_google_map_directions','fieldtype_items_by_query') and f.entities_id='73' and f.forms_tabs_id=t.id and f.id in (524,525,4377,1806,543,540,539,545,2333,544,2433,2546,) order by t.sort_order, t.name, f.sort_order, f.name
Page: /index.php?module=reports/sorting&reports_id=838&redirect_to=listing&path=73
При этом безумно замедляется работа с этой (73) сущностью: по минуте занимает вывод списка, добавление записи. В остальных сущностях все хорошо.
У кого-нибудь были аналогичные проблемы? Что помогло решить?
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 ') and f.entities_id='73' and f.forms_tabs_id=t.id order by field(f.id,524,525,4' at line 1
Query: select f.*, t.name as tab_name from app_fields f, app_forms_tabs t where f.id in (524,525,4377,1806,543,540,539,545,2333,544,2433,2546,) and f.entities_id='73' and f.forms_tabs_id=t.id order by field(f.id,524,525,4377,1806,543,540,539,545,2333,544,2433,2546,)
Page: /index.php?module=reports/configure&reports_id=838&redirect_to=listing&path=73
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 ') and type='fieldtype_text_pattern'' at line 1
Query: select configuration from app_fields where entities_id='73' and id in (524,525,4377,1806,543,540,539,545,2333,544,2433,2546,) and type='fieldtype_text_pattern'
Page: /index.php?module=items/listing
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 t.sort_order, t.name, f.sort_order, f.name' at line 1
Query: select f.*, t.name as tab_name from app_fields f, app_forms_tabs t where f.id not in (4377) and f.type not in ('fieldtype_action','fieldtype_text_pattern','fieldtype_qrcode','fieldtype_mapbbcode','fieldtype_parent_value','fieldtype_google_map','fieldtype_google_map_directions','fieldtype_items_by_query') and f.entities_id='73' and f.forms_tabs_id=t.id and f.id in (524,525,4377,1806,543,540,539,545,2333,544,2433,2546,) order by t.sort_order, t.name, f.sort_order, f.name
Page: /index.php?module=reports/sorting&reports_id=838&redirect_to=listing&path=73
При этом безумно замедляется работа с этой (73) сущностью: по минуте занимает вывод списка, добавление записи. В остальных сущностях все хорошо.
У кого-нибудь были аналогичные проблемы? Что помогло решить?