Syntax Error on Sync

Andre Pfanz asked on February 23, 2017 19:14

We are using staging content on Kentico v9. When we try to sync a page update, we get a message saying the sync failed. I found this error in the event log:

Dependent task 'Publish page Mobile Medical Fleet' failed:SyncServer.ServerError: Exception occurred: 
[DataConnection.HandleError]: 

Query: 
UPDATE CMS_Tree SET
WHERE ([NodeSiteID] = @NodeSiteID AND [NodeAliasPath] LIKE @NodeAliasPath)

Caused exception: 
Incorrect syntax near the keyword 'WHERE'.
Synchronizing 'Publish page Mobile Medical Fleet' task

The SQL UPDATE statement is missing the fields to modify after the SET keyword. Does anyone have any ideas?

sync staging content

Correct Answer

Andre Pfanz answered on February 24, 2017 16:21

I upgraded from 9.0.0 to 9.0.50 and corrected the problem.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Michal Samuhel answered on February 24, 2017 08:09

Hi Andre,

Any macro related errors in the event log? Have you tried re-signing macros?

These problems are usually related to incorrect macro signatures, as these parameters are retrieved with macros.

1 votesVote for this answer Mark as a Correct answer