View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0014773 | MMW 5 | Playlists (Auto) / Search / Filters | public | 2018-04-24 23:24 | 2018-09-19 19:14 |
| Reporter | rusty | Assigned To | |||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 5.0 | ||||
| Target Version | 5.0 | Fixed in Version | 5.0 | ||
| Summary | 0014773: Some functions fail when tracklist contains Google Drive content | ||||
| Description | In build 2101, some actions related to library content that is stored to Google Drive fail (Artist:Queens of the stone age): 1) Perform a search for 'Queens' --> the search will fail to match relevant Artists OR generate an error: "There was a problem querying the database: Error executing SQL 'SELECT * FROM Albums, Songs WHERE () AND Albums.ID = Songs.IDAlbum AND Songs.TRackType in (0,4,3) GROUP BY Albums.ID" : near")":syntax error (1,1). To trigger the bug: 1 Click Music node 2 Ensure Browser view is active 3 Type 'Queens' --> error or failure to find matching artists See video: https://www.screencast.com/t/t5rJpSJabV 2) Clicking tracks by "Queens of the stone age' and using FMFS Artist --> Hourglass appears endlessly Log posted to ftp. I can share the DB if needed. | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 2102 | ||||
|
|
Re the SQL error: it is not seen on the video and/or in the debug log, nevertheless by code revision I found that such a SQL error is thrown when searching for '/' => Fixed in 2102 Re: 'Queens of the stone age' not found: I cannot replicate, but the issue is seen in the debug log and video, it seems that artist 'Queens of the stone age' is missing in the Artists table of your database for some reason. Please upload/share your DB for a deeper analyze. |
|
|
Watching DB shared over IM the artist "Queens of the stone age" isn't in the artists table of your database. Did you import the database from MM4 or created new and scanned the files into database? Watching the files they were added on 03/20/2018 so they were probably scanned into MM5 and not imported from MM4. Assigned to me to review the code to see how the artist could get lost. |
|
|
Rusty, I've analyzed your DB and also the tracks' album is missing from the database. It used to had index 3272, but looking at the albums table the first index is 5740, and the last is 8046. This means that 5740 albums have been already deleted from the database. I am verifying whether the "Rebuild database" process couldn't be the root of the problems. |
|
|
Confirmed taht 'Rebuild database' process seems to be root of the issues. It doesn't reconstruct some artists/albums. I can replicate with your DB and I am looking into it... |
|
|
Fixed in 2102, it was regression introduced while fixing 0014324 Test note: You will need to run 'Rebuild database' to repair |
|
|
Verified 2102. |
