WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Connections] No entry error (5 posts)

  1. JohnnyPea
    Member
    Posted 4 years ago #

    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/

  2. shazahm1
    Member
    Posted 4 years ago #

    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.

  3. fidzi
    Member
    Posted 4 years ago #

    This domain running on Unix server.

  4. shazahm1
    Member
    Posted 4 years ago #

    @fidzi

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

  5. fidzi
    Member
    Posted 4 years ago #

    Yes, with 0.7.0.1 release is fixed this problem, thanks :-)

Topic Closed

This topic has been closed to new replies.

About this Topic