Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: blangford on January 07, 2020, 07:24:21 PM

Title: Upgrading from version 30.10 to 30.11
Post by: blangford on January 07, 2020, 07:24:21 PM
Cannot upgrade DB to 3.11 give error


Upgrading from version 30.10 to 30.11                                                                                                                                             
SQL query failed (Duplicate column name 'raw_value'):                                                                                                                             
ALTER TABLE idata_119 ADD raw_value varchar(255)                                                                                                                                   
Rolling back last stage due to

How can i fix this?
Title: Re: Upgrading from version 30.10 to 30.11
Post by: Victor Kirhenshtein on January 07, 2020, 07:28:37 PM
Hi,

seems that DB schema is inconsistent. If only one table is corrupted you can drop "raw_value" column from it and try to run upgrade again. Otherwise you may run nxdbmgr with -X option (it will ignore upgrade errors) and after completion manually check all errors.

Best regards,
Victor
Title: Re: Upgrading from version 30.10 to 30.11
Post by: blangford on January 07, 2020, 07:32:11 PM
Victor, How do i manually change/edit that? I am not very good with CLI and MySql

Thanks
Title: Re: Upgrading from version 30.10 to 30.11
Post by: Victor Kirhenshtein on January 07, 2020, 07:39:13 PM
Create file batch.sql containing single line
Code Select

ALTER TABLE idata_119 DROP COLUMN raw_value;


and run command

nxdbmgr batch batch.sql

Best regards,
Victor

Title: Re: Upgrading from version 30.10 to 30.11
Post by: blangford on January 07, 2020, 08:03:17 PM
Got it!!! Thanks Again
Text only | Text with Images