Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Website Loads Inside SP Admin
Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 20, 2018 - 6:26 pm

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-subscriptions.pngImage Enlarger

 

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

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

Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 20, 2018 - 6:33 pm

When the pane loads, FF web console reports:

Blocked loading mixed active content “../wp-content/plugins/simple-press/admin/resources/css/fonts/sp-admin.woff?-1norbm”   ...   admin.php

sp-subs-console.pngImage Enlarger

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

Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 20, 2018 - 6:41 pm

And there are no relative errors in the server logs.

confused

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 20, 2018 - 7:21 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 21, 2018 - 12:38 am

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.

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

Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 21, 2018 - 12:53 am

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

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 21, 2018 - 4:30 am

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?

andy-signature.png
YELLOW
SWORDFISH
Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 21, 2018 - 1:46 pm

Yellow Swordfish said
Do you fancy trying that?

Sure! Thanks.

Odd issues like this always leave me wondering what's going on...

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 21, 2018 - 2:09 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 21, 2018 - 3:00 pm

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

function-vshow.pngImage Enlarger

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

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: 647
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17344
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79598