Update ocs server 2.0 to 2.3 db error

Question

I have a database problem when upgrading from version 2.0 to 2.3, after finishing the installation and using my existing database, I can see that the new records are not loaded correctly showing fields like the empty network.
If I do a clean installation with an empty database if the records are loaded correctly but when using the old database there are values ​​that are not loaded.

What are my options?
Update my old database or import the old data to the new database ??

regards

Answer 1

Hi,

Sometimes somes fields are not added depending on the mysql configuration.

Can you try to run these 2 queries on your updated database please ? :

ALTER TABLE `networks` ADD `MTU` VARCHAR(255) NULL DEFAULT NULL AFTER `SPEED`;

ALTER TABLE `download_available` ADD `DELETED` INT(1) NOT NULL DEFAULT '0' AFTER `ID_WK`;

Reload your apache 2 service and try again :)

Regards,

Gilles Dubois.