MySQLTalk.org

A de Vries · Guest

Hallo All,

I have a Big problem with Eventum.
There are constandly errors popping up on the error log.
What i do is sent an email of a case with an Attachment or recieve emails
with attachments.
Downloading the file to the case goes fine but sending no way.
Also incomming emails with attachments become a ghost reccord, they are
completly empty and of no use.
I can read the emails on the email client no problems with the e-mail.
The email i send is also not found on the mail Queue instead it's found on
the error log....
Who can help solve the problem?, it looks like a MYSQL problem but what ?

This is a part of the error log

[Fri Dec 12 07:46:27 2008] An error was found on line '858' of script
'C:\xampp\htdocs\nosa\include\class.project.php'.

The error message passed to us was:

'DB Error: no database selected'

A more detailed error message follows:

'SELECT
usr_full_name,
usr_email
FROM
nosa.eventum_user,
nosa.eventum_project_user
WHERE
pru_prj_id=1 AND
pru_usr_id=usr_id AND
usr_status='active' AND
usr_id <> 1 AND (usr_customer_id IS NULL OR
usr_customer_id=0)
ORDER BY
usr_customer_id DESC,
usr_full_name ASC [nativecode=2006 ** MySQL server has
gone away]'

A backtrace is available:

C:\xampp\htdocs\nosa\include\class.project.php:807
Project::getAddressBookAssocList((integer )1, (string )'76')
C:\xampp\htdocs\nosa\send.php:173
Project::getAddressBook((integer )1, (string )'76')

[Fri Dec 12 07:46:27 2008] An error was found on line '307' of script
'C:\xampp\htdocs\nosa\include\class.email_response.php'.

The error message passed to us was:

'DB Error: no database selected'

A more detailed error message follows:

'SELECT
ere_id,
ere_title
FROM
nosa.eventum_email_response,
nosa.eventum_project_email_response
WHERE
per_ere_id=ere_id AND
per_prj_id=1
ORDER BY
ere_title ASC [nativecode=2006 ** MySQL server has gone
away]'

A backtrace is available:

C:\xampp\htdocs\nosa\send.php:177
Email_Response::getAssocList((integer )1)

Lukman Chow · Guest

Hi,
I encountered the same problem. It is not an eventum's problem but
rather MySQL's.
Try to increase the value of 'max_allowed_packet' in my.cnf to, let's say, 32M.

HTH.

Cheers,
Lukman