Error updating version 12.8.2

 
1
0
-1
Hi,

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

DB: Mariadb

 

A Database Error Occurred
Error Number: 1091
Can't DROP 'id'; check that column/key exists
ALTER TABLE system DROP KEY id
Filename: controllers/admin.php
Line Number: 5352
    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      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.

       

        CommentAdd your comment...