Support Forum
Support Forum
Offline
Well, this is rather interesting...
A user reported all her subscriptions had "disappeared" so I attempt to check the SP Admin -> Users -> Subscriptions (by User) tab, and the pane takes longer than normal to load.
When the pane content finally populated, the website home page loaded inside the SP dashboard, or it tried to, with styles clearly broken. Still, homepage content populated the Subscriptions pane, instead of the expected SP administrative tools.
FYI: The other Subscriptions panes load fine, by Forum by Topic, by Digest - those all load within the pane as expected. Attempting to load Subscriptions (by User), however results in the website loading inside the pane instead...
I reset the SP CSS and Script cache, cleared browser cache, and issue persists in both firefox and chrome.
Perhaps unrelated, but I noticed one error in the SP Error log* pertaining to blog post linking from the day before. So I deactivated that SP plugin, and issue persists. After reactivating Blog Linking, the most recent error appeared in the log. But this business may warrant a separate topic, as I m primarily concerned about addressing the Subscriptions pane issue...see screenshot for example of this madness.
*SP Error Log Entries:
20 March 2018 4:09 pm | spaErrError | 2 | databasefile: /home/tripawds/public_html/wp-content/sp-resources/forum-plugins/blog-linking/sp-linking-plugin.php
line: 265
function: sp_linking_do_install
error: Duplicate key name 'post_idx'
ALTER TABLE wp_1_sflinks ADD KEY post_idx (post_id), ADD KEY forum_idx (forum_id), ADD KEY topic_idx (topic_id);
19 March 2018 9:49 pm | spaErrError | 1 | databasefile: /home/tripawds/public_html/wp-content/sp-resources/forum-plugins/blog-linking/sp-linking-plugin.php
line: 154
function: sp_update_blog_link
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND post_index=1' at line 1
UPDATE wp_1_sfposts SET post_content='The internet is filled with chatter about the Canine Osteosarcoma Vaccine...
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
When the pane loads, FF web console reports:
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
And there are no relative errors in the server logs.
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
I am unable to replicate but I feel more concerned about the users claim that her subs had vanished.
have you performed a database optimisation run recently and also checked for any errors in the DB tables? One ir two may need a repair...
 |
YELLOW
SWORDFISH
|
Offline
Yellow Swordfish said
I feel more concerned about the users claim that her subs had vanished.
I chalk that up to them accidentally hitting the delete all subscriptions button, which does not display any warning when doing so. The user said she "may have done that"...
Reviewing subscriptions by Topic or Forum reveals that many subscriptions do still exist, including some for this user (though she shared a screenshot of her empty subscriptions pop-up).
have you performed a database optimisation run recently and also checked for any errors in the DB tables? One ir two may need a repair...
I converted the db engine to innoDB a while back, which does not support table repair or optimize. What other type of optimization might you recommend.
I do see that our wp_1_sfmembers table includes 11,323 rows weighing in at 46± MB, and I presume the query to Show subscriptions (by User) is wrangling that beast, if that is worth noting.
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
Also...I am seeing a number of errors like this in the server logs, though it sheds no light on what query.
[21-Mar-2018 04:27:39 UTC] PHP Warning: Error while sending QUERY packet. PID=25162 in /home/tripawds/public_html/wp-includes/wp-db.php on line 1924
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
Unsure about the error there without further info... This is what I would call a fairly complex query so it might be worth trying to take a look at the SQL being constructed to see if anything stands out.
I can offer you a small edit to make that will expose the query so that it could then be copied and pasted into phpMyAdmin to see if it produces an error. Do you fancy trying that?
|
YELLOW
SWORDFISH
|
Offline
Yellow Swordfish said
Do you fancy trying that?
Sure! Thanks.
Odd issues like this always leave me wondering what's going on...
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
OK - you need the file in the subscriptions plugin at /library/sp-subscriptions-database.php
Find the function named sp_subscriptions_get_user_subscriptions
Before the line near the end of that function that is:
$records['data'] = spdb_select('set', $query);type in:
vshow($query);
and save. Then in the admin reload the users section iof the fiorum and select the subscriptions by users. All being well there will be a dump of the query. Might not be pretty but should be there before any other display. Copy it and save somewhere. We will need it later...
|
YELLOW
SWORDFISH
|
Offline
Yellow Swordfish said
All being well there will be a dump of the query.
Hmm...no query displayed on screen, just the same result of home page loading inside the admin pane.
Am I missing something here?
To make matters more confusing, I cannot replicate the issue on our staging site, using the same theme and active plugins...
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
All RSS1 Guest(s)