Whitescreen after join

[pastvne]

Hi Guys:
I have a fabrik site that I developed on a shared linux server. All is working athough I'm wrestling with some performance issues. I purchased a VPS cloud server from my hosting company and used Akeeba to backup the site and move it to the new VPS server.

The site is up and working in most respects but I have one issue with my large list when it is view unfiltered. Basically, it goes off to fetch and then in about three seconds it whitescreens and never comes back. I turned on FabrikDebug and I'm getting this which I think indicates that the process is failing during the join. I've watched the linux top listing and I'm nowhere close to full on memory, disk or CPU.



[fieldset]renderost
Array
(
)
joins
Array
(
[0] => stdClass Object
(
[id] => 124
[list_id] => 0
[element_id] => 776
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 65
[params] => {"join-label":"document_id","type":"element","pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes
[keytable] => bpi_edoc_document_control
)

[1] => stdClass Object
(
[id] => 243
[list_id] => 37
[element_id] => 0
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes_0
[keytable] => bpi_edoc_document_control
)

[2] => stdClass Object
(
[id] => 263
[list_id] => 0
[element_id] => 1290
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => bpi_edoc_roles
[table_key] => role
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"description","type":"element","pk":"`bpi_edoc_roles`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_roles
[keytable] => bpi_edoc_doctypes_0
)

[3] => stdClass Object
(
[id] => 266
[list_id] => 0
[element_id] => 1291
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => jos_content
[table_key] => template
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"title","type":"element","pk":"`jos_content`.`id`"}
[canUse] => 1
[table_join_alias] => jos_content
[keytable] => bpi_edoc_doctypes_0
)

)
joins
Array
(
[0] => stdClass Object
(
[id] => 124
[list_id] => 0
[element_id] => 776
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 65
[params] => {"join-label":"document_id","type":"element","pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes
[keytable] => bpi_edoc_document_control
)

[1] => stdClass Object
(
[id] => 243
[list_id] => 37
[element_id] => 0
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes_0
[keytable] => bpi_edoc_document_control
)

[2] => stdClass Object
(
[id] => 263
[list_id] => 0
[element_id] => 1290
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => bpi_edoc_roles
[table_key] => role
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"description","type":"element","pk":"`bpi_edoc_roles`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_roles
[keytable] => bpi_edoc_doctypes_0
)

[3] => stdClass Object
(
[id] => 266
[list_id] => 0
[element_id] => 1291
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => jos_content
[table_key] => template
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"title","type":"element","pk":"`jos_content`.`id`"}
[canUse] => 1
[table_join_alias] => jos_content
[keytable] => bpi_edoc_doctypes_0
)

)
filter array: after querystring filters
Array
(
)
filter array: after session filters
Array
(
)
filter array: search form
Array
(
)
filter array: before onGetPostFilter
Array
(
)
filter array: after onGetPostFilter
Array
(
)
filter array: after getpostfilters
Array
(
)
filter array
Array
(
)
filter array: after access taken into account
Array
(
)
filter:request
Array
(
)
prefilters
Array
(
)
filter:request keys
Array
(
)
tablemodel::getFilterArray middle
Array
(
)
table:mergeJoinedData get ids
SELECT DISTINCT `bpi_edoc_document_control`.`id` AS __pk_val0, `bpi_edoc_doctypes`.`id` AS __pk_val1 FROM `bpi_edoc_document_control` LEFT JOIN `bpi_edoc_doctypes` AS `bpi_edoc_doctypes` ON `bpi_edoc_doctypes`.`id` = `bpi_edoc_document_control`.`doc_type` LEFT JOIN `bpi_edoc_doctypes` AS `bpi_edoc_doctypes_0` ON `bpi_edoc_doctypes_0`.`id` = `bpi_edoc_document_control`.`doc_type` LEFT JOIN `bpi_edoc_roles` AS `bpi_edoc_roles` ON `bpi_edoc_roles`.`id` = `bpi_edoc_doctypes_0`.`role` LEFT JOIN `jos_content` AS `jos_content` ON `jos_content`.`id` = `bpi_edoc_doctypes_0`.`template` ORDER BY `bpi_edoc_document_control`.`id` DESC[/fieldset]




and that's where it stops...

 

[pastvne]

I've re-checked php.ini settings. working server max_memory = 768M and new non-working server is 128MB. I thought PHP would compain about memory exceeded if we hit a php memory limit but I'm going to update the new server's php.ini and try again. Will report result.

 

[pastvne]

Problem was new hosting co hadn't properly configure suPhP so my php.ini file was not executing leaving default values and insufficient memory. Not sure why PHP didn't complain as it usually does that memory allocation was exceeded but this appears to have solved the issue once we got the php.ini to properly read. Also, noting that a list that was pointing to the same MySQL table but with filters to reduce the result set worked properly while the unfiltered list failed with whitescreen. Documenting this behavior here in case anyone else runs into this. Closing thread.