Reply to thread

Message

Don't know why, or how to fix, but something amiss with your database setup.

From fanart handler log (only one entry, short log)....

20-Mar-2013 16:44:15 Error [ DatabaseManager]: GetAllFilenames: SQLite.NET.SQLiteException: SQLiteClient: cmd:sqlite3_prepare16vm=null err:NOMEM detailedut of memory queryELECT Disk_Image FROM Scorecenter_Fanart;
at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
at SQLite.NET.SQLiteClient.Execute(String query)

From Movingpicture log (one of many) ....

20-Mar-2013 16:44:05 Error [ DatabaseManager]: Error getting by ID from local_media table. SQLite.NET.SQLiteException: SQLiteClient: movingpictures.db3 cmd:sqlite3_prepare16vm=null err:NOMEM detailedut of memory query:select media_label, fullpath, originalfilename, volume_serial, discid, filehash, part, duration, ignored, importpath, videowidth, videoheight, videoresolution, videocodec, videoframerate, videoaspectratio, audiocodec, audiochannels, hassubtitles, videoformat, id from local_media where id = 142
at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)

From MPTVSeries log (one of many)....

00000001 - 3/20/2013 4:44:05 PM - Commit failed on this command: <select value from options where property = 'logoConfig'> (SQLiteClient: cmd:sqlite3_prepare16vm=null err:NOMEM detailedut of memory query:select value from options where property = 'logoConfig').

And finally, Error Log (of many)....

2013-03-20 16:43:53.125907 [ERROR][MPMain(1)]: SQLiteClient: cmd:sqlite3_step err:ERROR detailedQL logic error or missing database query:delete from FormattingRules
2013-03-20 16:44:05.540617 [ERROR][MPMain(1)]: SQLiteClient: cmd:sqlite3_prepare16vm=null err:NOMEM detailedut of memory query:select * from FormattingRules where FormattingRules.ID = 9
2013-03-20 16:44:05.542617 [ERROR][(9)]: SQLiteClient: movingpictures.db3 cmd:sqlite3_prepare16vm=null err:NOMEM detailedut of memory query:select media_label, fullpath, originalfilename, volume_serial, discid, filehash, part, duration, ignored, importpath, videowidth, videoheight, videoresolution, videocodec, videoframerate, videoaspectratio, audiocodec, audiochannels, hassubtitles, videoformat, id from local_media where id = 142

As it's multiple problems, either something has diddled with your databases or I suspect a corrupt .dll.

Hopefully, what I've pulled from log will help someone narrow your problems and suggest a fix(s).

TTFN - JCMP

PS - I've just noticed all the smiley's in log snippets generated by text itself - I'm not having a laugh, honest - J

