List:Eventum General Discussion« Previous MessageNext Message »
From:Stephen North Date:September 22 2008 10:14am
Subject:FW: A blank email has come into Eventum....
View as plain text  
Hi all,

Further to the problem I reported last week I have found the following:
Whilst the support_email table is getting an entry written, the
support_email_body table isn't getting an entry.

I looked in the error.log file and found that it was filling with horrid
errors....

If anybody has had similar problems and would be able to air their
opinions on the likely cause I would be eternally grateful.

Kind regards,

Steve North

****************
[Mon Sep 22 11:04:34 2008] An error was found on line '1066' of script
'C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.support.
php'.

The error message passed to us was:

'DB Error: unknown error'

A more detailed error message follows:

'INSERT INTO
                        eventum.eventum_support_email_body
                     (
                        seb_sup_id,
                        seb_body,
                        seb_full_email
                     ) VALUES (
                        1013,
                        'From: Receivables Management/Open Item
Management/Open Items/ Maintain\r\nItems - Debit Note\r\n\r\n \r\n\r\nIf
you maintain a Debit note the system is prompting you for a
terms\r\ncode.  This is incorrect as Debit notes do not age.  Please
find\r\nattached an example of maintaining a credit note which is how
the debit\r\nnote should operate.\r\n\r\n \r\n\r\nThanks\r\n\r\n
\r\n\r\nLorraine\r\n\r\n \r\n\r\nChallenge Finance Limited\r\n\r\nReg
Office: 2 Webbs Court, Buckhurst Avenue, Sevenoaks, Kent TN13
1LZ\r\nTelephone:  01732 454676  Fax:  01732 455904  Reg. No:
04086089\r\nWeb:
http://www.challengefinance.co.uk\r\n<blocked::blocked::http://www.chall
engefinance.co.uk/> \r\n\r\nPrivileged/Confidential information m' ...
[nativecode=2006 ** MySQL server has gone away]

A backtrace is available:

C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.support.
php:671
  Support::insertEmail((array )Array, Object stdClass, (integer )1013)
C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\misc\download_emails.p
hp:141
  Support::getEmailInfo((resource )Resource id #81, (array )Array,
(integer )67)


[Mon Sep 22 11:04:34 2008] An error was found on line '427' of script
'C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.user.php
'.

The error message passed to us was:

'DB Error: no database selected'

A more detailed error message follows:

'SELECT
                    usr_id
                 FROM
                    eventum.eventum_user
                 WHERE
                    usr_email='stephen.north@stripped'
[nativecode=2006 ** MySQL server has gone away]'

A backtrace is available:

C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.mail_que
ue.php:82
  User->getUserIDByEmail((string )'stephen.north@stripped')
C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.mail.php
:574
  Mail_Queue->add((string )'stephen.north@stripped', (array )Array,
(string )'Hello,

An error was found on line '1066' of script 'C:\Program Files\Apache
Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.support.
php'.

The error message passed to us was:

'DB Error: unknown error'

A more detailed error message follows:

'INSERT INTO
                        eventum.eventum_support_email_body
                     (
                        seb_sup_id,
                        seb_body,
                        seb_full_email
                     ) VALUES (
                        1013,
                        'From: Receivables Management/Open Item
Management/Open Items/ Maintain\r\nItems - Debit Note\r\n\r\n \r\n\r\nIf
you maintain a Debit note the system is prompting you for a
terms\r\ncode.  This is incorrect as Debit notes do not age.  Please
find\r\nattached an example of maintaining a credit note which is how
the debit\r\nnote should operate.\r\n\r\n \r\n\r\nThanks\r\n\r\n
\r\n\r\nLorraine\r\n\r\n \r\n\r\nChallenge Finance Limited\r\n\r\nReg
Office: 2 '..., (integer )0, true, (string )'error', true, true)
C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.error_ha
ndler.php:127
  Mail_API->send((string )'sbssupport@stripped', (string
)'stephen.north@stripped', (string )'Eventum - Error found! -
09/22/2008 11:04:34', (integer )0, true, (string )'error')
C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.error_ha
ndler.php:75
  Error_Handler::_notify((string )'An error was found on line '1066' of
script 'C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\Eventum\eventum-2.1.1\include\class.support.
php'.

The error message passed to us was:

'DB Error: unknown error'



-----Original Message-----
From: Stephen North 
Sent: 19 September 2008 16:32
To: 'Jorey Bump'; Eventum Users Support List
Subject: RE: A blank email has come into Eventum....



Yes, in outlook and when it arrived at hotmail it viewed fine and the
PDF attachment was fine, everything is fine.  The only time you'd know
there was a problem with it is when its in 'associate emails' within
eventum where it is blank.  It was bought to my attention by a user who
tried to create an issue with it and on the create issue screen the
subject and body were blank.  I then tried to open the email in
associate emails and it was blank there also.  And when she created an
issue with it, although it shows as being associated in the associate
emails screen, when you view the issue there is no associated email at
the bottom! (thanks for your reply). 

-----Original Message-----
From: Jorey Bump [mailto:list@stripped] 
Sent: 19 September 2008 16:26
To: Eventum Users Support List
Subject: Re: A blank email has come into Eventum....

Stephen North wrote, at 09/19/2008 09:55 AM:

> I have got an email in Outlook from an external user, and when it was
> swept into Eventum it has come across as empty and without the
> attachment (although it still shows a paper clip).
> 
> I couldn't understand why, so I forwarded the email to my hotmail
> account, then sent it back to my support email account, and it was
swept
> into Eventum.  But again it has come in as blank !?

Without forwarding it, can you look at the message in your support email
account using an ordinary email client (like Thunderbird)? If so, does
it display anything?





-- 
Eventum Users Mailing List
For list archives: http://lists.mysql.com/eventum-users
To unsubscribe:
http://lists.mysql.com/eventum-users?unsub=1




This mail was sent via Mail-SeCure System.


Thread
FW: A blank email has come into Eventum....Stephen North22 Sep