Updateing database doesn't set dateAdded (1 Viewer)

Slurm

MP Donator
  • Premium Supporter
  • December 16, 2006
    301
    33
    57
    Graz
    Home Country
    Austria Austria
    Don't know if it's only me, but if I update database the newly added tracks all get '1899-12-30 00:00:00.000' as dateAdded. Can anyone else confirm this?
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    Don't know if it's only me, but if I update database the newly added tracks all get '1899-12-30 00:00:00.000' as dateAdded. Can anyone else confirm this?

    What are your settings for importing? Is this import everything since xxxx? What date created date did you choose (the default one?)

    On my system and all tests I have done it is populated fine.
     

    Slurm

    MP Donator
  • Premium Supporter
  • December 16, 2006
    301
    33
    57
    Graz
    Home Country
    Austria Austria
    AW: Re: Updateing database doesn't set dateAdded

    What are your settings for importing? Is this import everything since xxxx? What date created date did you choose (the default one?)
    Here's a screenshot of my settings: https://forum.team-mediaportal.com/...tist-one-folder-cover-image-96076/#post739765
    On my system and all tests I have done it is populated fine.
    Good to know (or not).

    I have seen this behaviour on my machine with and without 'import everything since ...' checked and from within mp and also from mp configuration. If I do a complete update (without 'import everything since ...' checked) all tracks get the wrong dateAdded.

    It also takes extremly long to update the whole collection (some hours for ~40.000 entries) whereas with previous mp version it never took longer than half an hour to an hour.

    Is there something I can do to find out where the problem is?
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    Do you have CUE files?
    Is there anything odd about how your files are stored (in one big folder?)
    Do you have massive album thumbs?
    Are you using the default date added option (current date)?
    Are your files stored on a NAS?

    I am importing about 12k tracks in 10 mins but I have seen another report of slow imports so could do with tracking this down
     

    Slurm

    MP Donator
  • Premium Supporter
  • December 16, 2006
    301
    33
    57
    Graz
    Home Country
    Austria Austria
    AW: Updateing database doesn't set dateAdded

    Do you have CUE files?
    No.
    Is there anything odd about how your files are stored (in one big folder?)
    No. They are stored alphabetically in artists folder with every album in its own folder: e.g. \mp3\m\Moby\Moby - Play (1999)\...
    Do you have massive album thumbs?
    What do you mean with massive. The thumbs are at least 500x500 to a maximum of 1500x1500. Maximum filesize is ~1MB.
    Are you using the default date added option (current date)?
    Yes.
    Are your files stored on a NAS?
    Yes, I access it through IP. MP and NAS are both connected through a router with 100 Mbit/s.
    I am importing about 12k tracks in 10 mins but I have seen another report of slow imports so could do with tracking this down
    That's the speed I had previously.

    Another thing I have seen: The first database after updating to 1.2 beta had a filesize of 42 MB (new v12 database). After updating my collection the filesize shrunk to 15 MB. I couldn't see a difference in the tables except the wrong dateAdded in table tracks.
     

    Slurm

    MP Donator
  • Premium Supporter
  • December 16, 2006
    301
    33
    57
    Graz
    Home Country
    Austria Austria
    AW: Updateing database doesn't set dateAdded

    I've had some time to test whether dateAdded was filled with the correct value or not and I haven't found any way to set the correct value.

    I tried all 3 settings from the dropdown, I tried it with mp3s on my nas and local, I even set up mp on my notebook and tried it there, the result was always the same: dateAdded got '1899-12-30 00:00:00.000' as value.

    Can anyone confirm that there's a way to get the right value with mp 1.2 beta?

    btw: in 1.2 beta there's no visual feedback anymore when I add tracks to the database from within mp (previously there was a popup where you could see the progress).
     

    Slurm

    MP Donator
  • Premium Supporter
  • December 16, 2006
    301
    33
    57
    Graz
    Home Country
    Austria Austria
    AW: Updateing database doesn't set dateAdded

    If I set the type of the field dateAdded to varchar(255) I get a value (in this case: 17.05.2011 12:13:14). Maybe there's a problem with the date format?
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    Can you try this (first off rename the existing file as a backup)
     

    Attachments

    • Databases.zip
      107.4 KB

    Slurm

    MP Donator
  • Premium Supporter
  • December 16, 2006
    301
    33
    57
    Graz
    Home Country
    Austria Austria
    AW: Re: Updateing database doesn't set dateAdded

    Can you try this (first off rename the existing file as a backup)

    This solves the problem.

    :D
     

    Users who are viewing this thread

    Similar threads

    I have all of my media on a NAS. I guess it might just be a network issue, then.
    I have all of my media on a NAS. I guess it might just be a network issue, then.
    Whenever I go into the back end for Moving Pictures, it almost immediately hangs on the Movie Importer tab. If I want to go into...
    Replies
    4
    Views
    507
    I removed all sign of MySQL, rebooted, did a clean reinstall. It reinstalled 5.6, But I've still got both the same problem - unable to connect to any of the specified MySQL hosts. And Hostname is still in red. I don't understand - this is a dedicated TV computer. Unless an update did this I don't know why there's a problem in the...
    I removed all sign of MySQL, rebooted, did a clean reinstall. It reinstalled 5.6, But I've still got both the same problem -...
    I've been using MediaPortal for 20 or so years. Last night it recorded perfectly. This arvo it doesn't - will run videos but not...
    Replies
    2
    Views
    459
    I uninstalled MP, made sure no sub folders were left n any programmes folders, changed the computer name, rebooted, installed MP and set logs and rebooted and ran TVServer. Didn't do anything in regard to S Loopback adapter. I've been using NextPvr since the problem became insurmountable. Only reason it's not a good long term...
    I uninstalled MP, made sure no sub folders were left n any programmes folders, changed the computer name, rebooted, installed MP...
    I've been using MediaPortal for 20 or so years. Last night it recorded perfectly. This arvo it doesn't - will run videos but not...
    Replies
    24
    Views
    2K
    If anyone ever experiences the above, I found a fix. Removing and reinstalling MP-TVSeries fixed it. It must have gotten corrupted during the reinstall of MP. I also had to do the same with TRAKT which had some issues too that were not apparent at the time. All is well once again. :cool:
    If anyone ever experiences the above, I found a fix. Removing and reinstalling MP-TVSeries fixed it. It must have gotten corrupted...
    After much trial and error and comparing this computer with another that was working, I finally found out that Fanarthandler...
    Replies
    1
    Views
    851
    So far I needed to limit the media items to respect the token limit of ChatGPT. Now the complete media items can be used, because the movie list is splitted into chunks of a specified size and responses for each chunk are concentrated into the result list :) private async Task<string> GenerateResponseWithGPT(string searchQuery...
    So far I needed to limit the media items to respect the token limit of ChatGPT. Now the complete media items can be used, because...
    Hi, I'm planning to write a plugin for MediaPortal 2, that supports users to find the right media items with help of AI...
    Replies
    6
    Views
    976
    Top Bottom