{"action":"created","issue":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/792","labels_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/792/labels{/name}","comments_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/792/comments","events_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/792/events","html_url":"https://github.com/salesagility/SuiteCRM/issues/792","id":122711613,"number":792,"title":"AOS Settings: Initial Invoice Number","user":{"login":"EZS-JD","id":15463075,"avatar_url":"https://avatars.githubusercontent.com/u/15463075?v=3","gravatar_id":"","url":"https://api.github.com/users/EZS-JD","html_url":"https://github.com/EZS-JD","followers_url":"https://api.github.com/users/EZS-JD/followers","following_url":"https://api.github.com/users/EZS-JD/following{/other_user}","gists_url":"https://api.github.com/users/EZS-JD/gists{/gist_id}","starred_url":"https://api.github.com/users/EZS-JD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EZS-JD/subscriptions","organizations_url":"https://api.github.com/users/EZS-JD/orgs","repos_url":"https://api.github.com/users/EZS-JD/repos","events_url":"https://api.github.com/users/EZS-JD/events{/privacy}","received_events_url":"https://api.github.com/users/EZS-JD/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-17T10:56:00Z","updated_at":"2015-12-17T14:15:20Z","closed_at":null,"body":"It seems to be possible to enter an initial invoice number under Admin->AOS Settings that surpasses the allowed integer length defined in the database field \"number\" in table \"aos_invoices\" (11).\r\n\r\n-> Entering an initial invoice number of more than 10 digits in the aos settings admin panel should produce an error.\r\nAlso it might be good to inform the user of this restriction in a help-box or something, to keep in mind, that this auto-populated number may never exceed 9'999'999'999 lest there be database errors. (if I understand correctly)\r\n\r\nThe error message I'm seeing in suitecrm.log:\r\n\r\n> Out of range value for column 'number' at row 1\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/comments/165462605","html_url":"https://github.com/salesagility/SuiteCRM/issues/792#issuecomment-165462605","issue_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/792","id":165462605,"user":{"login":"pribeiro42","id":5657365,"avatar_url":"https://avatars.githubusercontent.com/u/5657365?v=3","gravatar_id":"","url":"https://api.github.com/users/pribeiro42","html_url":"https://github.com/pribeiro42","followers_url":"https://api.github.com/users/pribeiro42/followers","following_url":"https://api.github.com/users/pribeiro42/following{/other_user}","gists_url":"https://api.github.com/users/pribeiro42/gists{/gist_id}","starred_url":"https://api.github.com/users/pribeiro42/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pribeiro42/subscriptions","organizations_url":"https://api.github.com/users/pribeiro42/orgs","repos_url":"https://api.github.com/users/pribeiro42/repos","events_url":"https://api.github.com/users/pribeiro42/events{/privacy}","received_events_url":"https://api.github.com/users/pribeiro42/received_events","type":"User","site_admin":false},"created_at":"2015-12-17T14:15:20Z","updated_at":"2015-12-17T14:15:20Z","body":"The \"11\" in the field definition is not a limit on the integer range, its a display hint that mysql provides, allowing an application to check for a \"maximum display width\" or a \"padding factor\" or something like that... The column, being defined as INT, will allow values in the range -2147483648 to 2147483647. \r\nHowever, the UI should in fact warn the user..."}}