Welcome Guest Search | Active Topics | Members | Log In | Register

MM5.25PR2: freezing when updating actors Options · View
xycommander
Posted: Thursday, July 18, 2019 8:31:07 PM

Groups: Member

Joined: 11/4/2012
Posts: 385
Location: Germany

Rank:
Rank based on contribution points and purchased points. Click to see details. (21285)
Hey :)

For some weeks now, whenever I try to update the crew and actors, My Movies stops working. All I can do is to terminate the program.
After restarting the program, I try to update again. But it stops at the exact same person (Claudio Maniscalco). I something wrong on my end or is it something on server side?

Happened on Win10 1809 and also on 1903. All available updates are installed.

Cheers :)




The log shows these lines:

2019-07-18 20:09:09 . 44 - Common.UPDATE tblPersonLanguageSpecific SET ntxBiography = '' AND datDataChanged = @datDataChanged WHERE intPerson = (SELECT intId FROM tblPersons WHERE nvcWebServiceId = '60259ead-6919-42f6-96d0-82f3d877d123') AND bitAlternative = 1
2019-07-18 20:09:09 . 44 - Common.Database.ExecuteNonQuery - 'UPDATE tblPersonLanguageSpecific SET ntxBiography = '' AND datDataChanged = @datDataChanged WHERE intPerson = (SELECT intId FROM tblPersons WHERE nvcWebServiceId = '60259ead-6919-42f6-96d0-82f3d877d123') AND bitAlternative = 1'
2019-07-18 20:09:09 . 93 - Common.Database.ExecuteNonQuery - Attempt 1 of 3 to execute command failed: 'UPDATE tblPersonLanguageSpecific SET ntxBiography = '' AND datDataChanged = @datDataChanged WHERE intPerson = (SELECT intId FROM tblPersons WHERE nvcWebServiceId = '60259ead-6919-42f6-96d0-82f3d877d123') AND bitAlternative = 1', 'Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.'
2019-07-18 20:09:10 . 18 - Common.Database.ExecuteNonQuery - Attempt 2 of 3 to execute command failed: 'UPDATE tblPersonLanguageSpecific SET ntxBiography = '' AND datDataChanged = @datDataChanged WHERE intPerson = (SELECT intId FROM tblPersons WHERE nvcWebServiceId = '60259ead-6919-42f6-96d0-82f3d877d123') AND bitAlternative = 1', 'Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.'
2019-07-18 20:09:10 . 43 - Common.Database.ExecuteNonQuery - Attempt 3 of 3 to execute command failed: 'UPDATE tblPersonLanguageSpecific SET ntxBiography = '' AND datDataChanged = @datDataChanged WHERE intPerson = (SELECT intId FROM tblPersons WHERE nvcWebServiceId = '60259ead-6919-42f6-96d0-82f3d877d123') AND bitAlternative = 1', 'Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.'
2019-07-18 20:09:10 . 70 - Common.Database.ExecuteNonQuery - All attempts to execute command failed: 'UPDATE tblPersonLanguageSpecific SET ntxBiography = '' AND datDataChanged = @datDataChanged WHERE intPerson = (SELECT intId FROM tblPersons WHERE nvcWebServiceId = '60259ead-6919-42f6-96d0-82f3d877d123') AND bitAlternative = 1', 'Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.'
2019-07-18 20:09:15 . 02 - CollectionManagement.UnhandledThreadExceptionHandler - Executing query failed over 3 retries, 'Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.', ' bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei MyMovies.Database.ExecuteNonQuery(SqlCommand objCommand, Boolean bolWriteLog, Int32 intMaxRetries)' - bei MyMovies.Database.ExecuteNonQuery(SqlCommand objCommand, Boolean bolWriteLog, Int32 intMaxRetries)
bei MyMovies.CollectionManagement.mitCheckForUpdatedPersonProfiles_Click(Object sender, EventArgs e) in C:\Users\brian\Documents\Visual Studio 2015\Projects\My Movies for WMC and CM 5.10\My Movies - Collection\Collection Management.vb:Zeile 20272.
bei System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
bei System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
bei System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
bei System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
bei System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
bei System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.ToolStrip.WndProc(Message& m)
bei System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

And logex:

2019-07-18 20:09:10 . 69 - Common.Database.ExecuteNonQuery - All attempts to execute command failed: 'UPDATE tblPersonLanguageSpecific SET ntxBiography = '' AND datDataChanged = @datDataChanged WHERE intPerson = (SELECT intId FROM tblPersons WHERE nvcWebServiceId = '60259ead-6919-42f6-96d0-82f3d877d123') AND bitAlternative = 1', 'Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.'


