Page 1 of 1

Allowed memory size ubuntu

Posted: Thu Sep 08, 2022 11:35 am
by kknm
When opening a complex form of 7 tables suddenly got this error -
"Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10489856 bytes) in /var/www/report/core/nuapi.php on line 141"
Changed in /etc/php/7.4/fpm/php.ini and /etc/php/7.4/apache2/php.ini -
memory_limit = 128M to 256M
After that the form began to open, but with 1 empty table, in which I recently replaced several values โ€‹โ€‹of 1 field.Based on this, it is clear that I messed up the table.There is nothing to do - I will look for an error, but another question arose -
After all the manipulations in php.ini, I see that PHPMYADMIN has not changed at all
innodb buffer pool size=134217728
innodb buffer pool chunk size =134217728
I suppose that this prevents me from getting the lost table.
Any thoughts?

Re: Allowed memory size ubuntu

Posted: Thu Sep 08, 2022 11:47 am
by kknm
I will add that I have not lost this table and I can view its data separately, but on the main form it is empty.

Re: Allowed memory size ubuntu

Posted: Thu Sep 08, 2022 12:30 pm
by kev1n
kknm wrote: โ†‘Thu Sep 08, 2022 11:35 am I see that PHPMYADMIN has not changed at all
innodb buffer pool size=134217728
innodb buffer pool chunk size =134217728
I suppose that this prevents me from getting the lost table.
Any thoughts?
Your question might be better suited for a forum like stackoverflow.com

Re: Allowed memory size ubuntu

Posted: Thu Sep 08, 2022 1:16 pm
by kknm
And there are thoughts why the subform is not displayed - after all, I can make requests to it and get results?

Re: Allowed memory size ubuntu

Posted: Thu Sep 08, 2022 1:35 pm
by kknm
I'll answer my own question.
Before correcting the table, I expanded the query for this table to find replacements. Fixed the table and then commented out my extensions (several lines) with '-- ' as is customary in SQL. Then I checked the request in PHPMYADMIN. Since then I have been getting an error in nubuilder.
Replaced '-- ' with multiline '/* */'.

in PHPMYADMIN everything worked with any comment, but nubuilder only with multiline.