RE: Email not being sent

[Andrew Berman]

Sorry, that last error was on line '1134' of script 'c:\htdocs\eventum\include\class.issue.php'.


	-----Original Message----- 
	From: Berman, Andrew 
	Sent: Wed 6/2/2004 5:15 PM 
	To: Joao Prado Maia; [e-mail] 
	Cc: 
	Subject: RE: Email not being sent
	
	

	Here's one more error:
	
	'DB Error: syntax error'
	
	A more detailed error message follows:
	
	'UPDATE
	                    eventum.eventum_issue
	                 SET
	                    iss_updated_date='2004-06-02 21:09:01',
	                    iss_prc_id=4,
	                    iss_pri_id=1,
	                    iss_sta_id=,
	                    iss_res_id=0,
	                    iss_summary='Test',
	                    iss_description='Test ewewfwef',
	                    iss_dev_time=0,
	                    iss_trigger_reminders=1
	                 WHERE
	                    iss_id=1 [nativecode=1064 ** You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '
	                    iss_res_id=0,
	                    iss_summ]'
	
	--Andrew
	
	        -----Original Message-----
	        From: Joao Prado Maia [mailto:jpm@stripped]
	        Sent: Wed 6/2/2004 3:07 PM
	        To: [e-mail]
	        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=aberman@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.