WordPress.org

Ready to get started?Download WordPress

Forums

Subscribe To Comments Reloaded
[resolved] - view all the subscriptions broken (21 posts)

  1. utnalove
    Member
    Posted 3 years ago #

    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?

  2. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  3. utnalove
    Member
    Posted 3 years ago #

    Thank youuuuu :)

  4. beedy
    Member
    Posted 3 years 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.

  5. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  6. beedy
    Member
    Posted 3 years 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! ;-)

  7. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Cool! I'm glad it worked.

    A vote for my plugin would be a nice way to thank me :)

    Have a nice day,
    Camu

  8. utnalove
    Member
    Posted 3 years ago #

    5 stars also from me :)

  9. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  10. utnalove
    Member
    Posted 3 years ago #

    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 ^_^

  11. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  12. utnalove
    Member
    Posted 3 years ago #

    Ok cool... you are the expert :)

  13. azazure
    Member
    Posted 3 years 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!

  14. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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_ID

    PS a vote for my plugin would be a nice way to thank me :)

  15. Delete Me
    Member
    Posted 3 years ago #

    Yaaaaaaaay that worked, finally! Thanks for the code!

  16. azazure
    Member
    Posted 3 years 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?

  17. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  18. azazure
    Member
    Posted 3 years ago #

    Yes, I understand. Thanks for all your help! I'll make sure to vote for your plugin, it's really been great.

  19. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Thank you, really appreciated!

  20. i3inary
    Member
    Posted 2 years ago #

    You are the man. Many thanks for the help and sql code!

  21. camu
    Member
    Plugin Contributor

    Posted 2 years ago #

    i3inary,

    a vote for my plugin would be a nice way to thank me :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic