Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Running into a few issues with various plug-ins
Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Oct 13, 2013 - 1:35 pm

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.

Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Oct 13, 2013 - 1:43 pm

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

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 13, 2013 - 4:42 pm

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

 

Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Oct 13, 2013 - 5:09 pm

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

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 13, 2013 - 10:07 pm

thanks for the update...

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

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625