Support Forum

Running into a few issues with various plug-ins

TH Thorsten
Thorsten
Member

First, Blog Post Linking. I deactivated the plugin but decided to activate it again. Got the following error:

file: xxxxx/wp-content/sp-resources/forum-plugins/blog-linking/sp-linking-plugin.php
line: 254
function: sp_linking_do_install
error:

ALTER TABLE xxxxx_sflinks ADD KEY post_idx (post_id), ADD KEY forum_idx (forum_id), ADD KEY topic_idx (topic_id);

Here’s what sflinks looks like:

id                   post_id          forum_id        topic_id           syncedit
825438257      958406706     976761146     1528837936     NULL
790650213      796029813     NULL             1937337647     NULL
1867391034    1818324338    NULL             2003788916     2670 

I don’t recall ever actually using this plugin so never linked any posts from the blog to the forum. Not sure what these records are.

Next, Prune Database no longer functions, at least for me. I get as far as clicking ‘Filter Topics’. After that selecting topics and clicking ‘Update’ does nothing. It used to work fine. Perhaps connected to the issue above?

I also notice an odd behavior with some bulk actions, e.g. in ‘Simple:Press Administration’ I select ‘Available Plugins’, then tick the top box to select all plugins. Nothing happens. But, clicking on ‘Plugins’ under ‘Forum’ in the WP admin menu now allows me to bulk select all plugins. Tried this a few times, always with the same result. Tried deactivating all other WP plug-ins but the behavior didn’t change.

4 Answers

New Answer

TH Thorsten
Thorsten
Member

FYI, server error log says:

WordPress database error Duplicate key name ‘post_idx’ for query ALTER TABLE
WordPress database error Duplicate key name ‘blog_post_idx’ for query ALTER TABLE

MP Mr Papa
Mr Papa
Member

well, that clearly shows the plugin was active before and used (only way to get rows in the table)…  irregardless of reactivating the plugin and getting those errors which are not critical, does the blog linking function?

if you want to clean it up, just uninstall the blog linking plugin and then reactivate it…

I will have to check and see if the check all button has gotten knocked… it used wp code, but perhaps that has changed…  again, doesnt really affect any operaton – you could still check one by one.. but will open a ticket for checking…

as to prune database, will try to run some tests…

 

TH Thorsten
Thorsten
Member

Yes, the blog linking functions perfectly fine. Followed your instruction of uninstalling and reactivating and the error went away. Thank so much.

MP Mr Papa
Mr Papa
Member

thanks for the update…

btw, looks like I can recreate the prune db issue you are seeing, so a ticket is open..