News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Problem with email

Started by InfoStrides, May 31, 2010, 05:04:12 PM

Previous topic - Next topic

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



My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

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.
Freelance writer and advocate for security, privacy & DRM-free distribution
Support and Community Management at SMFNew Free Forum Hosting

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...
Freelance writer and advocate for security, privacy & DRM-free distribution
Support and Community Management at SMFNew Free Forum Hosting

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.


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

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.


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

InfoStrides

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

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?


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

InfoStrides

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!

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.


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

InfoStrides

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?

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.


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

InfoStrides

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.

Kill Em All

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


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

InfoStrides

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'

Advertisement: