Solved

UPGRADE - 23.10.8 Failed

  • 15 February 2024
  • 7 replies
  • 270 views
S
Userlevel 1
Badge +1

Hello everyone,

I run the Centreon update as usual, and now I have the problem below:
I restored my virtual machine, no time yet to investigate, if anyone has had a similar problem?
Thanks

 

“23.10.7 to 23.10.8    UPGRADE - 23.10.8: Unable to insert centreon-widget-resourcestable in dashboard_widgets

You seem to be having trouble with your upgrade.

Please check the "upgrade.log" and the "sql-error.log" located in "/var/log/centreon" for more details
You may refer to the line in the specified file in order to correct the issue.

The SQL files are located in "/usr/share/centreon/www/install/sql/"
But do not edit the SQL files unless you know what you are doing.Refresh this page when the problem is fixed.”

icon

Best answer by sfs 15 February 2024, 11:20

View original

7 replies

R
Badge +4

I got the same issue. SQLError Log states the following:

2024-02-15 09:23|0|0|SQLSTATE[HY000]: General error: 1364 Field 'version' doesn't have a default value QUERY : INSERT INTO dashboard_widgets (name)
VALUES ('centreon-widget-resourcestable')


And the upgrade log the follwing:

2024-02-15 09:23|0|0|UPGRADE - 23.10.8: Unable to insert centreon-widget-resourcestable in dashboard_widgets - Code : 0 - Error : SQLSTATE[HY000]: General error: 136>
#1 /usr/share/centreon/www/install/php/Update-23.10.8.php(35): CentreonDB->query()
#2 /usr/share/centreon/www/install/php/Update-23.10.8.php(49): Core\Platform\Infrastructure\Repository\DbWriteUpdateRepository->{closure}()
#3 /usr/share/centreon/src/Core/Platform/Infrastructure/Repository/DbWriteUpdateRepository.php(144): include_once('...')
#4 /usr/share/centreon/src/Core/Platform/Infrastructure/Repository/DbWriteUpdateRepository.php(61): Core\Platform\Infrastructure\Repository\DbWriteUpdateRepository->>
#5 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(46): Core\Platform\Infrastructure\Repository\DbWriteUpdateRepository->runUpdate()
#6 {main}


 

bertrandll
Badge +2

Hello slayderz2,

 

same for me on Debian 11

 

Sincerely,

bl

S
Userlevel 1
Badge

Hello,

same error on AlmaLinux 8

Sincerely

A
Badge +2

hello same error on debian11

S
Userlevel 1
Badge

I resolved the problem by execute this SQL command :

 

 INSERT INTO `dashboard_widgets` (`name`, `version`)  VALUES ('centreon-widget-resourcestable', '23.10.8')

 

In fact, the field ‘version’ is defined Not NULL. The field must be defined.

 

Sincerely,

sfs

 

S
Userlevel 1
Badge +1

mysql 
use centreon;
INSERT INTO `dashboard_widgets` (`name`, `version`)  VALUES ('centreon-widget-resourcestable', '23.10.8');

it’s OK !

thanks

bertrandll
Badge +2

yes, worked me also

Reply


Terms & ConditionsCookie settings