Got a question or problem? Have a look here first: http://kb.mymovies.dk/Default.aspx

Collection: c.mymovies.dk/xyCommander

Active Android devices: My Movies Pro 2.27 B6
- Huawei: Mate 9 [MHA-L29/A 9.0.0/stock]
- Samsung: Galaxy Note 10.1/'14 [P600/A 7.1.2/custom]


My Movies for Windows 5.25PR5 @ Win10 (1903.18362.295, 64Bit)
xycommander
Posted: Sunday, July 28, 2019 9:13:32 AM

Groups: Member

Joined: 11/4/2012
Posts: 385
Location: Germany

Rank:
Rank based on contribution points and purchased points. Click to see details. (21285)
Hey.
Any ideas from anyone?
Cheers :)

Got a question or problem? Have a look here first: http://kb.mymovies.dk/Default.aspx

Collection: c.mymovies.dk/xyCommander

Active Android devices: My Movies Pro 2.27 B6
- Huawei: Mate 9 [MHA-L29/A 9.0.0/stock]
- Samsung: Galaxy Note 10.1/'14 [P600/A 7.1.2/custom]


My Movies for Windows 5.25PR5 @ Win10 (1903.18362.295, 64Bit)
michael1
Posted: Sunday, July 28, 2019 1:45:51 PM

Groups: Member

Joined: 11/23/2008
Posts: 45
Location: Japan

Rank:
Rank based on contribution points and purchased points. Click to see details. (2538)
Hi,

I have exactly the same problem. Just the person is different, it's the actress Jana Pallaske.

Happened on Win10 1809 and also on 1903. All available updates are installed.
All I can do is to terminate the program.

Any thoughts please ...?

HTPC connected to TV incl. HDD with stored movies
Win10 x64 1903 incl. latest updates - MyMovies 5.25 PR2, PowerDVD 19
Collection: HDD 600+, Blu-Ray Discs 200+ and a few UHD Blu-Ray Discs
MyMovies3 App for iOS
binnerup
Posted: Monday, July 29, 2019 8:31:21 AM

Groups: Administration , Windows RT/8 Discussion Group

Joined: 2/1/2005
Posts: 46,746
Location: Aarhus, Denmark

Rank:
Rank based on contribution points and purchased points. Click to see details. (131686)
xycommander
Posted: Monday, July 29, 2019 9:35:28 AM

Groups: Member

Joined: 11/4/2012
Posts: 385
Location: Germany

Rank:
Rank based on contribution points and purchased points. Click to see details. (21285)
Good morning.
Thank you very much :)
Have a nice week

Got a question or problem? Have a look here first: http://kb.mymovies.dk/Default.aspx

Collection: c.mymovies.dk/xyCommander

Active Android devices: My Movies Pro 2.27 B6
- Huawei: Mate 9 [MHA-L29/A 9.0.0/stock]
- Samsung: Galaxy Note 10.1/'14 [P600/A 7.1.2/custom]


My Movies for Windows 5.25PR5 @ Win10 (1903.18362.295, 64Bit)
xycommander
Posted: Monday, September 09, 2019 1:40:39 PM

Groups: Member

Joined: 11/4/2012
Posts: 385
Location: Germany

Rank:
Rank based on contribution points and purchased points. Click to see details. (21285)
Works perfectly fine again. Thanks for correcting :)
Cheers

Got a question or problem? Have a look here first: http://kb.mymovies.dk/Default.aspx

Collection: c.mymovies.dk/xyCommander

Active Android devices: My Movies Pro 2.27 B6
- Huawei: Mate 9 [MHA-L29/A 9.0.0/stock]
- Samsung: Galaxy Note 10.1/'14 [P600/A 7.1.2/custom]


My Movies for Windows 5.25PR5 @ Win10 (1903.18362.295, 64Bit)
binnerup
Posted: Monday, September 09, 2019 1:49:43 PM

Groups: Administration , Windows RT/8 Discussion Group

Joined: 2/1/2005
Posts: 46,746
Location: Aarhus, Denmark

Rank:
Rank based on contribution points and purchased points. Click to see details. (131686)
Users browsing this topic
guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Powered by Yet Another Forum.net version 1.9.0 (NET v4.0) - 10/10/2006
Copyright © 2003-2006 Yet Another Forum.net. All rights reserved.