Internal Server Error - cant get more info

[Crank]

Hello

I'm running SugarCRM Version 5.0.0b (Build 3150)
It was running perfectly unless yesterday. I've managed to install it, to add all required contacts and calls...
But today I get Internal Server Error while trying to enter Calendar or Accounts pages.
I looked into sugarcrm.log file and found nothing specific about that error:

Thu Mar 13 10:23:43 2008,423 [9015] FATAL SugarCRM - +7 (495) xxxx-xxxx
Thu Mar 13 10:23:43 2008,454 [9015] FATAL SugarCRM - +74955xxxxxxxx
Thu Mar 13 10:24:16 2008,952 [11203] FATAL SugarCRM - +7 (495) xxx-xxxx
Thu Mar 13 10:24:16 2008,953 [11203] FATAL SugarCRM - +749555555555
Thu Mar 13 10:27:32 2008,069 [18969] FATAL SugarCRM - +375 29x xxxxxxx


First I tried to change log4php so it could put ERROR level messages in errors.log
The file was created but it was empty after error.
I've changed log4php so that it would put DEBUG level messages in a new file.
And to be honest I didn't find the reason for crash again - pls see my log below.
Folks, is there any way I could find out what is the real root cause of the problem?

PS
Recently my hosting provider was upgrading my Linux box to the latest stable Deb - not sure if this could affect the situation anyhow.


Log4php config:
log4php.appender.A2=LoggerAppenderRollingFile
log4php.appender.A2.MaxFileSize=10MB
log4php.appender.A2.MaxBackupIndex=5
log4php.appender.A2.layout=LoggerLayoutTTCC
log4php.appender.A2.layout.ContextPrinting="true"
log4php.appender.A2.layout.DateFormat="%c"
log4php.appender.A2.File=./main_.log

//log4php.rootLogger=fatal, A2
//log4php.rootLogger=error, A2
//log4php.rootLogger=warn, A2
//log4php.rootLogger=info, A2
log4php.rootLogger=debug, A2


Here's an excerpt from log file
Fri Mar 14 04:47:26 2008,027 [4195] DEBUG SugarCRM - No VarDef Label For time_start in module Calls
Fri Mar 14 04:47:26 2008,034 [4195] DEBUG SugarCRM - No VarDef Label For time_start in module Calls
Fri Mar 14 04:47:26 2008,045 [4195] DEBUG SugarCRM - Loading Preferences DB demichev
Fri Mar 14 04:47:26 2008,046 [4195] INFO SugarCRM - Query:SELECT contents FROM user_preferences WHERE assigned_user_id='f396f495-8d3e-ff36-4f05-47d1a0aab71f' AND category = 'Calendar' AND deleted = 0
Fri Mar 14 04:47:26 2008,047 [4195] INFO SugarCRM - Query Execution Time:0.000669
Fri Mar 14 04:47:26 2008,049 [4195] DEBUG SugarCRM - Loading Preferences DB demichev
Fri Mar 14 04:47:26 2008,050 [4195] INFO SugarCRM - Query:SELECT contents FROM user_preferences WHERE assigned_user_id='f396f495-8d3e-ff36-4f05-47d1a0aab71f' AND category = 'Calendar2_TASK' AND deleted = 0
Fri Mar 14 04:47:26 2008,050 [4195] INFO SugarCRM - Query Execution Time:0.000261
Fri Mar 14 04:47:26 2008,051 [4195] DEBUG SugarCRM - Limit Query: SELECT tasks.id , tasks.status , tasks.name , tasks.date_due , tasks.assigned_user_id FROM tasks where ((tasks.assigned_user_id='f396f495-8d3e-ff36-4f05-47d1a0aab71f' and tasks.status<>'Completed' and tasks.status<>'Deferred'and (tasks.date_start is NULL or tasks.date_start <= '2008-03-15 23:59:59'))) AND tasks.deleted=0 Start: 0 count: 21
Fri Mar 14 04:47:26 2008,052 [4195] INFO SugarCRM - Query: SELECT tasks.id , tasks.status , tasks.name , tasks.date_due , tasks.assigned_user_id FROM tasks where ((tasks.assigned_user_id='f396f495-8d3e-ff36-4f05-47d1a0aab71f' and tasks.status<>'Completed' and tasks.status<>'Deferred'and (tasks.date_start is NULL or tasks.date_start <= '2008-03-15 23:59:59'))) AND tasks.deleted=0 LIMIT 0,21
Fri Mar 14 04:47:26 2008,052 [4195] INFO SugarCRM - Query Execution Time:0.000304

[Crank]

Some additional info

MySQL Version: 5.0.32
MySQL Host Info: xxxxxxxx via TCP/IP
MySQL Server Info: 5.0.32
MySQL Client Encoding: latin1

MySQL Character Set Settings
Variable Name Value
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8






PHP Version 4.4.8

System Linux infong 2.4 #1 SMP Wed Sep 26 00:19:50 CEST 2007 i686 GNU/Linux
Build Date Mar 6 2008 18:08:31
Configure Command '../configure' '--with-pear=/usr/lib/php' '--prefix=/usr' '--with-mysql=/usr/' '--with-zlib' '--enable-debug=no' '--enable-safe-mode=no' '--enable-discard-path=no' '--with-gd' '--with-png-dir' '--enable-track-vars' '--with-db' '--with-gdbm' '--enable-force-cgi-redirect' '--with-ttf' '--enable-ftp' '--with-mcrypt' '--enable-dbase' '--enable-memory-limit' '--enable-calendar' '--enable-wddx' '--with-jpeg-dir' '--enable-bcmath' '--enable-gd-imgstrttf' '--enable-shmop' '--enable-mhash' '--with-mhash' '--with-openssl' '--enable-xslt' '--with-xslt-sablot' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--with-imap' '--with-curl' '--with-iconv' '--with-freetype-dir' '--with-bz2' '--with-gettext' '--enable-exif' '--with-idn' '--enable-mbstring=all' '--with-kerberos' '--with-imap-ssl' '--with-sqlite' '--with-zip'
Server API CGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/lib/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.bzip2, compress.zlib

[Crank]

Could it be that some phone numbers may be the root cause of the problem?
Maybe something like +375 (29) 239-2928 ?

It looks like the system is not crashing until you click on the page with phone numbers - i.e. account details or calendar items...

[emanresu]

We've had a number of issues with Internal Server Errors but we reduced then significantly by moving from PHP Version 4.4.8 to PHP Version 5.2.5.

Don;t think 4.4.8 is supportted so it may be better to change