<blockquote data-quote="JimCatMP" data-source="post: 976806" data-attributes="member: 103549">Don't know why, or how to fix, but something amiss with your database setup.&nbsp;From fanart handler log (only one entry, short log)....&nbsp;20-Mar-2013 16:44:15 Error [&nbsp; &nbsp;&nbsp; DatabaseManager]: GetAllFilenames: SQLite.NET.SQLiteException: SQLiteClient: cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:NOMEM detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" />ut of memory query<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />ELECT Disk_Image FROM Scorecenter_Fanart;at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr&amp; pVm)at SQLite.NET.SQLiteClient.Execute(String query)&nbsp;From Movingpicture log (one of many) ....&nbsp;20-Mar-2013 16:44:05 Error [&nbsp; &nbsp;&nbsp; DatabaseManager]: Error getting by ID from local_media table. SQLite.NET.SQLiteException: SQLiteClient: movingpictures.db3 cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:NOMEM detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" />ut of memory query:select media_label, fullpath, originalfilename, volume_serial, discid, filehash, part, duration, ignored, importpath, videowidth, videoheight, videoresolution, videocodec, videoframerate, videoaspectratio, audiocodec, audiochannels, hassubtitles, videoformat, id from local_media where id = 142at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)at SQLite.NET.SQLiteClient.Execute(String query)&nbsp;From MPTVSeries log (one of many)....&nbsp;00000001 - 3/20/2013 4:44:05 PM - Commit failed on this command: &lt;select value from options where property = 'logoConfig'&gt; (SQLiteClient: cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:NOMEM detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" />ut of memory query:select value from options where property = 'logoConfig').&nbsp;And finally, Error Log (of many)....&nbsp;2013-03-20 16:43:53.125907 [ERROR][MPMain(1)]: SQLiteClient: cmd:sqlite3_step err:ERROR detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />QL logic error or missing database query:delete from FormattingRules2013-03-20 16:44:05.540617 [ERROR][MPMain(1)]: SQLiteClient: cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:NOMEM detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" />ut of memory query:select * from FormattingRules where FormattingRules.ID = 92013-03-20 16:44:05.542617 [ERROR][(9)]: SQLiteClient: movingpictures.db3 cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:NOMEM detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" />ut of memory query:select media_label, fullpath, originalfilename, volume_serial, discid, filehash, part, duration, ignored, importpath, videowidth, videoheight, videoresolution, videocodec, videoframerate, videoaspectratio, audiocodec, audiochannels, hassubtitles, videoformat, id from local_media where id = 142&nbsp;&nbsp;As it's multiple problems, either something has diddled with your databases or I suspect a corrupt .dll.&nbsp;Hopefully, what I've pulled from log will help someone narrow your problems and suggest a fix(s).&nbsp;TTFN - JCMP&nbsp;PS - I've just noticed all the smiley's in log snippets generated by text itself - I'm not having a laugh, honest - J</blockquote>

[QUOTE="JimCatMP, post: 976806, member: 103549"] Don't know why, or how to fix, but something amiss with your database setup. From fanart handler log (only one entry, short log).... 20-Mar-2013 16:44:15 Error [ DatabaseManager]: GetAllFilenames: SQLite.NET.SQLiteException: SQLiteClient: cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:eek:ut of memory query:confused:ELECT Disk_Image FROM Scorecenter_Fanart; at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err) at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm) at SQLite.NET.SQLiteClient.Execute(String query) From Movingpicture log (one of many) .... 20-Mar-2013 16:44:05 Error [ DatabaseManager]: Error getting by ID from local_media table. SQLite.NET.SQLiteException: SQLiteClient: movingpictures.db3 cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:eek:ut of memory query:select media_label, fullpath, originalfilename, volume_serial, discid, filehash, part, duration, ignored, importpath, videowidth, videoheight, videoresolution, videocodec, videoframerate, videoaspectratio, audiocodec, audiochannels, hassubtitles, videoformat, id from local_media where id = 142 at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err) at SQLite.NET.SQLiteClient.Execute(String query) From MPTVSeries log (one of many).... 00000001 - 3/20/2013 4:44:05 PM - Commit failed on this command: <select value from options where property = 'logoConfig'> (SQLiteClient: cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:eek:ut of memory query:select value from options where property = 'logoConfig'). And finally, Error Log (of many).... 2013-03-20 16:43:53.125907 [ERROR][MPMain(1)]: SQLiteClient: cmd:sqlite3_step err:ERROR detailed:confused:QL logic error or missing database query:delete from FormattingRules 2013-03-20 16:44:05.540617 [ERROR][MPMain(1)]: SQLiteClient: cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:eek:ut of memory query:select * from FormattingRules where FormattingRules.ID = 9 2013-03-20 16:44:05.542617 [ERROR][(9)]: SQLiteClient: movingpictures.db3 cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:eek:ut of memory query:select media_label, fullpath, originalfilename, volume_serial, discid, filehash, part, duration, ignored, importpath, videowidth, videoheight, videoresolution, videocodec, videoframerate, videoaspectratio, audiocodec, audiochannels, hassubtitles, videoformat, id from local_media where id = 142 As it's multiple problems, either something has diddled with your databases or I suspect a corrupt .dll. Hopefully, what I've pulled from log will help someone narrow your problems and suggest a fix(s). TTFN - JCMP PS - I've just noticed all the smiley's in log snippets generated by text itself - I'm not having a laugh, honest - J [/QUOTE]