[Sowmya]

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 entry_type
WHEN ‘individual’ THEN last_name
WHEN ‘organization’ THEN organization
WHEN ‘connection_group’ THEN family_name
WHEN ‘family’ THEN family_name
END AS sort_column FROM 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->entries

[Steven Zahm]

@ Sowmya

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 128M should be more than sufficient.

[Sowmya]

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…

[Steven Zahm]

@ Sowmya

Which MySQL client, web base or local app.

[Sowmya]

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!!!

???

[Steven Zahm]

@ Sowmya

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.

[Arizona Lowe]

The question is WHERE do we make that change – which file?

[Steven Zahm]

@ Arizona Lowe

The file is class.retrieve.php found here:
../wp-content/plugins/connections/includes/

Do a search for DISTINCT.

[Arizona Lowe]

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 :-(

[Steven Zahm]

@ Arizona Lowe

Yes, I saw you other post and did reply to it
http://connections-pro.com/support/topic/category-dropdown-gone/#post-303024

You do not really say why you want to remove DISTINCT which has nothing to do with the couple issue you posted about in the other support thread.

[Author]

Posts