SQL Error updating TMDB Show (Data too long)

Open t0815 opened this issue 4 months ago • 0 comments

Before submitting your issue, please verify the following.

[x] You're using the latest Stable or Daily version of Shoko Server.
[x] You're using the latest and correct (Stable:Stable, Daily:Daily) Web UI for the version of Shoko you're using.
[x] You've searched this repository (top of the page) for the issue you are reporting.

Shoko Version

5.1.0

Shoko Version - Daily Commit

No response

Install Type

Windows

Description

When updating TMDB-Data (Images) for the show "Domestic Girlfriend" (https://www.themoviedb.org/tv/83103) an exception is thrown, preventing the data to update. The Schema needs an update it seems, because some data is too long to be updated/inserted.

Steps to Reproduce

Have the Show "Domestic Girlfriend"
Update the TMDB Data for the show
No Images will be updated

Log File

Job TMDB.UpdateTmdbShowJob_TmdbShowID:83103_DownloadImages:true threw a JobExecutionException: : Parameters: refire = False, unscheduleFiringTrigger = False, unscheduleAllTriggers = False Quartz.JobExecutionException: could not update: [Shoko.Server.Models.TMDB.TMDB_Show#1968][SQL: UPDATE TMDB_Show SET TmdbShowID = ?, TvdbShowID = ?, PosterPath = ?, BackdropPath = ?, EnglishTitle = ?, EnglishOverview = ?, OriginalTitle = ?, OriginalLanguageCode = ?, IsRestricted = ?, Genres = ?, Keywords = ?, ContentRatings = ?, ProductionCountries = ?, EpisodeCount = ?, HiddenEpisodeCount = ?, SeasonCount = ?, AlternateOrderingCount = ?, UserRating = ?, UserVotes = ?, FirstAiredAt = ?, LastAiredAt = ?, CreatedAt = ?, LastUpdatedAt = ?, PreferredAlternateOrderingID = ? WHERE TMDB_ShowID = ?] ---> NHibernate.Exceptions.GenericADOException: could not update: [Shoko.Server.Models.TMDB.TMDB_Show#1968][SQL: UPDATE TMDB_Show SET TmdbShowID = ?, TvdbShowID = ?, PosterPath = ?, BackdropPath = ?, EnglishTitle = ?, EnglishOverview = ?, OriginalTitle = ?, OriginalLanguageCode = ?, IsRestricted = ?, Genres = ?, Keywords = ?, ContentRatings = ?, ProductionCountries = ?, EpisodeCount = ?, HiddenEpisodeCount = ?, SeasonCount = ?, AlternateOrderingCount = ?, UserRating = ?, UserVotes = ?, FirstAiredAt = ?, LastAiredAt = ?, CreatedAt = ?, LastUpdatedAt = ?, PreferredAlternateOrderingID = ? WHERE TMDB_ShowID = ?] ---> MySqlConnector.MySqlException (0x80004005): Data too long for column 'Keywords' at row 1 at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 1081 at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 131 at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 487 at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56 at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd) at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) --- End of inner exception stack trace --- at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) at NHibernate.Action.EntityUpdateAction.Execute() at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable) at NHibernate.Engine.ActionQueue.ExecuteActions[T](List`1 list) at NHibernate.Engine.ActionQueue.ExecuteActions() at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) at NHibernate.Impl.SessionImpl.Flush() at NHibernate.Impl.SessionImpl.BeforeTransactionCompletion(ITransaction tx) at NHibernate.Transaction.AdoTransaction.Commit() at Shoko.Server.Repositories.BaseCachedRepository`2.<>c__DisplayClass47_0.<Save>b__0() in D:\a\ShokoServer\ShokoServer\Shoko.Server\Repositories\BaseCachedRepository.cs:line 226 at Shoko.Server.Repositories.BaseRepository.Lock(Action action) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Repositories\BaseRepository.cs:line 22 at Shoko.Server.Repositories.BaseCachedRepository`2.Save(T obj) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Repositories\BaseCachedRepository.cs:line 221 at Shoko.Server.Providers.TMDB.TmdbMetadataService.UpdateShow(Int32 showId, Boolean forceRefresh, Boolean downloadImages, Boolean downloadCrewAndCast, Boolean downloadAlternateOrdering, Boolean quickRefresh) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Providers\TMDB\TmdbMetadataService.cs:line 1073 at Shoko.Server.Scheduling.Jobs.TMDB.UpdateTmdbShowJob.Process() in D:\a\ShokoServer\ShokoServer\Shoko.Server\Scheduling\Jobs\TMDB\UpdateTmdbShowJob.cs:line 65 at Shoko.Server.Scheduling.Jobs.BaseJob.Execute(IJobExecutionContext context) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Scheduling\Jobs\BaseJob.cs:line 33 --- End of inner exception stack trace --- at Shoko.Server.Scheduling.Jobs.BaseJob.Execute(IJobExecutionContext context) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Scheduling\Jobs\BaseJob.cs:line 50 at Quartz.Core.JobRunShell.Run(CancellationToken cancellationToken) [See nested exception: NHibernate.Exceptions.GenericADOException: could not update: [Shoko.Server.Models.TMDB.TMDB_Show#1968][SQL: UPDATE TMDB_Show SET TmdbShowID = ?, TvdbShowID = ?, PosterPath = ?, BackdropPath = ?, EnglishTitle = ?, EnglishOverview = ?, OriginalTitle = ?, OriginalLanguageCode = ?, IsRestricted = ?, Genres = ?, Keywords = ?, ContentRatings = ?, ProductionCountries = ?, EpisodeCount = ?, HiddenEpisodeCount = ?, SeasonCount = ?, AlternateOrderingCount = ?, UserRating = ?, UserVotes = ?, FirstAiredAt = ?, LastAiredAt = ?, CreatedAt = ?, LastUpdatedAt = ?, PreferredAlternateOrderingID = ? WHERE TMDB_ShowID = ?] ---> MySqlConnector.MySqlException (0x80004005): Data too long for column 'Keywords' at row 1 at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 1081 at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 131 at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 487 at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56 at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd) at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) --- End of inner exception stack trace --- at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) at NHibernate.Action.EntityUpdateAction.Execute() at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable) at NHibernate.Engine.ActionQueue.ExecuteActions[T](List`1 list) at NHibernate.Engine.ActionQueue.ExecuteActions() at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) at NHibernate.Impl.SessionImpl.Flush() at NHibernate.Impl.SessionImpl.BeforeTransactionCompletion(ITransaction tx) at NHibernate.Transaction.AdoTransaction.Commit() at Shoko.Server.Repositories.BaseCachedRepository`2.<>c__DisplayClass47_0.<Save>b__0() in D:\a\ShokoServer\ShokoServer\Shoko.Server\Repositories\BaseCachedRepository.cs:line 226 at Shoko.Server.Repositories.BaseRepository.Lock(Action action) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Repositories\BaseRepository.cs:line 22 at Shoko.Server.Repositories.BaseCachedRepository`2.Save(T obj) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Repositories\BaseCachedRepository.cs:line 221 at Shoko.Server.Providers.TMDB.TmdbMetadataService.UpdateShow(Int32 showId, Boolean forceRefresh, Boolean downloadImages, Boolean downloadCrewAndCast, Boolean downloadAlternateOrdering, Boolean quickRefresh) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Providers\TMDB\TmdbMetadataService.cs:line 1073 at Shoko.Server.Scheduling.Jobs.TMDB.UpdateTmdbShowJob.Process() in D:\a\ShokoServer\ShokoServer\Shoko.Server\Scheduling\Jobs\TMDB\UpdateTmdbShowJob.cs:line 65 at Shoko.Server.Scheduling.Jobs.BaseJob.Execute(IJobExecutionContext context) in D:\a\ShokoServer\ShokoServer\Shoko.Server\Scheduling\Jobs\BaseJob.cs:line 33]

Screenshots

No response

Aug 28 '25 00:08 t0815