Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Sat Nov 23, 2019 11:36 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
PostPosted: Thu Oct 18, 2018 8:39 pm 
Offline
Newbie

Joined: Tue Jan 31, 2006 7:16 pm
Posts: 7
Hello,

how it is possbile to upgrade from Version 1.12 to the 2.2.7 open audit version (with database!!!)

We exported the old database. Then we installed the newest version on a new host and use the old database.
At the start, we get the webpage with an database upgrade button. We click on the button and a few minutes later we get an error message:

Quote:
A Database Error Occurred

Error Number: 1075
Incorrect table definition; there can be only one auto column and it must be defined as a key
ALTER TABLE `system` DROP KEY system_id
Filename: C:\xampplite\open-audit\code_igniter\system\database\DB_driver.php
Line Number: 330



Please Help


Attachments:
Unbenannt.png
Unbenannt.png [ 21.31 KiB | Viewed 799 times ]
Top
 Profile  
Reply with quote  
PostPosted: Tue Oct 30, 2018 9:27 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
Absolutely no promises on this working or not breaking the DB (so make SURE you backup your DB first, see below), but you could try commenting out line 626 in /open-audit/code_igniter/application/controllers/db_upgrades/db_1.14.04.php, then re-running the upgrade from the web GUI.
Backup commands below. Note if you're on Windows, you'll need to run them from c:\xampplite\mysql\bin
Code:
mysql -u openaudit -popenauditpassword -e "DELETE FROM oa_user_sessions;"
mysqldump -u openaudit -popenauditpassword --extended-insert=FALSE --routines openaudit > openaudit_mysql_backup.sql

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group