Skip to main content
Solved

UPGRADE - 23.10.8 Failed

  • February 15, 2024
  • 7 replies
  • 436 views
S
Forum|alt.badge.img+6

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.”

Best answer by sfs

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

 

View original
Did this topic help you find an answer to your question?

R
Forum|alt.badge.img+4
  • ReneRohe
  • Steward **
  • February 15, 2024

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
Forum|alt.badge.img+2

Hello slayderz2,

 

same for me on Debian 11

 

Sincerely,

bl

S
Forum|alt.badge.img
  • sfs
  • Steward *
  • February 15, 2024

Hello,

same error on AlmaLinux 8

Sincerely

A
Forum|alt.badge.img+2
  • anthonys
  • Steward *
  • February 15, 2024

hello same error on debian11

S
Forum|alt.badge.img
  • sfs
  • Steward *
  • February 15, 2024

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

 

Fabrix
JonioDiPonio
B
7 people like this
  • Fabrix
    Fabrix
  • JonioDiPonio
    JonioDiPonio
  • B
    belfegorvegeta
  • bertrandll
    bertrandll
  • T
    tomasfonseca
  • S
    slayderz2
  • A
    anthonys
S
Forum|alt.badge.img+6
  • slayderz2
  • Steward **
  • February 15, 2024

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

it’s OK !

thanks

H
B
bertrandll
3 people like this
  • H
    hqdam
  • B
    belfegorvegeta
  • bertrandll
    bertrandll
bertrandll
Forum|alt.badge.img+2

yes, worked me also

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings