Upgrading from version 30.10 to 30.11

[blangford]

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?

[victor]

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

[blangford]

Victor, How do i manually change/edit that? I am not very good with CLI and MySql

Thanks

[victor]

Create file batch.sql containing single line

ALTER TABLE idata_119 DROP COLUMN raw_value;

and run command

nxdbmgr batch batch.sql

Best regards,
Victor

[blangford]

Got it!!! Thanks Again