Open-AudIT

What's on your network?
It is currently Wed Jan 17, 2018 9:30 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Thu Apr 21, 2016 3:53 am 
Offline
Newbie

Joined: Fri Aug 08, 2014 3:48 am
Posts: 8
I was using Open-AudIT 1.8.4 and upgraded to 1.12. After the upgrade, my sys_man_additional_fields and sys_man_additional_fields_data tables are totally empty.

I had put a lot of time into populating thousands of data points into that table.

Is this expected that the upgrade nukes all that work?


Top
 Profile  
Reply with quote  
PostPosted: Thu Apr 21, 2016 1:39 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Hi Nathan,

I've dug into this and unfortunately this looks related to refreshing the groups as part of the upgrade. The sys_man_additional_fields table is linked to the oa_group table by group_id. If the group your fields are assigned to is deleted, so are the fields - and consequently so is the data. My sincerest apologies. The only way to recover the data will be from a backup.

Obviously I will fix this ASAP and include it in our next release.

Again, my apologies.

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


Top
 Profile  
Reply with quote  
PostPosted: Thu Apr 21, 2016 2:12 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Nathan,

Are you using the Windows or Linux version of Open-AudIT?

If you're using the Linux version, when you upgraded you should have been given the option to backup your database. If you did that, no data will be permanently lost.

As at this post, I have patched and uploaded Open-AudIT 1.12.4 so you can (if you have a database backup), restore your database and reinstall from a fresh download. This will result in no lost data.

Mark.

_________________
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  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 3 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