Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#11847 closed Bug Report - General (fixed)

Music scan produces lots of QSLQuery errors

Reported by: stuartm Owned by: paulh
Priority: minor Milestone: 0.27
Component: Plugin - MythMusic Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

It produces a lot of "QSqlQuery::value: not positioned on a valid record" and "Asked to update track with invalid ID - 0". I've included a tiny sample below.

QSqlQuery::value: not positioned on a valid record
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:37.162903 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:37.195323 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:37.247607 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:37.287091 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:37.350583 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:37.400978 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:37.482959 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:37.536207 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:37.644857 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:37.698199 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:37.833311 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:37.937142 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.078971 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:38.154785 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.284099 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.384151 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.530676 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.607241 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.729034 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.795480 E  Asked to update track with invalid ID - 0
QSqlQuery::value: not positioned on a valid record
2013-09-12 12:39:38.942193 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:39.042870 E  Asked to update track with invalid ID - 0
2013-09-12 12:39:45.835711 N  Resuming idle timer
2013-09-12 12:39:46.462849 E  Playlist: Got a bad track 7121
2013-09-12 12:39:46.462905 E  Playlist: Got a bad track 6767
2013-09-12 12:39:46.462988 E  Playlist: Got a bad track 16037
2013-09-12 12:39:46.463038 E  Playlist: Got a bad track 14939
2013-09-12 12:39:46.463071 E  Playlist: Got a bad track 16030
2013-09-12 12:39:46.463120 E  Playlist: Got a bad track 15985
2013-09-12 12:39:46.463240 E  Playlist: Got a bad track 16041
2013-09-12 12:39:46.463260 E  Playlist: Got a bad track 7758
2013-09-12 12:39:46.463318 E  Playlist: Got a bad track 16074
2013-09-12 12:39:46.463370 E  Playlist: Got a bad track 15604
2013-09-12 12:39:46.463406 E  Playlist: Got a bad track 6824
2013-09-12 12:39:46.463435 E  Playlist: Got a bad track 16189
2013-09-12 12:39:46.463558 E  Playlist: Got a bad track 16805
2013-09-12 12:39:46.463608 E  Playlist: Got a bad track 14695
2013-09-12 12:39:46.463630 E  Playlist: Got a bad track 7526
2013-09-12 12:39:46.463676 E  Playlist: Got a bad track 14819
2013-09-12 12:39:46.463731 E  Playlist: Got a bad track 9052
2013-09-12 12:39:46.463741 E  Playlist: Got a bad track 14772
2013-09-12 12:39:46.464060 E  Playlist: Got a bad track 15995
2013-09-12 12:39:46.464094 E  Playlist: Got a bad track 15981
2013-09-12 12:39:46.464239 E  Playlist: Got a bad track 10760
2013-09-12 12:39:46.464251 E  Playlist: Got a bad track 14867
2013-09-12 12:39:46.464266 E  Playlist: Got a bad track 16036
2013-09-12 12:39:46.464278 E  Playlist: Got a bad track 14853
2013-09-12 12:39:46.464339 E  Playlist: Got a bad track 14517
2013-09-12 12:39:46.464577 E  Playlist: Got a bad track 16804
2013-09-12 12:39:46.464701 E  Playlist: Got a bad track 6900
2013-09-12 12:39:46.464833 E  Playlist: Got a bad track 14720
2013-09-12 12:39:46.464945 E  Playlist: Got a bad track 14681
2013-09-12 12:39:46.465052 E  Playlist: Got a bad track 14401
2013-09-12 12:39:46.465202 E  Playlist: Got a bad track 14773
2013-09-12 12:39:46.465275 E  Playlist: Got a bad track 16040
2013-09-12 12:39:46.465453 E  Playlist: Got a bad track 14697
2013-09-12 12:39:46.465536 E  Playlist: Got a bad track 13954}}}

Change History (4)

comment:1 Changed 6 years ago by paulh

Looks like there is a query.next() missing from MusicMetadata::createFromFilename(const QString &filename) which is causing the songid lookup to fail.

Can you try adding that and test again.

comment:2 Changed 6 years ago by paulh

Owner: set to paulh
Status: newassigned

comment:3 Changed 6 years ago by Paul Harrison <pharrison@…>

Resolution: fixed
Status: assignedclosed

In af88052c4bd6e15330520b31c8f72d7b0428939e/mythtv:

MythMusic: fix file scan sql errors

A missing query.next() was causing the songid lookup query to fail.
Fixes #11847.

comment:4 Changed 6 years ago by Paul Harrison <pharrison@…>

In 0754c65f620598e1470aaf00f5a043c77be3e235/mythtv:

MythMusic: fix file scan sql errors

A missing query.next() was causing the songid lookup query to fail.
Fixes #11847.

(cherry picked from commit af88052c4bd6e15330520b31c8f72d7b0428939e)

Note: See TracTickets for help on using tickets.