WordPress.org

1. JohnnyPea
   Member
   Posted 2 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. Steven Zahm
   Member
   Posted 2 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 2 years ago #

   This domain running on Unix server.

4. Steven Zahm
   Member
   Posted 2 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 2 years ago #

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

Topic Closed

This topic has been closed to new replies.