search

ProjectNami / projectnami

WordPress powered by Microsoft SQL Server
http://projectnami.org
Other
271 stars 138 forks source link

issue in ODBC Driver #452

Open muneb-Ex opened 3 years ago

muneb-Ex commented 3 years ago

we have encountered an issue while displaying entries of from view I'm using formidable plugin

WordPress database error: [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'FIELD' is not a recognized built-in function name. Code - 195] SELECT it.id, it.item_key, it.name, it.ip, it.form_id, it.post_id, it.user_id, it.parent_item_id, it.updated_by, it.created_at, it.updated_at, it.is_draft FROM wp_frm_items it WHERE id in ('18', '17', '16', '15', '14', '13') ORDER BY FIELD(it.id, 18, 17, 16, 15, 14, 13)

patrickebates commented 3 years ago

Not seen this MySQL-specific command before. A translation would need to be added to support it. But if memory serves, there may be other issues with Formidable.