WordPress.org

Support

Support » Plugins and Hacks » [Resolved] [Plugin: Subscribe To Comments Reloaded] 2.0 issue [tag] and localization

[Resolved] [Plugin: Subscribe To Comments Reloaded] 2.0 issue [tag] and localization

  • Thank you for the 2.0 update, i noticed a few problems.

    1. The tag [post_title] doesn’t show up anymore.
    Is there a list of tags that i can use ?

    2. Another thing is that the (dutch) localization is not up to date anymore. I’ll guess i have to wait untill ‘Dutch – Muratje’ updated his localization file?

    3. Third point is that i receive many questions from users that receiving subscribe mails. how is this possible?

    Thanks in advance!

    Margje

    http://wordpress.org/extend/plugins/subscribe-to-comments-reloaded/

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

    @coolmann

    Hi Margje,

    thank you for upgrading to 2.0. Unfortunately this new version had a few bugs, the good news is that thanks to your feedback, I’ve identified most of them, and a new version will be released early next week to address all these issues.

    1. The tag [post_title] doesn’t show up anymore.
    Is there a list of tags that i can use ?

    Yes, this tag is not working properly in 2.0, it’s a known bug. As for the list, you can find that in the description associated to each field.

    2. Another thing is that the (dutch) localization is not up to date anymore. I’ll guess i have to wait untill ‘Dutch – Muratje’ updated his localization file?

    You’re more than welcome to contribute. If you want, contact me and I’ll tell you were to send your updated localization files

    la buca delle lettere

    3. Third point is that i receive many questions from users that receiving subscribe mails. how is this possible?

    Could you please elaborate on this?

    Best
    Camu

    Thanks for your reply Camu,

    I’ve contacted Muratje and he will send you a fresh dutch localization soon.

    Another issue. I’ve de-activated and activated the plugin and after that:

    – All the email adresses that where subscribed in the past where subscribed again

    and

    – All the email adresses that have a subscribtion are subscribed TWICE (!) with the same mail adres!

    Problem: over 5000 subscribions and many angry users 🙁

    I have to remove all email adresses i guess ….

    is it possible to start ‘ all over’ ?
    i have removed all subscribtions, but when i deactivate – activate the plugin, there all back again. how to flush this information?

    Plugin Contributor Jason Crouse

    @coolmann

    All the email adresses that have a subscribtion are subscribed TWICE (!) with the same mail adres!

    This should not happen, actually there’s a check in my plugin just to prevent this from happening. Not sure why this didn’t work in your specific case.

    is it possible to start ‘ all over’ ?

    Yes, you will need to manually DROP the table wp_subscribe_reloaded from your database, or at least rename it. Make sure to export the data first, just in case you need to restore it later!

    Camu

    im confused!

    Dropped the wp_subscribe_reloaded tabel, deactivated, activated. all the mail adresses are back again!

    Removed wp_subscribe_reloaded tabeb, deactivated, activated double all the mail adresses

    deactivated, activated, triple etc.

    But the wp_subscribe_reloaded is not there anymore. what the f… ?

    Where are the mail adresses in my mysql ???

    I’ve upgraded from ‘subscribe to comments’ to your ‘reloaded’ plugin a few months ago, maybe this had something to do with this?

    For the moment i’v disable the plugin and i’m very disapointed! 🙁

    looked like the mail adresses are in wp_postmeta ?

    Plugin Contributor Jason Crouse

    @coolmann

    I’ve upgraded from ‘subscribe to comments’ to your ‘reloaded’ plugin a few months ago, maybe this had something to do with this?

    That’s the problem! You hadn’t mentioned it before 🙂 Unfortunately the “old” Subscribe to Comments by Mark Jaquith doesn’t clean-up the data when uninstalled, so what my plugin is doing is to import that data in your database. You may want to drop that plugin’s data as well (it is in a column inside wp_comments).

    But you gave me a good idea, which is to prevent DOUBLE importing Jaquith’s plugin’s data. I will add this to the next release!

    Thank you so much for your feedback, really helpful!

    Camu

    Great Camu! And how to solve my problem?

    2500 subscribed mail adresses are 5 times in my mysql database. So 12.500 mail adresses. The plugin is useless for me at this moment.

    How to clean up this mess and start with a clean ‘subscribe to comments reloaded’ plugin / database ?

    Thanks in advance!

    empty _subscribe_reloaded

    remove from wp_comments this ones:

    comment_subscribe_optin_mailed
    comment_subscribe_optin_verified
    comment_subscribe_optin

    ?

    What about wp_subscribe2

    tnx

    Plugin Contributor Jason Crouse

    @coolmann

    you can drop that as well. backup your data first!

    Now it’s getting serious camu,

    I’ve renamed:

    comment_subscribe_optin_mailed
    comment_subscribe_optin_verified
    comment_subscribe_optin

    Activated your plugin again and…

    The mail adresses are 6 times subscribed !

    Where is the key to solve this and stop messing up my database?

    Plugin Contributor Jason Crouse

    @coolmann

    You forgot to remove comment_subscribe from wp_comments, that’s the key column 🙂

    there is no comment_subscribe column in my wp_comments table

    Plugin Contributor Jason Crouse

    @coolmann

    Can you list all the columns in your wp_comments table, please?

    1 comment_ID bigint(20) UNSIGNED Nee Geen AUTO_INCREMENT Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    2 comment_post_ID bigint(20) UNSIGNED Nee 0 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    3 comment_author tinytext utf8_general_ci Nee Geen Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    4 comment_author_email varchar(100) utf8_general_ci Nee Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    5 comment_author_url varchar(200) utf8_general_ci Nee Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    6 comment_author_IP varchar(100) utf8_general_ci Nee Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    7 comment_date datetime Nee 0000-00-00 00:00:00 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    8 comment_date_gmt datetime Nee 0000-00-00 00:00:00 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    9 comment_content text utf8_general_ci Nee Geen Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    10 comment_karma int(11) Nee 0 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    11 comment_approved varchar(20) utf8_general_ci Nee 1 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    12 comment_agent varchar(255) utf8_general_ci Nee Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    13 comment_type varchar(20) utf8_general_ci Nee Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    14 comment_parent bigint(20) UNSIGNED Nee 0 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    15 user_id bigint(20) UNSIGNED Nee 0 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    16 comment_reply_ID int(11) Nee 0 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    17 rating_like int(11) Ja 0 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    18 rating_dislike int(11) Ja 0 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    19 x-comment_subscribe_optin enum(‘Y’, ‘N’) utf8_general_ci Nee N Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    20 x-comment_subscribe_optin_verified char(15) utf8_general_ci Nee 000000000000000 Veranderen Veranderen Verwijderen Verwijderen Meer Geef meer acties weer
    21 x-comment_subscribe_optin_mailed

Viewing 15 replies - 1 through 15 (of 26 total)
  • The topic ‘[Resolved] [Plugin: Subscribe To Comments Reloaded] 2.0 issue [tag] and localization’ is closed to new replies.