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?
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Allowed memory size ubuntu
-
- Posts: 377
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Allowed memory size ubuntu
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.
-
- nuBuilder Team
- Posts: 4565
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 76 times
- Been thanked: 529 times
- Contact:
Re: Allowed memory size ubuntu
Your question might be better suited for a forum like stackoverflow.com
-
- Posts: 377
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Allowed memory size ubuntu
And there are thoughts why the subform is not displayed - after all, I can make requests to it and get results?
-
- Posts: 377
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Allowed memory size ubuntu
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.
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.