{"action":"created","issue":{"url":"https://api.github.com/repos/webyog/sqlyog-community/issues/2125","repository_url":"https://api.github.com/repos/webyog/sqlyog-community","labels_url":"https://api.github.com/repos/webyog/sqlyog-community/issues/2125/labels{/name}","comments_url":"https://api.github.com/repos/webyog/sqlyog-community/issues/2125/comments","events_url":"https://api.github.com/repos/webyog/sqlyog-community/issues/2125/events","html_url":"https://github.com/webyog/sqlyog-community/issues/2125","id":190957818,"number":2125,"title":"Error while updating joined table (wine)","user":{"login":"Infidel75","id":23653583,"avatar_url":"https://avatars.githubusercontent.com/u/23653583?v=3","gravatar_id":"","url":"https://api.github.com/users/Infidel75","html_url":"https://github.com/Infidel75","followers_url":"https://api.github.com/users/Infidel75/followers","following_url":"https://api.github.com/users/Infidel75/following{/other_user}","gists_url":"https://api.github.com/users/Infidel75/gists{/gist_id}","starred_url":"https://api.github.com/users/Infidel75/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Infidel75/subscriptions","organizations_url":"https://api.github.com/users/Infidel75/orgs","repos_url":"https://api.github.com/users/Infidel75/repos","events_url":"https://api.github.com/users/Infidel75/events{/privacy}","received_events_url":"https://api.github.com/users/Infidel75/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-11-22T10:14:47Z","updated_at":"2016-12-06T16:02:23Z","closed_at":null,"body":"I run this trivial query:\r\n\r\n`select R.ID, UV.ID, UV.VALUE from `VEP_COMMON`.`REGISTER` as R \r\nleft join `VEP_COMMON`.`FW_USER_VALUES` as UV on R.USER_ID=PID and UV.`KEY`='PROFILE_RIGHTS'\r\nwhere R.`RKEY` = 'cr/list/menubuttons/toolsapp'; ` \r\n\r\nResult is as expected: grid with some rows in it.\r\n\r\nThen I'd like to make some changes on joined table, so i switch dropdown menu from Read only to desired table to edit, exactly, in this case, \"`VEP_COMMON`.`FW_USER_VALUES`\"\r\n\r\nThen I enter a cell (using F2), change value. Stil working as expected. \r\n\r\nBut now, if I move to another row expecting saving changes, one of three possibilities occurs:\r\n1. (most often) SQLyog freezes and I can only kill its process. Or\r\n2. Mysql error dialog window is shown up with these texts:\r\n`Executed SQL statement`\r\n`update `VEP_COMMON`.`FW_USER_VALUES` set `VALUE` = 'TOOLS,' where `ID` = '1109'`\r\n`Error  1064`\r\n`Error message`\r\n`You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE FIELD='VALUE' AND (Extra LIKE '%VIRTUAL%' OR Extra LIKE '%STORED%' OR Extr' at line 1`. Or\r\n3. `SQLyog crashes` dialog window. (I am not sure with this text because it's hard to simulate).\r\n\r\nSo far it looks working (it saves values without problems) when using button \"Save changes\", but it's not too much comfortable.\r\n\r\n--------------\r\nOS: Linux mint 17.3\r\nSQLyog Community v.12.3.2 (64 bit)\r\nWine 1.6.2\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/webyog/sqlyog-community/issues/comments/265189222","html_url":"https://github.com/webyog/sqlyog-community/issues/2125#issuecomment-265189222","issue_url":"https://api.github.com/repos/webyog/sqlyog-community/issues/2125","id":265189222,"user":{"login":"peterwy","id":11457737,"avatar_url":"https://avatars.githubusercontent.com/u/11457737?v=3","gravatar_id":"","url":"https://api.github.com/users/peterwy","html_url":"https://github.com/peterwy","followers_url":"https://api.github.com/users/peterwy/followers","following_url":"https://api.github.com/users/peterwy/following{/other_user}","gists_url":"https://api.github.com/users/peterwy/gists{/gist_id}","starred_url":"https://api.github.com/users/peterwy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterwy/subscriptions","organizations_url":"https://api.github.com/users/peterwy/orgs","repos_url":"https://api.github.com/users/peterwy/repos","events_url":"https://api.github.com/users/peterwy/events{/privacy}","received_events_url":"https://api.github.com/users/peterwy/received_events","type":"User","site_admin":false},"created_at":"2016-12-06T16:02:22Z","updated_at":"2016-12-06T16:02:22Z","body":"http://faq.webyog.com/content/1/178/en/sqlyog-is-a-client-for-the-mysql-server-_-but-what-server-versions-are-supported.html\r\n\r\n\"If you for some reason need to stay with 4.1, we recommend 4.1.20 or higher.\"\r\n\r\nI don't think we will be able to get 4.1.15 from anywhere today.  It is around 15 years old. But we have 4.1.21  or 4.1.22 somewhere I think."}}
{"actor":{"display_login":"peterwy"}}