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? (http://docs.simplemachines.org/index.php?topic=856.0)
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'
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.
Quote from: Kill Em All on June 17, 2010, 07:45:22 PM
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.
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.
Quote from: Kill Em All on June 18, 2010, 01:35:46 AM
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.
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.
Quote from: Kill Em All on June 19, 2010, 02:56:09 PM
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"
Quote
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
I expanded all "_settings" to check all variables inside but could not see anything like "smfVersion"
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