vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - Cron based e-mail sending (https://vborg.vbsupport.ru/showthread.php?t=201318)

vwdforum 10-24-2009 01:49 PM

Quote:

Originally Posted by Paul M (Post 1902857)
If you dont get an error message then there isnt much i can tell you - it sounds like your server is unable to send mail. Have you tried this in the diagnostics ?

JFYI, Im about to go on holiday, so I may not actually see your reply until the end of next week.

Hope you enjoy your holidays!

I'm pulling my hair out now, I am able to send emails via the diagnostic test email, also, the standard emails are being sent out (like password reminder, new member etc)

Any suggestions please, your help is appreciated

alla n1015 10-26-2009 05:42 PM

Just wondering if there is any way to test this module?
I see that there is a 'test' selection on the send email to user, but no ideas if that tests this module?

Allan

BOWZONE 10-27-2009 12:50 PM

Great mod! Been using this since last year on 3.7...Upgraded to 3.8 and forgot to upgrade to the newest version...OOPS! Hope my ISP doesn't catch my email blast of many thousands of emails this morning.

**INSTALLED!!!**...and upgraded...

ChopSuey 10-27-2009 03:34 PM

So awesome this works fine =] Thanks
*installed /nominated

alla n1015 11-07-2009 03:55 PM

Any Ideas on how to test this? If I select a thousand members, and hit send, I dont want to actually send mail to 1000 members, before making sure this works.

Paul M 11-07-2009 07:20 PM

Quote:

Originally Posted by vwdforum (Post 1905573)
Any suggestions please, your help is appreciated

Sorry, there is nothing else i can suggest, it would need server access to start tracing what your server is (or isnt) doing.

len backus 11-07-2009 07:56 PM

Hi Paul,

I've been getting frequent database errors that reference "mailqueue":
Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE datastore SET
data = data - 49,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, November 7th 2009 @ 07:40:22 AM
Error Date : Saturday, November 7th 2009 @ 07:40:57 AM
Script : http://www.longrangehunting.com/foru...and=1257597618
Referrer : http://www.longrangehunting.com/forums/
IP Address : 173.73.121.35
Username : Unregistered
Classname : vB_Database
MySQL Version :
Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE datastore SET
data = data - 5,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, November 7th 2009 @ 09:00:24 AM
Error Date : Saturday, November 7th 2009 @ 09:00:45 AM
Script : http://www.longrangehunting.com/foru...hp?rand=147496
Referrer : http://www.longrangehunting.com/arti...enance-2-3.php
IP Address : 98.125.108.202
Username : Unregistered
Classname : vB_Database
MySQL Version :
These are just 2 that came in this morning. There have been at least 2 each day. I submitted a support ticket to my server techs (ServInt VPS) and it was suggested that it isn't a MySQL server error:
Quote:

This seems to be an SQL error as opposed to a MySQL server error. Check the script or the SQL query you're running. Also, try to run a similar query manually to verify if this is a SQL error.
I may be able to run a query with more guidance. I thought I'd check with you first and if there is a specific query I should run, you could guide me.

Thanks.

Paul M 11-07-2009 08:26 PM

Its very much a MySQL error - MySQL server has gone away is a bit of a give away ;)

It means that the mysql connection has closed, almost certainly because its timed out - suggesting that MYSQL on your server has a very low timeout setting (Wait Timeout).

len backus 11-07-2009 08:53 PM

That's what I thought and discussed that with them several days ago. Different tech. I'll ask for the other techie and see if it can be resolved. Thanks for your response.

alla n1015 11-07-2009 10:38 PM

For testing I have modified email.php to put the To address to a dedicated account
and modified the message body to add the address it would have gone to.
This way I can run some samples and validate everything, the timings etc.

Call me stupid but i cant figure out hwo to drop the cron timing from once every 10m to once every 1m ?

Help?

Update - Never mind, found it under Schedule Task Manager


All times are GMT. The time now is 07:23 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01440 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete