{"action":"created","issue":{"url":"https://api.github.com/repos/zikula/core/issues/2696","labels_url":"https://api.github.com/repos/zikula/core/issues/2696/labels{/name}","comments_url":"https://api.github.com/repos/zikula/core/issues/2696/comments","events_url":"https://api.github.com/repos/zikula/core/issues/2696/events","html_url":"https://github.com/zikula/core/issues/2696","id":123479801,"number":2696,"title":"User settings changes crash site","user":{"login":"pheski","id":1130881,"avatar_url":"https://avatars.githubusercontent.com/u/1130881?v=3","gravatar_id":"","url":"https://api.github.com/users/pheski","html_url":"https://github.com/pheski","followers_url":"https://api.github.com/users/pheski/followers","following_url":"https://api.github.com/users/pheski/following{/other_user}","gists_url":"https://api.github.com/users/pheski/gists{/gist_id}","starred_url":"https://api.github.com/users/pheski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pheski/subscriptions","organizations_url":"https://api.github.com/users/pheski/orgs","repos_url":"https://api.github.com/users/pheski/repos","events_url":"https://api.github.com/users/pheski/events{/privacy}","received_events_url":"https://api.github.com/users/pheski/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/zikula/core/labels/Bug","name":"Bug","color":"e102d8"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/zikula/core/milestones/19","html_url":"https://github.com/zikula/core/milestones/1.4.2","labels_url":"https://api.github.com/repos/zikula/core/milestones/19/labels","id":1391003,"number":19,"title":"1.4.2","description":"second service release for 1.4.x series.","creator":{"login":"cmfcmf","id":2145092,"avatar_url":"https://avatars.githubusercontent.com/u/2145092?v=3","gravatar_id":"","url":"https://api.github.com/users/cmfcmf","html_url":"https://github.com/cmfcmf","followers_url":"https://api.github.com/users/cmfcmf/followers","following_url":"https://api.github.com/users/cmfcmf/following{/other_user}","gists_url":"https://api.github.com/users/cmfcmf/gists{/gist_id}","starred_url":"https://api.github.com/users/cmfcmf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cmfcmf/subscriptions","organizations_url":"https://api.github.com/users/cmfcmf/orgs","repos_url":"https://api.github.com/users/cmfcmf/repos","events_url":"https://api.github.com/users/cmfcmf/events{/privacy}","received_events_url":"https://api.github.com/users/cmfcmf/received_events","type":"User","site_admin":false},"open_issues":53,"closed_issues":48,"state":"open","created_at":"2015-11-03T10:48:29Z","updated_at":"2016-01-16T15:17:11Z","due_on":"2016-03-20T04:00:00Z","closed_at":null},"comments":3,"created_at":"2015-12-22T13:17:00Z","updated_at":"2016-01-16T21:00:02Z","closed_at":null,"body":"Using Zikula 1.4.1 and Andreas08, I changed User settings so that unverified email addresses would expire in 2 days. The default is 0.  I had a number of (spammy) users with unverified email addresses.\r\n\r\nWhen I saved this change, I got a Server 500 error:\r\n\r\nThe server returned a \"500 Internal Server Error\".\r\n\r\nSomething is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.\r\n\r\nAn exception has been thrown during the rendering of a template (\"An exception occurred while executing 'DELETE FROM users WHERE uid = ?' with params [3]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`pemdblog`.`users_attributes`, CONSTRAINT `FK_E6F031E4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`))\") in \"ZikulaAndreas08Theme:Include:header.html.twig\" at line 15.\r\n\r\nThe fix was to go to the MySQL database and look at the user table and user_attributes table to identify the users with unverified email address (was pretty easy to tell), then remove them FIRST from user_attributes (they cannot be removed from the parent users table until removed from users_attributes) and then remove them from users.\r\n\r\nBoom. Back in business.  But looks like a bug. Beyond my expertise, but sounds like changing that parameter either needs to fail gracefully (\"No, I won't do this until you...\") or do the task in the background. \r\n\r\nThe same may apply to changing the password reset timelimit, though I have not checked that.\r\n\r\nDon't know how to mark this ticket as a bug, so I put [Bug] in Subject line. Hope that is ok.\r\n\r\nPeter"},"comment":{"url":"https://api.github.com/repos/zikula/core/issues/comments/172257552","html_url":"https://github.com/zikula/core/issues/2696#issuecomment-172257552","issue_url":"https://api.github.com/repos/zikula/core/issues/2696","id":172257552,"user":{"login":"craigh","id":350048,"avatar_url":"https://avatars.githubusercontent.com/u/350048?v=3","gravatar_id":"","url":"https://api.github.com/users/craigh","html_url":"https://github.com/craigh","followers_url":"https://api.github.com/users/craigh/followers","following_url":"https://api.github.com/users/craigh/following{/other_user}","gists_url":"https://api.github.com/users/craigh/gists{/gist_id}","starred_url":"https://api.github.com/users/craigh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigh/subscriptions","organizations_url":"https://api.github.com/users/craigh/orgs","repos_url":"https://api.github.com/users/craigh/repos","events_url":"https://api.github.com/users/craigh/events{/privacy}","received_events_url":"https://api.github.com/users/craigh/received_events","type":"User","site_admin":false},"created_at":"2016-01-16T21:00:02Z","updated_at":"2016-01-16T21:00:02Z","body":"> Consequently I have harvested as much content as I can and this is a fresh 1.4.1 install\r\n\r\n> I had a number of (spammy) users with unverified email addresses.\r\n\r\nI cannot reconcile the two statements above. How is it possible that you had a number of spammy unverified accounts if this is not an upgrade?"}}