WSOD Opigno 8 DevDesktop

FrancoisL
Thu, 01/23/2020 - 11:49
Forums
Support
Hello, I'm having a WSOD after using Opigno on DevDesktop. No errors during the install process. I created multiple basic content. Today I tried to connect to continue my testing and it comes to a WSOD. I tried to add scripts to show error but nothing is appearing. I'm using PHP version 7.0.32. I tried to change to other versions but nothing better. Could you please hep me? Thanks in advance. François
admin
Thu, 01/23/2020 - 18:32

Hi FrancoisL,

Hi FrancoisL,

We do not recommend using php 7.0. Please replace with version 7.2.

If that does not fix the issue, please check the db logs on the platform as well as the php server logs to know the specific error your getting.

Best regards

FrancoisL

In reply to by admin

Mon, 01/27/2020 - 14:07

Hello

Hello thanks for your comment. I started over with 7.2. I was able to reinstall an instance. everything was working, creating content, login, logout. But for some reason the WSOD came back. Here is what I have in MySQL Logs: 2020-01-27 11:31:04 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:04 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."search_api_db_default_index_text" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:04 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:04 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."semaphore" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:04 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:04 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."cache_menu" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:05 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:05 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."key_value_expire" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:05 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:05 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."cache_render" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:05 700010aa9000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:05 700010aa9000 InnoDB: Error: Fetch of persistent statistics requested for table "opigno_8_1"."opigno_answer" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2020-01-27 11:31:06 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:06 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."cache_entity" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:16 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:16 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."user_module_status" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:26 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:26 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."cache_render" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:36 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:36 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."semaphore" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:31:46 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:31:46 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."cache_bootstrap" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2020-01-27 11:32:32 700010916000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2020-01-27 11:32:32 700010916000 InnoDB: Recalculation of persistent statistics requested for table "opigno_8_1"."sessions" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. On Apache logs I saw nothing bad. I tried multiple php.ini configuration but nothing changed.
Profile picture for user James Aparicio
James Aparicio
Mon, 01/27/2020 - 14:41

Hi FrancoisL,

Hi FrancoisL,

 

Seems to be an issue with your mysql database.

 

Best regards

FrancoisL
Wed, 01/29/2020 - 11:45

Hi,

Hi, progressing in debugging this I noticed a new error, it now referring to this: opigno_module/4/edit. which module has this id? how can I know that? For some reason, my opigno went back to life en was able to find which module was with 4 id. In the end this is what I was suspecting. Main problems are coming from h5p. what could be the reason? I don't know. Can it be a memory problem ? I would say no as I have much more than what is recommended for php.ini. Thanks in advance