check mail does not work, new emails page is shown blank

[panoramia]

Dear Friends,
I've been using Suger CRM OS for a few months without touching anything, just a couple of new fields added, nothing more. I use SugarCRM OS 4.5.1d.

I configured my eamail in order to send/receive with pop/smtp configuration. It's been working for months without any problem.
And suddenly yesterda, I can't receive any emails. The emails are not downloaded from the server and shown when I click on "Check email now" on sugar. I get a blank page, where before I could see the list of emails on the inbox and the new ones. Now, this is not possible.

I check my email account from my cpanel and the emails are there, but they are not downloaded by sugarcrm, the page is blank when I click on check mail. I've not touched anything for months and suddenly I can't read the emails and the page with the new emails is blank. Why is that? How can I fix this please?

Thanks a million,
Alfonso Moreno

[tparson]

The first thing you might check is that your c-client files have not been wiped out during a c-panel update. It happens when apache is rebuilt without including c-client. While you are at it, other files that can disappear during an update are curl and mbstring, all of which impact Sugar.

The easiest way to check this is to go to "admin" in Sugar, go to "inbound mail" and select "monitor new mailbox". If the c-client files are gone you will see a warning in this screen.

Don't know if this is an answer but with mail issues, this is always the first thing to check.

Tracy

[panoramia]

Hi Tracy,
Thanks a lot for your answer. I really apprecaite it.

I did what you suggested and clicked on "Monitor new mailbox" but I got no warning message, so I guess the problem is not there this time. I'm just lost on what the problem's source might be

Warm regards,
Alfonso Moreno

[tparson]

Alfonso:

The next step is to take a look at your error logs and find all errors relating to this. Copy and paste them in the forum and remove any references to your server name.

Error logs are found in the main Sugar directory.

We'll get this figured out!

Tracy

[panoramia]

Dear Tracy,
Thanks for your kind answer again.
I've edited the error log and removed duplicates, since there were a lot of the same errors over and over.

Take a look at this here, can you tell me what might be wrong?

[03-Oct-2007 01:51:33] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[03-Oct-2007 04:31:00] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[03-Oct-2007 04:36:51] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[03-Oct-2007 05:43:24] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
[03-Oct-2007 05:46:00] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[03-Oct-2007 06:14:57] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[03-Oct-2007 06:48:34] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
[04-Oct-2007 04:33:01] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[04-Oct-2007 05:30:39] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
[04-Oct-2007 06:02:21] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
[08-Oct-2007 05:13:22] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[08-Oct-2007 15:45:06] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[10-Oct-2007 03:53:53] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
[10-Oct-2007 05:54:04] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[10-Oct-2007 06:38:54] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
[10-Oct-2007 11:43:02] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[11-Oct-2007 02:09:36] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[11-Oct-2007 02:35:43] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
ry '/usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin: cannot open shared object file: No such file or directory in Unknown on line 0
[12-Oct-2007 02:03:28] PHP Warning: Unknown(): Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin: cannot open shared object file: No such file or directory in Unknown on line 0
[12-Oct-2007 02:03:28] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[12-Oct-2007 02:03:28] PHP Warning: Unknown(): Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin: cannot open shared object file: No such file or directory in Unknown on line 0
[12-Oct-2007 02:03:38] PHP Warning: Unknown(): Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//etc/ixed/ixed.4.4.lin: cannot open shared object file: No such file or directory in Unknown on line 0
[15-Oct-2007 04:30:13] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[15-Oct-2007 05:09:21] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/cena6/public_html/crm/modules/Emails/Save.php on line 154
[17-Oct-2007 02:34:04] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[17-Oct-2007 04:52:13] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[17-Oct-2007 05:24:54] PHP Warning: Division by zero in /home/cena6/public_html/crm/data/SugarBean.php on line 3034
[17-Oct-2007 05:25:46] PHP Warning: Division by zero in /home/cena6/public_html/crm/data/SugarBean.php on line 3034
[17-Oct-2007 10:31:50] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499
[22-Oct-2007 02:06:26] PHP Warning: mysql_close(): 146 is not a valid MySQL-Link resource in /home/cena6/public_html/crm/include/database/MysqlManager.php on line 499


Thanks a million!
Warm regards,
Alfonso

[tparson]

Alfsonso:

I apologise for the delay but I have been away.

Can you please upgrade to 4.51g because based on what I can see here, this problem should be fixed by this upgrade.

Fingers crossed!

Tracy

[kenlyle]

The originally reported symptom happened to me, and the cause was that my host had upgraded to an unsupported PHP version.

Does v5 support PHP 5.2.4? Hoping...

Ken

[philipmartinjones]

Hi,

I am having a similar problem: Since earlier this week I have been unable to use the menu option 'Check My Mail' to collect new POP3 emails. When I click the button, after a short delay the screen goes blank. The page source is completely empty.

I have looked in the error logs and every time it is the same:

PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/accountname/public_html/subdirectory/modules/Emails/Save.php on line 164

Looking at the PHP file in question, the offending line is the 'if' statement halfway down this block:

//// handle legacy parent_id/parent_type relationship calls
elseif(isset($_REQUEST['parent_type']) && !empty($_REQUEST['parent_type']) && isset($_REQUEST['parent_id']) && !empty($_REQUEST['parent_id'])) {
//run linking code only if the object_id has not been linked as part of the contacts above
if(!in_array($_REQUEST['parent_id'],$exContactIds)){
$rel = strtolower($_REQUEST['parent_type']);
$focus->load_relationship($rel);
$focus->$rel->add($_REQUEST['parent_id']);
}
}

nb. (I have pasted 'accountname' and 'subdirectory' in place of real company names)

I was using 4.5.1g and tried upgrading to the latest patch Version 4.5.1h (Build 1104). There were a lot of files that need to be merged. I have not done so as I don't know where to start with this task.

We have two instances of sugar on the same hosting, running in separate subdirectories. Because of the hosting arrangements, php.ini is in the subdirectory.

Our hosting company configuration is:
Apache 1.3.39
PHP 5.0.0
MySQL 5.0.27-standard.log

Please can you help me resolve this,

Philip

[HolmesA]

Did you install any type of PHP caching or PHP accelerator? Check this by creating a simple phpinfo.php file:

<?php
phpinfo();
?>

Look for zend keyword and post it here.

Some PHP caching utilities are know to cause such a problem sometimes.

[philipmartinjones]

phpinfo returned a few references to zend:

1. Right at the top, under 'configure command' was the reference
./configure' '--prefix=/usr' '--with-config-file-path=/usr/local/Zend/etc5' '--with-xml' '--with-mm'

2. 'Zend extension' was 220040412

3. 'zend memory manager' was 'enabled'

4.At the bottom of the first section was a box containing the text:
This program makes use of the Zend Scripting Language Engine: Zend Engine v2.0.5, Copyright (c) 1998-2004 Zend Technologies

5. under the main header PHP core, report_zend_debug had the value 'on'

6. zend.ze1_compatibility_mode is 'off'

Do you think this is causing the problem with 'check mail' now constantly returning a white screen? If so, please can you advise what steps might overcome it.

Thanks very much,

Philip