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:jp...@mysql.com] Sent: Wed 6/2/2004 3:07 PM To: even...@lists.mysql.com Cc: Subject: RE: Email not being sent

Andrew,

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.

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