Hello,
I have a large form that include several groups and elements. Works fine for insert/update but when i try to delete a row, i'm getting the message "PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes)"
I tried to increase the memory_limit value from 128M to 1GB, same problem.
When Fabrik debug is activated and i tried to edit an existing row and press the delete button, the debug shows:
running this query in database will return over a 1 milion rows..hence the memory limit. Adding a where condition like "where contracts_tool_servicii.id = 123456" will decrease the result to 10 rows.
My question is: where is the "where" condition?
Thank you
I have a large form that include several groups and elements. Works fine for insert/update but when i try to delete a row, i'm getting the message "PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes)"
I tried to increase the memory_limit value from 128M to 1GB, same problem.
When Fabrik debug is activated and i tried to edit an existing row and press the delete button, the debug shows:
Code:
....
table:mergeJoinedData get ids
SELECT distinct `contracts_tool_servicii`.`id` AS __pk_val0, `contracts_tool_servicii_1291_repeat`.`id` AS __pk_val1, `contracts_tool_servicii_1251_repeat`.`id` AS __pk_val2,
`contracts_tool_servicii_1250_repeat`.`id` AS __pk_val3, `contracts_tool_servicii_1265_repeat`.`id` AS __pk_val4 FROM `contracts_tool_servicii`
LEFT JOIN `contracte_setari_repeat_activeaza_abonament` AS `contracte_setari_repeat_activeaza_abonament` ON `contracte_setari_repeat_activeaza_abonament`.`activeaza_abonament` = `contracts_tool_servicii`.`abonament_bundle`
LEFT JOIN `contracte_setari_753_repeat` AS `contracte_setari_753_repeat` ON `contracte_setari_753_repeat`.`id` = `contracts_tool_servicii`.`optiuni_clasa`
LEFT JOIN `contracte_setari_739_repeat` AS `contracte_setari_739_repeat` ON `contracte_setari_739_repeat`.`parent_id` = `contracts_tool_servicii`.`abonament`
LEFT JOIN `contracte_setari_739_repeat` AS `contracte_setari_739_repeat_0` ON `contracte_setari_739_repeat_0`.`parent_id` = `contracts_tool_servicii`.`clasa`
LEFT JOIN `contracte_setari_739_repeat` AS `contracte_setari_739_repeat_1` ON `contracte_setari_739_repeat_1`.`parent_id` = `contracts_tool_servicii`.`serviciu`
LEFT JOIN `contracts_tool_servicii_1291_repeat` AS `contracts_tool_servicii_1291_repeat` ON `contracts_tool_servicii_1291_repeat`.`parent_id` = `contracts_tool_servicii`.`id`
LEFT JOIN `contracts_tool_servicii_1251_repeat` AS `contracts_tool_servicii_1251_repeat` ON `contracts_tool_servicii_1251_repeat`.`parent_id` = `contracts_tool_servicii`.`id`
LEFT JOIN `contracts_tool_servicii_1250_repeat` AS `contracts_tool_servicii_1250_repeat` ON `contracts_tool_servicii_1250_repeat`.`parent_id` = `contracts_tool_servicii`.`id`
LEFT JOIN `contracte_lista_terminale` AS `contracte_lista_terminale` ON `contracte_lista_terminale`.`terminal` = `contracts_tool_servicii_1250_repeat`.`accesoriu_optiune`
LEFT JOIN `contracte_setari_sectiuni` AS `contracte_setari_sectiuni` ON `contracte_setari_sectiuni`.`id_sectiune` = `contracts_tool_servicii_1250_repeat`.`tip_produs`
LEFT JOIN `contracts_tool_servicii_1265_repeat` AS `contracts_tool_servicii_1265_repeat` ON `contracts_tool_servicii_1265_repeat`.`parent_id` = `contracts_tool_servicii`.`id`
LEFT JOIN `contracte_setari_745_repeat` AS `contracte_setari_745_repeat` ON `contracte_setari_745_repeat`.`id` = `contracts_tool_servicii`.`optiuni_abonament_trei`
LEFT JOIN `contracte_setari_745_repeat` AS `contracte_setari_745_repeat_0` ON `contracte_setari_745_repeat_0`.`id` = `contracts_tool_servicii`.`optiuni_abonament_doi`
LEFT JOIN `contracte_setari_745_repeat` AS `contracte_setari_745_repeat_1` ON `contracte_setari_745_repeat_1`.`id` = `contracts_tool_servicii`.`optiuni_abonament_unu`
running this query in database will return over a 1 milion rows..hence the memory limit. Adding a where condition like "where contracts_tool_servicii.id = 123456" will decrease the result to 10 rows.
My question is: where is the "where" condition?
Thank you