Hello,

I have a problem sending email to my members of my forum. The email shown as sent but not reaching the members. I also attempted to send the email in the mail queue but I got this error:

"The database value you're trying to insert does not exist: last_mail_send"

Please help!

Thanks.

Why aren't my members getting emails sent from the forum?

Also check your database/smf forum for any errors.

Thank you for the information. I will go through the procedures and give feedback.

I tested with the script as instructed. I got a confirmation that "mail is send :-)" but did not receive any message in the email address used. Please help!

Like Kill said, make sure all of your database settings are correct.

How do I check my database for correctness?

it probs wouldent be your db.
check the settings under : logs - mail - settings

Directories are within your database...

Just to make sure, you did change the email address on that script, right? If so, then your host does not have PHP mail enabled. You have two options, well 3 I guess...
1. Ask your host to enable PHP mail.
2. Setup SMTP mail where Ryanteck pointed out. You can use your personal email if you want.
3. Switch hosts, would probably be my last resort if the first 2 didn't work and your host can confirm that the SMTP port isn't blocked.

Thank you all for supports. I contacted my host and it was confirmed that PHP mail is enabled. I was also given SMTP settings but did not work either. I don't know what could have caused the problem because I usually send emails before.

When you ran that script. You did change the email address in it, right? I'm just making sure because if so, then PHP mail is obviously not enabled.
If not, try it again and make sure to replace your email address. Check your spam folder as well.

Quote from: Kill Em All on June 06, 2010, 07:38:07 PM
When you ran that script. You did change the email address in it, right? I'm just making sure because if so, then PHP mail is obviously not enabled.
If not, try it again and make sure to replace your email address. Check your spam folder as well.

I did change the email address. Please find below error message in my logs. It is classified "critical":

Quotehttp://www.theinfostrides.com/index.php?action=admin;area=mailqueue;sa=clear;te=3113;sent=3000;bd8c33f83247=b2e39d96361f4341325222ef4464fe78
Apply Filter: Only show the errors with the same message
The database value you're trying to insert does not exist: last_mail_send
Function: ReduceMailQueue
Apply Filter: Only show the errors from this file
File: /home/infostr1/public_html/theinfostrides.com/Sources/ScheduledTasks.php
Line: 982

What mods do you have installed. How did you upgrade to 2.0, or was it a clean install, what versions was it from and to?

Quote from: Kill Em All on June 07, 2010, 05:48:32 PM
What mods do you have installed. How did you upgrade to 2.0, or was it a clean install, what versions was it from and to?

I have the following mods installed:

