• Registered: 2005-11-30
  • Posts: 165

Topic: Dont Receive Email Notificiation

Hi,
i've subscribed many of thread on my forum ; and ; for a reason i dont understand ; i dont receive any email notification.

so i've thought to remove all the subscribe i made with a SQL query and subscribe again, but manually.

so the question is which SQL query could i execute to remove all subscription ?

regards.

http://www.foxmask.info

foxmask's Website

  • From: Ottawa, Canada
  • Registered: 2006-09-05
  • Posts: 308

Re: Dont Receive Email Notificiation

Did you configure your smtp options in the admin section of the forum?
Do you recieve e-mail for alternative sources?

Try this:
1) Log-on as yourself
2) Click "Profile"
3) Click "Privacy"
4) Select "Hide your e-mail address but allow form e-mail."
5) Click Submit

Now log-off and create a new user. Log on as that new user, and click the user list. Find your name and click it. In the "Personal" section there will be a "Send e-mail" button. Try to send yourself an e-mail through the form.

If it fails, then you havn't configured you smtp options properly.

echo "deadram"; echo; fortune;

3 Reply by foxmask (edited by foxmask 2006-09-14 22:21)

  • Registered: 2005-11-30
  • Posts: 165

Re: Dont Receive Email Notificiation

The smtp used is the hosting's one. And before few days i always received my notifications hmm

http://www.foxmask.info

foxmask's Website

4 Reply by deadram (edited by deadram 2006-09-15 04:17)

  • From: Ottawa, Canada
  • Registered: 2006-09-05
  • Posts: 308

Re: Dont Receive Email Notificiation

Here's the command to delete EVERY subscription you (or anyone else) has:

DROP TABLE subscriptions;

Now the next part is VERY IMPORTANT TO GET RIGHT!!!!
Click on Administration and find out what type of databse you have. It should be at the very bottom, something like this:

Database            PDO_SQLite 3.2.8

if you use mysql, or msqli, to restore the table do this:

CREATE TABLE subscriptions (
                    user_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                    topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                    PRIMARY KEY (user_id, topic_id)
                    ) TYPE=MyISAM;

if you use pgsql, to restore the table do this:

CREATE TABLE subscriptions (
                    user_id INT NOT NULL DEFAULT 0,
                    topic_id INT NOT NULL DEFAULT 0,
                    PRIMARY KEY (user_id, topic_id)
                    );

if you use sqlite, to restore the table do this:

CREATE TABLE subscriptions (
                    user_id INTEGER NOT NULL DEFAULT 0,
                    topic_id INTEGER NOT NULL DEFAULT 0,
                    PRIMARY KEY (user_id, topic_id)
                    );

I suggest you backup your database before doing this.

To confirm that the table has been removed and recreated, dump the table.
In sqlite the command is

.dump subscriptions

I'm not sure about mysql or pgsql though.
Then make a new subscription and dump the table again, you should see something like this:

CREATE TABLE subscriptions (
                    user_id INTEGER NOT NULL DEFAULT 0,
                    topic_id INTEGER NOT NULL DEFAULT 0,
                    PRIMARY KEY (user_id, topic_id)
                    );
INSERT INTO "subscriptions" VALUES(3, 1);

PS: I take no responsibility if your forum blows up and causes you mother's, friend's, pet's, imaginary bird to poop out walnuts.

echo "deadram"; echo; fortune;