hey all, first time trying to upgrade magicinfo to V9
could not upgrade the db inthe magicinfo seerver installer (db and was are on same box)
when trying to upgrade via http://localhost:8080 as prompted im getting this error
Migration V211000.0__Update.sql failed
--------------------------------------
SQL State : 42601
Error Code : 0
Message : ERROR: syntax error at or near "ON"
Position: 122
Location : C:\MagicInfo Premium\flyway\sql_postgres\V211000.0__Update.sql (C:\MagicInfo Premium\flyway\sql_postgres\V211000.0__Update.sql)
Line : 68
Statement : INSERT INTO MI_CMS_MAP_FILE ( MEDIA_TYPE, FILE_TYPE, DEVICE_TYPE, DEVICE_TYPE_VERSION) VALUES('DLK','DLK','SPLAYER',9.0) ON CONFLICT ON CONSTRAINT mi_cms_map_file_pkey DO NOTHING
anyone got any idea how or why it is happening, and how to resolve it