Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

problem importing

2008-10-28
2013-01-20
  • hi,

    i have upgraded from:

    3.202 to 3.221 and all appears well, using all your incremental versions

    3.221 to 3.3 the following error occurs:

    restarting database

    pop-up window:

    an exception occurred. Please restore your latest backup & retry. Contact the developer if the error persists.

    End of pop-up window

    Re-applying settings
    Restore is finished
    Loading database

    and all appears well - all entries are present

    3.3 to 3.4 the following error occurs:

    Could not determine version...etc

    and only the 9 books i have entered appear correctly, the video section is corrupt & unusable

    any help would be appreciated

    regards

    robin

    data_crow log:

    INFO [main] (DataCrow.java:130) - System is being started
    INFO [main] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Genres
    INFO [main] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Artists
    INFO [main] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Genres
    INFO [main] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module audiocd, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module audiotrack, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module musicalbum, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module musictrack, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module book, altered field Publishers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module book, altered field Authors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Actors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Directors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Subtitle Language
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field ASIN
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Developers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Publishers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field ASIN
    INFO [main] (DataCrow.java:136) - Modules have been loaded
    ERROR [main] (DatabaseManager.java:138) - java.sql.SQLException: User not found: DC_ADMIN
    INFO [main] (DcDatabase.java:122) - Found the picture table
    INFO [main] (DcDatabase.java:125) - x_audiocd_musicartist table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1a7789c[sql=[CREATE MEMORY TABLE x_audiocd_musicartist
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_audiocd_musicgenre table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@22ce00[sql=[CREATE MEMORY TABLE x_audiocd_musicgenre
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_audiotrack_musicartist table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@102a0a5[sql=[CREATE MEMORY TABLE x_audiotrack_musicartist
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_audiotrack_musicgenre table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@31fb31[sql=[CREATE MEMORY TABLE x_audiotrack_musicgenre
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_book_author table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@146e381[sql=[CREATE MEMORY TABLE x_book_author
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_book_bookpublisher table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1df2964[sql=[CREATE MEMORY TABLE x_book_bookpublisher
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_movie_actor table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@19b4748[sql=[CREATE MEMORY TABLE x_movie_actor
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_movie_director table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@e0c7c3[sql=[CREATE MEMORY TABLE x_movie_director
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_movie_movie_genre table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@9fdee[sql=[CREATE MEMORY TABLE x_movie_movie_genre
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_musicalbum_musicartist table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@8beff2[sql=[CREATE MEMORY TABLE x_musicalbum_musicartist
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_musicalbum_musicgenre table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1b5c22f[sql=[CREATE MEMORY TABLE x_musicalbum_musicgenre
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_musictrack_musicartist table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@2bfdff[sql=[CREATE MEMORY TABLE x_musictrack_musicartist
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_musictrack_musicgenre table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1fac852[sql=[CREATE MEMORY TABLE x_musictrack_musicgenre
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_software_developer table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@40ece0[sql=[CREATE MEMORY TABLE x_software_developer
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - x_software_softwarepublisher table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1ca209e[sql=[CREATE MEMORY TABLE x_software_softwarepublisher
    (ObjectID bigint, ReferencedId bigint);]]
    INFO [main] (DcDatabase.java:125) - actor table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@8c7be5[sql=[CREATE MEMORY TABLE actor
    (Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - musicartist table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@ae97c4[sql=[CREATE MEMORY TABLE musicartist
    (Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - audiocd table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@4b0bbb[sql=[CREATE MEMORY TABLE audiocd
    (Created varchar(10), Description longvarchar, DiscID varchar(255), ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - audiotrack table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@ef4504[sql=[CREATE MEMORY TABLE audiotrack
    (AlbumID bigint, Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Location varchar(255), Lyric longvarchar, Modified varchar(10), Playlength bigint, Rating bigint, Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - author table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@9c176c[sql=[CREATE MEMORY TABLE author
    (Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - book table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@82d603[sql=[CREATE MEMORY TABLE book
    (Category bigint, Created varchar(10), Description longvarchar, Filehash varchar(32), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, ISBN varchar(20), ISBN13 varchar(20), Location varchar(255), Modified varchar(10), pages bigint, Rating bigint, Series varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VolumeNumber bigint, VolumeName varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - person_category table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@552a2b[sql=[CREATE MEMORY TABLE person_category
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - book_category table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@3eec1a[sql=[CREATE MEMORY TABLE book_category
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - image_category table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@79b177[sql=[CREATE MEMORY TABLE image_category
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - software_category table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@114a306[sql=[CREATE MEMORY TABLE software_category
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - person table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@381a9c[sql=[CREATE MEMORY TABLE person
    (Address longvarchar, Category bigint, City varchar(255), Country varchar(255), Created varchar(10), Description longvarchar, Email varchar(255), ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), PhoneHome varchar(50), PhoneWork varchar(50), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255));]]
    INFO [main] (DcDatabase.java:125) - developer table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@b79701[sql=[CREATE MEMORY TABLE developer
    (Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - director table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@e2b07b[sql=[CREATE MEMORY TABLE director
    (Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - movie_genre table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@15e00b7[sql=[CREATE MEMORY TABLE movie_genre
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - image table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@9b87f6[sql=[CREATE MEMORY TABLE image
    (Camera varchar(255), Category bigint, Compression bigint, Created varchar(10), ImageDate date, Description longvarchar, Filehash varchar(32), Filename varchar(500), Filesize bigint, Height bigint, ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Place varchar(500), Rating bigint, State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Width bigint, Year bigint);]]
    INFO [main] (DcDatabase.java:125) - loans table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@fb6763[sql=[CREATE MEMORY TABLE loans
    (PersonID bigint, Created varchar(10), EndDate date, ID bigint PRIMARY KEY, Modified varchar(10), ObjectID bigint, StartDate date);]]
    INFO [main] (DcDatabase.java:125) - movie table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@f70ee1[sql=[CREATE MEMORY TABLE movie
    (ASIN varchar(50), AudioBitrate varchar(10), AudioChannels varchar(10), AudioCodec varchar(255), AudioLanguage varchar(50), AudioSampleRate varchar(10), Certification varchar(255), Country varchar(255), Created varchar(10), Description longvarchar, EpisodeNumber bigint, EpisodeName varchar(255), Filehash varchar(32), Filename varchar(500), Filesize bigint, Fps varchar(10), Frames varchar(10), Height varchar(10), ID bigint PRIMARY KEY, Language varchar(50), Location varchar(255), Modified varchar(10), Playlength bigint, Rating bigint, Season varchar(255), Program varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, SubtitleLanguage varchar(500), Title varchar(255), Title2 varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VideoBitRate varchar(10), VideoCodec varchar(255), webpage varchar(255), Width varchar(10), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - musicalbum table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1b9f88b[sql=[CREATE MEMORY TABLE musicalbum
    (Created varchar(10), Description longvarchar, DiscID varchar(255), ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - musicgenre table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@5539d8[sql=[CREATE MEMORY TABLE musicgenre
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - musictrack table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1a05bdb[sql=[CREATE MEMORY TABLE musictrack
    (AlbumID bigint, Created varchar(10), Description longvarchar, Encoding varchar(255), Filehash varchar(32), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Location varchar(255), Lyric longvarchar, Modified varchar(10), Playlength bigint, Quality bigint, Rating bigint, State bigint, Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:122) - Found the permission table
    INFO [main] (DcDatabase.java:125) - book_storagemedium table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@bc0eba[sql=[CREATE MEMORY TABLE book_storagemedium
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - image_storagemedium table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@6af790[sql=[CREATE MEMORY TABLE image_storagemedium
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - movie_storagemedium table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@17834de[sql=[CREATE MEMORY TABLE movie_storagemedium
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - musicalbum_storagemedium table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@8a9d2a[sql=[CREATE MEMORY TABLE musicalbum_storagemedium
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - software_platform table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@96e599[sql=[CREATE MEMORY TABLE software_platform
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - software_storagemedium table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@5a58e0[sql=[CREATE MEMORY TABLE software_storagemedium
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - bookpublisher table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@7d2796[sql=[CREATE MEMORY TABLE bookpublisher
    (Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - softwarepublisher table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@15e0638[sql=[CREATE MEMORY TABLE softwarepublisher
    (Created varchar(10), Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - software table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@dc64a2[sql=[CREATE MEMORY TABLE software
    (ASIN varchar(50), Category bigint, Created varchar(10), Description longvarchar, Filehash varchar(32), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Multiplayer varchar(4), Platform bigint, Rating bigint, SerialKey varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - audiocd_state table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@7a4076[sql=[CREATE MEMORY TABLE audiocd_state
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - book_state table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@be6108[sql=[CREATE MEMORY TABLE book_state
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - image_state table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1f2412a[sql=[CREATE MEMORY TABLE image_state
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - movie_state table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@ed3b53[sql=[CREATE MEMORY TABLE movie_state
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - musicalbum_state table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@76f1f4[sql=[CREATE MEMORY TABLE musicalbum_state
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - musictrack_state table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@15004dd[sql=[CREATE MEMORY TABLE musictrack_state
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - software_state table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@2bae98[sql=[CREATE MEMORY TABLE software_state
    (Created varchar(10), ID bigint PRIMARY KEY, Icon longvarchar, Modified varchar(10), Name varchar(255));]]
    INFO [main] (DcDatabase.java:125) - user_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@d591a6[sql=[CREATE MEMORY TABLE user_template
    (Address varchar(255), Admin boolean, City varchar(255), Country varchar(255), Created varchar(10), DefaultTemplate boolean, Description longvarchar, Email varchar(255), Enabled boolean, ID bigint PRIMARY KEY, LoginName varchar(255), Modified varchar(10), Name varchar(255), PhoneHome varchar(255), PhoneWork varchar(255), TemplateName varchar(255));]]
    INFO [main] (DcDatabase.java:125) - permission_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@6bbb36[sql=[CREATE MEMORY TABLE permission_template
    (Created varchar(10), DefaultTemplate boolean, Edit boolean, Field bigint, ID bigint PRIMARY KEY, Modified varchar(10), Module bigint, Plugin varchar(255), TemplateName varchar(255), User bigint, View boolean);]]
    INFO [main] (DcDatabase.java:125) - actor_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@35be06[sql=[CREATE MEMORY TABLE actor_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - author_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@18b0b4a[sql=[CREATE MEMORY TABLE author_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - bookpublisher_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@bed4c8[sql=[CREATE MEMORY TABLE bookpublisher_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - person_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@8398e7[sql=[CREATE MEMORY TABLE person_template
    (Address longvarchar, Category bigint, City varchar(255), Country varchar(255), Created varchar(10), DefaultTemplate boolean, Description longvarchar, Email varchar(255), ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), PhoneHome varchar(50), PhoneWork varchar(50), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255));]]
    INFO [main] (DcDatabase.java:125) - developer_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@f4fb44[sql=[CREATE MEMORY TABLE developer_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - director_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@16ff9e0[sql=[CREATE MEMORY TABLE director_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - musicartist_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1c9d17e[sql=[CREATE MEMORY TABLE musicartist_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - softwarepublisher_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@74c144[sql=[CREATE MEMORY TABLE softwarepublisher_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Modified varchar(10), Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
    INFO [main] (DcDatabase.java:125) - audiocd_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1611ed3[sql=[CREATE MEMORY TABLE audiocd_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, DiscID varchar(255), ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - audiotrack_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@161401f[sql=[CREATE MEMORY TABLE audiotrack_template
    (AlbumID bigint, Created varchar(10), DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Location varchar(255), Lyric longvarchar, Modified varchar(10), Playlength bigint, Rating bigint, TemplateName varchar(255), Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - book_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@3a3e1b[sql=[CREATE MEMORY TABLE book_template
    (Category bigint, Created varchar(10), DefaultTemplate boolean, Description longvarchar, Filehash varchar(32), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, ISBN varchar(20), ISBN13 varchar(20), Location varchar(255), Modified varchar(10), pages bigint, Rating bigint, Series varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VolumeNumber bigint, VolumeName varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - image_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@1c39412[sql=[CREATE MEMORY TABLE image_template
    (Camera varchar(255), Category bigint, Compression bigint, Created varchar(10), ImageDate date, DefaultTemplate boolean, Description longvarchar, Filehash varchar(32), Filename varchar(500), Filesize bigint, Height bigint, ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Place varchar(500), Rating bigint, State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Width bigint, Year bigint);]]
    INFO [main] (DcDatabase.java:125) - movie_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@67e236[sql=[CREATE MEMORY TABLE movie_template
    (ASIN varchar(50), AudioBitrate varchar(10), AudioChannels varchar(10), AudioCodec varchar(255), AudioLanguage varchar(50), AudioSampleRate varchar(10), Certification varchar(255), Country varchar(255), Created varchar(10), DefaultTemplate boolean, Description longvarchar, EpisodeNumber bigint, EpisodeName varchar(255), Filehash varchar(32), Filename varchar(500), Filesize bigint, Fps varchar(10), Frames varchar(10), Height varchar(10), ID bigint PRIMARY KEY, Language varchar(50), Location varchar(255), Modified varchar(10), Playlength bigint, Rating bigint, Season varchar(255), Program varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, SubtitleLanguage varchar(500), TemplateName varchar(255), Title varchar(255), Title2 varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VideoBitRate varchar(10), VideoCodec varchar(255), webpage varchar(255), Width varchar(10), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - musicalbum_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@15b758[sql=[CREATE MEMORY TABLE musicalbum_template
    (Created varchar(10), DefaultTemplate boolean, Description longvarchar, DiscID varchar(255), ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - musictrack_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@5a8a7e[sql=[CREATE MEMORY TABLE musictrack_template
    (AlbumID bigint, Created varchar(10), DefaultTemplate boolean, Description longvarchar, Encoding varchar(255), Filehash varchar(32), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Location varchar(255), Lyric longvarchar, Modified varchar(10), Playlength bigint, Quality bigint, Rating bigint, State bigint, TemplateName varchar(255), Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:125) - software_template table has not been found, creating new !
    INFO [main] (DcDatabase.java:171) - org.hsqldb.jdbc.jdbcPreparedStatement@5a9c6e[sql=[CREATE MEMORY TABLE software_template
    (ASIN varchar(50), Category bigint, Created varchar(10), DefaultTemplate boolean, Description longvarchar, Filehash varchar(32), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Location varchar(255), Modified varchar(10), Multiplayer varchar(4), Platform bigint, Rating bigint, SerialKey varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
    INFO [main] (DcDatabase.java:122) - Found the user table
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT Field, Filename, Height, ObjectID, Width FROM picture
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_author
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_bookpublisher
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_actor
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_director
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_movie_genre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_developer
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_softwarepublisher
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_category ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_category ORDER BY Name
    INFO [datafetcher-Loan] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, DefaultTemplate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image_template ORDER BY ID
    INFO [datafetcher-Music Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicgenre ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musictrack_state ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM developer_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, DefaultTemplate, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, TemplateName, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, DefaultTemplate, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork, TemplateName FROM user_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_state ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM actor_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher_template ORDER BY ID
    INFO [datafetcher-Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_genre ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_state ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_storagemedium ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_category ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM person_category ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_storagemedium ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_storagemedium ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, DefaultTemplate, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Edit, Field, ID, Modified, Module, Plugin, TemplateName, User, View FROM permission_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM audiocd_state ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_platform ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_storagemedium ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_storagemedium ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, ID, Location, Lyric, Modified, Playlength, Rating, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack_template ORDER BY ID
    INFO [datafetcher-contactperson] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person ORDER BY ID
    INFO [datafetcher-director] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director ORDER BY ID
    INFO [datafetcher-softwarepublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher ORDER BY ID
    INFO [datafetcher-Actor] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Actor ORDER BY ID
    INFO [datafetcher-musicartist] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist ORDER BY ID
    INFO [datafetcher-bookpublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher ORDER BY ID
    INFO [datafetcher-developer] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Developer ORDER BY ID
    INFO [datafetcher-author] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, ID, Location, Lyric, Modified, Playlength, Rating, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT Created, Edit, Field, ID, Modified, Module, Plugin, User, View FROM permission ORDER BY ID
    INFO [datafetcher-audiocd] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-book] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book ORDER BY ID
    INFO [datafetcher-media] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-User] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork FROM user ORDER BY ID
    INFO [datafetcher-image] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image ORDER BY ID
    INFO [datafetcher-musicalbum] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum ORDER BY ID
    INFO [datafetcher-movie] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie ORDER BY ID
    INFO [datafetcher-Software] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software ORDER BY ID
    INFO [Timer-0] (ImageStore.java:99) - There are 8 images loaded into memory. Removing 4.
    INFO [AWT-EventQueue-0] (MainFrame.java:509) - Session has been interrupted. Shutting down!
    INFO [main] (DataCrow.java:130) - System is being started
    INFO [main] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Genres
    INFO [main] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Artists
    INFO [main] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Genres
    INFO [main] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module audiocd, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module audiotrack, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module musicalbum, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module musictrack, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module book, altered field Publishers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module book, altered field Authors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Actors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Directors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Subtitle Language
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field ASIN
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Developers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Publishers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field ASIN
    INFO [main] (DataCrow.java:136) - Modules have been loaded
    INFO [main] (DcDatabase.java:122) - Found the picture table
    INFO [main] (DcDatabase.java:122) - Found the x_audiocd_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_audiocd_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_audiotrack_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_audiotrack_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_book_author table
    INFO [main] (DcDatabase.java:122) - Found the x_book_bookpublisher table
    INFO [main] (DcDatabase.java:122) - Found the x_movie_actor table
    INFO [main] (DcDatabase.java:122) - Found the x_movie_director table
    INFO [main] (DcDatabase.java:122) - Found the x_movie_movie_genre table
    INFO [main] (DcDatabase.java:122) - Found the x_musicalbum_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_musicalbum_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_musictrack_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_musictrack_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_software_developer table
    INFO [main] (DcDatabase.java:122) - Found the x_software_softwarepublisher table
    INFO [main] (DcDatabase.java:122) - Found the actor table
    INFO [main] (DcDatabase.java:122) - Found the musicartist table
    INFO [main] (DcDatabase.java:122) - Found the audiocd table
    INFO [main] (DcDatabase.java:122) - Found the audiotrack table
    INFO [main] (DcDatabase.java:122) - Found the author table
    INFO [main] (DcDatabase.java:122) - Found the book table
    INFO [main] (DcDatabase.java:122) - Found the person_category table
    INFO [main] (DcDatabase.java:122) - Found the book_category table
    INFO [main] (DcDatabase.java:122) - Found the image_category table
    INFO [main] (DcDatabase.java:122) - Found the software_category table
    INFO [main] (DcDatabase.java:122) - Found the person table
    INFO [main] (DcDatabase.java:122) - Found the developer table
    INFO [main] (DcDatabase.java:122) - Found the director table
    INFO [main] (DcDatabase.java:122) - Found the movie_genre table
    INFO [main] (DcDatabase.java:122) - Found the image table
    INFO [main] (DcDatabase.java:122) - Found the loans table
    INFO [main] (DcDatabase.java:122) - Found the movie table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum table
    INFO [main] (DcDatabase.java:122) - Found the musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the musictrack table
    INFO [main] (DcDatabase.java:122) - Found the permission table
    INFO [main] (DcDatabase.java:122) - Found the book_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the image_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the movie_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the software_platform table
    INFO [main] (DcDatabase.java:122) - Found the software_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the bookpublisher table
    INFO [main] (DcDatabase.java:122) - Found the softwarepublisher table
    INFO [main] (DcDatabase.java:122) - Found the software table
    INFO [main] (DcDatabase.java:122) - Found the audiocd_state table
    INFO [main] (DcDatabase.java:122) - Found the book_state table
    INFO [main] (DcDatabase.java:122) - Found the image_state table
    INFO [main] (DcDatabase.java:122) - Found the movie_state table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum_state table
    INFO [main] (DcDatabase.java:122) - Found the musictrack_state table
    INFO [main] (DcDatabase.java:122) - Found the software_state table
    INFO [main] (DcDatabase.java:122) - Found the user_template table
    INFO [main] (DcDatabase.java:122) - Found the permission_template table
    INFO [main] (DcDatabase.java:122) - Found the actor_template table
    INFO [main] (DcDatabase.java:122) - Found the author_template table
    INFO [main] (DcDatabase.java:122) - Found the bookpublisher_template table
    INFO [main] (DcDatabase.java:122) - Found the person_template table
    INFO [main] (DcDatabase.java:122) - Found the developer_template table
    INFO [main] (DcDatabase.java:122) - Found the director_template table
    INFO [main] (DcDatabase.java:122) - Found the musicartist_template table
    INFO [main] (DcDatabase.java:122) - Found the softwarepublisher_template table
    INFO [main] (DcDatabase.java:122) - Found the audiocd_template table
    INFO [main] (DcDatabase.java:122) - Found the audiotrack_template table
    INFO [main] (DcDatabase.java:122) - Found the book_template table
    INFO [main] (DcDatabase.java:122) - Found the image_template table
    INFO [main] (DcDatabase.java:122) - Found the movie_template table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum_template table
    INFO [main] (DcDatabase.java:122) - Found the musictrack_template table
    INFO [main] (DcDatabase.java:122) - Found the software_template table
    INFO [main] (DcDatabase.java:122) - Found the user table
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT Field, Filename, Height, ObjectID, Width FROM picture
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_author
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_bookpublisher
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_actor
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_director
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_movie_genre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_developer
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_softwarepublisher
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM person_category ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_category ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_category ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_storagemedium ORDER BY Name
    INFO [datafetcher-Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_genre ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_category ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_state ORDER BY Name
    INFO [datafetcher-Music Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicgenre ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, DefaultTemplate, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork, TemplateName FROM user_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM actor_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_state ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_storagemedium ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_storagemedium ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_platform ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_storagemedium ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musictrack_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM audiocd_state ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM developer_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, DefaultTemplate, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, TemplateName, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, DefaultTemplate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, ID, Location, Lyric, Modified, Playlength, Rating, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, DefaultTemplate, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Edit, Field, ID, Modified, Module, Plugin, TemplateName, User, View FROM permission_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software_template ORDER BY ID
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_storagemedium ORDER BY Name
    INFO [datafetcher-Loan] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    INFO [datafetcher-Actor] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Actor ORDER BY ID
    INFO [datafetcher-author] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author ORDER BY ID
    INFO [datafetcher-musicartist] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist ORDER BY ID
    INFO [datafetcher-contactperson] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person ORDER BY ID
    INFO [datafetcher-director] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director ORDER BY ID
    INFO [datafetcher-softwarepublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher ORDER BY ID
    INFO [datafetcher-developer] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Developer ORDER BY ID
    INFO [datafetcher-bookpublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, ID, Location, Lyric, Modified, Playlength, Rating, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT Created, Edit, Field, ID, Modified, Module, Plugin, User, View FROM permission ORDER BY ID
    INFO [datafetcher-audiocd] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-image] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image ORDER BY ID
    INFO [datafetcher-movie] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie ORDER BY ID
    INFO [datafetcher-Software] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software ORDER BY ID
    INFO [datafetcher-book] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book ORDER BY ID
    INFO [datafetcher-musicalbum] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum ORDER BY ID
    INFO [datafetcher-media] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-User] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork FROM user ORDER BY ID
    INFO [Timer-0] (ImageStore.java:99) - There are 4 images loaded into memory. Removing 0.
    INFO [Thread-10] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Genres
    INFO [Thread-10] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Artists
    INFO [Thread-10] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Genres
    INFO [Thread-10] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Artists
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module audiocd, altered field Artists
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module audiotrack, altered field Artists
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module musicalbum, altered field Artists
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module musictrack, altered field Artists
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module book, altered field Publishers
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module book, altered field Authors
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Actors
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Directors
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Subtitle Language
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module movie, altered field ASIN
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Developers
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Publishers
    INFO [Thread-10] (ModuleUpgrade.java:317) - Upgraded module Software, altered field ASIN
    INFO [Thread-10] (DcDatabase.java:122) - Found the picture table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_audiocd_musicartist table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_audiocd_musicgenre table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_audiotrack_musicartist table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_audiotrack_musicgenre table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_book_author table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_book_bookpublisher table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_movie_actor table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_movie_director table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_movie_movie_genre table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_musicalbum_musicartist table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_musicalbum_musicgenre table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_musictrack_musicartist table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_musictrack_musicgenre table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_software_developer table
    INFO [Thread-10] (DcDatabase.java:122) - Found the x_software_softwarepublisher table
    INFO [Thread-10] (DcDatabase.java:122) - Found the actor table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musicartist table
    INFO [Thread-10] (DcDatabase.java:122) - Found the audiocd table
    INFO [Thread-10] (DcDatabase.java:122) - Found the audiotrack table
    INFO [Thread-10] (DcDatabase.java:122) - Found the author table
    INFO [Thread-10] (DcDatabase.java:122) - Found the book table
    INFO [Thread-10] (DcDatabase.java:122) - Found the person_category table
    INFO [Thread-10] (DcDatabase.java:122) - Found the book_category table
    INFO [Thread-10] (DcDatabase.java:122) - Found the image_category table
    INFO [Thread-10] (DcDatabase.java:122) - Found the software_category table
    INFO [Thread-10] (DcDatabase.java:122) - Found the person table
    INFO [Thread-10] (DcDatabase.java:122) - Found the developer table
    INFO [Thread-10] (DcDatabase.java:122) - Found the director table
    INFO [Thread-10] (DcDatabase.java:122) - Found the movie_genre table
    INFO [Thread-10] (DcDatabase.java:122) - Found the image table
    INFO [Thread-10] (DcDatabase.java:122) - Found the loans table
    INFO [Thread-10] (DcDatabase.java:122) - Found the movie table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musicalbum table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musicgenre table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musictrack table
    INFO [Thread-10] (DcDatabase.java:122) - Found the permission table
    INFO [Thread-10] (DcDatabase.java:122) - Found the book_storagemedium table
    INFO [Thread-10] (DcDatabase.java:122) - Found the image_storagemedium table
    INFO [Thread-10] (DcDatabase.java:122) - Found the movie_storagemedium table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musicalbum_storagemedium table
    INFO [Thread-10] (DcDatabase.java:122) - Found the software_platform table
    INFO [Thread-10] (DcDatabase.java:122) - Found the software_storagemedium table
    INFO [Thread-10] (DcDatabase.java:122) - Found the bookpublisher table
    INFO [Thread-10] (DcDatabase.java:122) - Found the softwarepublisher table
    INFO [Thread-10] (DcDatabase.java:122) - Found the software table
    INFO [Thread-10] (DcDatabase.java:122) - Found the audiocd_state table
    INFO [Thread-10] (DcDatabase.java:122) - Found the book_state table
    INFO [Thread-10] (DcDatabase.java:122) - Found the image_state table
    INFO [Thread-10] (DcDatabase.java:122) - Found the movie_state table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musicalbum_state table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musictrack_state table
    INFO [Thread-10] (DcDatabase.java:122) - Found the software_state table
    INFO [Thread-10] (DcDatabase.java:122) - Found the user_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the permission_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the actor_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the author_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the bookpublisher_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the person_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the developer_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the director_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musicartist_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the softwarepublisher_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the audiocd_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the audiotrack_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the book_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the image_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the movie_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musicalbum_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the musictrack_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the software_template table
    INFO [Thread-10] (DcDatabase.java:122) - Found the user table
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT Field, Filename, Height, ObjectID, Width FROM picture
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicartist
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicgenre
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicartist
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicgenre
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_author
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_bookpublisher
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_actor
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_director
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_movie_genre
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicartist
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicgenre
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicartist
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicgenre
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_developer
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_softwarepublisher
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM person_category ORDER BY Name
    INFO [datafetcher-Loan] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_category ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_category ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_platform ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_storagemedium ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_storagemedium ORDER BY Name
    INFO [datafetcher-Music Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicgenre ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_category ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_storagemedium ORDER BY Name
    INFO [datafetcher-Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_genre ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_storagemedium ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM audiocd_state ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_storagemedium ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, ID, Location, Lyric, Modified, Playlength, Rating, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM actor_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, DefaultTemplate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, DefaultTemplate, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM developer_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, DefaultTemplate, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork, TemplateName FROM user_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Edit, Field, ID, Modified, Module, Plugin, TemplateName, User, View FROM permission_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musictrack_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_state ORDER BY Name
    ERROR [datafetcher-Template] (WorkFlow.java:133) - An error occurred while converting result set to items
    java.lang.NullPointerException
        at net.datacrow.core.data.DataManager.getObject(DataManager.java:532)
        at net.datacrow.core.data.DataManager.getObject(DataManager.java:520)
        at net.datacrow.core.data.DataManager.getObject(DataManager.java:512)
        at net.datacrow.core.objects.DcValue.setValue(DcValue.java:125)
        at net.datacrow.core.objects.DcObject.setValue(DcObject.java:513)
        at net.datacrow.core.objects.DcObject.setValueForColumn(DcObject.java:176)
        at net.datacrow.core.wf.WorkFlow.convertToDCObjects(WorkFlow.java:114)
        at net.datacrow.core.db.DatabaseManager.executeQuery(DatabaseManager.java:194)
        at net.datacrow.core.db.DatabaseManager.executeQuery(DatabaseManager.java:155)
        at net.datacrow.core.modules.DcModule.loadData(DcModule.java:393)
        at net.datacrow.core.data.DataManager$DataFetcher.run(DataManager.java:762)
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, DefaultTemplate, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, TemplateName, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie_template ORDER BY ID
    INFO [datafetcher-bookpublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher ORDER BY ID
    INFO [datafetcher-developer] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Developer ORDER BY ID
    INFO [datafetcher-softwarepublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher ORDER BY ID
    INFO [datafetcher-contactperson] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person ORDER BY ID
    INFO [datafetcher-director] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director ORDER BY ID
    INFO [datafetcher-musicartist] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist ORDER BY ID
    INFO [datafetcher-author] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author ORDER BY ID
    INFO [datafetcher-Actor] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Actor ORDER BY ID
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, ID, Location, Lyric, Modified, Playlength, Rating, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack ORDER BY ID
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack ORDER BY ID
    INFO [AWT-EventQueue-0] (DatabaseManager.java:207) - SELECT DISTINCT Created, Edit, Field, ID, Modified, Module, Plugin, User, View FROM permission ORDER BY ID
    INFO [datafetcher-audiocd] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-image] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image ORDER BY ID
    INFO [datafetcher-book] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book ORDER BY ID
    INFO [datafetcher-musicalbum] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum ORDER BY ID
    INFO [datafetcher-Software] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software ORDER BY ID
    INFO [datafetcher-media] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-User] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork FROM user ORDER BY ID
    INFO [datafetcher-movie] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie ORDER BY ID
    INFO [AWT-EventQueue-0] (MainFrame.java:509) - Session has been interrupted. Shutting down!
    INFO [main] (DataCrow.java:130) - System is being started
    INFO [main] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Genres
    INFO [main] (ModuleUpgrade.java:348) - Upgraded module audiotrack, remove field Artists
    INFO [main] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Genres
    INFO [main] (ModuleUpgrade.java:270) - Upgraded module audiotrack, added field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module audiocd, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module audiotrack, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module musicalbum, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module musictrack, altered field Artists
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module book, altered field Publishers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module book, altered field Authors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Actors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Directors
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field Subtitle Language
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module movie, altered field ASIN
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Developers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field Publishers
    INFO [main] (ModuleUpgrade.java:317) - Upgraded module Software, altered field ASIN
    INFO [main] (DataCrow.java:136) - Modules have been loaded
    INFO [main] (DcDatabase.java:122) - Found the picture table
    INFO [main] (DcDatabase.java:122) - Found the x_audiocd_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_audiocd_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_audiotrack_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_audiotrack_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_book_author table
    INFO [main] (DcDatabase.java:122) - Found the x_book_bookpublisher table
    INFO [main] (DcDatabase.java:122) - Found the x_movie_actor table
    INFO [main] (DcDatabase.java:122) - Found the x_movie_director table
    INFO [main] (DcDatabase.java:122) - Found the x_movie_movie_genre table
    INFO [main] (DcDatabase.java:122) - Found the x_musicalbum_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_musicalbum_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_musictrack_musicartist table
    INFO [main] (DcDatabase.java:122) - Found the x_musictrack_musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the x_software_developer table
    INFO [main] (DcDatabase.java:122) - Found the x_software_softwarepublisher table
    INFO [main] (DcDatabase.java:122) - Found the actor table
    INFO [main] (DcDatabase.java:122) - Found the musicartist table
    INFO [main] (DcDatabase.java:122) - Found the audiocd table
    INFO [main] (DcDatabase.java:122) - Found the audiotrack table
    INFO [main] (DcDatabase.java:122) - Found the author table
    INFO [main] (DcDatabase.java:122) - Found the book table
    INFO [main] (DcDatabase.java:122) - Found the person_category table
    INFO [main] (DcDatabase.java:122) - Found the book_category table
    INFO [main] (DcDatabase.java:122) - Found the image_category table
    INFO [main] (DcDatabase.java:122) - Found the software_category table
    INFO [main] (DcDatabase.java:122) - Found the person table
    INFO [main] (DcDatabase.java:122) - Found the developer table
    INFO [main] (DcDatabase.java:122) - Found the director table
    INFO [main] (DcDatabase.java:122) - Found the movie_genre table
    INFO [main] (DcDatabase.java:122) - Found the image table
    INFO [main] (DcDatabase.java:122) - Found the loans table
    INFO [main] (DcDatabase.java:122) - Found the movie table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum table
    INFO [main] (DcDatabase.java:122) - Found the musicgenre table
    INFO [main] (DcDatabase.java:122) - Found the musictrack table
    INFO [main] (DcDatabase.java:122) - Found the permission table
    INFO [main] (DcDatabase.java:122) - Found the book_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the image_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the movie_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the software_platform table
    INFO [main] (DcDatabase.java:122) - Found the software_storagemedium table
    INFO [main] (DcDatabase.java:122) - Found the bookpublisher table
    INFO [main] (DcDatabase.java:122) - Found the softwarepublisher table
    INFO [main] (DcDatabase.java:122) - Found the software table
    INFO [main] (DcDatabase.java:122) - Found the audiocd_state table
    INFO [main] (DcDatabase.java:122) - Found the book_state table
    INFO [main] (DcDatabase.java:122) - Found the image_state table
    INFO [main] (DcDatabase.java:122) - Found the movie_state table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum_state table
    INFO [main] (DcDatabase.java:122) - Found the musictrack_state table
    INFO [main] (DcDatabase.java:122) - Found the software_state table
    INFO [main] (DcDatabase.java:122) - Found the user_template table
    INFO [main] (DcDatabase.java:122) - Found the permission_template table
    INFO [main] (DcDatabase.java:122) - Found the actor_template table
    INFO [main] (DcDatabase.java:122) - Found the author_template table
    INFO [main] (DcDatabase.java:122) - Found the bookpublisher_template table
    INFO [main] (DcDatabase.java:122) - Found the person_template table
    INFO [main] (DcDatabase.java:122) - Found the developer_template table
    INFO [main] (DcDatabase.java:122) - Found the director_template table
    INFO [main] (DcDatabase.java:122) - Found the musicartist_template table
    INFO [main] (DcDatabase.java:122) - Found the softwarepublisher_template table
    INFO [main] (DcDatabase.java:122) - Found the audiocd_template table
    INFO [main] (DcDatabase.java:122) - Found the audiotrack_template table
    INFO [main] (DcDatabase.java:122) - Found the book_template table
    INFO [main] (DcDatabase.java:122) - Found the image_template table
    INFO [main] (DcDatabase.java:122) - Found the movie_template table
    INFO [main] (DcDatabase.java:122) - Found the musicalbum_template table
    INFO [main] (DcDatabase.java:122) - Found the musictrack_template table
    INFO [main] (DcDatabase.java:122) - Found the software_template table
    INFO [main] (DcDatabase.java:122) - Found the user table
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT Field, Filename, Height, ObjectID, Width FROM picture
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_author
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_bookpublisher
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_actor
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_director
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_movie_genre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicartist
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicgenre
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_developer
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_softwarepublisher
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM person_category ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_category ORDER BY Name
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_category ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_storagemedium ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM actor_template ORDER BY ID
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_storagemedium ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher_template ORDER BY ID
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_storagemedium ORDER BY Name
    INFO [datafetcher-Music Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicgenre ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_state ORDER BY Name
    INFO [datafetcher-Genre] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_genre ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM developer_template ORDER BY ID
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_storagemedium ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book_template ORDER BY ID
    INFO [datafetcher-Category] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_category ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, DefaultTemplate, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork, TemplateName FROM user_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musictrack_state ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_state ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_storagemedium ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM audiocd_state ORDER BY Name
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_state ORDER BY Name
    INFO [datafetcher-Platform] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_platform ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, DefaultTemplate, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, ID, Location, Lyric, Modified, Playlength, Rating, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack_template ORDER BY ID
    INFO [datafetcher-State] (DatabaseManager.java:207) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_state ORDER BY Name
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, ID, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Edit, Field, ID, Modified, Module, Plugin, TemplateName, User, View FROM permission_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Created, DefaultTemplate, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, DefaultTemplate, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software_template ORDER BY ID
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, DefaultTemplate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image_template ORDER BY ID
    INFO [datafetcher-Loan] (DatabaseManager.java:207) - SELECT DISTINCT PersonID, Created, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
    ERROR [datafetcher-Template] (WorkFlow.java:133) - An error occurred while converting result set to items
    java.lang.NullPointerException
        at net.datacrow.core.data.DataManager.getObject(DataManager.java:532)
        at net.datacrow.core.data.DataManager.getObject(DataManager.java:520)
        at net.datacrow.core.data.DataManager.getObject(DataManager.java:512)
        at net.datacrow.core.objects.DcValue.setValue(DcValue.java:125)
        at net.datacrow.core.objects.DcObject.setValue(DcObject.java:513)
        at net.datacrow.core.objects.DcObject.setValueForColumn(DcObject.java:176)
        at net.datacrow.core.wf.WorkFlow.convertToDCObjects(WorkFlow.java:114)
        at net.datacrow.core.db.DatabaseManager.executeQuery(DatabaseManager.java:194)
        at net.datacrow.core.db.DatabaseManager.executeQuery(DatabaseManager.java:155)
        at net.datacrow.core.modules.DcModule.loadData(DcModule.java:393)
        at net.datacrow.core.data.DataManager$DataFetcher.run(DataManager.java:762)
    INFO [datafetcher-Template] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, DefaultTemplate, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, TemplateName, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie_template ORDER BY ID
    INFO [datafetcher-musicartist] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist ORDER BY ID
    INFO [datafetcher-softwarepublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher ORDER BY ID
    INFO [datafetcher-contactperson] (DatabaseManager.java:207) - SELECT DISTINCT Address, Category, City, Country, Created, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person ORDER BY ID
    INFO [datafetcher-director] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director ORDER BY ID
    INFO [datafetcher-developer] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Developer ORDER BY ID
    INFO [datafetcher-bookpublisher] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher ORDER BY ID
    INFO [datafetcher-author] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author ORDER BY ID
    INFO [datafetcher-Actor] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, ID, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Actor ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, ID, Location, Lyric, Modified, Playlength, Rating, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT AlbumID, Created, Description, Encoding, Filehash, Filename, Filesize, ID, Location, Lyric, Modified, Playlength, Quality, Rating, State, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack ORDER BY ID
    INFO [main] (DatabaseManager.java:207) - SELECT DISTINCT Created, Edit, Field, ID, Modified, Module, Plugin, User, View FROM permission ORDER BY ID
    INFO [datafetcher-audiocd] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-image] (DatabaseManager.java:207) - SELECT DISTINCT Camera, Category, Compression, Created, ImageDate, Description, Filehash, Filename, Filesize, Height, ID, Location, Modified, Place, Rating, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image ORDER BY ID
    INFO [datafetcher-book] (DatabaseManager.java:207) - SELECT DISTINCT Category, Created, Description, Filehash, Filename, Filesize, ID, ISBN, ISBN13, Location, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book ORDER BY ID
    INFO [datafetcher-musicalbum] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum ORDER BY ID
    INFO [datafetcher-User] (DatabaseManager.java:207) - SELECT DISTINCT Address, Admin, City, Country, Created, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork FROM user ORDER BY ID
    INFO [datafetcher-Software] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, Category, Created, Description, Filehash, Filename, Filesize, ID, Location, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software ORDER BY ID
    INFO [datafetcher-media] (DatabaseManager.java:207) - SELECT DISTINCT Created, Description, DiscID, ID, Location, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
    INFO [datafetcher-movie] (DatabaseManager.java:207) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Country, Created, Description, EpisodeNumber, EpisodeName, Filehash, Filename, Filesize, Fps, Frames, Height, ID, Language, Location, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie ORDER BY ID
    INFO [Timer-0] (ImageStore.java:99) - There are 4 images loaded into memory. Removing 0.
    INFO [Thread-9] (DcDatabase.java:122) - Found the picture table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_audiocd_musicartist table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_audiocd_musicgenre table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_audiotrack_musicartist table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_audiotrack_musicgenre table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_book_author table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_book_bookpublisher table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_movie_actor table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_movie_director table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_movie_movie_genre table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_musicalbum_musicartist table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_musicalbum_musicgenre table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_musictrack_musicartist table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_musictrack_musicgenre table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_software_developer table
    INFO [Thread-9] (DcDatabase.java:122) - Found the x_software_softwarepublisher table
    INFO [Thread-9] (DcDatabase.java:122) - Found the actor table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musicartist table
    INFO [Thread-9] (DcDatabase.java:122) - Found the audiocd table
    INFO [Thread-9] (DcDatabase.java:122) - Found the audiotrack table
    INFO [Thread-9] (DcDatabase.java:122) - Found the author table
    INFO [Thread-9] (DcDatabase.java:122) - Found the book table
    INFO [Thread-9] (DcDatabase.java:122) - Found the person_category table
    INFO [Thread-9] (DcDatabase.java:122) - Found the book_category table
    INFO [Thread-9] (DcDatabase.java:122) - Found the image_category table
    INFO [Thread-9] (DcDatabase.java:122) - Found the software_category table
    INFO [Thread-9] (DcDatabase.java:122) - Found the person table
    INFO [Thread-9] (DcDatabase.java:122) - Found the developer table
    INFO [Thread-9] (DcDatabase.java:122) - Found the director table
    INFO [Thread-9] (DcDatabase.java:122) - Found the movie_genre table
    INFO [Thread-9] (DcDatabase.java:122) - Found the image table
    INFO [Thread-9] (DcDatabase.java:122) - Found the loans table
    INFO [Thread-9] (DcDatabase.java:122) - Found the movie table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musicalbum table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musicgenre table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musictrack table
    INFO [Thread-9] (DcDatabase.java:122) - Found the permission table
    INFO [Thread-9] (DcDatabase.java:122) - Found the book_storagemedium table
    INFO [Thread-9] (DcDatabase.java:122) - Found the image_storagemedium table
    INFO [Thread-9] (DcDatabase.java:122) - Found the movie_storagemedium table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musicalbum_storagemedium table
    INFO [Thread-9] (DcDatabase.java:122) - Found the software_platform table
    INFO [Thread-9] (DcDatabase.java:122) - Found the software_storagemedium table
    INFO [Thread-9] (DcDatabase.java:122) - Found the bookpublisher table
    INFO [Thread-9] (DcDatabase.java:122) - Found the softwarepublisher table
    INFO [Thread-9] (DcDatabase.java:122) - Found the software table
    INFO [Thread-9] (DcDatabase.java:122) - Found the audiocd_state table
    INFO [Thread-9] (DcDatabase.java:122) - Found the book_state table
    INFO [Thread-9] (DcDatabase.java:122) - Found the image_state table
    INFO [Thread-9] (DcDatabase.java:122) - Found the movie_state table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musicalbum_state table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musictrack_state table
    INFO [Thread-9] (DcDatabase.java:122) - Found the software_state table
    INFO [Thread-9] (DcDatabase.java:122) - Found the user_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the permission_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the actor_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the author_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the bookpublisher_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the person_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the developer_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the director_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musicartist_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the softwarepublisher_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the audiocd_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the audiotrack_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the book_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the image_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the movie_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musicalbum_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the musictrack_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the software_template table
    INFO [Thread-9] (DcDatabase.java:122) - Found the user table
    INFO [AWT-EventQueue-0] (MainFrame.java:509) - Session has been interrupted. Shutting down!

     
    • You do not need to upgrade to each of the incremental versions. (It should work though).
      For now, could you try to install the latest version and restore your database in that version?

       
    • on upgrading from 3.2.2.1 to 3.4.1

      pop-up window:

      Could not determine version...etc

      pop-up window:

      The restore was successful... datacrow will now

      exit

      re-start datacrow

      pop-up widow:

      Could not determine version...etc

      pop-up window:

      Upgrade for version <3.4.0 location will be

      converted to new container structure

      pop-up window:

      Upgrade for <3.4.0 created & modified columns

      will be converted to date column

      hi,

      thanks for your reply, here's the upgrade details

      pop-up window:

      (with Error at top - no message)

      click ok

      datacrow exits

      re-start datacrow

      empty error pop-up widow appears - nothing else

      regards

      robin

      INFO [main] (Services.java:73) - Registered online server MusicBrainzArtistServer
      INFO [main] (Services.java:73) - Registered online server ImdbDirectorServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesSoftwareServer
      INFO [main] (Services.java:73) - Registered online server OfdbMovieServer
      INFO [main] (Services.java:73) - Registered online server BolMovieServer
      INFO [main] (Services.java:73) - Registered online server AmazonBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbActorServer
      INFO [main] (Services.java:73) - Registered online server AmazonSoftwareServer
      INFO [main] (Services.java:73) - Registered online server AmazonAudioCDServer
      INFO [main] (Services.java:73) - Registered online server DiscogsAudioCDServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesPublisherServer
      INFO [main] (Services.java:73) - Registered online server WikipediaMovieServer
      INFO [main] (Services.java:73) - Registered online server BolBookServer
      INFO [main] (Services.java:73) - Registered online server AlapageBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbMovieServer
      INFO [main] (Services.java:73) - Registered online server McuBookServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesDeveloperServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMovieServer
      INFO [main] (Services.java:73) - Registered online server DiscogsMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzAudioCDServer
      INFO [main] (Services.java:73) - Registered online server BarnesNobleBookServer
      INFO [main] (DataCrow.java:153) - System is being started
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Genres
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Artists
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Genres
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiocd, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiotrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musicalbum, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musictrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Authors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Actors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Directors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Subtitle Language
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field ASIN
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Developers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field ASIN
      INFO [main] (DataCrow.java:160) - Modules have been loaded
      INFO [main] (DatabaseManager.java:156) - User 'dc_admin' with password 'UK*soccer*96' cannot login
      INFO [main] (DatabaseManager.java:156) - User 'dc_admin' with password 'UK*soccer*96' cannot login
      INFO [main] (DcDatabase.java:163) - Found the picture table
      INFO [main] (DcDatabase.java:166) - x_audiocd_musicartist table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@140984b[sql=[CREATE MEMORY TABLE x_audiocd_musicartist
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_audiocd_musicgenre table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1ce669e[sql=[CREATE MEMORY TABLE x_audiocd_musicgenre
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_audiotrack_musicartist table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1b33a0e[sql=[CREATE MEMORY TABLE x_audiotrack_musicartist
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_audiotrack_musicgenre table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1a8773c[sql=[CREATE MEMORY TABLE x_audiotrack_musicgenre
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_book_author table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@12c3327[sql=[CREATE MEMORY TABLE x_book_author
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_book_bookpublisher table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@10f41e9[sql=[CREATE MEMORY TABLE x_book_bookpublisher
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_movie_actor table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@b05acd[sql=[CREATE MEMORY TABLE x_movie_actor
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_movie_director table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1989b5[sql=[CREATE MEMORY TABLE x_movie_director
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_movie_movie_genre table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@a00185[sql=[CREATE MEMORY TABLE x_movie_movie_genre
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_musicalbum_musicartist table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@c3c315[sql=[CREATE MEMORY TABLE x_musicalbum_musicartist
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_musicalbum_musicgenre table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@3c9c31[sql=[CREATE MEMORY TABLE x_musicalbum_musicgenre
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_musictrack_musicartist table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1328c7a[sql=[CREATE MEMORY TABLE x_musictrack_musicartist
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_musictrack_musicgenre table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1a4ded3[sql=[CREATE MEMORY TABLE x_musictrack_musicgenre
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_software_developer table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@121177e[sql=[CREATE MEMORY TABLE x_software_developer
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - x_software_softwarepublisher table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@18d7ace[sql=[CREATE MEMORY TABLE x_software_softwarepublisher
      (ObjectID bigint, ReferencedId bigint);]]
      INFO [main] (DcDatabase.java:166) - actor table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@179953c[sql=[CREATE MEMORY TABLE actor
      (Created date, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - musicartist table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1d381d2[sql=[CREATE MEMORY TABLE musicartist
      (Created date, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - audiocd table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@f01771[sql=[CREATE MEMORY TABLE audiocd
      (Container bigint, Created date, Description longvarchar, DiscID varchar(255), EAN varchar(255), ID bigint PRIMARY KEY, Modified date, Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - audiotrack table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@933bcb[sql=[CREATE MEMORY TABLE audiotrack
      (AlbumID bigint, Created date, Description longvarchar, ID bigint PRIMARY KEY, Lyric longvarchar, Modified date, Playlength bigint, Rating bigint, Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - author table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@3ac93e[sql=[CREATE MEMORY TABLE author
      (Created date, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - book table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1722456[sql=[CREATE MEMORY TABLE book
      (Category bigint, Container bigint, Created date, Description longvarchar, Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, ISBN varchar(20), ISBN13 varchar(20), Modified date, pages bigint, Rating bigint, Series varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VolumeNumber bigint, VolumeName varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - person_category table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@afa68a[sql=[CREATE MEMORY TABLE person_category
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - book_category table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@aa233f[sql=[CREATE MEMORY TABLE book_category
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - image_category table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1f01a29[sql=[CREATE MEMORY TABLE image_category
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - software_category table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@c01e99[sql=[CREATE MEMORY TABLE software_category
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - person table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@d75415[sql=[CREATE MEMORY TABLE person
      (Address longvarchar, Category bigint, City varchar(255), Country varchar(255), Created date, Description longvarchar, Email varchar(255), ID bigint PRIMARY KEY, Modified date, Name varchar(255), PhoneHome varchar(50), PhoneWork varchar(50), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255));]]
      INFO [main] (DcDatabase.java:166) - container_containertype table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@d16fc1[sql=[CREATE MEMORY TABLE container_containertype
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - container table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1eb0[sql=[CREATE MEMORY TABLE container
      (ContainerType bigint, Created date, Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Modified date, Name varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255));]]
      INFO [main] (DcDatabase.java:166) - developer table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1dee400[sql=[CREATE MEMORY TABLE developer
      (Created date, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - director table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@c5e9c[sql=[CREATE MEMORY TABLE director
      (Created date, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - movie_genre table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1777b1[sql=[CREATE MEMORY TABLE movie_genre
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - image table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@e3849c[sql=[CREATE MEMORY TABLE image
      (Camera varchar(255), Category bigint, Compression bigint, Container bigint, Created date, ImageDate date, Description longvarchar, Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, Height bigint, ID bigint PRIMARY KEY, Modified date, Place varchar(500), Rating bigint, State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Width bigint, Year bigint);]]
      INFO [main] (DcDatabase.java:166) - loans table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@13936e1[sql=[CREATE MEMORY TABLE loans
      (PersonID bigint, Created date, DueDate date, EndDate date, ID bigint PRIMARY KEY, Modified date, ObjectID bigint, StartDate date);]]
      INFO [main] (DcDatabase.java:166) - movie table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@141fab6[sql=[CREATE MEMORY TABLE movie
      (ASIN varchar(50), AudioBitrate varchar(10), AudioChannels varchar(10), AudioCodec varchar(255), AudioLanguage varchar(50), AudioSampleRate varchar(10), Certification varchar(255), Container bigint, Country varchar(255), Created date, Description longvarchar, EAN varchar(255), EpisodeNumber bigint, EpisodeName varchar(255), Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, Fps varchar(10), Frames varchar(10), Height varchar(10), ID bigint PRIMARY KEY, Language varchar(50), Modified date, Playlength bigint, Rating bigint, Season varchar(255), Program varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, SubtitleLanguage varchar(500), Title varchar(255), Title2 varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VideoBitRate varchar(10), VideoCodec varchar(255), webpage varchar(255), Width varchar(10), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - musicalbum table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@b301f2[sql=[CREATE MEMORY TABLE musicalbum
      (Container bigint, Created date, Description longvarchar, DiscID varchar(255), ID bigint PRIMARY KEY, Modified date, Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - musicgenre table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@44cbbe[sql=[CREATE MEMORY TABLE musicgenre
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - musictrack table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1697b67[sql=[CREATE MEMORY TABLE musictrack
      (AlbumID bigint, Created date, Description longvarchar, Encoding varchar(255), Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Lyric longvarchar, Modified date, Playlength bigint, Quality bigint, Rating bigint, State bigint, Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:163) - Found the permission table
      INFO [main] (DcDatabase.java:166) - software_platform table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@24c4a3[sql=[CREATE MEMORY TABLE software_platform
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - bookpublisher table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1554d32[sql=[CREATE MEMORY TABLE bookpublisher
      (Created date, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - softwarepublisher table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@13f136e[sql=[CREATE MEMORY TABLE softwarepublisher
      (Created date, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - software table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@7a4489[sql=[CREATE MEMORY TABLE software
      (ASIN varchar(50), Category bigint, Container bigint, Created date, Description longvarchar, EAN varchar(255), Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Modified date, Multiplayer varchar(4), Platform bigint, Rating bigint, SerialKey varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - audiocd_state table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1a61172[sql=[CREATE MEMORY TABLE audiocd_state
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - book_state table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1c391c3[sql=[CREATE MEMORY TABLE book_state
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - image_state table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1e67e6a[sql=[CREATE MEMORY TABLE image_state
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - movie_state table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1758500[sql=[CREATE MEMORY TABLE movie_state
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - musicalbum_state table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@6ed322[sql=[CREATE MEMORY TABLE musicalbum_state
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - musictrack_state table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@bf053f[sql=[CREATE MEMORY TABLE musictrack_state
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - software_state table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@f1916f[sql=[CREATE MEMORY TABLE software_state
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - book_storagemedium table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1f54c5f[sql=[CREATE MEMORY TABLE book_storagemedium
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - image_storagemedium table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@16917ee[sql=[CREATE MEMORY TABLE image_storagemedium
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - movie_storagemedium table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@a23610[sql=[CREATE MEMORY TABLE movie_storagemedium
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - musicalbum_storagemedium table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1d49247[sql=[CREATE MEMORY TABLE musicalbum_storagemedium
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - software_storagemedium table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1fe8ce8[sql=[CREATE MEMORY TABLE software_storagemedium
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:166) - user_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@d4d66b[sql=[CREATE MEMORY TABLE user_template
      (Address varchar(255), Admin boolean, City varchar(255), Country varchar(255), Created date, DefaultTemplate boolean, Description longvarchar, Email varchar(255), Enabled boolean, ID bigint PRIMARY KEY, LoginName varchar(255), Modified date, Name varchar(255), PhoneHome varchar(255), PhoneWork varchar(255), TemplateName varchar(255));]]
      INFO [main] (DcDatabase.java:166) - permission_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@149105b[sql=[CREATE MEMORY TABLE permission_template
      (Created date, DefaultTemplate boolean, Edit boolean, Field bigint, ID bigint PRIMARY KEY, Modified date, Module bigint, Plugin varchar(255), TemplateName varchar(255), User bigint, View boolean);]]
      INFO [main] (DcDatabase.java:166) - actor_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1d0d45b[sql=[CREATE MEMORY TABLE actor_template
      (Created date, DefaultTemplate boolean, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - author_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@196f4b5[sql=[CREATE MEMORY TABLE author_template
      (Created date, DefaultTemplate boolean, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - bookpublisher_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@19ba640[sql=[CREATE MEMORY TABLE bookpublisher_template
      (Created date, DefaultTemplate boolean, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - person_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1bfc4fc[sql=[CREATE MEMORY TABLE person_template
      (Address longvarchar, Category bigint, City varchar(255), Country varchar(255), Created date, DefaultTemplate boolean, Description longvarchar, Email varchar(255), ID bigint PRIMARY KEY, Modified date, Name varchar(255), PhoneHome varchar(50), PhoneWork varchar(50), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255));]]
      INFO [main] (DcDatabase.java:166) - container_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@11db6bb[sql=[CREATE MEMORY TABLE container_template
      (ContainerType bigint, Created date, DefaultTemplate boolean, Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Modified date, Name varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255));]]
      INFO [main] (DcDatabase.java:166) - developer_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1fe571f[sql=[CREATE MEMORY TABLE developer_template
      (Created date, DefaultTemplate boolean, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - director_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@109ea96[sql=[CREATE MEMORY TABLE director_template
      (Created date, DefaultTemplate boolean, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - musicartist_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@608760[sql=[CREATE MEMORY TABLE musicartist_template
      (Created date, DefaultTemplate boolean, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - softwarepublisher_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@157ea4a[sql=[CREATE MEMORY TABLE softwarepublisher_template
      (Created date, DefaultTemplate boolean, Description longvarchar, Firstname varchar(255), ID bigint PRIMARY KEY, Lastname varchar(255), Modified date, Name varchar(255), service varchar(255), serviceurl varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), webpage varchar(255));]]
      INFO [main] (DcDatabase.java:166) - audiocd_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@d6b059[sql=[CREATE MEMORY TABLE audiocd_template
      (Container bigint, Created date, DefaultTemplate boolean, Description longvarchar, DiscID varchar(255), EAN varchar(255), ID bigint PRIMARY KEY, Modified date, Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - audiotrack_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@d3c65d[sql=[CREATE MEMORY TABLE audiotrack_template
      (AlbumID bigint, Created date, DefaultTemplate boolean, Description longvarchar, ID bigint PRIMARY KEY, Lyric longvarchar, Modified date, Playlength bigint, Rating bigint, TemplateName varchar(255), Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - book_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1843a75[sql=[CREATE MEMORY TABLE book_template
      (Category bigint, Container bigint, Created date, DefaultTemplate boolean, Description longvarchar, Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, ISBN varchar(20), ISBN13 varchar(20), Modified date, pages bigint, Rating bigint, Series varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VolumeNumber bigint, VolumeName varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - image_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1fcc0a2[sql=[CREATE MEMORY TABLE image_template
      (Camera varchar(255), Category bigint, Compression bigint, Container bigint, Created date, ImageDate date, DefaultTemplate boolean, Description longvarchar, Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, Height bigint, ID bigint PRIMARY KEY, Modified date, Place varchar(500), Rating bigint, State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Width bigint, Year bigint);]]
      INFO [main] (DcDatabase.java:166) - movie_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@10e35d5[sql=[CREATE MEMORY TABLE movie_template
      (ASIN varchar(50), AudioBitrate varchar(10), AudioChannels varchar(10), AudioCodec varchar(255), AudioLanguage varchar(50), AudioSampleRate varchar(10), Certification varchar(255), Container bigint, Country varchar(255), Created date, DefaultTemplate boolean, Description longvarchar, EAN varchar(255), EpisodeNumber bigint, EpisodeName varchar(255), Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, Fps varchar(10), Frames varchar(10), Height varchar(10), ID bigint PRIMARY KEY, Language varchar(50), Modified date, Playlength bigint, Rating bigint, Season varchar(255), Program varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, SubtitleLanguage varchar(500), TemplateName varchar(255), Title varchar(255), Title2 varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), VideoBitRate varchar(10), VideoCodec varchar(255), webpage varchar(255), Width varchar(10), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - musicalbum_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1f03691[sql=[CREATE MEMORY TABLE musicalbum_template
      (Container bigint, Created date, DefaultTemplate boolean, Description longvarchar, DiscID varchar(255), ID bigint PRIMARY KEY, Modified date, Rating bigint, service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - musictrack_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1ce85c4[sql=[CREATE MEMORY TABLE musictrack_template
      (AlbumID bigint, Created date, DefaultTemplate boolean, Description longvarchar, Encoding varchar(255), Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Lyric longvarchar, Modified date, Playlength bigint, Quality bigint, Rating bigint, State bigint, TemplateName varchar(255), Title varchar(255), Track bigint, UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:166) - software_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1b03c1a[sql=[CREATE MEMORY TABLE software_template
      (ASIN varchar(50), Category bigint, Container bigint, Created date, DefaultTemplate boolean, Description longvarchar, EAN varchar(255), Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Modified date, Multiplayer varchar(4), Platform bigint, Rating bigint, SerialKey varchar(255), service varchar(255), serviceurl varchar(255), State bigint, StorageMedium bigint, TemplateName varchar(255), Title varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255), Webpage varchar(255), Year bigint);]]
      INFO [main] (DcDatabase.java:163) - Found the user table
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT Field, Filename, Height, ObjectID, Width FROM picture
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT PersonID, Created, DueDate, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_author
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_bookpublisher
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_actor
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_director
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_movie_genre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_developer
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_softwarepublisher
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM person_category ORDER BY Name
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_category ORDER BY Name
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_category ORDER BY Name
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_category ORDER BY Name
      INFO [datafetcher-Container Type] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM container_containertype ORDER BY Name
      INFO [datafetcher-Genre] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_genre ORDER BY Name
      INFO [datafetcher-Loan] (DatabaseManager.java:225) - SELECT DISTINCT PersonID, Created, DueDate, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
      INFO [datafetcher-Music Genre] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicgenre ORDER BY Name
      INFO [datafetcher-Platform] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_platform ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM audiocd_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musictrack_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_state ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_storagemedium ORDER BY Name
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Address, Admin, City, Country, Created, DefaultTemplate, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork, TemplateName FROM user_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Edit, Field, ID, Modified, Module, Plugin, TemplateName, User, View FROM permission_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM actor_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Address, Category, City, Country, Created, DefaultTemplate, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT ContainerType, Created, DefaultTemplate, Filehash, FilehashType, Filename, Filesize, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM container_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM developer_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, DefaultTemplate, Description, DiscID, EAN, ID, Modified, Rating, service, serviceurl, State, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, ID, Lyric, Modified, Playlength, Rating, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Category, Container, Created, DefaultTemplate, Description, Filehash, FilehashType, Filename, Filesize, ID, ISBN, ISBN13, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Camera, Category, Compression, Container, Created, ImageDate, DefaultTemplate, Description, Filehash, FilehashType, Filename, Filesize, Height, ID, Modified, Place, Rating, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Container, Country, Created, DefaultTemplate, Description, EAN, EpisodeNumber, EpisodeName, Filehash, FilehashType, Filename, Filesize, Fps, Frames, Height, ID, Language, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, TemplateName, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, DefaultTemplate, Description, DiscID, ID, Modified, Rating, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, Encoding, Filehash, FilehashType, Filename, Filesize, ID, Lyric, Modified, Playlength, Quality, Rating, State, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, Category, Container, Created, DefaultTemplate, Description, EAN, Filehash, FilehashType, Filename, Filesize, ID, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software_template ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, Description, ID, Lyric, Modified, Playlength, Rating, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, Description, Encoding, Filehash, FilehashType, Filename, Filesize, ID, Lyric, Modified, Playlength, Quality, Rating, State, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT Created, Edit, Field, ID, Modified, Module, Plugin, User, View FROM permission ORDER BY ID
      INFO [datafetcher-Actor] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Actor ORDER BY ID
      INFO [datafetcher-musicartist] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist ORDER BY ID
      INFO [datafetcher-author] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author ORDER BY ID
      INFO [datafetcher-contactperson] (DatabaseManager.java:225) - SELECT DISTINCT Address, Category, City, Country, Created, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person ORDER BY ID
      INFO [datafetcher-container] (DatabaseManager.java:225) - SELECT DISTINCT ContainerType, Created, Filehash, FilehashType, Filename, Filesize, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM container ORDER BY ID
      INFO [datafetcher-developer] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Developer ORDER BY ID
      INFO [datafetcher-director] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director ORDER BY ID
      INFO [datafetcher-bookpublisher] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher ORDER BY ID
      INFO [datafetcher-softwarepublisher] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher ORDER BY ID
      INFO [datafetcher-audiocd] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, Description, DiscID, EAN, ID, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
      INFO [datafetcher-book] (DatabaseManager.java:225) - SELECT DISTINCT Category, Container, Created, Description, Filehash, FilehashType, Filename, Filesize, ID, ISBN, ISBN13, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book ORDER BY ID
      INFO [datafetcher-image] (DatabaseManager.java:225) - SELECT DISTINCT Camera, Category, Compression, Container, Created, ImageDate, Description, Filehash, FilehashType, Filename, Filesize, Height, ID, Modified, Place, Rating, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image ORDER BY ID
      INFO [datafetcher-movie] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Container, Country, Created, Description, EAN, EpisodeNumber, EpisodeName, Filehash, FilehashType, Filename, Filesize, Fps, Frames, Height, ID, Language, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie ORDER BY ID
      INFO [datafetcher-musicalbum] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, Description, DiscID, ID, Modified, Rating, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum ORDER BY ID
      INFO [datafetcher-Software] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, Category, Container, Created, Description, EAN, Filehash, FilehashType, Filename, Filesize, ID, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software ORDER BY ID
      INFO [datafetcher-User] (DatabaseManager.java:225) - SELECT DISTINCT Address, Admin, City, Country, Created, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork FROM user ORDER BY ID
      INFO [Timer-0] (ImageStore.java:99) - There are 4 images loaded into memory. Removing 4.
      INFO [AWT-EventQueue-0] (MainFrame.java:536) - Data Crow is gracefully shutting down.
      INFO [AWT-EventQueue-0] (DataManager.java:694) - Writing item cache to disk.
      INFO [main] (Services.java:73) - Registered online server MusicBrainzArtistServer
      INFO [main] (Services.java:73) - Registered online server ImdbDirectorServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesSoftwareServer
      INFO [main] (Services.java:73) - Registered online server OfdbMovieServer
      INFO [main] (Services.java:73) - Registered online server BolMovieServer
      INFO [main] (Services.java:73) - Registered online server AmazonBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbActorServer
      INFO [main] (Services.java:73) - Registered online server AmazonSoftwareServer
      INFO [main] (Services.java:73) - Registered online server AmazonAudioCDServer
      INFO [main] (Services.java:73) - Registered online server DiscogsAudioCDServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesPublisherServer
      INFO [main] (Services.java:73) - Registered online server WikipediaMovieServer
      INFO [main] (Services.java:73) - Registered online server BolBookServer
      INFO [main] (Services.java:73) - Registered online server AlapageBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbMovieServer
      INFO [main] (Services.java:73) - Registered online server McuBookServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesDeveloperServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMovieServer
      INFO [main] (Services.java:73) - Registered online server DiscogsMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzAudioCDServer
      INFO [main] (Services.java:73) - Registered online server BarnesNobleBookServer
      INFO [main] (DataCrow.java:153) - System is being started
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Genres
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Artists
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Genres
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiocd, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiotrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musicalbum, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musictrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Authors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Actors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Directors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Subtitle Language
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field ASIN
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Developers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field ASIN
      INFO [main] (DataCrow.java:160) - Modules have been loaded
      INFO [main] (DcDatabase.java:163) - Found the picture table
      INFO [main] (DcDatabase.java:163) - Found the x_audiocd_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_audiocd_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_audiotrack_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_audiotrack_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_book_author table
      INFO [main] (DcDatabase.java:163) - Found the x_book_bookpublisher table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_actor table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_director table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_movie_genre table
      INFO [main] (DcDatabase.java:163) - Found the x_musicalbum_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_musicalbum_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_musictrack_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_musictrack_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_software_developer table
      INFO [main] (DcDatabase.java:163) - Found the x_software_softwarepublisher table
      INFO [main] (DcDatabase.java:163) - Found the actor table
      INFO [main] (DcDatabase.java:163) - Found the musicartist table
      INFO [main] (DcDatabase.java:163) - Found the audiocd table
      INFO [main] (DcDatabase.java:163) - Found the audiotrack table
      INFO [main] (DcDatabase.java:163) - Found the author table
      INFO [main] (DcDatabase.java:163) - Found the book table
      INFO [main] (DcDatabase.java:163) - Found the person_category table
      INFO [main] (DcDatabase.java:163) - Found the book_category table
      INFO [main] (DcDatabase.java:163) - Found the image_category table
      INFO [main] (DcDatabase.java:163) - Found the software_category table
      INFO [main] (DcDatabase.java:163) - Found the person table
      INFO [main] (DcDatabase.java:163) - Found the container_containertype table
      INFO [main] (DcDatabase.java:163) - Found the container table
      INFO [main] (DcDatabase.java:163) - Found the developer table
      INFO [main] (DcDatabase.java:163) - Found the director table
      INFO [main] (DcDatabase.java:163) - Found the movie_genre table
      INFO [main] (DcDatabase.java:163) - Found the image table
      INFO [main] (DcDatabase.java:163) - Found the loans table
      INFO [main] (DcDatabase.java:163) - Found the movie table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum table
      INFO [main] (DcDatabase.java:163) - Found the musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the musictrack table
      INFO [main] (DcDatabase.java:163) - Found the permission table
      INFO [main] (DcDatabase.java:163) - Found the software_platform table
      INFO [main] (DcDatabase.java:163) - Found the bookpublisher table
      INFO [main] (DcDatabase.java:163) - Found the softwarepublisher table
      INFO [main] (DcDatabase.java:163) - Found the software table
      INFO [main] (DcDatabase.java:163) - Found the audiocd_state table
      INFO [main] (DcDatabase.java:163) - Found the book_state table
      INFO [main] (DcDatabase.java:163) - Found the image_state table
      INFO [main] (DcDatabase.java:163) - Found the movie_state table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_state table
      INFO [main] (DcDatabase.java:163) - Found the musictrack_state table
      INFO [main] (DcDatabase.java:163) - Found the software_state table
      INFO [main] (DcDatabase.java:163) - Found the book_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the image_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the movie_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the software_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the user_template table
      INFO [main] (DcDatabase.java:163) - Found the permission_template table
      INFO [main] (DcDatabase.java:163) - Found the actor_template table
      INFO [main] (DcDatabase.java:163) - Found the author_template table
      INFO [main] (DcDatabase.java:163) - Found the bookpublisher_template table
      INFO [main] (DcDatabase.java:163) - Found the person_template table
      INFO [main] (DcDatabase.java:163) - Found the container_template table
      INFO [main] (DcDatabase.java:163) - Found the developer_template table
      INFO [main] (DcDatabase.java:163) - Found the director_template table
      INFO [main] (DcDatabase.java:163) - Found the musicartist_template table
      INFO [main] (DcDatabase.java:163) - Found the softwarepublisher_template table
      INFO [main] (DcDatabase.java:163) - Found the audiocd_template table
      INFO [main] (DcDatabase.java:163) - Found the audiotrack_template table
      INFO [main] (DcDatabase.java:163) - Found the book_template table
      INFO [main] (DcDatabase.java:163) - Found the image_template table
      INFO [main] (DcDatabase.java:163) - Found the movie_template table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_template table
      INFO [main] (DcDatabase.java:163) - Found the musictrack_template table
      INFO [main] (DcDatabase.java:163) - Found the software_template table
      INFO [main] (DcDatabase.java:163) - Found the user table
      INFO [Timer-0] (ImageStore.java:99) - There are 0 images loaded into memory. Removing 0.
      INFO [Thread-9] (MainFrame.java:536) - Data Crow is gracefully shutting down.
      INFO [Thread-9] (DataManager.java:694) - Writing item cache to disk.
      INFO [main] (Services.java:73) - Registered online server MusicBrainzArtistServer
      INFO [main] (Services.java:73) - Registered online server ImdbDirectorServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesSoftwareServer
      INFO [main] (Services.java:73) - Registered online server OfdbMovieServer
      INFO [main] (Services.java:73) - Registered online server BolMovieServer
      INFO [main] (Services.java:73) - Registered online server AmazonBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbActorServer
      INFO [main] (Services.java:73) - Registered online server AmazonSoftwareServer
      INFO [main] (Services.java:73) - Registered online server AmazonAudioCDServer
      INFO [main] (Services.java:73) - Registered online server DiscogsAudioCDServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesPublisherServer
      INFO [main] (Services.java:73) - Registered online server WikipediaMovieServer
      INFO [main] (Services.java:73) - Registered online server BolBookServer
      INFO [main] (Services.java:73) - Registered online server AlapageBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbMovieServer
      INFO [main] (Services.java:73) - Registered online server McuBookServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesDeveloperServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMovieServer
      INFO [main] (Services.java:73) - Registered online server DiscogsMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzAudioCDServer
      INFO [main] (Services.java:73) - Registered online server BarnesNobleBookServer
      INFO [main] (DataCrow.java:153) - System is being started
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Genres
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Artists
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module softwarepublisher, added field Firstname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module softwarepublisher, added field Lastname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module musicartist, added field Firstname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module musicartist, added field Lastname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module director, added field Firstname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module director, added field Lastname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module developer, added field Firstname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module developer, added field Lastname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module bookpublisher, added field Firstname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module bookpublisher, added field Lastname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module author, added field Firstname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module author, added field Lastname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module Actor, added field Firstname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module Actor, added field Lastname
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Genres
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Artists
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module movie, added field EAN
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module Software, added field EAN
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiocd, added field EAN
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiocd, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiotrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musicalbum, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musictrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Authors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Actors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Directors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Subtitle Language
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field ASIN
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Developers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field ASIN
      INFO [main] (DataCrow.java:160) - Modules have been loaded
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for actor
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musicartist
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for audiocd
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for audiotrack
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for author
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for book
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for person_category
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for book_category
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for image_category
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for software_category
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for person
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for container
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for developer
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for director
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for movie_genre
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for image
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for loans
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for movie
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musicalbum
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musicgenre
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musictrack
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for permission
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for software_platform
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for bookpublisher
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for softwarepublisher
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for software
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for audiocd_state
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for book_state
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for image_state
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for movie_state
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musicalbum_state
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musictrack_state
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for software_state
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for book_storagemedium
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for image_storagemedium
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for movie_storagemedium
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musicalbum_storagemedium
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for software_storagemedium
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for user_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for permission_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for actor_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for author_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for bookpublisher_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for person_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for developer_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for director_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musicartist_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for softwarepublisher_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for audiocd_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for audiotrack_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for book_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for image_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for movie_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musicalbum_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for musictrack_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for software_template
      INFO [main] (DatabaseUpgrade.java:172) - Converting dates for user
      INFO [main] (DcDatabase.java:163) - Found the picture table
      INFO [main] (DcDatabase.java:163) - Found the x_audiocd_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_audiocd_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_audiotrack_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_audiotrack_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_book_author table
      INFO [main] (DcDatabase.java:163) - Found the x_book_bookpublisher table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_actor table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_director table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_movie_genre table
      INFO [main] (DcDatabase.java:163) - Found the x_musicalbum_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_musicalbum_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_musictrack_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_musictrack_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_software_developer table
      INFO [main] (DcDatabase.java:163) - Found the x_software_softwarepublisher table
      INFO [main] (DcDatabase.java:163) - Found the actor table
      INFO [main] (DcDatabase.java:163) - Found the musicartist table
      INFO [main] (DcDatabase.java:210) - Table audiocd needs to be upgraded. Missing column EAN
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@b4be3d[sql=[alter table audiocd add column EAN varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the audiocd table
      INFO [main] (DcDatabase.java:163) - Found the audiotrack table
      INFO [main] (DcDatabase.java:163) - Found the author table
      INFO [main] (DcDatabase.java:210) - Table book needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@35bb0f[sql=[alter table book add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the book table
      INFO [main] (DcDatabase.java:163) - Found the person_category table
      INFO [main] (DcDatabase.java:163) - Found the book_category table
      INFO [main] (DcDatabase.java:163) - Found the image_category table
      INFO [main] (DcDatabase.java:163) - Found the software_category table
      INFO [main] (DcDatabase.java:163) - Found the person table
      INFO [main] (DcDatabase.java:166) - container_containertype table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@18bd7f1[sql=[CREATE MEMORY TABLE container_containertype
      (Created date, ID bigint PRIMARY KEY, Icon longvarchar, Modified date, Name varchar(255));]]
      INFO [main] (DcDatabase.java:163) - Found the container table
      INFO [main] (DcDatabase.java:163) - Found the developer table
      INFO [main] (DcDatabase.java:163) - Found the director table
      INFO [main] (DcDatabase.java:163) - Found the movie_genre table
      INFO [main] (DcDatabase.java:210) - Table image needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@11eb199[sql=[alter table image add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the image table
      INFO [main] (DcDatabase.java:210) - Table loans needs to be upgraded. Missing column Due Date
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1f0aecc[sql=[alter table loans add column DueDate date]]
      INFO [main] (DcDatabase.java:163) - Found the loans table
      INFO [main] (DcDatabase.java:210) - Table movie needs to be upgraded. Missing column EAN
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@64023c[sql=[alter table movie add column EAN varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table movie needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1cebc9f[sql=[alter table movie add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the movie table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum table
      INFO [main] (DcDatabase.java:163) - Found the musicgenre table
      INFO [main] (DcDatabase.java:210) - Table musictrack needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1c1ac46[sql=[alter table musictrack add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the musictrack table
      INFO [main] (DcDatabase.java:163) - Found the permission table
      INFO [main] (DcDatabase.java:163) - Found the software_platform table
      INFO [main] (DcDatabase.java:163) - Found the bookpublisher table
      INFO [main] (DcDatabase.java:163) - Found the softwarepublisher table
      INFO [main] (DcDatabase.java:210) - Table software needs to be upgraded. Missing column EAN
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1557c0[sql=[alter table software add column EAN varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table software needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1342a67[sql=[alter table software add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the software table
      INFO [main] (DcDatabase.java:163) - Found the audiocd_state table
      INFO [main] (DcDatabase.java:163) - Found the book_state table
      INFO [main] (DcDatabase.java:163) - Found the image_state table
      INFO [main] (DcDatabase.java:163) - Found the movie_state table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_state table
      INFO [main] (DcDatabase.java:163) - Found the musictrack_state table
      INFO [main] (DcDatabase.java:163) - Found the software_state table
      INFO [main] (DcDatabase.java:163) - Found the book_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the image_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the movie_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the software_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the user_template table
      INFO [main] (DcDatabase.java:163) - Found the permission_template table
      INFO [main] (DcDatabase.java:210) - Table actor_template needs to be upgraded. Missing column Firstname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@57ea52[sql=[alter table actor_template add column Firstname varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table actor_template needs to be upgraded. Missing column Lastname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1d8d39f[sql=[alter table actor_template add column Lastname varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the actor_template table
      INFO [main] (DcDatabase.java:210) - Table author_template needs to be upgraded. Missing column Firstname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@2d95b3[sql=[alter table author_template add column Firstname varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table author_template needs to be upgraded. Missing column Lastname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@bf5555[sql=[alter table author_template add column Lastname varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the author_template table
      INFO [main] (DcDatabase.java:210) - Table bookpublisher_template needs to be upgraded. Missing column Firstname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@17b4703[sql=[alter table bookpublisher_template add column Firstname varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table bookpublisher_template needs to be upgraded. Missing column Lastname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@73305c[sql=[alter table bookpublisher_template add column Lastname varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the bookpublisher_template table
      INFO [main] (DcDatabase.java:163) - Found the person_template table
      INFO [main] (DcDatabase.java:166) - container_template table has not been found, creating new !
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@6c1a82[sql=[CREATE MEMORY TABLE container_template
      (ContainerType bigint, Created date, DefaultTemplate boolean, Filehash varchar(32), FilehashType varchar(10), Filename varchar(500), Filesize bigint, ID bigint PRIMARY KEY, Modified date, Name varchar(255), TemplateName varchar(255), UserLongText1 longvarchar, UserInteger1 bigint, UserInteger2 bigint, UserShortText1 varchar(255), UserShortText2 varchar(255));]]
      INFO [main] (DcDatabase.java:210) - Table developer_template needs to be upgraded. Missing column Firstname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1408a92[sql=[alter table developer_template add column Firstname varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table developer_template needs to be upgraded. Missing column Lastname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@4977e2[sql=[alter table developer_template add column Lastname varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the developer_template table
      INFO [main] (DcDatabase.java:210) - Table director_template needs to be upgraded. Missing column Firstname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@15db13f[sql=[alter table director_template add column Firstname varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table director_template needs to be upgraded. Missing column Lastname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1fc1a6[sql=[alter table director_template add column Lastname varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the director_template table
      INFO [main] (DcDatabase.java:210) - Table musicartist_template needs to be upgraded. Missing column Firstname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@e29820[sql=[alter table musicartist_template add column Firstname varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table musicartist_template needs to be upgraded. Missing column Lastname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@718242[sql=[alter table musicartist_template add column Lastname varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the musicartist_template table
      INFO [main] (DcDatabase.java:210) - Table softwarepublisher_template needs to be upgraded. Missing column Firstname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1ec58a[sql=[alter table softwarepublisher_template add column Firstname varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table softwarepublisher_template needs to be upgraded. Missing column Lastname
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@c4d04d[sql=[alter table softwarepublisher_template add column Lastname varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the softwarepublisher_template table
      INFO [main] (DcDatabase.java:210) - Table audiocd_template needs to be upgraded. Missing column Container
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@147917a[sql=[alter table audiocd_template add column Container bigint]]
      INFO [main] (DcDatabase.java:210) - Table audiocd_template needs to be upgraded. Missing column EAN
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@19fe451[sql=[alter table audiocd_template add column EAN varchar(255)]]
      INFO [main] (DcDatabase.java:163) - Found the audiocd_template table
      INFO [main] (DcDatabase.java:163) - Found the audiotrack_template table
      INFO [main] (DcDatabase.java:210) - Table book_template needs to be upgraded. Missing column Container
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@46b90a[sql=[alter table book_template add column Container bigint]]
      INFO [main] (DcDatabase.java:210) - Table book_template needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@11e67ac[sql=[alter table book_template add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the book_template table
      INFO [main] (DcDatabase.java:210) - Table image_template needs to be upgraded. Missing column Container
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1284fd4[sql=[alter table image_template add column Container bigint]]
      INFO [main] (DcDatabase.java:210) - Table image_template needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@190ef12[sql=[alter table image_template add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the image_template table
      INFO [main] (DcDatabase.java:210) - Table movie_template needs to be upgraded. Missing column Container
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@3f96ee[sql=[alter table movie_template add column Container bigint]]
      INFO [main] (DcDatabase.java:210) - Table movie_template needs to be upgraded. Missing column EAN
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@ce16ad[sql=[alter table movie_template add column EAN varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table movie_template needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@32bd65[sql=[alter table movie_template add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the movie_template table
      INFO [main] (DcDatabase.java:210) - Table musicalbum_template needs to be upgraded. Missing column Container
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@130633a[sql=[alter table musicalbum_template add column Container bigint]]
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_template table
      INFO [main] (DcDatabase.java:210) - Table musictrack_template needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1c286e2[sql=[alter table musictrack_template add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the musictrack_template table
      INFO [main] (DcDatabase.java:210) - Table software_template needs to be upgraded. Missing column Container
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@257f1b[sql=[alter table software_template add column Container bigint]]
      INFO [main] (DcDatabase.java:210) - Table software_template needs to be upgraded. Missing column EAN
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@1bbdd48[sql=[alter table software_template add column EAN varchar(255)]]
      INFO [main] (DcDatabase.java:210) - Table software_template needs to be upgraded. Missing column Filehash Type
      INFO [main] (DcDatabase.java:228) - org.hsqldb.jdbc.jdbcPreparedStatement@5a3923[sql=[alter table software_template add column FilehashType varchar(10)]]
      INFO [main] (DcDatabase.java:163) - Found the software_template table
      INFO [main] (DcDatabase.java:163) - Found the user table
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT Field, Filename, Height, ObjectID, Width FROM picture
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT PersonID, Created, DueDate, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiocd_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_audiotrack_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_author
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_book_bookpublisher
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_actor
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_director
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_movie_movie_genre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musicalbum_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicartist
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_musictrack_musicgenre
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_developer
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT ObjectID, ReferencedId FROM X_software_softwarepublisher
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM person_category ORDER BY Name
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_category ORDER BY Name
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_category ORDER BY Name
      INFO [datafetcher-Category] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_category ORDER BY Name
      INFO [datafetcher-Container Type] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM container_containertype ORDER BY Name
      INFO [datafetcher-Genre] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_genre ORDER BY Name
      INFO [datafetcher-Loan] (DatabaseManager.java:225) - SELECT DISTINCT PersonID, Created, DueDate, EndDate, ID, Modified, ObjectID, StartDate FROM loans ORDER BY ID
      INFO [datafetcher-Music Genre] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicgenre ORDER BY Name
      INFO [datafetcher-Platform] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_platform ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM audiocd_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musictrack_state ORDER BY Name
      INFO [datafetcher-State] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_state ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM book_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM image_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM movie_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM musicalbum_storagemedium ORDER BY Name
      INFO [datafetcher-Storage Medium] (DatabaseManager.java:225) - SELECT DISTINCT Created, ID, Icon, Modified, Name FROM software_storagemedium ORDER BY Name
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Address, Admin, City, Country, Created, DefaultTemplate, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork, TemplateName FROM user_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Edit, Field, ID, Modified, Module, Plugin, TemplateName, User, View FROM permission_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM actor_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Address, Category, City, Country, Created, DefaultTemplate, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT ContainerType, Created, DefaultTemplate, Filehash, FilehashType, Filename, Filesize, ID, Modified, Name, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM container_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM developer_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Created, DefaultTemplate, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, TemplateName, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, DefaultTemplate, Description, DiscID, EAN, ID, Modified, Rating, service, serviceurl, State, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, ID, Lyric, Modified, Playlength, Rating, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Category, Container, Created, DefaultTemplate, Description, Filehash, FilehashType, Filename, Filesize, ID, ISBN, ISBN13, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Camera, Category, Compression, Container, Created, ImageDate, DefaultTemplate, Description, Filehash, FilehashType, Filename, Filesize, Height, ID, Modified, Place, Rating, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Container, Country, Created, DefaultTemplate, Description, EAN, EpisodeNumber, EpisodeName, Filehash, FilehashType, Filename, Filesize, Fps, Frames, Height, ID, Language, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, TemplateName, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, DefaultTemplate, Description, DiscID, ID, Modified, Rating, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, DefaultTemplate, Description, Encoding, Filehash, FilehashType, Filename, Filesize, ID, Lyric, Modified, Playlength, Quality, Rating, State, TemplateName, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack_template ORDER BY ID
      INFO [datafetcher-Template] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, Category, Container, Created, DefaultTemplate, Description, EAN, Filehash, FilehashType, Filename, Filesize, ID, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, TemplateName, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software_template ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, Description, ID, Lyric, Modified, Playlength, Rating, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM audiotrack ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT AlbumID, Created, Description, Encoding, Filehash, FilehashType, Filename, Filesize, ID, Lyric, Modified, Playlength, Quality, Rating, State, Title, Track, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Year FROM musictrack ORDER BY ID
      INFO [main] (DatabaseManager.java:225) - SELECT DISTINCT Created, Edit, Field, ID, Modified, Module, Plugin, User, View FROM permission ORDER BY ID
      INFO [datafetcher-Actor] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Actor ORDER BY ID
      INFO [datafetcher-musicartist] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM musicartist ORDER BY ID
      INFO [datafetcher-author] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM author ORDER BY ID
      INFO [datafetcher-contactperson] (DatabaseManager.java:225) - SELECT DISTINCT Address, Category, City, Country, Created, Description, Email, ID, Modified, Name, PhoneHome, PhoneWork, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM person ORDER BY ID
      INFO [datafetcher-container] (DatabaseManager.java:225) - SELECT DISTINCT ContainerType, Created, Filehash, FilehashType, Filename, Filesize, ID, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2 FROM container ORDER BY ID
      INFO [datafetcher-developer] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM Developer ORDER BY ID
      INFO [datafetcher-director] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM director ORDER BY ID
      INFO [datafetcher-bookpublisher] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM bookpublisher ORDER BY ID
      INFO [datafetcher-softwarepublisher] (DatabaseManager.java:225) - SELECT DISTINCT Created, Description, Firstname, ID, Lastname, Modified, Name, service, serviceurl, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, webpage FROM softwarepublisher ORDER BY ID
      INFO [datafetcher-audiocd] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, Description, DiscID, EAN, ID, Modified, Rating, service, serviceurl, State, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM audiocd ORDER BY ID
      INFO [datafetcher-book] (DatabaseManager.java:225) - SELECT DISTINCT Category, Container, Created, Description, Filehash, FilehashType, Filename, Filesize, ID, ISBN, ISBN13, Modified, pages, Rating, Series, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VolumeNumber, VolumeName, Webpage, Year FROM book ORDER BY ID
      INFO [datafetcher-image] (DatabaseManager.java:225) - SELECT DISTINCT Camera, Category, Compression, Container, Created, ImageDate, Description, Filehash, FilehashType, Filename, Filesize, Height, ID, Modified, Place, Rating, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Width, Year FROM image ORDER BY ID
      INFO [datafetcher-movie] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, AudioBitrate, AudioChannels, AudioCodec, AudioLanguage, AudioSampleRate, Certification, Container, Country, Created, Description, EAN, EpisodeNumber, EpisodeName, Filehash, FilehashType, Filename, Filesize, Fps, Frames, Height, ID, Language, Modified, Playlength, Rating, Season, Program, service, serviceurl, State, StorageMedium, SubtitleLanguage, Title, Title2, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, VideoBitRate, VideoCodec, webpage, Width, Year FROM movie ORDER BY ID
      INFO [datafetcher-musicalbum] (DatabaseManager.java:225) - SELECT DISTINCT Container, Created, Description, DiscID, ID, Modified, Rating, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM musicalbum ORDER BY ID
      INFO [datafetcher-Software] (DatabaseManager.java:225) - SELECT DISTINCT ASIN, Category, Container, Created, Description, EAN, Filehash, FilehashType, Filename, Filesize, ID, Modified, Multiplayer, Platform, Rating, SerialKey, service, serviceurl, State, StorageMedium, Title, UserLongText1, UserInteger1, UserInteger2, UserShortText1, UserShortText2, Webpage, Year FROM software ORDER BY ID
      INFO [datafetcher-User] (DatabaseManager.java:225) - SELECT DISTINCT Address, Admin, City, Country, Created, Description, Email, Enabled, ID, LoginName, Modified, Name, PhoneHome, PhoneWork FROM user ORDER BY ID
      FATAL [main] (DataCrow.java:234) - Severe error occurred while starting Data Crow. The application cannot continue.
      java.lang.reflect.InvocationTargetException
          at java.awt.EventQueue.invokeAndWait(Unknown Source)
          at javax.swing.SwingUtilities.invokeAndWait(Unknown Source)
          at net.datacrow.core.DataCrow.main(DataCrow.java:210)
      Caused by: java.lang.NullPointerException
          at net.datacrow.console.menu.DcQuickFilterToolBar.setSearchField(DcQuickFilterToolBar.java:147)
          at net.datacrow.console.menu.DcQuickFilterToolBar.applySelectedField(DcQuickFilterToolBar.java:180)
          at net.datacrow.console.menu.DcQuickFilterToolBar.actionPerformed(DcQuickFilterToolBar.java:242)
          at javax.swing.JComboBox.fireActionEvent(Unknown Source)
          at javax.swing.JComboBox.setSelectedItem(Unknown Source)
          at net.datacrow.console.menu.DcQuickFilterToolBar.<init>(DcQuickFilterToolBar.java:80)
          at net.datacrow.console.MainFrame.updateQuickFilterBar(MainFrame.java:213)
          at net.datacrow.console.MainFrame.changeModule(MainFrame.java:448)
          at net.datacrow.console.MainFrame.initialize(MainFrame.java:124)
          at net.datacrow.core.DataCrow$1.run(DataCrow.java:212)
          at java.awt.event.InvocationEvent.dispatch(Unknown Source)
          at java.awt.EventQueue.dispatchEvent(Unknown Source)
          at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
          at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
          at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
          at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
          at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
          at java.awt.EventDispatchThread.run(Unknown Source)
      INFO [main] (Services.java:73) - Registered online server MusicBrainzArtistServer
      INFO [main] (Services.java:73) - Registered online server ImdbDirectorServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesSoftwareServer
      INFO [main] (Services.java:73) - Registered online server OfdbMovieServer
      INFO [main] (Services.java:73) - Registered online server BolMovieServer
      INFO [main] (Services.java:73) - Registered online server AmazonBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbActorServer
      INFO [main] (Services.java:73) - Registered online server AmazonSoftwareServer
      INFO [main] (Services.java:73) - Registered online server AmazonAudioCDServer
      INFO [main] (Services.java:73) - Registered online server DiscogsAudioCDServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesPublisherServer
      INFO [main] (Services.java:73) - Registered online server WikipediaMovieServer
      INFO [main] (Services.java:73) - Registered online server BolBookServer
      INFO [main] (Services.java:73) - Registered online server AlapageBookServer
      INFO [main] (Services.java:73) - Registered online server ImdbMovieServer
      INFO [main] (Services.java:73) - Registered online server McuBookServer
      INFO [main] (Services.java:73) - Registered online server MobyGamesDeveloperServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server AmazonMovieServer
      INFO [main] (Services.java:73) - Registered online server DiscogsMusicAlbumServer
      INFO [main] (Services.java:73) - Registered online server MusicBrainzAudioCDServer
      INFO [main] (Services.java:73) - Registered online server BarnesNobleBookServer
      INFO [main] (DataCrow.java:153) - System is being started
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Genres
      INFO [main] (ModuleUpgrade.java:361) - Upgraded module audiotrack, remove field Artists
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Genres
      INFO [main] (ModuleUpgrade.java:283) - Upgraded module audiotrack, added field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiocd, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module audiotrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musicalbum, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module musictrack, altered field Artists
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module book, altered field Authors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Actors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Directors
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field Subtitle Language
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module movie, altered field ASIN
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Developers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field Publishers
      INFO [main] (ModuleUpgrade.java:330) - Upgraded module Software, altered field ASIN
      INFO [main] (DataCrow.java:160) - Modules have been loaded
      INFO [main] (DcDatabase.java:163) - Found the picture table
      INFO [main] (DcDatabase.java:163) - Found the x_audiocd_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_audiocd_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_audiotrack_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_audiotrack_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_book_author table
      INFO [main] (DcDatabase.java:163) - Found the x_book_bookpublisher table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_actor table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_director table
      INFO [main] (DcDatabase.java:163) - Found the x_movie_movie_genre table
      INFO [main] (DcDatabase.java:163) - Found the x_musicalbum_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_musicalbum_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_musictrack_musicartist table
      INFO [main] (DcDatabase.java:163) - Found the x_musictrack_musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the x_software_developer table
      INFO [main] (DcDatabase.java:163) - Found the x_software_softwarepublisher table
      INFO [main] (DcDatabase.java:163) - Found the actor table
      INFO [main] (DcDatabase.java:163) - Found the musicartist table
      INFO [main] (DcDatabase.java:163) - Found the audiocd table
      INFO [main] (DcDatabase.java:163) - Found the audiotrack table
      INFO [main] (DcDatabase.java:163) - Found the author table
      INFO [main] (DcDatabase.java:163) - Found the book table
      INFO [main] (DcDatabase.java:163) - Found the person_category table
      INFO [main] (DcDatabase.java:163) - Found the book_category table
      INFO [main] (DcDatabase.java:163) - Found the image_category table
      INFO [main] (DcDatabase.java:163) - Found the software_category table
      INFO [main] (DcDatabase.java:163) - Found the person table
      INFO [main] (DcDatabase.java:163) - Found the container_containertype table
      INFO [main] (DcDatabase.java:163) - Found the container table
      INFO [main] (DcDatabase.java:163) - Found the developer table
      INFO [main] (DcDatabase.java:163) - Found the director table
      INFO [main] (DcDatabase.java:163) - Found the movie_genre table
      INFO [main] (DcDatabase.java:163) - Found the image table
      INFO [main] (DcDatabase.java:163) - Found the loans table
      INFO [main] (DcDatabase.java:163) - Found the movie table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum table
      INFO [main] (DcDatabase.java:163) - Found the musicgenre table
      INFO [main] (DcDatabase.java:163) - Found the musictrack table
      INFO [main] (DcDatabase.java:163) - Found the permission table
      INFO [main] (DcDatabase.java:163) - Found the software_platform table
      INFO [main] (DcDatabase.java:163) - Found the bookpublisher table
      INFO [main] (DcDatabase.java:163) - Found the softwarepublisher table
      INFO [main] (DcDatabase.java:163) - Found the software table
      INFO [main] (DcDatabase.java:163) - Found the audiocd_state table
      INFO [main] (DcDatabase.java:163) - Found the book_state table
      INFO [main] (DcDatabase.java:163) - Found the image_state table
      INFO [main] (DcDatabase.java:163) - Found the movie_state table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_state table
      INFO [main] (DcDatabase.java:163) - Found the musictrack_state table
      INFO [main] (DcDatabase.java:163) - Found the software_state table
      INFO [main] (DcDatabase.java:163) - Found the book_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the image_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the movie_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the software_storagemedium table
      INFO [main] (DcDatabase.java:163) - Found the user_template table
      INFO [main] (DcDatabase.java:163) - Found the permission_template table
      INFO [main] (DcDatabase.java:163) - Found the actor_template table
      INFO [main] (DcDatabase.java:163) - Found the author_template table
      INFO [main] (DcDatabase.java:163) - Found the bookpublisher_template table
      INFO [main] (DcDatabase.java:163) - Found the person_template table
      INFO [main] (DcDatabase.java:163) - Found the container_template table
      INFO [main] (DcDatabase.java:163) - Found the developer_template table
      INFO [main] (DcDatabase.java:163) - Found the director_template table
      INFO [main] (DcDatabase.java:163) - Found the musicartist_template table
      INFO [main] (DcDatabase.java:163) - Found the softwarepublisher_template table
      INFO [main] (DcDatabase.java:163) - Found the audiocd_template table
      INFO [main] (DcDatabase.java:163) - Found the audiotrack_template table
      INFO [main] (DcDatabase.java:163) - Found the book_template table
      INFO [main] (DcDatabase.java:163) - Found the image_template table
      INFO [main] (DcDatabase.java:163) - Found the movie_template table
      INFO [main] (DcDatabase.java:163) - Found the musicalbum_template table
      INFO [main] (DcDatabase.java:163) - Found the musictrack_template table
      INFO [main] (DcDatabase.java:163) - Found the software_template table
      INFO [main] (DcDatabase.java:163) - Found the user table
      FATAL [main] (DataCrow.java:234) - Severe error occurred while starting Data Crow. The application cannot continue.
      java.lang.reflect.InvocationTargetException
          at java.awt.EventQueue.invokeAndWait(Unknown Source)
          at javax.swing.SwingUtilities.invokeAndWait(Unknown Source)
          at net.datacrow.core.DataCrow.main(DataCrow.java:210)
      Caused by: java.lang.NullPointerException
          at net.datacrow.console.menu.DcQuickFilterToolBar.setSearchField(DcQuickFilterToolBar.java:147)
          at net.datacrow.console.menu.DcQuickFilterToolBar.applySelectedField(DcQuickFilterToolBar.java:180)
          at net.datacrow.console.menu.DcQuickFilterToolBar.actionPerformed(DcQuickFilterToolBar.java:242)
          at javax.swing.JComboBox.fireActionEvent(Unknown Source)
          at javax.swing.JComboBox.setSelectedItem(Unknown Source)
          at net.datacrow.console.menu.DcQuickFilterToolBar.<init>(DcQuickFilterToolBar.java:80)
          at net.datacrow.console.MainFrame.updateQuickFilterBar(MainFrame.java:213)
          at net.datacrow.console.MainFrame.changeModule(MainFrame.java:448)
          at net.datacrow.console.MainFrame.initialize(MainFrame.java:124)
          at net.datacrow.core.DataCrow$1.run(DataCrow.java:212)
          at java.awt.event.InvocationEvent.dispatch(Unknown Source)
          at java.awt.EventQueue.dispatchEvent(Unknown Source)
          at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
          at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
          at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
          at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
          at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
          at java.awt.EventDispatchThread.run(Unknown Source)

       
    • Thanks for the additional information. Please back up and then remove all .properties files from the data folder, except dc.properties.

      Kind regards,
      Robert Jan

       
    • hi again,

      thanks for your help

      i removed the files but the same thing happened

      if its any help there are no image files in the data folder, however there are image files in the webapp\datacrow folder

      regards

      robin

       
    • Fred Wang
      Fred Wang
      2008-11-08

      hi,

      some entries in the Actors & Directors were incorrect/corrupt - when fixed the upgrade went smoothly