Jump to content

Search the Community

Showing results for tags 'backup.'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General
    • Announcements
    • Emby Premiere Purchase/Subscription Support
    • Feature Requests
    • Tutorials and Guides
  • Emby Server
    • General/Windows
    • Android Server
    • Asustor
    • FreeBSD
    • Linux
    • NetGear ReadyNAS
    • MacOS
    • QNAP
    • Synology
    • TerraMaster NAS
    • Thecus
    • Western Digital
    • DLNA
    • Live TV
  • Emby Apps
    • Amazon Alexa
    • Android Mobile
    • Android TV / Fire TV
    • Emby Theater
    • iOS
    • Apple TV
    • Kodi
    • Raspberry Pi
    • Roku
    • Samsung Smart TV
    • Sony PlayStation
    • LG Smart TV
    • Web App
    • Windows Media Center
    • Plugins
  • Language-specific support
    • Arabic
    • Dutch
    • French
    • German
    • Italian
    • Portuguese
    • Russian
    • Spanish
    • Swedish
  • Community Contributions
    • Ember for Emby
    • Fan Art & Videos
    • Tools and Utilities
    • Web App CSS
  • Other
    • General Discussion
    • Developer API
    • Hardware
    • Media Clubs
    • Legacy Support

Blogs

  • Emby Blog

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Found 1 result

  1. Hi folks, Short question: How do I convert the old "LastPlayedDate" datetime field in the "userdata" table in library.db into the newer "LastPlayedDateint" integer field? Long question: I had emby installed on my FreeNAS for a while, and in December I wanted to update the FreeNAS version and at the same time consolidate my jails into my docker VM on ESX on another server. Unfortunately, emby in docker for me seemed to cause a lot of DB corruption in library.db about 24 hours after the library had finished being scanned and I started to watch stuff. Looking in the logs didn't yield anything spectacularly wrong or obvious. So I deleted it and started again, with no luck - the same corruption. In the end, I'd recreated/re-downloaded the container about 5 times, set local and remote storage for config (NFS, samba, etc), use another docker vm on a faster/different disk - seems no matter what I did, it still had issues. I even ran a memtest on the ESX server, which as you may know takes aaaaaages! (during which I had to rely on Netflix and ::shudder:: DVDs!) Long story short, I ended up creating a dedicated emby VM and copied across the config. At that time, v4 was released, so it did an upgrade on the databases, then I ran a library scan. After a few days, I decided it was stable enough that I removed the emby jail in FreeNAS and cleaned away all the config files (after making a final backup!). As per the instructions on how to manually backup and restore, I'm now at the point where I'd like to re-import my watched data. But... It looks like the upgrade or something else along the way changed the field type on the lastplayeddate from a datetime to an integer in the userdata table. So, what is the process of converting the datetime fields into an int? Is this SQLite or emby specific? I've exported the old table to an SQL file, so I can apply any formulas or do other processing easily. In case it matters, I'm a programmer by day, IT enthusiast by night, so I'm OK if the answer is not sugar coated! Actually, I could just set that field to null in my exported file... What does emby use that field for anyway? I haven't ever seen a "last played" tag anywhere, and to be honest might be quite nice to actually have it displayed! Thanks in advance!
×
×
  • Create New...