{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/444","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/444/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/444/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/444/events","html_url":"https://github.com/sysown/proxysql/issues/444","id":121072645,"number":444,"title":"Prepare Statements in mysqli for php fail","user":{"login":"tachu","id":183196,"avatar_url":"https://avatars.githubusercontent.com/u/183196?v=3","gravatar_id":"","url":"https://api.github.com/users/tachu","html_url":"https://github.com/tachu","followers_url":"https://api.github.com/users/tachu/followers","following_url":"https://api.github.com/users/tachu/following{/other_user}","gists_url":"https://api.github.com/users/tachu/gists{/gist_id}","starred_url":"https://api.github.com/users/tachu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tachu/subscriptions","organizations_url":"https://api.github.com/users/tachu/orgs","repos_url":"https://api.github.com/users/tachu/repos","events_url":"https://api.github.com/users/tachu/events{/privacy}","received_events_url":"https://api.github.com/users/tachu/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sysown/proxysql/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/sysown/proxysql/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/sysown/proxysql/labels/PROTOCOL","name":"PROTOCOL","color":"006b75"}],"state":"open","locked":false,"assignee":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-12-08T18:46:19Z","updated_at":"2015-12-09T05:52:48Z","closed_at":null,"body":"When ever I go over the proxy the prepare statements fail\r\n\r\n<?php\r\n$mysqli = new mysqli(\"127.0.0.1\", \"user\", \"pass\", \"mydb\");\r\nif ($mysqli->connect_errno) {\r\n    echo \"Failed to connect to MySQL: (\" . $mysqli->connect_errno . \") \" . $mysqli->connect_error;\r\n}\r\nif (!($stmt = $mysqli->prepare(\"SELECT t0.id AS id1, t0.product AS product2, t0.name AS name3, t0.environment AS environment4, t0.whitelist_users AS whitelist_users5, t0.blacklist_users AS blacklist_users6, t0.percentage AS percentage7, t0.start_date AS start_date8, t0.end_date AS end_date9, t0.min_version AS min_version10, t0.max_version AS max_version11, t0.install_date AS install_date12 FROM FeatureToggles t0 WHERE t0.product = ? AND t0.name = ? AND t0.environment = ? LIMIT 1\"))) {\r\n    echo \"Prepare failed: (\" . $mysqli->errno . \") \" . $mysqli->error;\r\n}\r\n\r\n\r\nPrepare failed: (1045) Command not supported[root@cfcg-fl1-1 ~]# \r\n"},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/163118102","html_url":"https://github.com/sysown/proxysql/issues/444#issuecomment-163118102","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/444","id":163118102,"user":{"login":"aismail","id":82345,"avatar_url":"https://avatars.githubusercontent.com/u/82345?v=3","gravatar_id":"","url":"https://api.github.com/users/aismail","html_url":"https://github.com/aismail","followers_url":"https://api.github.com/users/aismail/followers","following_url":"https://api.github.com/users/aismail/following{/other_user}","gists_url":"https://api.github.com/users/aismail/gists{/gist_id}","starred_url":"https://api.github.com/users/aismail/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aismail/subscriptions","organizations_url":"https://api.github.com/users/aismail/orgs","repos_url":"https://api.github.com/users/aismail/repos","events_url":"https://api.github.com/users/aismail/events{/privacy}","received_events_url":"https://api.github.com/users/aismail/received_events","type":"User","site_admin":false},"created_at":"2015-12-09T05:52:48Z","updated_at":"2015-12-09T05:52:48Z","body":"Which ORM?\n\n>\n\n-- \nAndrei Ismail\n\n*Software Engineer*\nhttp://ismail.strikingly.com\n"}}