I wanted to update version 12.6.1 to 12.8.2 and I get this error. Someone could help me?
S.O: Centos 7
A Database Error Occurred
Error Number: 1091
Can't DROP 'id'; check that column/key exists
ALTER TABLE system DROP KEY id
Line Number: 5352
Hi, I have upgraded databases from 1.8.2 and onwards and have not been able to replicate this issue. If you only have a small set of devices in the DB, I'd suggest a new DB.
mysql -u openaudit -popenauditpassword -e "drop database openaudit; create database openaudit;"
mysql -u openaudit -popenauditpassword openaudit < /usr/local/open-audit/other/openaudit_mysql.sql
If you have a significant number of devices and you can send me a backup (zipped) of your database, please let me know.
Powered by a free Atlassian Confluence Open Source Project License granted to Opmantek. Evaluate Confluence today.