colai

Thanks, this also solved my problems.

Wow, awesome! I can just repeat spencerp, thanks a lot for sharing. You made my day!

Hi, I couldn’t find a newer thread for the subscribe2 plugin from Skippy, so I just post my problems in this quite old thing here and hope that someone can help me:

When I fill in subscribe addresses in WP under “manage – subscribers” by myself it worked, but I got the following error message:

WordPress database error: [Unknown column ‘date’ in ‘field list’]
SELECT email, date FROM wp_subscribe2
()

I made a test and posted a new blog entry. It was sending emails to the subscribers, so it worked although I have under each subscriber this error message (only in the manage-subscribers area).

Then I erased two of the email addresses and wanted to subscribe them again, but after clicking the subscribe button it now gives me the following error message (above the field):
WordPress database error:
[Unknown column ‘date’ in ‘field list’]
INSERT INTO wp_subscribe2 (email, active, date) VALUES (‘[email protected]’, ‘1’, NOW())

It strangely says “Adress(es) subscribed!” but above I have the mentioned error message…hmm..

I tried it with other (new) email addresses that haven’t been subscribed before, but always the same error message and the new email addresses are not in the “all subscribers” list.

Any ideas?

I hope I didn’t explain it too complicated (I’m not English).
I use WP 2.0.2. with a modified benevolence theme.

I had the same problems (WP 2.0.2) and just changed the PERMALINKS back to default (I had date and name based before) and now everything works fine ??

Hey,
Does nobody knows an answer?
I’m frightened to use the “reset tables” button because I don’t know what happens with all entries in the blacklist. Will they be removed, erased, set back to approved comments??? What happens exactly?

I got an email notification about a new comment, but I cannot find it on my blog and not in SpamKarma and not my database either. What happens here? I’m lost. ??
Please help…

May I ask what happens to the comments in the blacklist when I reset the tables? Do they appear in the blog where they where before? I accedently moved a lot of my comments to the blacklist and don’t know how to undo this step…

Thanks for any help!