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:
UPDATE CMS_Tree SET
WHERE ([NodeSiteID] = @NodeSiteID AND [NodeAliasPath] LIKE @NodeAliasPath)
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?
I upgraded from 9.0.0 to 9.0.50 and corrected the problem.
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.
Please, sign in to be able to submit a new answer.