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!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Allowed memory size ubuntu
-
- Posts: 366
- 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: 4299
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 445 times
- Contact:
Re: Allowed memory size ubuntu
Your question might be better suited for a forum like stackoverflow.com
-
- Posts: 366
- 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: 366
- 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.