Search not working

  • Hi,

    great plugin overall, but whenever I try to use search, I get this error window:

    DataTables warning: table id=nimble_table_data – An SQL error occurred: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LIKE ‘%h%’ OR Nuotrauka LIKE ‘%h%’ OR Lytis LIKE ‘%h%’ OR Gimimas LIKE ‘%h’ at line 3

Viewing 1 replies (of 1 total)

  • I’ve the same problem but only in a form with a file field

    All other contact forms have only text/textarea/select fields and work properly (and it’s a great plugin!).

    My error message:
    “DataTables warning: table id=nimble_table_data – An SQL error occurred: SQLSTATE[42000]: Syntax error or access violation: 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 ‘LIKE ‘%prog%’ OR ****** LIKE ‘%prog%’ OR created_on LIKE ‘%prog%’)
    ORDER’ at line 3

    • This reply was modified 7 years, 6 months ago by a_les.
Viewing 1 replies (of 1 total)
  • The topic ‘Search not working’ is closed to new replies.