Unable to view leads, contacts, accounts etc after creation

[mylspace]

Hi,

We recently upgraded to sugar pro 6.2.1. Im getting HTTP Error 500 (Internal Server Error) page after creating new leads, accounts, contacts etc from the modules located in standard navigation menu (ok when created using icons located at top of page). I then navigate to dashboard for leads list, for example, and can see newly created lead but cannot view it - sugar dialogue says: "Error retrieving record. This record may be deleted or you may not be authorized to view it."

php test file loads ok https://www.domain.com/test.php

fyi - sugar instance is running under https. i edited .htaccess file located in public_html and added following lines:

RewriteEngine on

RewriteCond %{HTTPS} !=on
RewriteRule .* https://www.domain.com%{REQUEST_URI} [R,L]

I've also tried deleting ssl host and removing above lines from .htaccess, no resolution.

I figured this was a permissions issue, so i changed permissions as per kb documentation:

0775 on directories and sub-directories, 0664 on files for following:

config.php
config_override.php
sugarcrmlog.php
/cache
/custom
/data
/modules

restarted apache, issue remains.

No relevant errors in cpanel logs. I've attached recent raw apache log generated from steps described above.

What other files and directories should I check permissions for?..

Thanks in advance.

[andopes]

Make sure php.ini is configured in order to log errors. Additionally let us know the content of apache error log.

Cheers

[mylspace]

Ok. I enabled php error display and had a closer look at apache logs. when attempting to create a new lead, contact or account - I get error below or similar on screen:

HTTP/1.1 200 OK Date: Wed, 07 Sep 2011 01:42:10 GMT Server: Apache Expires: Thu, 19 Nov 1981
08:52:00 GMT Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache Set-Cookie: ck_login_id_20=1; expires=Tue, 06-Dec-2011 01:42:10 GMT; path=/;
domain=www.domain.com Set-Cookie: ck_login_language_20=en_us; expires=Tue, 06-
Dec-2011 01:42:10 GMT; path=/; domain=www.domain.com Set-Cookie:
sugar_user_theme=Sugar; expires=Thu, 06-Sep-2012 01:42:10 GMT Keep-Alive: timeout=5, max=99
Connection: Keep-Alive Transfer-Encoding: chunked Content-Type: text/html; charset=UTF-8 f72b
Warning: apc_store() [function.apc-store]: Potential cache slam averted for key
'5a09c533fd01a448faf5de72403b36b3LanguageManager.L eads.en_us' in/home/filepath/
public_html/include/SugarCache/SugarCacheAPC.php on line 62

I could see the errors mentioned apc - we have apc module enabled in our php. so i added the following to config_override.php but it didn't resolve issue.

$GLOBALS['sugar_config']['external_cache_disabled'] = true;

Also run Admin->Repair->Quick Repair and Rebuild. It looks as though the function did not complete - see attached file. This just led to totally blank pages when i navigated away from this admin page. I had to restore sugar to a backup version.

With regard to apache errors, I can see the following:

[Sat Sep 10 07:04:44 2011] [warn] RSA server certificate CommonName (CN) `www.domain.com' does NOT match server name!?

Any thoughts?