Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
SoloInter Posted October 16 Posted October 16 (edited) Hi guys, Long story short, I tried to upgrade our test site to v5 and faced 500 errors. I showed a little more info and it was pointed out to me that the architecture of my root folder was strange. In fact since 2015 on IPB and coming from a phpbb conversion, this inevitably leaves traces and files which no longer have anything to do here. So I tried a brand new installation of v5, not an upgrade. I modified the conf file to point to a database that had undergone the upgrade in order to find our 20 years of data. I rsync all the uploads folder to get back all the pictures. And it works. Is this bad? Do I need to check/adjust certain essential points? Edited October 16 by SoloInter
Marc Posted October 17 Posted October 17 12 hours ago, SoloInter said: I showed a little more info and it was pointed out to me that the architecture of my root folder was strange. In fact since 2015 on IPB and coming from a phpbb conversion, this inevitably leaves traces and files which no longer have anything to do here. Its worth pointing out here, some of the files you have in locations have never actually been there. So its more than just leaving traces there. You could certainly do it the way you have done there. However personally, if it were me I would have gone about it by sorting out your 4.x installation first. To do that, you would do the following Delete everything other than - Uploads Folder -conf_global.php - constants.php (if you have it) - plugins folder Upload a fresh set of files from your client area Its important to note the following This doesnt take into account any 3rd party applications you may have in your applications folder. If you do have any, copy those folders out, and re-add them to your uploads folder once the above is done It assumes all storage locations are in the default 'uploads' location. You would need to adjust your steps accordingly if you have changed these SoloInter 1
SoloInter Posted October 17 Author Posted October 17 Ok, I will try to do this. Clean everything. I will delete all 3rd party applications, delete custom template also, and also template for Page. Thanks for your advices. Marc 1
SoloInter Posted October 17 Author Posted October 17 (edited) @Marc Version 4.7.18 working. I can go through all the pages, forum, articles, everything is fine. I go to the ACP Admin. I deleted the themes and restored the original. I deleted all the templates for the pages. I uninstalled all 3rd apps. I removed the languages and put back the original French version. I set everything back to as "clean" and "default" as possible. I go to FTP. I deleted all the files and folders except the ones you said to keep. I sent the contents of the beta 5 folder. When I first go to the home page, I have a template error with GlobalTemplate mentioned. I then went directly to admin/upgrade. The installation starts, I have to run a query manually. I run it : ALTER TABLE `ibf_core_reputation_index` ENGINE=InnoDB, ADD KEY `item_lookup` (`rep_class`,`item_id`,`reaction`); Result : Error Error ALTER TABLE `ibf_core_reputation_index` ENGINE=InnoDB, ADD KEY `item_lookup` (`rep_class`,`item_id`,`reaction`); MySQL : #1061 - Key name 'item_lookup' already used ... I click on "I have run the queries manually and confirm they were run successfully" Install continu. New query : ALTER TABLE `ibf_forums_posts` ADD( `post_score` FLOAT NULL , `post_score_last_event` BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last time an event occurred which requires the post score to be recalculated', `post_share_count` BIGINT UNSIGNED NOT NULL DEFAULT 0 , `post_quote_count` BIGINT UNSIGNED NULL DEFAULT 0 , `post_linked_count` BIGINT UNSIGNED NOT NULL DEFAULT 0 , `post_reaction_count` BIGINT NULL DEFAULT 0 , `post_view_time` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Average time this post was displayed on screen', `post_view_time_view_count` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The number of times (roughly) this post\'s content was displayed in a browser', `post_force_in_summary` TINYINT UNSIGNED NOT NULL DEFAULT 0 , `post_embed_count` BIGINT UNSIGNED NOT NULL DEFAULT 0 , `post_featured` INT UNSIGNED NOT NULL DEFAULT 0 ); Result : Ok MySQL returned an empty result (i.e. no rows). (processing in 0.1680 second(s).) I click on "I have run the queries manually and confirm they were run successfully" Install continu. New query : ALTER TABLE `ibf_forums_posts` CHANGE COLUMN `post_field_t2` `post_field_t2` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL ; Result : Ok MySQL returned an empty result (i.e. no rows). (processing in 0.0304 second(s).) I click on "I have run the queries manually and confirm they were run successfully" Install continu. New query : ALTER TABLE `ibf_core_reputation_index` DROP INDEX `item_lookup`, ENGINE=InnoDB, ADD KEY `item_lookup` (`rep_class`,`item_id`,`reaction`); Result : Ok MySQL returned an empty result (i.e. no rows). (processing in 43.4510 second(s).) I click on "I have run the queries manually and confirm they were run successfully" Install continu. New query : ALTER TABLE `ibf_forums_posts` ADD COLUMN `post_helpful_count` INT UNSIGNED NULL DEFAULT 0 ; Result : Ok MySQL returned an empty result (i.e. no rows). (processing in 0.1383 second(s).) I click on "I have run the queries manually and confirm they were run successfully" Install continu. Install finish. Go to the suite : Error 500 Go to the AdminCP : I can connect Edited October 17 by SoloInter
Marc Posted October 18 Posted October 18 Check your server error logs and let us know what the error itself is
SoloInter Posted October 18 Author Posted October 18 [Sat Oct 19 00:02:15.540573 2024] [fastcgi:error] [pid 407063:tid 139978688427584] [client 2a02:842a:1ef:9001:e06d:f14c:e0ae:61d1:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40, referer: https://dev.internazionale.fr/admin/upgrade/?controller=done [Sat Oct 19 00:02:45.714290 2024] [fastcgi:error] [pid 407064:tid 139978017338944] [client 2a02:842a:1ef:9001:e06d:f14c:e0ae:61d1:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40, referer: https://dev.internazionale.fr/admin/upgrade/?controller=done [Sat Oct 19 00:05:28.514849 2024] [fastcgi:error] [pid 407064:tid 139979074295360] [client 2a02:842a:1ef:9001:e06d:f14c:e0ae:61d1:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40, referer: https://dev.internazionale.fr/admin/upgrade/?controller=done [Sat Oct 19 00:05:40.814572 2024] [fastcgi:error] [pid 407064:tid 139979713828416] [client 178.170.1.148:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40 [Sat Oct 19 00:06:08.390831 2024] [fastcgi:error] [pid 407064:tid 139979074295360] [client 2a02:842a:1ef:9001:e06d:f14c:e0ae:61d1:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40, referer: https://dev.internazionale.fr/admin/upgrade/?controller=done [Sat Oct 19 00:06:35.968566 2024] [fastcgi:error] [pid 407064:tid 139979057509952] [client 2a02:842a:1ef:9001:e06d:f14c:e0ae:61d1:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40, referer: https://dev.internazionale.fr/admin/upgrade/?controller=done [Sat Oct 19 00:14:02.413933 2024] [fastcgi:error] [pid 407064:tid 139978394814016] [client 133.242.174.119:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40 [Sat Oct 19 00:15:14.295716 2024] [fastcgi:error] [pid 407063:tid 139979040724544] [client 149.88.104.27:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: PHP message: PHP Fatal error: Declaration of IPS\\core\\extensions\\core\\FrontNavigation\\_Promoted::canAccessContent() must be compatible with IPS\\core\\FrontNavigation\\FrontNavigationAbstract::canAccessContent(): bool in /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/FrontNavigation/Promoted.php on line 40 [Sat Oct 19 00:15:19.586217 2024] [fastcgi:error] [pid 407063:tid 139979713828416] [client 52.169.29.233:0] FastCGI: server "/usr/lib/cgi-bin/php-Internazionaleprod" stderr: Primary script unknown After send all the file, before upgrade, I access the homepage and get : [[Template core/front/global/globalTemplate is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]
SoloInter Posted October 18 Author Posted October 18 If I try to go to /forums I get HTTP ERROR 500 access.log say this : 2a02:842a:1ef:9001:e06d:f14c:e0ae:61d1 - - [19/Oct/2024:00:36:19 +0200] "GET /forums HTTP/1.1" 500 209 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36" 2a02:842a:1ef:9001:e06d:f14c:e0ae:61d1 - - [19/Oct/2024:00:36:20 +0200] "GET /index.php?app=core&module=system&controller=serviceworker&v=51f62afe7e1729289191&type=admin&loggedIn=false HTTP/1.1" 200 4271 "https://*****/index.php?app=core&module=system&controller=serviceworker&v=51f62afe7e1729289191&type=admin&loggedIn=false" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36" error.log say nothing php_errors.log say this : PHP Fatal error: Type of IPS\core\Statuses\_Status::$commentClass must be ?string (as in class IPS\Co[18-Oct-2024 22:41:10 UTC] PHP Fatal error: Type of IPS\core\Statuses\_Status::$commentClass must be ?string (as in class IPS\Content\Item) in /home/damien_prod/Internazionaleprod/public_html/applications/core/sources/Statuses/Status.php on line 23
SoloInter Posted October 18 Author Posted October 18 (edited) Ok this resolve a little bit my issue : I delete the file and now I can access the home page, also forums home page. But if I want to go to a topic or an article from page I get again an error 500. Topic error : [18-Oct-2024 23:00:51 UTC] PHP Fatal error: Declaration of IPS\forums\widgets\_hotTopics::isExecutableByApp($app) must be compatible with IPS\Widget::isExecutableByApp(array|string $app): bool in /home/damien_prod/Internazionaleprod/public_html/applications/forums/widgets/hotTopics.php on line 62 Article error from database (Page) : [18-Oct-2024 23:02:10 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 7359536 bytes) in /home/damien_prod/Internazionaleprod/public_html/applications/cms/modules/front/database/record.php on line 403 Calendar is fine. Gallery is fine, I can open a picture, but if a auto-generate preview of an intern link (article) was present on the description of the picture I get a white table : It's actually like that on 4.7.18 : On the home page, all the block are showing the same things; If I edit and save directly it's resolve the issue. Edited October 18 by SoloInter
SoloInter Posted October 18 Author Posted October 18 I deleted the file : applications/forums/widgets/hotTopics.php It's resolve the issue for the topics. I can access to them now. Articles from Page : still error 500 with error php : [18-Oct-2024 23:38:52 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 7359504 bytes) in /home/damien_prod/Internazionaleprod/public_html/applications/cms/modules/front/database/record.php on line 403
Marc Posted October 21 Posted October 21 Is this a fresh articles database, or one from your 4.x that has been upgraded? SoloInter 1
Marc Posted October 21 Posted October 21 Im not able to replicate any issue on this end, even with my upgraded databases. Are you using custom templates at all?
SoloInter Posted October 21 Author Posted October 21 Did you try with a database with 20 000 articles, each of them using tag, pictures, have comments, etc ... ? I'm using nothing esle than your templates. Yes I change some colors using your tool, but nothing more.
SoloInter Posted October 21 Author Posted October 21 (edited) I edit this file : /public_html/applications/cms/modules/front/database/record.php I add this before line 403 : error_log('Utilisation de la mémoire avant : ' . memory_get_usage(true)); I add this after line 405 : error_log('Utilisation de la mémoire après : ' . memory_get_usage(true)); Code before : Dispatcher::i()->output .= \IPS\cms\Theme::i()->getTemplate( $record->container()->_template_display, 'cms', 'database' )->record( $record, $comments, $form, $nextUnread ); return null; Code after : error_log('Utilisation de la mémoire avant : ' . memory_get_usage(true)); Dispatcher::i()->output .= \IPS\cms\Theme::i()->getTemplate( $record->container()->_template_display, 'cms', 'database' )->record( $record, $comments, $form, $nextUnread ); return null; error_log('Utilisation de la mémoire après : ' . memory_get_usage(true)); fyi : "Utilisation de la mémoire avant :" = "memory usage before :" fyi : "Utilisation de la mémoire après :" = "memory usage after :" After upload the file, I tried to open an article from database with the dedicated page. Errors logs show [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 8388608 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 8388608 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 8388608 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 12582912 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 12582912 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 14680064 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 14680064 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 16777216 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 18874368 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 20971520 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 23068672 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 25165824 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 27262976 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 29360128 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 31457280 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 33554432 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 35651584 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 37748736 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 39854080 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 42053632 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 44347392 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 46739456 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 49225728 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 51806208 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 54484992 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 57257984 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 60125184 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 63086592 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 66146304 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 69300224 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 72548352 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 75894784 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 79335424 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 82870272 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 86503424 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 90230784 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 94052352 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 97972224 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 101986304 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 106094592 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 110301184 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 114601984 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 118996992 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 123490304 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 128077824 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 132759552 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 137539584 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 142413824 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 147382272 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 152449024 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 157609984 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 162865152 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 168218624 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 173666304 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 179208192 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 184844288 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 190578688 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 196407296 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 204427264 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 210448384 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 216563712 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 222773248 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 229081088 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 235483136 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 241979392 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 248573952 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 255262720 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 262045696 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 268926976 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 275902464 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 285069312 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 292237312 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 299499520 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 306855936 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 314310656 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 321859584 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 329502720 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 337244160 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 345079808 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 353009664 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 361037824 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 369160192 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 377376768 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 387788800 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 396197888 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 404701184 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 413298688 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 421994496 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 430784512 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 439668736 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 448651264 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 457728000 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 466898944 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 478265344 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 487628800 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 497086464 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 506642432 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 516292608 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 526036992 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 535879680 [21-Oct-2024 12:21:10 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 9934744 bytes) in /home/damien_prod/Internazionaleprod/public_html/applications/cms/modules/front/database/record.php on line 404 We didn't go succed to pass the line 403 and the dispatcher. Edited October 21 by SoloInter
SoloInter Posted October 21 Author Posted October 21 (edited) I just put some ideas on the table, I want to find a way to deal with this. What do you think, is it already done? Isn't that relevant? it's not that simple? : The line $record = parent::manage(); loads the record, and further processing (e.g. commentReviewTabs(), commentReviews(), etc.) will likely consume memory, especially if the record contains large amounts of data, comments, or reviews. The edit records form ($form = new Form(...)) can use a significant amount of memory, especially if there are many custom fields to process. The $updateFields array and subsequent processing of $form->values() can increase memory usage, especially with revisions and notification processing. The section that generates the JSON-LD metadata for the article (with detailed information such as author, article body, and image) can also consume memory, especially when it comes to large body text or high-resolution images. Explicitly disable large variables or objects after use, especially if they will not be needed later in the function: unset($form, $updateFields, $activeTabContents); Database queries (e.g. $record->fieldValues(), $record->container()) are optimized and do not return excess data. Edited October 21 by SoloInter
Esther E. Posted October 21 Posted October 21 Are you using a custom template on the database? What about on the category?
SoloInter Posted October 21 Author Posted October 21 I was using a custom template on 4.7.18 Here : admin/?app=cms&module=pages&controller=templates And here : admin/?app=core&module=customization&controller=themes But before the upgrade, I deleted all template files, download a new fresh version of your templates. So it was the template by default. I also deleted all Page -> Template (html, css, ...). I also edited settings of all the databases + categories to change for "Listing" and "Display". On the Beta Admin side it's like that :
Marc Posted October 21 Posted October 21 If you go to edit templates, does it show them as custom Jesus2024 1
SoloInter Posted October 21 Author Posted October 21 (edited) For information OS Ubuntu 22.04 : And also fyi : Data Storage Method : MySQL Database Caching Method : - No caching - Edited October 21 by SoloInter
SoloInter Posted October 21 Author Posted October 21 (edited) If it can help the investigation, here is the constant.php <?php \define( 'USE_DEVELOPMENT_BUILDS', true ); \define( 'BYPASS_ACP_IP_CHECK', true ); \define( 'COOKIE_PATH', '/' ); \define( 'READ_WRITE_SEPARATION', false ); \define( 'REDIS_ENABLED', true ); \define( 'STORE_METHOD', 'Database' ); \define( 'STORE_CONFIG', '[]' ); \define( 'CACHE_METHOD', 'None' ); \define( 'CACHE_CONFIG', '[]' ); \define( 'SUITE_UNIQUE_KEY', '*******' ); \define('EMAIL_DEBUG_PATH', '/dev/null'); Also : Edited October 21 by SoloInter
SoloInter Posted October 24 Author Posted October 24 On 10/21/2024 at 2:27 PM, SoloInter said: I edit this file : /public_html/applications/cms/modules/front/database/record.php I add this before line 403 : error_log('Utilisation de la mémoire avant : ' . memory_get_usage(true)); I add this after line 405 : error_log('Utilisation de la mémoire après : ' . memory_get_usage(true)); Code before : Dispatcher::i()->output .= \IPS\cms\Theme::i()->getTemplate( $record->container()->_template_display, 'cms', 'database' )->record( $record, $comments, $form, $nextUnread ); return null; Code after : error_log('Utilisation de la mémoire avant : ' . memory_get_usage(true)); Dispatcher::i()->output .= \IPS\cms\Theme::i()->getTemplate( $record->container()->_template_display, 'cms', 'database' )->record( $record, $comments, $form, $nextUnread ); return null; error_log('Utilisation de la mémoire après : ' . memory_get_usage(true)); fyi : "Utilisation de la mémoire avant :" = "memory usage before :" fyi : "Utilisation de la mémoire après :" = "memory usage after :" After upload the file, I tried to open an article from database with the dedicated page. Errors logs show [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 8388608 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 8388608 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 8388608 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 10485760 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 12582912 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 12582912 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 14680064 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 14680064 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 16777216 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 18874368 [21-Oct-2024 12:21:01 UTC] Utilisation de la mémoire avant : 20971520 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 23068672 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 25165824 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 27262976 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 29360128 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 31457280 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 33554432 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 35651584 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 37748736 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 39854080 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 42053632 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 44347392 [21-Oct-2024 12:21:02 UTC] Utilisation de la mémoire avant : 46739456 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 49225728 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 51806208 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 54484992 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 57257984 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 60125184 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 63086592 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 66146304 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 69300224 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 72548352 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 75894784 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 79335424 [21-Oct-2024 12:21:03 UTC] Utilisation de la mémoire avant : 82870272 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 86503424 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 90230784 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 94052352 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 97972224 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 101986304 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 106094592 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 110301184 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 114601984 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 118996992 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 123490304 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 128077824 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 132759552 [21-Oct-2024 12:21:04 UTC] Utilisation de la mémoire avant : 137539584 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 142413824 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 147382272 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 152449024 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 157609984 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 162865152 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 168218624 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 173666304 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 179208192 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 184844288 [21-Oct-2024 12:21:05 UTC] Utilisation de la mémoire avant : 190578688 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 196407296 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 204427264 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 210448384 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 216563712 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 222773248 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 229081088 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 235483136 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 241979392 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 248573952 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 255262720 [21-Oct-2024 12:21:06 UTC] Utilisation de la mémoire avant : 262045696 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 268926976 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 275902464 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 285069312 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 292237312 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 299499520 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 306855936 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 314310656 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 321859584 [21-Oct-2024 12:21:07 UTC] Utilisation de la mémoire avant : 329502720 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 337244160 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 345079808 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 353009664 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 361037824 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 369160192 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 377376768 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 387788800 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 396197888 [21-Oct-2024 12:21:08 UTC] Utilisation de la mémoire avant : 404701184 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 413298688 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 421994496 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 430784512 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 439668736 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 448651264 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 457728000 [21-Oct-2024 12:21:09 UTC] Utilisation de la mémoire avant : 466898944 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 478265344 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 487628800 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 497086464 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 506642432 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 516292608 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 526036992 [21-Oct-2024 12:21:10 UTC] Utilisation de la mémoire avant : 535879680 [21-Oct-2024 12:21:10 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 9934744 bytes) in /home/damien_prod/Internazionaleprod/public_html/applications/cms/modules/front/database/record.php on line 404 We didn't go succed to pass the line 403 and the dispatcher. After BETA 2 , still the same here fyi
Management Matt Posted October 24 Management Posted October 24 Send me PM with an admin log in and FTP and I can take a look. I'll remove the info once done. SoloInter 1
Recommended Posts