Problem with email

[InfoStrides]

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.

[Kill Em All]

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

Also check your database/smf forum for any errors.

[InfoStrides]

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

[InfoStrides]

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!

[Jakob Fel]

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

[InfoStrides]

How do I check my database for correctness?

[Ryanteck]

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

[Jakob Fel]

Directories are within your database...

[Kill Em All]

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.

[InfoStrides]

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.

[Kill Em All]

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.

[InfoStrides]

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":

http://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

[Kill Em All]

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?

[InfoStrides]

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:

1.     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!

[Kill Em All]

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.

[InfoStrides]

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?

[Kill Em All]

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.

[InfoStrides]

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.

[Kill Em All]

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

[InfoStrides]

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

I got the following error at first instance:

Creating 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'

[Kill Em All]

Try replacing your upgrade_2-0_mysql.sql that is in the same directory as your upgrade.php with this file provided. Then run the upgrade.php again.

[InfoStrides]

Try replacing your upgrade_2-0_mysql.sql that is in the same directory as your upgrade.php with this file provided. Then run the upgrade.php again.

There was no difference. Similar error occurred.

[Kill Em All]

After looking at your error and the upgrade_2-0_mysql.sql file, I have no idea what might be the problem. I had one hunch at first, but I do not think it was right. I'm gonna see if anyone else might know what the problem may be. Sorry I could not be further help. I'll post back if I come up with a better solution.

[InfoStrides]

After looking at your error and the upgrade_2-0_mysql.sql file, I have no idea what might be the problem. I had one hunch at first, but I do not think it was right. I'm gonna see if anyone else might know what the problem may be. Sorry I could not be further help. I'll post back if I come up with a better solution.

Thank you very much for your help.

[Kill Em All]

In your database, look in your smf_settings table. Replace "smf" with the prefix you typed when installing SMF. Look for a variable in there that says "smfVersion" and let us know what it says for it. It should say SMF 2.0 RC2.

[InfoStrides]

In your database, look in your smf_settings table. Replace "smf" with the prefix you typed when installing SMF. Look for a variable in there that says "smfVersion" and let us know what it says for it. It should say SMF 2.0 RC2.

I have the correct prefix in it "infostrides_settings". I checked for the variable "smfVersion", there is nothing like that there. Please find below contents of "_settings"

     Edit      Delete     rand_seed     xxxxxxxx
   Edit    Delete    next_task_time    xxxxxxxx
   Edit    Delete    memberlist_updated    xxxxxxx
   Edit    Delete    latestMember    1859
   Edit    Delete    totalMembers    1661
   Edit    Delete    latestRealName    adeomos
   Edit    Delete    totalMessages    5189
   Edit    Delete    maxMsgID    5365
   Edit    Delete    totalTopics    3916
   Edit    Delete    spider_name_cache    xxxxxxxxx..
   Edit    Delete    admin_features    xxxxxxxx
   Edit    Delete    cal_enabled    1
   Edit    Delete    karmaMode    2
   Edit    Delete    warning_settings    0,,
   Edit    Delete    spider_mode    x
   Edit    Delete    allow_guestAccess    x
   Edit    Delete    allow_hideOnline    x
   Edit    Delete    number_format    1234.00
   Edit    Delete    default_timezone    Africa/Lagos
   Edit    Delete    lastActive    1440
   Edit    Delete    trackStats    1
   Edit    Delete    hitStats    1
   Edit    Delete    allow_disableAnnounce    x
   Edit    Delete    mostOnline    1240
   Edit    Delete    mostDate    xxxxxxxx
   Edit    Delete    mostOnlineUpdated    2010-07-01
   Edit    Delete    mostOnlineToday    684
   Edit    Delete    time_format    %B %d, %Y, %I:%M %p
   Edit    Delete    topbottomEnable    1
   Edit    Delete    defaultMaxMembers    25

[InfoStrides]

I expanded all "_settings" to check all variables inside but could not see anything like "smfVersion"

[Kill Em All]

Would you mind sending me login details for phpmyadmin for me to take a look at your database.

http://www.simplemachines.org/community/index.php?topic=87130.0