Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Allowed memory size ubuntu

Questions related to customising nuBuilder Forte with JavaScript or PHP.
Post Reply
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Allowed memory size ubuntu

Unread post 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?
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Allowed memory size ubuntu

Unread post 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.
kev1n
nuBuilder Team
Posts: 4299
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 445 times
Contact:

Re: Allowed memory size ubuntu

Unread post 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
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Allowed memory size ubuntu

Unread post by kknm »

And there are thoughts why the subform is not displayed - after all, I can make requests to it and get results?
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Allowed memory size ubuntu

Unread post 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.
Post Reply