Support » Plugins and Hacks » [Plugin: Connections] No entry error

  • JohnnyPea

    (@johnnypea)


    When there is no entry in a category 5 and I use shortcode [connections_list category=5] I get this error:
    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 'NONE'') ) UNION (SELECT *,group_nameASsort_column` FROM socio_c’ at line 1]
    (SELECT *, organization AS sort_column FROM socio_connections WHERE last_name = ” AND group_name = ” AND id IN (”NONE”) ) UNION (SELECT *, group_name AS sort_column FROM socio_connections WHERE group_name != ” AND id IN (”NONE”) ) UNION (SELECT *, last_name AS sort_column FROM socio_connections WHERE last_name != ” AND id IN (”NONE”) ) ORDER BY sort_column, last_name, first_name`

    http://wordpress.org/extend/plugins/connections/

Viewing 4 replies - 1 through 4 (of 4 total)
  • shazahm1

    (@shazahm1hotmailcom)

    I’m sorry but I can duplicate this error. Are you by chance running on a windows server? I ask because I can’t test on that environment.

    fidzi

    (@fidzi)

    This domain running on Unix server.

    shazahm1

    (@shazahm1hotmailcom)

    @fidzi

    I can’t reproduce this error. Regardless, it should not occur in the next release as I’ve completely re-wrote the query.

    Yes, with 0.7.0.1 release is fixed this problem, thanks 🙂

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: Connections] No entry error’ is closed to new replies.