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

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

https://www.duechiacchiere.it/contatto

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?

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 ?

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

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?

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

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