{"action":"created","issue":{"url":"https://api.github.com/repos/abantecart/abantecart-src/issues/506","repository_url":"https://api.github.com/repos/abantecart/abantecart-src","labels_url":"https://api.github.com/repos/abantecart/abantecart-src/issues/506/labels{/name}","comments_url":"https://api.github.com/repos/abantecart/abantecart-src/issues/506/comments","events_url":"https://api.github.com/repos/abantecart/abantecart-src/issues/506/events","html_url":"https://github.com/abantecart/abantecart-src/issues/506","id":145608406,"number":506,"title":"can not enable Encryption ","user":{"login":"BasaraABC","id":2631910,"avatar_url":"https://avatars.githubusercontent.com/u/2631910?v=3","gravatar_id":"","url":"https://api.github.com/users/BasaraABC","html_url":"https://github.com/BasaraABC","followers_url":"https://api.github.com/users/BasaraABC/followers","following_url":"https://api.github.com/users/BasaraABC/following{/other_user}","gists_url":"https://api.github.com/users/BasaraABC/gists{/gist_id}","starred_url":"https://api.github.com/users/BasaraABC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BasaraABC/subscriptions","organizations_url":"https://api.github.com/users/BasaraABC/orgs","repos_url":"https://api.github.com/users/BasaraABC/repos","events_url":"https://api.github.com/users/BasaraABC/events{/privacy}","received_events_url":"https://api.github.com/users/BasaraABC/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/abantecart/abantecart-src/labels/in%20core","name":"in core","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"abolabo","id":1264239,"avatar_url":"https://avatars.githubusercontent.com/u/1264239?v=3","gravatar_id":"","url":"https://api.github.com/users/abolabo","html_url":"https://github.com/abolabo","followers_url":"https://api.github.com/users/abolabo/followers","following_url":"https://api.github.com/users/abolabo/following{/other_user}","gists_url":"https://api.github.com/users/abolabo/gists{/gist_id}","starred_url":"https://api.github.com/users/abolabo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abolabo/subscriptions","organizations_url":"https://api.github.com/users/abolabo/orgs","repos_url":"https://api.github.com/users/abolabo/repos","events_url":"https://api.github.com/users/abolabo/events{/privacy}","received_events_url":"https://api.github.com/users/abolabo/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/abantecart/abantecart-src/milestones/10","html_url":"https://github.com/abantecart/abantecart-src/milestones/1.2.7","labels_url":"https://api.github.com/repos/abantecart/abantecart-src/milestones/10/labels","id":1651214,"number":10,"title":"1.2.7","description":"","creator":{"login":"BasaraABC","id":2631910,"avatar_url":"https://avatars.githubusercontent.com/u/2631910?v=3","gravatar_id":"","url":"https://api.github.com/users/BasaraABC","html_url":"https://github.com/BasaraABC","followers_url":"https://api.github.com/users/BasaraABC/followers","following_url":"https://api.github.com/users/BasaraABC/following{/other_user}","gists_url":"https://api.github.com/users/BasaraABC/gists{/gist_id}","starred_url":"https://api.github.com/users/BasaraABC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BasaraABC/subscriptions","organizations_url":"https://api.github.com/users/BasaraABC/orgs","repos_url":"https://api.github.com/users/BasaraABC/repos","events_url":"https://api.github.com/users/BasaraABC/events{/privacy}","received_events_url":"https://api.github.com/users/BasaraABC/received_events","type":"User","site_admin":false},"open_issues":8,"closed_issues":7,"state":"open","created_at":"2016-03-17T14:56:38Z","updated_at":"2016-04-06T12:21:14Z","due_on":"2016-04-22T17:00:00Z","closed_at":null},"comments":4,"created_at":"2016-04-04T07:35:03Z","updated_at":"2016-04-06T12:21:14Z","closed_at":null,"body":"Can not enable encryption on dev server and localserver. Once this line added to config.php\r\n`define('DATA_ENCRYPTION_ENABLED', true);` - cart stop work and the following errors in the log\r\n\r\n- `LEFT\r\n JOIN dsabc_customer_groups cg ON (c.customer_group_id = cg.customer_group_id) WHERE DATE(c.date_added) = DATE('2016-04-04') AND c.store_id = 0 in <b>/abc127_m04d04/core/database/amysqli.php</b> on line <b>106</b>\r\n, c.key_id FROM dsabc_customers_enc c\r\ncg.name AS customer_group\r\nCONCAT(c.firstname, ' ', c.lastname) AS name,\r\nc.customer_group_id,\r\nc.approved,\r\nc.status,\r\nc.sms,\r\nc.email,\r\nc.loginname,\r\nc.lastname,\r\nc.firstname,\r\n16-04-04 4:26:10 - database error: AbanteCart core v.1.2.7 Error: <br />SELECT c.customer_id,\r\nc.firstname,\r\nc.lastname,\r\nc.loginname,\r\nc.email,\r\nc.sms,\r\nc.status,\r\nc.approved,\r\nc.customer_group_id,\r\nCONCAT(c.firstname, ' ', c.lastname) AS name,\r\ncg.name AS customer_group\r\n, c.key_id FROM dsabc_customers_enc c\r\nLEFT JOIN dsabc_customer_groups cg ON (c.customer_group_id = cg.customer_group_id) WHERE DATE(c.date_added) = DATE('2016-04-04') AND c.store_id = 0 in <b>/abc127_m04d04/core/database/amysqli.php</b> on line <b>106</b>`"},"comment":{"url":"https://api.github.com/repos/abantecart/abantecart-src/issues/comments/206345675","html_url":"https://github.com/abantecart/abantecart-src/issues/506#issuecomment-206345675","issue_url":"https://api.github.com/repos/abantecart/abantecart-src/issues/506","id":206345675,"user":{"login":"BasaraABC","id":2631910,"avatar_url":"https://avatars.githubusercontent.com/u/2631910?v=3","gravatar_id":"","url":"https://api.github.com/users/BasaraABC","html_url":"https://github.com/BasaraABC","followers_url":"https://api.github.com/users/BasaraABC/followers","following_url":"https://api.github.com/users/BasaraABC/following{/other_user}","gists_url":"https://api.github.com/users/BasaraABC/gists{/gist_id}","starred_url":"https://api.github.com/users/BasaraABC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BasaraABC/subscriptions","organizations_url":"https://api.github.com/users/BasaraABC/orgs","repos_url":"https://api.github.com/users/BasaraABC/repos","events_url":"https://api.github.com/users/BasaraABC/events{/privacy}","received_events_url":"https://api.github.com/users/BasaraABC/received_events","type":"User","site_admin":false},"created_at":"2016-04-06T12:21:13Z","updated_at":"2016-04-06T12:21:13Z","body":"Issue reopened. Tried one more time on fresh install. Extension Installed and Enabled (Status ON) next after your add `define('DATA_ENCRYPTION_ENABLED', true);` to the config file the store is broken"}}