Blank page on saving changes to a record after server migration

[marcuscherry]

I have migrated my installation of sugar across to a new server from a shared hosting environment to a virtual private server.

Everything seems to work ok - I can view records, search etc.. - but I can't save changes to any records in any of the modules.

I can edit records but then when I click save I just get a blank page with the standard tabs and sidebar. The changes are not saved if I then go into the record again.

All files are set to permission 755 and all set to the correct owner and group.

System setup is:
Sugar version 5.1.0a
Apache version 2.0.63
PHP version 5.2.8
MySQL version 5.0.67-community
Architecture x86_64
Operating system Linux

ANy help would be very much appreciated.

thanks

Marcus

[JVWay]

Sometimes this happens due to missing fields in the database. I do a lot of development and with source code control the db sometimes gets out of synch and there are missing custom fields.

If you've customized Sugar, I would look into the db and see if your _cstm tables are there and have the right fields.

[gdoss]

First, php 5.2.8 is not supported for SugarCRM 5.1. PHP 5.2.8 support does not kick in until 5.2a, so that may be the issue. You should roll back to php 5.2.6 to meet the 5.1 standards. Did your previous setup have the exact same server specs?

http://www.sugarcrm.com/crm/products...tforms/51.html

Also, since you are getting a blank page it is likely an error is being suppressed, which it should be for a production environment. However this is hiding problems. Check your /var/log/httpd/error_log (or ssl_error_log if you are running ssl) and see what errors show.

You may need to adjust your php error settings in /etc/php.ini. Restart httpd if you do make any changes to this file. The following should be suitable.
error_reporting = E_ALL & ~E_NOTICE

Also, you mention your OS as Linux, but providing the specific distro version could be more useful (eg, CentOS 5.3 or Ubuntu 8.04 LTS server) since distros customize their packages.

[marcuscherry]

Thanks for the help guys. I've tried reimporting the database from a fresh dump and have checked the custom tables - they all look identical. I don't think this is the issue.

I'm using CentOS 5.3 - the server setup is not identical to the previous server.

I've rolled back to 5.2.6 now and changed the php config to display errors. Error I get is:

Fatal error: Call to undefined function mb_substr() in /home/cpi/public_html/sugarcrm/include/database/DBManager.php on line 1725.

No idea what this means.

[gdoss]

I believe your server is missing the package php-mbstring. Install that and see if that works.

[marcuscherry]

Yes that's it - managed to work that out.

Now I've done that, it works.

The next issue is that the only way I can make the dashlets work is by changing the cache file permissions to 777.

For some reason they don't work when set to 755 - I'm pretty sure I've got the owner and group set correctly.

What should the owner, group and permissions be set to?

[gdoss]

Great. Glad we got the first part fixed for you.

Apache must be able to write to all files and directories, so I'd guess apache is unable to write to the cache directory in 755 mode. Here is where you should check and answer these questions:
In the SugarCRM directory, what are your user and group set as? Are there files/directories that are set differently than others?

What does apache run as for user (found in /etc/httpd/conf/http.conf)? These must match on the user level to run as 755. The default for apache in CentOS for user and group is apache.

If your user is apache for your SugarCRM files, and apache runs as user apache, writing to all files/directories in SugarCRM should not be a problem.

[marcuscherry]

Great! It's all working fine!

Thanks so much for the help.