Subsonic Forum

Error in left tab on main page. Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [select id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, variable_bit_rate, ...

... [2023-07-28 15:45:59,796] ERROR MediaScannerService - Failed to scan media library. org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [update album set path=?,song_count=?,duration_seconds=?,cover_art_path=?,year=?,genre=?,play_count=?,last_played=?,comment=?,created=?,last_scanned=?,present=?, ...

... [2023-05-16 23:21:36,172] ERROR MediaScannerService - Failed to scan media library. org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [update media_file set present=?, last_scanned=? where path=?]; S1000 General error java.lang.NullPointerException in ...

... error in the Subsonic Forum. Please include the information below. Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [select min(id) from album where not present]; S1000 General error java.util.NoSuchElementException in statement [select ...

... this is message I get when I click clean up database "Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [select min(id) from media_file where not present]; S1000 General error java.util.NoSuchElementException in statement ...

... error in the Subsonic Forum. Please include the information below. Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [select id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, ...

... The error in the webUI: org.springframework.dao.DataAccessResourceFailureException Message PreparedStatementCallback; SQL [select username, password, email, ldap_authenticated, bytes_streamed, bytes_downloaded, bytes_uploaded from user where ...

... folder (on a USB connected external HDD) Here is the error log: Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, ...

Exception org.springframework.jdbc.BadSqlGrammarException Message PreparedStatementCallback; bad SQL grammar [select username, locale, theme_id, final_version_notification, beta_version_notification, song_notification, main_track_number, main_artist, main_album, ...

... [2020-12-31 10:14:22,458] ERROR MediaScannerService - Failed to scan media library. org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select id, path, name, artist, song_count, duration_seconds, cover_art_path, year, genre, play_count, last_played, comment, ...

... there is a better answer to this than a random blip corrupting it. Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [select id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, ...

... error in the Subsonic Forum. Please include the information below. Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [select id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, ...

... error in the Subsonic Forum. Please include the information below. Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL [select id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, ...

Problem Description: ALL WINDOWS FILLED WITH ERROR MESSAGES: Exception org.springframework.dao.TransientDataAccessResourceException Message PreparedStatementCallback; SQL Troubleshooting Steps: rebooted computer... Playback Application and version: desktop and Dsub Subsonic Version: not completely ...

Subsonic 6.1.6 (build 0cfa60) – November 10, 2019 Running with MySQL as a db. org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, ...