{"action":"created","issue":{"url":"https://api.github.com/repos/octobercms/october/issues/3999","repository_url":"https://api.github.com/repos/octobercms/october","labels_url":"https://api.github.com/repos/octobercms/october/issues/3999/labels{/name}","comments_url":"https://api.github.com/repos/octobercms/october/issues/3999/comments","events_url":"https://api.github.com/repos/octobercms/october/issues/3999/events","html_url":"https://github.com/octobercms/october/issues/3999","id":393174218,"node_id":"MDU6SXNzdWUzOTMxNzQyMTg=","number":3999,"title":"Backend Users deleted_at column migration not running on backend update to Build 445","user":{"login":"ayumihamsaki","id":17784082,"node_id":"MDQ6VXNlcjE3Nzg0MDgy","avatar_url":"https://avatars2.githubusercontent.com/u/17784082?v=4","gravatar_id":"","url":"https://api.github.com/users/ayumihamsaki","html_url":"https://github.com/ayumihamsaki","followers_url":"https://api.github.com/users/ayumihamsaki/followers","following_url":"https://api.github.com/users/ayumihamsaki/following{/other_user}","gists_url":"https://api.github.com/users/ayumihamsaki/gists{/gist_id}","starred_url":"https://api.github.com/users/ayumihamsaki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ayumihamsaki/subscriptions","organizations_url":"https://api.github.com/users/ayumihamsaki/orgs","repos_url":"https://api.github.com/users/ayumihamsaki/repos","events_url":"https://api.github.com/users/ayumihamsaki/events{/privacy}","received_events_url":"https://api.github.com/users/ayumihamsaki/received_events","type":"User","site_admin":false},"labels":[{"id":143615180,"node_id":"MDU6TGFiZWwxNDM2MTUxODA=","url":"https://api.github.com/repos/octobercms/october/labels/Status:%20Review%20Needed","name":"Status: Review Needed","color":"fbca04","default":false},{"id":67885479,"node_id":"MDU6TGFiZWw2Nzg4NTQ3OQ==","url":"https://api.github.com/repos/octobercms/october/labels/Type:%20Bug","name":"Type: Bug","color":"e11d21","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2018-12-20T19:06:42Z","updated_at":"2018-12-21T12:33:10Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"We updated the cms from V443 to V445 and found the following errors and solutions and I thought I'd post them here to help out everyone (not sure where to post this as the forum is closed).\r\n\r\n**_You will need to update two or three things._**\r\n\r\nIf you have bleeding updates turned on and turn to update from V443 to V445 you will come across this error message:\r\n\r\n![11111111a](https://user-images.githubusercontent.com/17784082/50304508-0a840b80-0488-11e9-899e-673a0e33bc2d.png)\r\n\r\nTo fix this edit the file found at: \r\n\r\n/public_html/modules/backend/database/migrations/2013_10_01_000001_Db_Backend_Users.php\r\n\r\nAdd the following code:\r\n\r\n`$table->timestamp('deleted_at')->nullable();`\r\n\r\nAfter the line:\r\n\r\n`$table->timestamps();`\r\n\r\nNext you need to update the database and add the missing row into the database table.\r\n\r\nOpen up your database, for me it was `cPanel > phpMyAdmin`\r\n\r\nFind the Table called: `backend_users` open it and go to SQL and add the line of code:\r\n\r\n`ALTER TABLE backend_users ADD COLUMN deleted_at TIMESTAMP NULL AFTER created_at;`\r\n\r\nNow go back into the admin backend and update the cms via settings and should work or command line etc.\r\n\r\nLastly, (and I think many people will not spot this!)\r\n\r\nOctober has updated the `|media` twig.\r\n\r\nSo for us we had the following twig code:\r\n\r\n`https://www.example.com{{ 'image.jpg'|media }}`\r\n\r\nV443 or below will output this:\r\n\r\n`https://www.example.com/storage/app/media/image.jpg`\r\n\r\nV445 now gives the following image URL:\r\n\r\n`https://www.example.com/https://www.example.com/storage/app/media/image.jpg`\r\n\r\nSo make sure to re-write your twig if you have done this into this:\r\n\r\n`{{ 'image.jpg'|media }}`\r\n\r\nThat's everything we did to update the cms.\r\n\r\nHope it helps people out."},"comment":{"url":"https://api.github.com/repos/octobercms/october/issues/comments/449377267","html_url":"https://github.com/octobercms/october/issues/3999#issuecomment-449377267","issue_url":"https://api.github.com/repos/octobercms/october/issues/3999","id":449377267,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0OTM3NzI2Nw==","user":{"login":"w20k","id":1053320,"node_id":"MDQ6VXNlcjEwNTMzMjA=","avatar_url":"https://avatars1.githubusercontent.com/u/1053320?v=4","gravatar_id":"","url":"https://api.github.com/users/w20k","html_url":"https://github.com/w20k","followers_url":"https://api.github.com/users/w20k/followers","following_url":"https://api.github.com/users/w20k/following{/other_user}","gists_url":"https://api.github.com/users/w20k/gists{/gist_id}","starred_url":"https://api.github.com/users/w20k/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/w20k/subscriptions","organizations_url":"https://api.github.com/users/w20k/orgs","repos_url":"https://api.github.com/users/w20k/repos","events_url":"https://api.github.com/users/w20k/events{/privacy}","received_events_url":"https://api.github.com/users/w20k/received_events","type":"User","site_admin":false},"created_at":"2018-12-21T12:33:10Z","updated_at":"2018-12-21T12:33:10Z","author_association":"NONE","body":"@tobias-kuendig, is right.\r\n\r\nAfter unpacking and before doing migrations, it calls for a User and fails gracefully :)    "}}
{"actor":{"display_login":"w20k"}}