White Screen of Death for "Filter List Max" greater than 50,000

[xycofryx]

Fabrik: 3.8.1
Joomla: 3.8.6
Apache: 2.4.9
PHP: 7.1.15
MariaDB: 10.1.31
OpCache: 7.1.15

"php.ini" settings:

engine=On
short_open_tag=Off
precision=14
output_buffering=Off
zlib.output_compression=On
implicit_flush=Off
unserialize_callback_func=
serialize_precision=-1
disable_functions=
disable_classes=
zend.enable_gc=On
expose_php=On
max_execution_time=600
max_input_time=600
memory_limit=1G
error_reporting=E_ALL & ~E_DEPRECATED & ~E_STRICT
display_errors=On
display_startup_errors=On
log_errors=On
log_errors_max_len=1024
ignore_repeated_errors=Off
ignore_repeated_source=Off
report_memleaks=On
track_errors=On
html_errors=On
variables_order="GPCS"
request_order="GP"
register_argc_argv=Off
auto_globals_jit=On
post_max_size=100M
auto_prepend_file=
auto_append_file=
default_mimetype="text/html"
default_charset="UTF-8"
include_path=\xampp\php\PEAR
doc_root=
user_dir=
extension_dir="\xampp\php\ext"
enable_dl=Off
file_uploads=On
upload_tmp_dir="\xampp\tmp"
upload_max_filesize=100M
max_file_uploads=20
allow_url_fopen=On
allow_url_include=Off
default_socket_timeout=600
extension=php_bz2.dll
extension=php_curl.dll
extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
extension=php_mbstring.dll
extension=php_mysqli.dll
extension=php_pdo_mysql.dll
extension=php_pdo_sqlite.dll
zend_extension=php_opcache.dll
asp_tags=Off
display_startup_errors=On
track_errors=Off
y2k_compliance=On
allow_call_time_pass_reference=Off
safe_mode=Off
safe_mode_gid=Off
safe_mode_allowed_env_vars=PHP_
safe_mode_protected_env_vars=LD_LIBRARY_PATH
error_log="\xampp\php\logs\php_error_log"
register_globals=Off
register_long_arrays=Off
magic_quotes_gpc=Off
magic_quotes_runtime=Off
magic_quotes_sybase=Off
extension=php_openssl.dll
extension=php_ftp.dll
[CLI Server]
cli_server.color=On
[Date]
[filter]
[iconv]
[intl]
[sqlite3]
[Pcre]
[Pdo]
pdo_mysql.default_socket="MySQL"
[Pdo_mysql]
pdo_mysql.cache_size=2000
pdo_mysql.default_socket=
[Phar]
[mail function]
SMTP=localhost
smtp_port=25
mail.add_x_header=On
[SQL]
sql.safe_mode=Off
[ODBC]
odbc.allow_persistent=On
odbc.check_persistent=On
odbc.max_persistent=-1
odbc.max_links=-1
odbc.defaultlrl=4096
odbc.defaultbinmode=1
[Interbase]
ibase.allow_persistent=1
ibase.max_persistent=-1
ibase.max_links=-1
ibase.timestampformat="%Y-%m-%d %H:%M:%S"
ibase.dateformat="%Y-%m-%d"
ibase.timeformat="%H:%M:%S"
[MySQLi]
mysqli.max_persistent=-1
mysqli.allow_persistent=On
mysqli.max_links=-1
mysqli.cache_size=50000
mysqli.default_port=3306
mysqli.default_socket=
mysqli.default_host=
mysqli.default_user=
mysqli.default_pw=
mysqli.reconnect=Off
[mysqlnd]
mysqlnd.collect_statistics=On
mysqlnd.collect_memory_statistics=On
[OCI8]
[PostgreSQL]
pgsql.allow_persistent=On
pgsql.auto_reset_persistent=Off
pgsql.max_persistent=-1
pgsql.max_links=-1
pgsql.ignore_notice=0
pgsql.log_notice=0
[bcmath]
bcmath.scale=0
[browscap]
browscap="\xampp\php\extras\browscap.ini"
[Session]
session.save_handler=files
session.save_path="\xampp\tmp"
session.use_strict_mode=0
session.use_cookies=1
session.use_only_cookies=1
session.name=PHPSESSID
session.auto_start=0
session.cookie_lifetime=0
session.cookie_path=/
session.cookie_domain=
session.cookie_httponly=
session.serialize_handler=php
session.gc_probability=1
session.gc_divisor=1000
session.gc_maxlifetime=1440
session.referer_check=
session.cache_limiter=nocache
session.cache_expire=180
session.use_trans_sid=0
session.sid_length=26
session.trans_sid_tags="a=href,area=href,frame=src,form="
session.sid_bits_per_character=5
[Assertion]
zend.assertions=1
[COM]
[mbstring]
[gd]
[exif]
[Tidy]
tidy.clean_output=Off
[soap]
soap.wsdl_cache_enabled=1
soap.wsdl_cache_dir="/tmp"
soap.wsdl_cache_ttl=86400
soap.wsdl_cache_limit=5
[sysvshm]
[ldap]
ldap.max_links=-1
[mcrypt]
[dba]
[opcache]
opcache.enable=1
[curl]
curl.cainfo="\xampp\apache\bin\curl-ca-bundle.crt"
[openssl]
openssl.cafile="\xampp\apache\bin\curl-ca-bundle.crt"
[Syslog]
define_syslog_variables=Off
[Session]
define_syslog_variables=Off
[Date]
date.timezone=Europe/Berlin
[MySQL]
mysql.allow_local_infile=On
mysql.allow_persistent=On
mysql.cache_size=50000
mysql.max_persistent=-1
mysql.max_link=-1
mysql.default_port=3306
mysql.default_socket="MySQL"
mysql.connect_timeout=3
mysql.trace_mode=Off
[Sybase-CT]
sybct.allow_persistent=On
sybct.max_persistent=-1
sybct.max_links=-1
sybct.min_server_severity=10
sybct.min_client_severity=10
[MSSQL]
mssql.allow_persistent=On
mssql.max_persistent=-1
mssql.max_links=-1
mssql.min_error_severity=10
mssql.min_message_severity=10
mssql.compatability_mode=Off
mssql.secure_connection=Off

