Fields disappearing in Studio when 'Save & Deploy'

[rgtft]

Using Sugar Version 5.1.0b (Build 4905) Community Edition on Linux with Apache, MySQL and PHP 5.2

I have added a large number of fields (aprox 100) on 10-12 panels in Studio for the Accounts module. Now, when I added a couple of more fields, some fields seem to randomly get removed from my DetailView or EditView (the behavior happens in both screens) when I click the 'Save & Deploy' button.

Have I hit some type of maximum number of fields?

Any idea why this might be?

I see two errors in the Apache error log (see below), these make me think I am trying to send too many fields. Is there something in the PHP.ini I need to increase? Is there an Apache setting that needs to be upped?

[Sun Feb 08 14:17:13 2009] [error] [client 192.168.38.5] ALERT - configured POST variable limit exceeded - dropped variable 'slot-12-8-label' (attacker '192.168.38.5', file '/srv/www/crm/index.php'), referer: http://crm.medadvgrp.com/index.php?m...w%3DDetailView

[Sun Feb 08 14:17:26 2009] [error] [client 192.168.38.5] PHP Notice: Undefined index: name in /srv/www/crm/modules/ModuleBuilder/parsers/views/GridLayoutMetaDataParser.php on line 483, referer: http://crm.medadvgrp.com/index.php?m...w%3DDetailView

[rgtft]

Using Sugar Version 5.1.0b (Build 4905) Community Edition on Linux with Apache, MySQL and PHP 5.2

I have added a large number of fields (aprox 100) on 10-12 panels in Studio for the Accounts module. Now, when I added a couple of more fields, some fields seem to randomly get removed from my DetailView or EditView (the behavior happens in both screens) when I click the 'Save & Deploy' button.

Have I hit some type of maximum number of fields?

Any idea why this might be?

I see two errors in the Apache error log (see below), these make me think I am trying to send too many fields. Is there something in the PHP.ini I need to increase? Is there an Apache setting that needs to be upped?

[Sun Feb 08 14:17:13 2009] [error] [client 192.168.38.5] ALERT - configured POST variable limit exceeded - dropped variable 'slot-12-8-label' (attacker '192.168.38.5', file '/srv/www/crm/index.php'), referer: http://crm.medadvgrp.com/index.php?m...w%3DDetailView

[Sun Feb 08 14:17:26 2009] [error] [client 192.168.38.5] PHP Notice: Undefined index: name in /srv/www/crm/modules/ModuleBuilder/parsers/views/GridLayoutMetaDataParser.php on line 483, referer: http://crm.medadvgrp.com/index.php?m...w%3DDetailView

I'm not sure if this is related or not, but I also seem to be getting this error (in the Apache error_log file):
[Sun Feb 08 20:27:16 2009] [error] [client 192.168.38.5] File does not exist: /srv/www/crm/pointer;, referer: http://crm.medadvgrp.com/index.php?m...ex&type=studio

I do not see a file /srv/www/crm/pointer on my system. Should there be one?

[crmsiva]

You can increase the post_max_size value in php.ini and check the problem exists or not.

[andopes]

Hi rgtft

I do not suggest to add hundreds of fields in the same module.
It affect the database performance.
A customer had requested some time ago to add 800 fields into Accounts module distributed over 16 panels.
So we created 16 simple modules (one for each panel) whose unique responsibility was to store those fields.
This way we linked the fields between the simple modules and the Accounts module.
The performance was not so good but we had no database issues or SugarCRM issues.

Kind regards

[rgtft]

You can increase the post_max_size value in php.ini and check the problem exists or not.

Increasing the post_max_size in didn't do the trick. It started at 30M and I incrementally upped it to 4096M (restarting the Apache server each time) with no change.

What did work was adding these lines to my php.ini and restarting apache:

[suhosin]
suhosin.post.max_vars = 2000
suhosin.request.max_vars = 1000

Apparently suhosin is a security project/app loaded on our SuSE box's apache web server.

[rgtft]

Hi rgtft
I do not suggest to add hundreds of fields in the same module.
It affect the database performance.
A customer had requested some time ago to add 800 fields into Accounts module distributed over 16 panels.
So we created 16 simple modules (one for each panel) whose unique responsibility was to store those fields.
This way we linked the fields between the simple modules and the Accounts module.

Andopes,

I was able to work around the POST variable limit exceeded problem. I do like your suggestion to create new modules to link to accounts. Do you have any suggestions on where to read up on how to do this?

Thank you,
Rob

[bquenneville]

Using Sugar Version 5.1.0b (Build 4905) Community Edition on Linux with Apache, MySQL and PHP 5.2

I have added a large number of fields (aprox 100) on 10-12 panels in Studio for the Accounts module. Now, when I added a couple of more fields, some fields seem to randomly get removed from my DetailView or EditView (the behavior happens in both screens) when I click the 'Save & Deploy' button.

Have I hit some type of maximum number of fields?

Any idea why this might be?

I see two errors in the Apache error log (see below), these make me think I am trying to send too many fields. Is there something in the PHP.ini I need to increase? Is there an Apache setting that needs to be upped?

[Sun Feb 08 14:17:13 2009] [error] [client 192.168.38.5] ALERT - configured POST variable limit exceeded - dropped variable 'slot-12-8-label' (attacker '192.168.38.5', file '/srv/www/crm/index.php'), referer: http://crm.medadvgrp.com/index.php?m...w%3DDetailView

[Sun Feb 08 14:17:26 2009] [error] [client 192.168.38.5] PHP Notice: Undefined index: name in /srv/www/crm/modules/ModuleBuilder/parsers/views/GridLayoutMetaDataParser.php on line 483, referer: http://crm.medadvgrp.com/index.php?m...w%3DDetailView

Find your suhosin setting (/etc/php5/apache2/conf.d/suhosin.ini) and uncomment(;) this 4 lines and set the value of each line to 1000 :

suhosin.cookie.max_vars = 1000
suhosin.get.max_vars = 1000
suhosin.post.max_vars = 1000
suhosin.request.max_vars = 1000

That works for me !