Viewing 5 reply threads
  • Author
    Posts
    • November 3, 2015 at 10:32 pm #4851
      tyera
      Member

      I am receiving a SQL syntax error in my WordPress site from the PikList get_meta_sql() function in class-piklist-wordpress.php:134.

      WordPress database error 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 GROUP BY post_id’ at line 1 for query SELECT post_id FROM wp_postmeta WHERE AND GROUP BY post_id

      I am a little stumped as to how the WHERE clause is ending up empty.

      Any ideas?

    • November 4, 2015 at 11:27 pm #4870
      Steve
      Keymaster

      @tyera– Welcome to the Piklist community!

      What version of Piklist are you running?

    • November 5, 2015 at 2:43 am #4876
      tyera
      Member

      Hello, Steve!
      I have Piklist version 0.9.4.29 installed.

    • November 5, 2015 at 9:57 am #4878
      Steve
      Keymaster

      This has been fixed in the latest version of Piklist, v0.9.9.x, and you can download it here.

      Otherwise, you can fix this by:
      -Opening this file: piklist/includes/class-piklist-wordpress.php and commenting out this line:

      //add_filter('get_meta_sql', array('piklist_wordpress', 'get_meta_sql'), 101, 6);
    • November 5, 2015 at 10:56 am #4879
      tyera
      Member

      Perfect, thank you!

    • November 5, 2015 at 10:57 am #4880
      Steve
      Keymaster

      Great! Closing ticket.

  • Author
    Posts
Viewing 5 reply threads
  • The topic ‘SQL Syntax Error, get_meta_sql’ is closed to new replies.