"my.ini" settings:

[client] 
port            = 3306 
socket          = "C:/XAMPP/mysql/mysql.sock"
[mysqld]
port= 3306
socket = "C:/XAMPP/mysql/mysql.sock"
basedir = "C:/XAMPP/mysql" 
tmpdir = "C:/XAMPP/tmp" 
datadir = "C:/XAMPP/mysql/data"
pid_file = "mysql.pid"
key_buffer = 16M
max_allowed_packet = 8M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"
plugin_dir = "C:/XAMPP/mysql/lib/plugin/" 
server-id    = 1
innodb_data_home_dir = "C:/XAMPP/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/XAMPP/mysql/data"
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

White Screen of Death occurs when setting it up to => 50,000. Is there any problem in my configuration? My head is going nuts on this one or better yet, is there a way to disable the Fabrik notice when setting it low for "Filter List Max" so I wouldn't have to set it so high?

 

[cheesegrits]

Well, that max is there so you don't make unconstrained queries, and it means that one of your filters is trying to build a dropdown of >50,000 entries, which isn't viable. If you set error reporting in J!'s global settings to max, do you get an actual error message, like memory limit?

You might consider using aut0complete, rather than dropdown as the filter method.

-- hugh

 

[xycofryx]

The error was:

Fatal error: Maximum execution time of 60 seconds exceeded in C:\XAMPP\htdocs\dops\components\com_fabrik\models\element.php on line 3695

1) The functionality of having multiple records to be filtered is a must. Any recommendations.
2) Can you kindly check if the "Casdacading Dropdown not filtering" bug has surfaced again.

Thank cheesegrits.

 

[cheesegrits]

Have you tried setting the "Filter data" in that element's filter settings to "Show All"? I think that filter limit only gets applied when you are using the "Recorded Data" method.

2) Can you kindly check if the "Casdacading Dropdown not filtering" bug has surfaced again.

Not sure which bug you mean. And my available time for checking on things in Community support is vanishingly small.

-- hugh

 

[xycofryx]

1) Yes it is a recorded data and I have set the "Show All" globally in the Fabrik configuration but to no avail.
2) I mean... in the list where filtering is set below the headers... filtering a cascading dropdown won't trigger if the database join filter with multi-select is selected as a filter.

Thanks cheesegrits for the unwavering support for the Fabrik community.

 

[xycofryx]

Update: Yes! "Show All" with > 50,000 "Filter List Max" does do the trick. without turning to WSOD. but still the the list filter for CDD dont work.

At least one step at a time I'm making progress with this one. Thanks cheesegrits.