{"action":"created","issue":{"url":"https://api.github.com/repos/2sic/2sxc/issues/1582","repository_url":"https://api.github.com/repos/2sic/2sxc","labels_url":"https://api.github.com/repos/2sic/2sxc/issues/1582/labels{/name}","comments_url":"https://api.github.com/repos/2sic/2sxc/issues/1582/comments","events_url":"https://api.github.com/repos/2sic/2sxc/issues/1582/events","html_url":"https://github.com/2sic/2sxc/issues/1582","id":330691560,"node_id":"MDU6SXNzdWUzMzA2OTE1NjA=","number":1582,"title":"Blog posts not saving - Could not find stored procedure ‘toSIC_EAV_ChangeLogAdd’","user":{"login":"valius79","id":10970576,"node_id":"MDQ6VXNlcjEwOTcwNTc2","avatar_url":"https://avatars3.githubusercontent.com/u/10970576?v=4","gravatar_id":"","url":"https://api.github.com/users/valius79","html_url":"https://github.com/valius79","followers_url":"https://api.github.com/users/valius79/followers","following_url":"https://api.github.com/users/valius79/following{/other_user}","gists_url":"https://api.github.com/users/valius79/gists{/gist_id}","starred_url":"https://api.github.com/users/valius79/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/valius79/subscriptions","organizations_url":"https://api.github.com/users/valius79/orgs","repos_url":"https://api.github.com/users/valius79/repos","events_url":"https://api.github.com/users/valius79/events{/privacy}","received_events_url":"https://api.github.com/users/valius79/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-08T14:55:52Z","updated_at":"2018-06-08T15:19:12Z","closed_at":null,"author_association":"NONE","body":"**I'm submitting a ...** \r\n[x] not sure\r\n\r\n**...about**  \r\n[x] other / unknown\r\n\r\n**Current behavior**\r\nThe module doesn't save posts anymore. When in Manage Content/Data I can see the post, but it is not rendering once you get out. This is the error when we click save now, and we did not upgrade the site. It just stopped working. *Had an error talking to the server (400)), Bad request, Could not find stored procedure ‘toSIC_EAV_ChangeLogAdd’. *\r\n\r\n**Expected behavior**\r\nPost should render on the page, and we should be able to save the new ones. \r\n\r\n**Minimal reproduction of the problem with instructions**\r\nLog into the DNN, go to the Blog page, open see all posts, open a single post, click save (not working). Error: *Had an error talking to the server (400)), Bad request, Could not find stored procedure ‘toSIC_EAV_ChangeLogAdd’. * The stored procedure ToSIC_EAV_changeLogSet is still there.\r\n\r\n**What is the motivation / use case for changing the behavior?**\r\nIt just stopped working.\r\n\r\n**Please tell us about your environment:**\r\n<!-- Operating system, IDE, package manager, HTTP server, ... -->\r\nWindows 10, HTTPS, Amazon AWS, Visual Studio.\r\n\r\n* **2sxc version(s):** 9.32.0 - Upgraded to this version after the issue happened. Still not saving.\r\n* **Browser:** ALL\r\n* **DNN:** 9.1.1\r\n* **Language:** English\r\n\r\n**Anything you would like to add**\r\nI already submitted to the StackOverflow and DNN site, and nobody is answering. I see many views but no answers. If somebody please could at least point me in the right direction, it would be greatly appreciated."},"comment":{"url":"https://api.github.com/repos/2sic/2sxc/issues/comments/395794247","html_url":"https://github.com/2sic/2sxc/issues/1582#issuecomment-395794247","issue_url":"https://api.github.com/repos/2sic/2sxc/issues/1582","id":395794247,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NTc5NDI0Nw==","user":{"login":"iJungleboy","id":5321186,"node_id":"MDQ6VXNlcjUzMjExODY=","avatar_url":"https://avatars3.githubusercontent.com/u/5321186?v=4","gravatar_id":"","url":"https://api.github.com/users/iJungleboy","html_url":"https://github.com/iJungleboy","followers_url":"https://api.github.com/users/iJungleboy/followers","following_url":"https://api.github.com/users/iJungleboy/following{/other_user}","gists_url":"https://api.github.com/users/iJungleboy/gists{/gist_id}","starred_url":"https://api.github.com/users/iJungleboy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iJungleboy/subscriptions","organizations_url":"https://api.github.com/users/iJungleboy/orgs","repos_url":"https://api.github.com/users/iJungleboy/repos","events_url":"https://api.github.com/users/iJungleboy/events{/privacy}","received_events_url":"https://api.github.com/users/iJungleboy/received_events","type":"User","site_admin":false},"created_at":"2018-06-08T15:19:12Z","updated_at":"2018-06-08T15:19:12Z","author_association":"CONTRIBUTOR","body":"So I never saw this before - my guess is something happened in the DB, maybe someone deleted a SP or set permissions to this stored procedure or something making it unavailable.  I don't think it's a 2sxc issue. Could you check some more?\r\n\r\nAlso: you're mentioning that it's looking for `...ChangeLogAdd` and saying that `...ChangeLogSet` is there. That's of course not the same thing. If someone deleted the ChangeLogAdd, try running this:\r\n\r\n```\r\nUSE [dnn920c]\r\nGO\r\n\r\n/****** Object:  StoredProcedure [dbo].[ToSIC_EAV_ChangeLogAdd]    Script Date: 08.06.2018 17:18:29 ******/\r\nSET ANSI_NULLS ON\r\nGO\r\n\r\nSET QUOTED_IDENTIFIER ON\r\nGO\r\n\r\n\r\nCREATE PROCEDURE [dbo].[ToSIC_EAV_ChangeLogAdd] \r\n\t-- Add the parameters for the stored procedure here\r\n\t@User nvarchar(255) = null\r\nAS\r\nBEGIN\r\n\t-- SET NOCOUNT ON added to prevent extra result sets from\r\n\t-- interfering with SELECT statements.\r\n\t--SET NOCOUNT ON;\r\n\r\n\t-- Insert statements for procedure here\r\n\tINSERT INTO [dbo].[ToSIC_EAV_ChangeLog] ([Timestamp] ,[User])\r\n\t VALUES (GetDate(), @user)\r\n\r\n\tDECLARE @ChangeID int\r\n\tSET @ChangeID = scope_identity()\r\n\tEXEC ToSIC_EAV_ChangeLogSet @ChangeID\r\n\r\n\tSELECT *\r\n\tFROM [dbo].[ToSIC_EAV_ChangeLog]\r\n\tWHERE [ChangeID] = @ChangeID\r\nEND\r\n\r\nGO\r\n\r\n\r\n\r\n```"}}
{"actor":{"display_login":"iJungleboy"}}