Hello, I had the 1.6 version and today I updated to 2.0.
Now if I go to
Manage subscriptions in the wp-admin and I click on the view all the subscriptions hyperlink... it doesn't work. I click, the page refreshes and it shown nothing. It looks like that only the page gets refreshed.
But I have hundreds of subscribers....
what can I do?
Hi there,
please read the first item in the FAQs
http://wordpress.org/extend/plugins/subscribe-to-comments-reloaded/faq/
Long story short: deactivate and activate StCR, and you should be good to go.
Camu
Thank youuuuu :)
Posted 1 year ago #
Hi Camu,
I have the same problem, but that don't work for me, when i deactivate and activate the StCR. The subscriptions are still not showing up.
Only the new subscriptions are shown, but not the old ones.
Hi Beedy,
the import routine doesn't start if the "new" table already contains some subscriptions. That's by design, to avoid importing the same data multiple times when you deactivate/activate more than once. You may need to manually import your data using phpmyadmin. Or, if you don't have too many "new" subscriptions, you may want to write them down, delete them, import the old ones, and then manually recreate those new subscriptions using the corresponding widget in the admin area.
Please let me know, I can give you the SQL query to import the data via phpmyadmin...
Camu
Posted 1 year ago #
Great Camu, it works! :-)
Thank you for your help! I've deleted the 2 new subsriptions and after reactivation all the old subsriptions are available!
From my site, this topic is officially resolved! ;-)
Cool! I'm glad it worked.
A vote for my plugin would be a nice way to thank me :)
Have a nice day,
Camu
5 stars also from me :)
Thank you, really appreciated! I will be releasing version 2.0.1 soon, which solves some minor glitches other users have found in the meanwhile. Nothing critical, just some code clean-ups ;)
Camu
Thank you... if there will be necessity to disable/enable the plugin or to take some non standard actions in future it would be a good idea to have the plugin suggest what to do :))
Just to avoid the same that happened from 1.6 to 2.0 ^_^
True, but that means adding extra checks to my code that would be useful only once, but that would add "computational weight" every time the plugin is used. I think it's easier to tell people and leave the source code clean and lightweight.
Camu
Ok cool... you are the expert :)
Posted 1 year ago #
Yes, I'm having the same problem and I don't know how to import the old subscriptions from phpmyadmin. Could you please post the script? I have hundreds of subscriptions that are no longer appearing. Thanks!
Hi there, assuming that your WordPress prefix is wp_, here it the SQL query to run:
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT sr.post_ID, CONCAT('_stcr@_', sr.email), CONCAT(sr.dt, '|Y')
FROM wp_subscribe_reloaded sr
WHERE sr.email LIKE '%@%.%' AND sr.status = 'Y'
GROUP BY sr.email, sr.post_IDPS a vote for my plugin would be a nice way to thank me :)
Posted 1 year ago #
Yaaaaaaaay that worked, finally! Thanks for the code!
Posted 1 year ago #
Thank you. I re-read the original posts/replies and deleted the new subscriptions, deactivated and reactivated the plugin and sure enough it imported all of my original subscriptions. I then added the subscriptions I had deleted and I'm all done. Somehow I missed the part about deleting the new stuff in order for the import to work, apologies. I don't understand though why this happened in the first place. Will I have to do this again in the future?
Yaaaaaaaay that worked, finally! Thanks for the code!
Good to know :) Everybody is happy now...
I don't understand though why this happened in the first place. Will I have to do this again in the future?
StCR 2.0 changed the way it stores the information about subscriptions, switching from its own table to a native WordPress table (wp_postmeta, for those who like technical details). So this step was needed to 'import' the data from the former into the latter. In order to make the source code lightweight, the only place where to add this import was the 'activation' step, since WordPress doesn't have (or at least I'm not aware of...) a hook for things like this.
The new approach will make StCR compatible with WordPress Multiuser, and scalable on big networks of blogs, and it's strongly suggested by core WordPress developers.
Does all this make sense? :)
Camu
Posted 1 year ago #
Yes, I understand. Thanks for all your help! I'll make sure to vote for your plugin, it's really been great.
Thank you, really appreciated!
Posted 1 year ago #
You are the man. Many thanks for the help and sql code!
i3inary,
a vote for my plugin would be a nice way to thank me :)
This topic has been closed to new replies.
