Support » Plugin: Subscribe To Comments Reloaded » [Plugin: Subscribe To Comments Reloaded] – view all the subscriptions broken

  • Resolved utnalove

    (@utnalove)


    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?

Viewing 15 replies - 1 through 15 (of 20 total)
  • Plugin Contributor Jason Crouse

    (@coolmann)

    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 🙂

    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.

    Plugin Contributor Jason Crouse

    (@coolmann)

    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

    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! 😉

    Plugin Contributor Jason Crouse

    (@coolmann)

    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 🙂

    Plugin Contributor Jason Crouse

    (@coolmann)

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

    Plugin Contributor Jason Crouse

    (@coolmann)

    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 🙂

    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!

    Plugin Contributor Jason Crouse

    (@coolmann)

    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 🙂

    Yaaaaaaaay that worked, finally! Thanks for the code!

    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?

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘[Plugin: Subscribe To Comments Reloaded] – view all the subscriptions broken’ is closed to new replies.