[Nathaniel Olin]

Hello,

For whatever reason, all entries have disappeared both from the website (http://africanpoliticsgroup.org/index.php/connect/) and from the Manage page. They still exist – the Manage screen lists 185 entries but is displaying “0 of 0.” If I filter by any category on the backend, the relevant entries appear, but “Show All Categories” returns nothing. I double checked and it is not filtering by character.

I added a “View All” link in the settings to see whether that would work, but clicking the link returns a 404 error. All entries are set to Public. Any help you could provide would be greatly appreciated. (I recently took over running this website, and plugins / wordpress have been recently updated, so although I know it was running recently I cannot pinpoint what changed to break things.)

[Steven Zahm]

@ Nathaniel

Can I get a temp admin account so I can take a closer look? Also, can you install the Query Logger plugin? That’ll help a lot once I log in to see what the issue may be.

In regards to the 404… looks like the server is IIS 6 … that’s pretty old. If you do not have access the the IIS config, then your host will have to make the change necessary to the rewrite rules in order to remove the index.php from the URL (that the website address in the browser address bar).

See the last post in this support thread, they are a few links which may help.
http://wordpress.org/support/topic/removing-indexphp-from-my-urls#post-4433162

Sorry that’s the best I can do because this is a web host issue. There’s nothing I can do to fix it, sorry.

[Nathaniel Olin]

This reply has been marked as private.

[Steven Zahm]

@ Nathaniel

Apologies for the late reply, for some reason your reply ended up in spam and I didn’t notice it until this morning.

I logged in and took a look…

The issue you’re having is the same as referenced in this support forum thread:
http://connections-pro.com/support/topic/out-of-memory-database-error/

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_connections.*, CASEentry_typeWHEN 'individual' THENlast_nameWHEN 'organization' THENorganizationWHEN 'connection_group' THENfamily_nameWHEN 'family' THENfamily_nameEND ASsort_column` FROM wp_connections WHERE 1=1 AND wp_connections.visibility IN (‘public’, ‘private’, ‘unlisted’) AND wp_connections.status IN (‘approved’) ORDER BY sort_column, last_name, first_name LIMIT 5
`

If I remove the DISTINCT clause from the main query, Connections starts working for you again.

The reason is that the MySQL instance at the web host is running out of memory, likely something only they can address. I do not know why as the query is no more complex than WordPress makes.

I left the DISTINCT query clause removed so Connections will continue to function for you. It should work fine for the most part, but, I have not done the required testing to ensure it.

If you update Connections, you’ll lose that change — just keep that in mind when updating.

I hope that helps!

[Author]

Posts