Deleting multiple records result in a blank screen and a just two record deletion

šŸ’¬ General Discussion
1

Hi everybody,
Iā€™m having some problem deleting multiple records.

I have the CRM empty, but 19 accounts which I want to delete in one single shot. I selected all of the accounts and clicked on the delete button, and, as a result, I got a blank screen. Where I reload the blank screen (just a cmd-R on my Mac), Iā€™m in the home. If I go to the accounts module again, I see 17 accounts, instead of 19.
Repeating the procedure, I found out that I can delete only two accounts at the timeā€¦ so to delete all the 19 accounts I had to do it 10 timesā€¦
Any Idea?

I take advantage of this to also make you aware that, if you import data (the 19 accounts) with the AOD enabled, the system stops with an error relating to many files openā€¦ It imports if AOD is disabledā€¦ (but this is another story)

Just to give you some extra info, this are my php settings from the phpinfo() function:

Core

PHP Version 5.5.14

Directive Local Value Master Value
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
disable_classes no value no value
disable_functions no value no value
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl Off Off
enable_post_data_reading On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 22527 22527
exit_on_timeout Off Off
expose_php On On
extension_dir /usr/lib/php/extensions/no-debug-non-zts-20121212 /usr/lib/php/extensions/no-debug-non-zts-20121212
file_uploads On On
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .: .:
log_errors On On
log_errors_max_len 1024 1024
mail.add_x_header On On
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 60 60
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 32M 32M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
report_memleaks On On
report_zend_debug On On
request_order GP GP
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 17 17
short_open_tag Off Off
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
sys_temp_dir no value no value
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 32M 32M
upload_tmp_dir no value no value
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
zend.detect_unicode On On
zend.enable_gc On On
zend.multibyte Off Off
zend.script_encoding no value no value

2

do you have any errors in the logs ? apache/sugarcrm.log ?

Regards,

3

I have no error in sugarcrm.log
On apacheā€™s error_log I found:

[Mon Oct 27 12:14:45.123412 2014] [:error] [pid 3935] [client 127.0.0.1:58349] PHP Warning: require_once(/Users/leonillo/Sites/suitecrm/modules/AOD_Index/Lib/Zend/Search/Lucene/Storage/File/Filesystem.php): failed to open stream: Too many open files in /Users/leonillo/Sites/suitecrm/modules/AOD_Index/Lib/Zend/Search/Lucene/Storage/Directory/Filesystem.php on line 349, referer: http://localhost/~leonillo/suitecrm/index.php?action=ajaxui

[Mon Oct 27 12:14:45.123519 2014] [:error] [pid 3935] [client 127.0.0.1:58349] PHP Fatal error: require_once(): Failed opening required ā€˜Zend/Search/Lucene/Storage/File/Filesystem.phpā€™ (include_path=ā€™/Users/leonillo/Sites/suitecrm:/Users/leonillo/Sites/suitecrm/include/HTMLPurifier/standalone:/Users/leonillo/Sites/suitecrm/include/ā€¦:.::modules/AOD_Index/Libā€™) in /Users/leonillo/Sites/suitecrm/modules/AOD_Index/Lib/Zend/Search/Lucene/Storage/Directory/Filesystem.php on line 349, referer: http://localhost/~leonillo/suitecrm/index.php?action=ajaxui

[Mon Oct 27 13:14:53.232000 2014] [:error] [pid 3947] [client 127.0.0.1:58362] PHP Notice: Undefined index: modlink in /Users/leonillo/Sites/suitecrm/themes/Suite7/css/colourSelector.php on line 72, referer: http://localhost/~leonillo/suitecrm/index.php?action=ajaxui

[Mon Oct 27 13:14:53.232158 2014] [:error] [pid 3947] [client 127.0.0.1:58362] PHP Notice: Undefined index: custom in /Users/leonillo/Sites/suitecrm/themes/Suite7/css/colourSelector.php on line 97, referer: http://localhost/~leonillo/suitecrm/index.php?action=ajaxui

There are two things I noticeā€¦ a PHP fatal error on AOD, and the wrong time in the log rows (it should be 13:14:45ā€¦). The rows before and after those two are all correct (in terms of time).

Thank you.

4

The first fatal error there looks like a restriction on the server. Eveery operating system only allows a certain number of open files, This refers to AOD which if turned off this would stop this from creating the error. the other thing you could do is try and extend the limit of the open files.

on a linux server you can check the number using ā€œulimit -nā€. you would need root access to increate this value.

The second error I am unsure why this is appearing, it might have something to do with the first issue.

is this the error which appears in the logs when you try and deleted the 19 accounts ?

Ian.