Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
- This topic has 9 replies, 3 voices, and was last updated 8 years, 8 months ago by Steven Zahm.
11/08/2013 at 3:55 am #273217SowmyaGuest
Hi for me when I try to view a single entry from frontend or backend, this database error is thrown and I see a ‘No results’ message on the frontend.
In the query if I remove DISTINCT then it works but don’t know if this is the right way to do it. I am using the latest version of Connections Plugin.
The error trace is below:
WordPress database error Out of memory; restart server and try again (needed 217080 bytes) for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_connections.*, CASE
WHEN ‘individual’ THEN
WHEN ‘organization’ THEN
WHEN ‘connection_group’ THEN
WHEN ‘family’ THEN
sort_columnFROM wp_connections WHERE 1=1 AND wp_connections.slug = ‘lakshmi’ AND wp_connections.visibility IN (‘public’, ‘private’) AND wp_connections.status IN (‘approved’) ORDER BY sort_column, last_name, first_name made by require(‘F:\SBI\intranet\wordpress\wp-blog-header.php’), require_once(‘F:\SBI\intranet\wordpress\wp-includes\template-loader.php’), include(‘F:\SBI\intranet\wordpress\wp-content\plugins\buddypress\bp-themes\bp-default\page.php’), get_sidebar, locate_template, load_template, require_once(‘F:\SBI\intranet\wordpress\wp-content\themes\involve\sidebar.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Posts->widget, the_title, get_the_title, apply_filters(‘the_title’), call_user_func_array, cnSEO::filterPostTitle, cnRetrieve->entries11/08/2013 at 10:08 am #273242
See this excellent blog post for ways to increase the memory allocated to PHP. Which method will work for you is dependant on your webhost. I suggest starting at the top and making your way down. A setting of
128Mshould be more than sufficient.11/14/2013 at 9:47 am #273658SowmyaGuest
Hi but I don’t think it is a php issue, as on just running the query in a mysql client returns this error. I have only 3 records in the connections table so definitely a memory issue should not be coming…11/14/2013 at 10:05 pm #273759
Which MySQL client, web base or local app.11/18/2013 at 3:06 am #273900SowmyaGuest
Hi Steven, Thank you for the quick responses & the great plugin.
I tried on SQLyog (desktop client) as well as on phpmyadmin.
but if i remove the DISTINCT clause it works!!!
???11/18/2013 at 1:36 pm #273917
I don’t know what that would cause this issue. I’ve googled around quite a bit and couldn’t find anything relevant. The query is fairly basic and I have had no other reports of this throughout the years using this query. Has to be some type of configuration issue. Unfortunately I don’t know what direction to point you in for a solution.09/07/2014 at 3:17 pm #303008Arizona LoweParticipant
The question is WHERE do we make that change – which file?09/08/2014 at 9:32 am #303031
@ Arizona Lowe
The file is
Do a search for
DISTINCT.09/08/2014 at 10:37 am #303035Arizona LoweGuest
When I remove all the DISTINCT(s) found it does not work. Is there just one removal that will make this work.
Per another post I submitted – I am now having all sorts of problems with the plugin :-(09/08/2014 at 2:31 pm #303100
@ Arizona Lowe
Yes, I saw you other post and did reply to it
You do not really say why you want to remove
DISTINCTwhich has nothing to do with the couple issue you posted about in the other support thread.
You cannot reply to this support topic. Please open your own support topic.