{"action":"created","issue":{"url":"https://api.github.com/repos/AVsitter/AVsitter/issues/49","repository_url":"https://api.github.com/repos/AVsitter/AVsitter","labels_url":"https://api.github.com/repos/AVsitter/AVsitter/issues/49/labels{/name}","comments_url":"https://api.github.com/repos/AVsitter/AVsitter/issues/49/comments","events_url":"https://api.github.com/repos/AVsitter/AVsitter/issues/49/events","html_url":"https://github.com/AVsitter/AVsitter/issues/49","id":261164727,"number":49,"title":"settings.php notecard size limit","user":{"login":"codeviolet","id":12992687,"avatar_url":"https://avatars1.githubusercontent.com/u/12992687?v=4","gravatar_id":"","url":"https://api.github.com/users/codeviolet","html_url":"https://github.com/codeviolet","followers_url":"https://api.github.com/users/codeviolet/followers","following_url":"https://api.github.com/users/codeviolet/following{/other_user}","gists_url":"https://api.github.com/users/codeviolet/gists{/gist_id}","starred_url":"https://api.github.com/users/codeviolet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codeviolet/subscriptions","organizations_url":"https://api.github.com/users/codeviolet/orgs","repos_url":"https://api.github.com/users/codeviolet/repos","events_url":"https://api.github.com/users/codeviolet/events{/privacy}","received_events_url":"https://api.github.com/users/codeviolet/received_events","type":"User","site_admin":false},"labels":[{"id":289639890,"url":"https://api.github.com/repos/AVsitter/AVsitter/labels/bug","name":"bug","color":"fc2929","default":true},{"id":289639892,"url":"https://api.github.com/repos/AVsitter/AVsitter/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-09-28T01:20:14Z","updated_at":"2017-09-29T09:34:08Z","closed_at":null,"author_association":"OWNER","body":"I am getting the (very occasional) email error notice from the ```settings.php``` script:\r\n\r\n```\r\nERR03: Data too long for column 'text' at row 1\r\n```\r\n\r\nWhen I look up the entry I note the user is attempting to submit a notecard larger than the [64K limit imposed by MySql type TEXT](https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html#data-types-storage-reqs-strings). I have manually changed the MySql field type to ```MEDIUMTEXT``` on the server as an interim fix but feel something more is probably wanted in the long run.\r\n\r\nPerhaps there should be a ```max_notecard_size``` specified at the top of settings.php and an error notice posted in place of the notecard if it is exceeded, when they visit the link? Currently a user exceeding the limit just receives the \"Data was incomplete, please try again.\" message.\r\n\r\nSL has a limitation on notecard size so perhaps this should be the limit accepted by the script, giving a special error message if it is exceeded. \r\n\r\nOr, rerhaps it is enough just to change the field type to ```MEDIUMTEXT```?"},"comment":{"url":"https://api.github.com/repos/AVsitter/AVsitter/issues/comments/333079901","html_url":"https://github.com/AVsitter/AVsitter/issues/49#issuecomment-333079901","issue_url":"https://api.github.com/repos/AVsitter/AVsitter/issues/49","id":333079901,"user":{"login":"Sei-Lisa","id":1100142,"avatar_url":"https://avatars3.githubusercontent.com/u/1100142?v=4","gravatar_id":"","url":"https://api.github.com/users/Sei-Lisa","html_url":"https://github.com/Sei-Lisa","followers_url":"https://api.github.com/users/Sei-Lisa/followers","following_url":"https://api.github.com/users/Sei-Lisa/following{/other_user}","gists_url":"https://api.github.com/users/Sei-Lisa/gists{/gist_id}","starred_url":"https://api.github.com/users/Sei-Lisa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sei-Lisa/subscriptions","organizations_url":"https://api.github.com/users/Sei-Lisa/orgs","repos_url":"https://api.github.com/users/Sei-Lisa/repos","events_url":"https://api.github.com/users/Sei-Lisa/events{/privacy}","received_events_url":"https://api.github.com/users/Sei-Lisa/received_events","type":"User","site_admin":false},"created_at":"2017-09-29T09:34:08Z","updated_at":"2017-09-29T09:34:08Z","author_association":"MEMBER","body":"Does the 64K limit apply to OpenSim as well? I don't know, but if not, then it seems clear that we have to support both at the same time. A run-time parameter that only applies to OpenSim would work for this purpose, something like:\r\n\r\n```lsl\r\nstring url = \"https://avsitter.com/settings.php\"; // OSS::string url=\"https://avsitter.com/settings.php?opensim=1\"\r\n```\r\n\r\nand emit an error message in case the 64K limit is exceeded in SL.\r\n\r\nMy RL complicated a lot more during this week than I anticipated, but I'll try to submit a PR for this today."}}
{"actor":{"display_login":"Sei-Lisa"}}