[fixed] Bug in importing music (1 Viewer)

[Developer58]

I did an import of all my music (on a first install) and only about 370 of the 670 artists were imported.
When i examined the error logs i found this:

2013-01-15 09:30:51.086890 [ERROR][(6)]: musicdatabase exception errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Alone" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Alone

where the above query line cut off there was an upper ascii sign like [], right behind 'Alone and before the closing '.

So it looked like: 'Alone[]'

This kind of error flooded my error log and must be the reason.

Can anybody help? I can rebuild the source if applicable.

 

[Developer58]

What info is missing?

I did the import from the external configuration utility, but it also fails from within MP.
Also it does not matter if i do the import from a mapped network drive or by the Windows smb. \\Server\Music fe

 

[Developer58]

Anybody? 10k of 40k songs failed to import

 

[megahorst]

I think you should add your logfiles.
error.log, mediaportal.log and configuration.log.
Please set loglevel in MePo configuration to "debug"

 

[Developer58]

Thanks, i uploaded the logs.

 

[kiwijunglist]

Can you please upload the smallest .flac file that is mentioned in error.log to a filesharing site like sendspace.com?

 

[Developer58]

Can you please upload the smallest .flac file that is mentioned in error.log to a filesharing site like sendspace.com?

I did: http://www.sendspace.com/file/sp7y74

Thanks a lot.

 

[kiwijunglist]

MePo failed to read any of the metadata. It would only show up in shares view. Not sure why MePo is failing to read the tags, as I can see the tags in my music editing software. That is why it looks like it didn't import all the artists, because it was unable to read the artist metadata tags. This is a bug.

My error.log (MP 1.3Beta)

Spoiler

2013-01-17 22:34:38.329670 [ERROR][MPMain(1)]: Exception while loading GUIWindows instances: TvPlugin.Radio
2013-01-17 22:34:38.329670 [ERROR][MPMain(1)]: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=HTPC;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;
2013-01-17 22:34:38.331670 [ERROR][MPMain(1)]: at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvDatabase.TvBusinessLayer.GetChannelsByName(String name)
at TvPlugin.Radio.LoadChannelGroups()
at TvPlugin.RadinAdded()
at MediaPortal.GUI.Library.GUIWindowManager.Add(GUIWindow& Window)
at MediaPortal.GUI.Library.PluginManager.LoadWindowPlugin(String strFile)
2013-01-17 22:34:49.408304 [ERROR][MPMain(1)]: TVHome: WOL - Failed to start the TV server
2013-01-17 22:34:52.018453 [ERROR][MPMain(1)]: TVHome: Error in Reload
2013-01-17 22:34:52.050455 [ERROR][MPMain(1)]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=HTPC;Database=MpTvDb;User ID=root;Password=***;charset=utf8;Connection Timeout=30; ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at MySql.Data.Common.StreamCreator.GetHostEntry(String hostname)
at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
at MySql.Data.MySqlClient.NativeDriver.Open()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Gentle.Provider.MySQL.MySQLProvider.GetConnection()
--- End of inner exception stack trace ---
at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvPlugin.ChannelNavigator.ReLoad()MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at MySql.Data.Common.StreamCreator.GetHostEntry(String hostname)
at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
at MySql.Data.MySqlClient.NativeDriver.Open()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Gentle.Provider.MySQL.MySQLProvider.GetConnection()System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at MySql.Data.Common.StreamCreator.GetHostEntry(String hostname)
at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
at MySql.Data.MySqlClient.NativeDriver.Open()
2013-01-17 22:34:52.051455 [ERROR][MPMain(1)]: Exception :The database backend (provider MySQL) could not be reached.
Check the connection string: Server=HTPC;Database=MpTvDb;User ID=root;Password=***;charset=utf8;Connection Timeout=30;
2013-01-17 22:34:52.051455 [ERROR][MPMain(1)]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
2013-01-17 22:34:52.051455 [ERROR][MPMain(1)]: source :Gentle.Common
2013-01-17 22:34:52.051455 [ERROR][MPMain(1)]: stacktrace: at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvPlugin.ChannelNavigator.ReLoad()
2013-01-17 22:35:24.668321 [ERROR][(19)]: SQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon '
2013-01-17 22:35:24.669321 [ERROR][(19)]: musicdatabase exception errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon ' stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Music.Database.MusicDatabase.GetAlbumInfo(String aAlbumName, String aArtistName, AlbumInfo& aAlbumInfo)
2013-01-17 22:35:26.467423 [ERROR][(26)]: SQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon '
2013-01-17 22:35:26.468423 [ERROR][(26)]: musicdatabase exception errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon ' stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Music.Database.MusicDatabase.GetAlbumInfo(String aAlbumName, String aArtistName, AlbumInfo& aAlbumInfo)
2013-01-17 22:35:42.800358 [ERROR][(26)]: SQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon '
2013-01-17 22:35:42.801358 [ERROR][(26)]: musicdatabase exception errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon ' stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Music.Database.MusicDatabase.GetAlbumInfo(String aAlbumName, String aArtistName, AlbumInfo& aAlbumInfo)
2013-01-17 22:35:45.591517 [ERROR][MPMain(1)]: SQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon '
2013-01-17 22:35:45.592517 [ERROR][MPMain(1)]: musicdatabase exception errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon ' stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Music.Database.MusicDatabase.GetAlbumInfo(String aAlbumName, String aArtistName, AlbumInfo& aAlbumInfo)
2013-01-17 23:11:45.230042 [ERROR][(24)]: SQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon '
2013-01-17 23:11:45.230042 [ERROR][(24)]: musicdatabase exception errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon ' stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Music.Database.MusicDatabase.GetAlbumInfo(String aAlbumName, String aArtistName, AlbumInfo& aAlbumInfo)
2013-01-17 23:11:46.403109 [ERROR][(24)]: SQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon '
2013-01-17 23:11:46.403109 [ERROR][(24)]: musicdatabase exception errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:unrecognized token: "'Blues From Laurel Canyon" query:select * from albuminfo where strArtist like 'unknown%' and strAlbum like 'Blues From Laurel Canyon ' stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Music.Database.MusicDatabase.GetAlbumInfo(String aAlbumName, String aArtistName, AlbumInfo& aAlbumInfo)

 

[kiwijunglist]

@Testers @hwahrmann can someone please confirm this is a bug and then take the appropriate action

[Music] Some .flac files are not being imported into the database

File - http://www.sendspace.com/file/sp7y74

John Mayall - Blues From Laurel Canyon - 04 - 2401.flac

Artist: John Mayall
Album Artist: [BLANK/EMPTY]
Title: 2401
Track: 4
Album: Blues from Laurel Canyon
Genre: Blues
Year: 1968

 

[Developer58]

Thanks a lot.
Indeed other software like XBMC, J. River etc. is reading the meta correct.