List:Eventum General Discussion« Previous MessageNext Message »
From:Andrew Berman Date:June 2 2004 9:01pm
Subject:RE: Email not being sent
View as plain text  
Ok, running the PHP script did the trick in sending the emails.  However, all the emails are error emails.  The following errors are trying to be sent to me since I filled in my address as the one to send with all the errors:
 
1.
 
An error was found at 06/02/2004 20:52:11 (1086209531) on line '70' of script 'c
:\htdocs\eventum\include\class.authorized_replier.php'.
The error message passed to us was:
'DB Error: no such table'
A more detailed error message follows:
'SELECT
                    iur_id,
                    iur_usr_id,
                    usr_email,
                    if (iur_usr_id = '1', iur_email, usr_full_name) replier,
                    if (iur_usr_id = '1', 'other', 'user') replier_type
                 FROM
                    eventum.eventum_issue_user_replier,
                    eventum.eventum_user
                 WHERE
                    iur_iss_id=1 AND
                    iur_usr_id=usr_id [nativecode=1146 ** Table 'eventum.eventum
_issue_user_replier' doesn't exist]'
That happened on page '/eventum/view.php' from IP Address '172.17.34.110' coming
 from the page (referrer) 'http://appmgr.itservices.icfconsulting.com/eventum/li
st.php'.
Sincerely yours,
Automated Error_Handler Class
 
2.
 
An error was found at 06/02/2004 20:52:11 (1086209531) on line '283' of script '
c:\htdocs\eventum\include\class.authorized_replier.php'.
The error message passed to us was:
'DB Error: no such table'
A more detailed error message follows:
'SELECT
                    count(iur_id)
                 FROM
                    eventum.eventum_issue_user_replier
                 WHERE
                    iur_iss_id = 1 AND
                    iur_usr_id = 2 [nativecode=1146 ** Table 'eventum.eventum_is
sue_user_replier' doesn't exist]'
That happened on page '/eventum/view.php' from IP Address '172.17.34.110' coming
 from the page (referrer) 'http://appmgr.itservices.icfconsulting.com/eventum/li
st.php'.
Sincerely yours,
Automated Error_Handler Class
 
 

	-----Original Message----- 
	From: Joao Prado Maia [mailto:jpm@stripped] 
	Sent: Wed 6/2/2004 3:07 PM 
	To: eventum-users@stripped 
	Cc: 
	Subject: RE: Email not being sent
	
	

	Andrew,
	
	> I setup Eventum and configured it to use the proper SMTP server
	> but it is not sending email notifications to the recipients.  I
	> checked the SMTP server logs and I see nothing so it does not
	> appear to be sending anything.  Is there something I'm missing? 
	> Is this functionality working?
	> 
	
	Yes, the current bitkeeper snapshot has a new feature that queues the outgoing emails in a separate table, and requires a cron job to run a script to process that mail queue. Please check and confirm that your outgoing emails are being stored in the eventum_mail_queue table.
	
	I'm in the middle of writing up some documentation on this, but this is the important bits on your case:
	
	==================== // ====================
	1)- Mail Queue Process (misc/process_mail_queue.php)
	
	Beginning with the first release of Eventum, emails are not directly sent out
	from the various scripts, but rather added to a mail queue table that is
	processed by a cron job. If an email cannot be sent, it will be marked as such
	in the mail queue log, and the cron job script will re-try to send it again the
	next time it runs.
	
	* * * * * cd /path-to-eventum/misc; /usr/bin/php -q process_mail_queue.php
	
	The above line will run the mail queue script every minute. To setup the SMTP
	server that Eventum should use to send these queued emails, go to:
	
	 Administration >>> General Setup > SMTP (Outgoing Email) Settings
	
	==================== // ====================
	
	Please let me know if that works for you.
	
	> Also, I have fixed a couple JavaScript errors and wanted to know
	> if you would like those fixes.
	> 
	
	Yes, please send the fixes over as patches. Or you could just tell me where the errors are and I'll fix them myself.
	
	--Joao
	
	
	--
	Eventum Users Mailing List
	For list archives: http://lists.mysql.com/eventum-users
	To unsubscribe:    http://lists.mysql.com/eventum-users?unsub=1erman@stripped
	
	


NOTICE:
This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited.
Thread
Email not being sentAndrew Berman2 Jun
RE: Email not being sentJoao Prado Maia2 Jun
RE: Email not being sentAndrew Berman2 Jun
RE: Email not being sentAndrew Berman2 Jun
RE: Email not being sentAndrew Berman2 Jun
RE: Email not being sentAndrew Berman2 Jun
RE: Email not being sentJoao Prado Maia2 Jun
RE: Email not being sentJoao Prado Maia2 Jun
RE: Email not being sentJoao Prado Maia2 Jun
RE: Email not being sentAndrew Berman2 Jun
RE: Email not being sentJoao Prado Maia3 Jun