{"action":"created","issue":{"url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3709","repository_url":"https://api.github.com/repos/SimpleMachines/SMF2.1","labels_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3709/labels{/name}","comments_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3709/comments","events_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3709/events","html_url":"https://github.com/SimpleMachines/SMF2.1/issues/3709","id":194085267,"number":3709,"title":"New errorr \"The database value you're trying to insert does not exist: topic\"","user":{"login":"bobrenja","id":20020367,"avatar_url":"https://avatars.githubusercontent.com/u/20020367?v=3","gravatar_id":"","url":"https://api.github.com/users/bobrenja","html_url":"https://github.com/bobrenja","followers_url":"https://api.github.com/users/bobrenja/followers","following_url":"https://api.github.com/users/bobrenja/following{/other_user}","gists_url":"https://api.github.com/users/bobrenja/gists{/gist_id}","starred_url":"https://api.github.com/users/bobrenja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bobrenja/subscriptions","organizations_url":"https://api.github.com/users/bobrenja/orgs","repos_url":"https://api.github.com/users/bobrenja/repos","events_url":"https://api.github.com/users/bobrenja/events{/privacy}","received_events_url":"https://api.github.com/users/bobrenja/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-12-07T15:47:19Z","updated_at":"2016-12-08T18:29:06Z","closed_at":null,"body":"Where it should be assigned this variable ??\r\n\r\n$topicOptions['id']\r\n\r\n```\r\n\r\n$request = $smcFunc['db_query']('', '\r\nSELECT id_member, email_address, lngfile\r\nFROM {db_prefix}topics AS t\r\nINNER JOIN {db_prefix}members AS mem ON (mem.id_member = t.id_member_started)\r\nWHERE id_topic = {int:topic}', \t\r\narray(\r\n'topic' => $topicOptions['id'],\r\n)\r\n);\r\n\r\n```\r\nSources/tasks/ApproveReply-Notify.php"},"comment":{"url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/comments/265815993","html_url":"https://github.com/SimpleMachines/SMF2.1/issues/3709#issuecomment-265815993","issue_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3709","id":265815993,"user":{"login":"Oldiesmann","id":89023,"avatar_url":"https://avatars.githubusercontent.com/u/89023?v=3","gravatar_id":"","url":"https://api.github.com/users/Oldiesmann","html_url":"https://github.com/Oldiesmann","followers_url":"https://api.github.com/users/Oldiesmann/followers","following_url":"https://api.github.com/users/Oldiesmann/following{/other_user}","gists_url":"https://api.github.com/users/Oldiesmann/gists{/gist_id}","starred_url":"https://api.github.com/users/Oldiesmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Oldiesmann/subscriptions","organizations_url":"https://api.github.com/users/Oldiesmann/orgs","repos_url":"https://api.github.com/users/Oldiesmann/repos","events_url":"https://api.github.com/users/Oldiesmann/events{/privacy}","received_events_url":"https://api.github.com/users/Oldiesmann/received_events","type":"User","site_admin":false},"created_at":"2016-12-08T18:29:06Z","updated_at":"2016-12-08T18:29:06Z","body":"What exactly is being done to generate that error? The code in question loads up information to notify a user that their reply to a topic has been approved, and $topicOptions['id'] should contain the ID of the topic that the approved reply is in, and $topicOptions itself should be passed to the function when the task is called (see lines 2444-2463 of Sources/Subs-Post.php for an example of how that's done).\r\n\r\nThat being said, I can't find this task being called anywhere. Even when posts are approved, everything goes through the CreatePost-Notify background task."}}
{"actor":{"display_login":"Oldiesmann"}}