Quote1.     Share This Topic      1.5       [ Uninstall ]  [ List Files ]  [ Delete ]
2.    Related Topics    1.4 RC1    [ Uninstall ] [ List Files ] [ Delete ]
3.    SMF_Points    1.0    [ Uninstall ] [ List Files ] [ Delete ]
4.    Display Signatures Only Once Per Page    1.0.3    [ Uninstall ] [ List Files ] [ Delete ]
5.    Stop Spammer    2.3.7    [ Uninstall ] [ List Files ] [ Delete ]
6.    Auto Email Inactive Users    1.7    [ Uninstall ] [ List Files ] [ Delete ]
7.    Sitemap    2.1.2    [ Uninstall ] [ List Files ] [ Delete ]
8.    Aeva Media    1.2    [ Uninstall ] [ List Files ] [ Delete ]
9.    AutoKeywords    1.4    [ Uninstall ] [ List Files ] [ Delete ]
10.    SimpleAds    1.0    [ Uninstall ] [ List Files ] [ Delete ]
11.    Titled Links    1.2    [ Uninstall ] [ List Files ] [ Delete ]
12.    Contact Page    2.0.1    [ Uninstall ] [ List Files ] [ Delete ]
13.    Twitter and Facebook Publisher mod    2.4    [ Uninstall ] [ List Files ] [ Delete ]
14.    More Spiders    1.2    [ Uninstall ] [ List Files ] [ Delete ]
15.    Welcome Topic Mod    2.1    [ Uninstall ] [ List Files ] [ Delete ]
16.    Curve_centered_menu    1.1    [ Uninstall ] [ List Files ] [ Delete ]
17.    RSS Feeder    1.1.4    [ Uninstall ] [ List Files ] [ Delete ]
18.    Google Analytics Code    1.1    [ Uninstall ] [ List Files ] [ Delete ]
19.    Karma Buttons    1.1    [ Uninstall ] [ List Files ] [ Delete ]
20.    Rename *Child Board* | S-Ace    2.0    [ Uninstall ] [ List Files ] [ Delete ]
21.    Wireless/RSS amount displayed    1.1.0    [ Uninstall ] [ List Files ] [ Delete ]
23.    eFloating Bar for Guest & Members    0.1    [ Uninstall ] [ List Files ] [ Delete ]
24.    SimplePortal    2.3.2    [ Uninstall ] [ List Files ] [ Delete ]
25.    Country Flags    1.1.1    [ Uninstall ] [ List Files ] [ Delete ]
26.    RedirectPage    1.2    [ Uninstall ] [ List Files ] [ Delete ]
27.    Location on Posts    1.1    [ Uninstall ] [ List Files ] [ Delete ]
28.    Birthday Posts    0.12.1 Beta    [ Uninstall ] [ List Files ] [ Delete ]
29.    Smf seo boards title[    1    [ Uninstall ] [ List Files ] [ Delete ]
30.    Google Tagged    1.4    [ Uninstall ] [ List Files ] [ Delete ]
31.    Referrals Mod    2.2.7.2    [ Uninstall ] [ List Files ] [ Delete ]
32.    Online status on login    1.5    [ Uninstall ] [ List Files ] [ Delete ]
33.    Easy Screenshot Dumpster    1.3.2    [ Uninstall ] [ List Files ] [ Delete ]
34.    SMF Links    2.2    [ Uninstall ] [ List Files ] [ Delete ]
35.    vBulletin Style Meta Tags    1.1    [ Uninstall ] [ List Files ] [ Delete ]
36.    Treasury    2.06    [ Uninstall ] [ List Files ] [ Delete ]
37.    SA FBConnect    0.2    [ Uninstall ] [ List Files ] [ Delete ]
38.    Resize Attached Images    2.1.1    [ Uninstall ] [ List Files ] [ Delete ]
39.    Infolinks Integration Mod | S-Ace    1.0    [ Uninstall ] [ List Files ] [ Delete ]

I actually started with 1.1.10, upgraded to 1.1.11, then to 2.0 RC2, and finally to 2.0 RC3. At a point in time, I did clean installation of 2.0RC3 with my old database. I hope this helps!

When you did the clean install of RC3, you did have a updated RC3 database, correct? A database that was with RC2 will not work in a RC3 forum.

Quote from: Kill Em All on June 09, 2010, 08:07:43 PM
When you did the clean install of RC3, you did have a updated RC3 database, correct? A database that was with RC2 will not work in a RC3 forum.

I doubt it if my forum database was fully upgraded to RC3. Is there any way to check this? Do we have any fix for it?

Grab a SMF 2.0 RC3 large upgrade package, then just upload the SQL files and the upgrade.php to the root of your SMF folder, then run the upgrade.php in your browser.

Once everything is all set and done, delete the SQL and upgrade.php files.

Quote from: Kill Em All on June 11, 2010, 11:02:14 AM
Grab a SMF 2.0 RC3 large upgrade package, then just upload the SQL files and the upgrade.php to the root of your SMF folder, then run the upgrade.php in your browser.

Once everything is all set and done, delete the SQL and upgrade.php files.

Thank you for your guide. I will do this and give feedback, although, I have attempted this before but failed to complete.

If it fails, make sure to give us the exact error message it gives you.

Quote from: Kill Em All on June 13, 2010, 04:36:44 PM
If it fails, make sure to give us the exact error message it gives you.

I got the following error at first instance:

QuoteCreating new tables and inserting default data... Successful!
Creating "themes"... Successful!
Creating "collapsed_categories"... Successful!
Creating and verifying "permissions"... Successful!
Inserting data into "permissions"... Successful!
Creating and verifying "board_permissions"... Successful!
Inserting data into "board_permissions"...
!!Error!
Unknown Error!
Unsuccessful!

This query:
INSERT IGNORE INTO infostrides_board_permissions
(ID_GROUP, ID_BOARD, permission)
VALUES (3, 0, 'moderate_board'), (2, 0, 'moderate_board');
Caused the error:
Unknown column 'ID_BOARD' in 'field list'