Subcriptions list doens’t load and publishing comment takes long time to load

Hi @f1news

When a new comment is processed, the notification emails are as well. So if there’s a lot of subscribers on a post it needs to go through sending out the emails to everyone.

A “mailing queue” should help out with that. Something like GD Mail Queue.

Thanks you for your answer.

I understand your email que, but it also happens when you place the first comment.

This query takes about 35 sec:
`SELECT
meta_id,
REPLACE(meta_key, ‘_stcr@_’, ”) AS email,
post_id,
SUBSTRING(meta_value, 1, 19) AS dt,
SUBSTRING(meta_value, 21) AS status,
srs.subscriber_unique_id AS email_key
FROM
wp_postmeta
INNER JOIN wp_subscribe_reloaded_subscribers srs ON (
REPLACE(meta_key, ‘_stcr@_’, ”) = srs.subscriber_email
)
WHERE
meta_key LIKE ‘\_stcr@\_%’
AND SUBSTRING(meta_value, 21) = ‘Y’
AND SUBSTRING(meta_key, 8) = ’[email protected]’
ORDER BY
dt ASC

Do you have any idea why I can’t load the subscribers list?

I’ve deleted all records in the subscriber’s database and now the issues seem to have been solved for now.

Hi @f1news

Which table’s records did you delete? Is it wp_subscribe_reloaded_subscribers? That one is needed for the system.

Yes, I dropped all records in that table with phpmyadmin and it started to work again.

I saw that users that subscribed their new comment also got their previous subscribtions back.

The subscriptions are stored in wp_postmeta but the info about subscribers is stored in wp_subscribe_reloaded_subscribers.

When they subscribe again they’ll be added to wp_subscribe_reloaded_subscribers and the subscriptions will work normally.

But without the connection between wp_subscribe_reloaded_subscribers and the data in wp_postmeta not everything is going to work. For example the deleted subscribers won’t be able to manage their subscriptions.

Also the subscribers that are missing should still be getting the notifications and in the email there are links to unsubscribe, but they won’t work.