INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Problem: Data disappears out of database  (Read 1974 times)

globetrotters1

  • Citizen of the Universe
  • *****
  • Posts: 566
Problem: Data disappears out of database
« on: December 12, 2021, 11:13:30 am »

Hello everyone,

hope that someone can help us. We run MC 27.0.84 on our server consisting of 500'000 music tracks and around 6'000 movies.
We assigned movies to their genres, together with cover pictures and descriptions.

When we loaded more movies into the system we ran an import/update of the whole movie database.
Then suddenly the already assigned movies of 2019 up to 2021 showed up in the 'unassigned' group again.
The pictures were most of the time still there, but the assigned data had disappeared.
Assuming it might have been our error we re-assigned all these movies, made a backup and...
when we looked into the database again a few days later, most of these data had disappeared again.

My wife, who does that work, is furious (understandably so).

Where might the problem be ?

Help is appreciated, thanks
Martin
Logged

Dawgincontrol

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 679
  • We have met the enemy and he is us.
Re: Problem: Data disappears out of database
« Reply #1 on: December 12, 2021, 02:57:06 pm »

She may be able to recover her work by doing a library restore.

Why?  Don't know.
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72437
  • Where did I put my teeth?
Re: Problem: Data disappears out of database
« Reply #2 on: December 12, 2021, 05:12:16 pm »

Describe your storage.  Internal, external, NAS?  Something's disappearing.
Logged

leezer3

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1588
Re: Problem: Data disappears out of database
« Reply #3 on: December 13, 2021, 02:37:34 am »

Turn off the fix missing links option.

I'd say its seeing them as missing & thus removing them.
It then reimports them sans metadata when the drive re-appears.

You might also want to turn on tag sidecars. This will preserve the metadata alongside the file (in a new XML file) and help protect from this in the future.
Logged

globetrotters1

  • Citizen of the Universe
  • *****
  • Posts: 566
Re: Problem: Data disappears out of database
« Reply #4 on: December 13, 2021, 08:27:46 am »

Thanks a lot for your advice, leezer3,

I found the missing links option and switched it off

But where can I switch on tag sidecars?
Please advise!
Logged

markf2748

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 818
Re: Problem: Data disappears out of database
« Reply #5 on: December 13, 2021, 07:03:05 pm »

But where can I switch on tag sidecars?
Options > General > Importing & Tagging > Sidecar tagging mode: ...

(Can also be found by entering "sidecar" or "tag" in the search box at bottom of the options menu  :))
Logged

globetrotters1

  • Citizen of the Universe
  • *****
  • Posts: 566
Re: Problem: Data disappears out of database
« Reply #6 on: December 15, 2021, 02:08:28 am »

Thanks, very much appreciated !

We test it, if this solves our problem
Logged

globetrotters1

  • Citizen of the Universe
  • *****
  • Posts: 566
Re: Problem: Data disappears out of database
« Reply #7 on: January 07, 2023, 01:17:54 pm »

Well, we tested it thoroughly and now we are sure that there is a serious problem with the 'backup/restore database' function

After having completed the tag update in a database of 500'000 music tracks and 6'000 movies we did a library BACKUP which was 'successful'

When we do a library RESTORE of the same backup we get problems - tag data disappear, but not only the latest updated tags, no, RANDOM tags !!!

We work since version 9 of this program and have this problem since approximately version 16 (cannot remember really, but a long time ago)

Who can help ?
Thanks
Martin
Logged
Pages: [1]   Go Up