{"action":"created","issue":{"url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/5208","repository_url":"https://api.github.com/repos/Dolibarr/dolibarr","labels_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/5208/labels{/name}","comments_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/5208/comments","events_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/5208/events","html_url":"https://github.com/Dolibarr/dolibarr/issues/5208","id":154705438,"number":5208,"title":"Unknown column 'XXX' in 'field list'","user":{"login":"Max84","id":6622400,"avatar_url":"https://avatars3.githubusercontent.com/u/6622400?v=4","gravatar_id":"","url":"https://api.github.com/users/Max84","html_url":"https://github.com/Max84","followers_url":"https://api.github.com/users/Max84/followers","following_url":"https://api.github.com/users/Max84/following{/other_user}","gists_url":"https://api.github.com/users/Max84/gists{/gist_id}","starred_url":"https://api.github.com/users/Max84/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Max84/subscriptions","organizations_url":"https://api.github.com/users/Max84/orgs","repos_url":"https://api.github.com/users/Max84/repos","events_url":"https://api.github.com/users/Max84/events{/privacy}","received_events_url":"https://api.github.com/users/Max84/received_events","type":"User","site_admin":false},"labels":[{"id":143201146,"url":"https://api.github.com/repos/Dolibarr/dolibarr/labels/Discussion","name":"Discussion","color":"d4c5f9","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-05-13T12:55:59Z","updated_at":"2018-04-11T19:41:45Z","closed_at":"2016-06-04T15:46:48Z","author_association":"NONE","body":"Hi Folks,\n\nI've dolibarr 3.7. I added a few fields into a customer order.\nAfter, i updated Dolibarr to the last version 3.9.1.\nNow, i create an order and i try to deliver it.\n\nI can't  : order isn't validated and an error message is displayed : Unknown column 'XXX' in 'field list' is my added field.\n\nBest regards,\nMaxime\n"},"comment":{"url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/comments/380572266","html_url":"https://github.com/Dolibarr/dolibarr/issues/5208#issuecomment-380572266","issue_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/5208","id":380572266,"user":{"login":"EddTamuse","id":38297997,"avatar_url":"https://avatars1.githubusercontent.com/u/38297997?v=4","gravatar_id":"","url":"https://api.github.com/users/EddTamuse","html_url":"https://github.com/EddTamuse","followers_url":"https://api.github.com/users/EddTamuse/followers","following_url":"https://api.github.com/users/EddTamuse/following{/other_user}","gists_url":"https://api.github.com/users/EddTamuse/gists{/gist_id}","starred_url":"https://api.github.com/users/EddTamuse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EddTamuse/subscriptions","organizations_url":"https://api.github.com/users/EddTamuse/orgs","repos_url":"https://api.github.com/users/EddTamuse/repos","events_url":"https://api.github.com/users/EddTamuse/events{/privacy}","received_events_url":"https://api.github.com/users/EddTamuse/received_events","type":"User","site_admin":false},"created_at":"2018-04-11T19:41:45Z","updated_at":"2018-04-11T19:41:45Z","author_association":"NONE","body":"Hello all,\r\n\r\nI've found the fix for my issue, thanks to lawrence in following link: [https://www.dolibarr.org/forum/527-bugs-on-a-stable-version/27247-6-0-2-error-in-adding-note-to-project-task](url)\r\n\r\nMy issue was the same from him:\r\nWhen attempting to add note to a task of a project, following error encountered:\r\nUnknown column 'fk_user_modif' in 'field list'\r\n\r\nThe reason, the column 'fk_user_modif' does not exist in the table 'llx_projet_task' or in other case yourdatabaseprefix=ydp  or how ever you put in database prefix variable 'ydp_projet_task'.\r\n\r\nRecommended fix add the column in mysql or phpmyadmin or whatever with this command:\r\nALTER TABLE ydp_projet_task ADD COLUMN fk_user_modif integer;\r\n\r\n"}}
{"actor":{"display_login":"EddTamuse"}}