{"action":"created","issue":{"url":"https://api.github.com/repos/wlox/wlox/issues/74","repository_url":"https://api.github.com/repos/wlox/wlox","labels_url":"https://api.github.com/repos/wlox/wlox/issues/74/labels{/name}","comments_url":"https://api.github.com/repos/wlox/wlox/issues/74/comments","events_url":"https://api.github.com/repos/wlox/wlox/issues/74/events","html_url":"https://github.com/wlox/wlox/issues/74","id":156880806,"number":74,"title":"Crontab DB errors","user":{"login":"domgolonka","id":1701220,"avatar_url":"https://avatars.githubusercontent.com/u/1701220?v=3","gravatar_id":"","url":"https://api.github.com/users/domgolonka","html_url":"https://github.com/domgolonka","followers_url":"https://api.github.com/users/domgolonka/followers","following_url":"https://api.github.com/users/domgolonka/following{/other_user}","gists_url":"https://api.github.com/users/domgolonka/gists{/gist_id}","starred_url":"https://api.github.com/users/domgolonka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/domgolonka/subscriptions","organizations_url":"https://api.github.com/users/domgolonka/orgs","repos_url":"https://api.github.com/users/domgolonka/repos","events_url":"https://api.github.com/users/domgolonka/events{/privacy}","received_events_url":"https://api.github.com/users/domgolonka/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-26T00:45:22Z","updated_at":"2016-06-03T01:33:37Z","closed_at":null,"body":"I am using your updated mbassan/wlox version. I am getting some crontab errors:\r\n\r\n\r\n/cron/get_stats.php \r\n`Beginning Get Status processing...\r\nPHP Fatal error:  Can't execute query<pre>UPDATE currencies SET usd_bid = (CASE currency  WHEN \"AUD\" THEN 0.7188  WHEN \"BGN\" THEN 0.5671  WHEN \"CAD\" THEN 0.7672  WHEN \"CNY\" THEN 0.1526  WHEN \"CZK\" THEN 0.0413  WHEN \"DKK\" THEN 0.1500  WHEN \"EUR\" THEN 1.1155  WHEN \"GBP\" THEN 1.4696  WHEN \"HKD\" THEN 0.1288  WHEN \"HRK\" THEN 0.1480  WHEN \"ILS\" THEN 0.2600  WHEN \"INR\" THEN 0.0149  WHEN \"JPY\" THEN 0.0091  WHEN \"LTC\" THEN N/A  WHEN \"MUR\" THEN 0.0282  WHEN \"MXN\" THEN 0.0541  WHEN \"NOK\" THEN 0.1201  WHEN \"NZD\" THEN 0.6708  WHEN \"PLN\" THEN 0.2531  WHEN \"RON\" THEN 0.2476  WHEN \"RUB\" THEN 0.0153  WHEN \"SEK\" THEN 0.1205  WHEN \"SGD\" THEN 0.7259  WHEN \"THB\" THEN 0.0280  WHEN \"TRY\" THEN 0.3402  WHEN \"ZAR\" THEN 0.0638  END), usd_ask = (CASE currency  WHEN \"AUD\" THEN 0.7190  WHEN \"BGN\" THEN 0.5736  WHEN \"CAD\" THEN 0.7673  WHEN \"CNY\" THEN 0.1526  WHEN \"CZK\" THEN 0.0413  WHEN \"DKK\" THEN 0.1501  WHEN \"EUR\" THEN 1.1158  WHEN \"GBP\" THEN 1.4698  WHEN \"HKD\" THEN 0.1288  WHEN \"HRK\" THEN 0.1497  WHEN \"ILS\" THEN 0.2602  WHEN \"INR\" THEN 0.0149  WHEN \"JPY\"  in /var/www/bitcoiniacs/cron/lib/dblib.php on line 378\r\n`\r\n\r\nand process.php\r\n`./process_bitcoin.sh \r\nBeginning Receive Bitcoin processing...\r\nPHP Notice:  Undefined property: object::$bitcoin_username in /var/www/bitcoiniacs/cron/receive_bitcoin.php on line 10\r\nPHP Notice:  Undefined property: object::$bitcoin_passphrase in /var/www/bitcoiniacs/cron/receive_bitcoin.php on line 10\r\nPHP Notice:  Undefined property: object::$bitcoin_host in /var/www/bitcoiniacs/cron/receive_bitcoin.php on line 10\r\nPHP Notice:  Undefined property: object::$bitcoin_port in /var/www/bitcoiniacs/cron/receive_bitcoin.php on line 10\r\nPHP Notice:  Undefined property: object::$bitcoin_protocol in /var/www/bitcoiniacs/cron/receive_bitcoin.php on line 10\r\nPHP Notice:  Undefined property: object::$bitcoin_warm_wallet_address in /var/www/bitcoiniacs/cron/receive_bitcoin.php on line 164\r\nPHP Fatal error:  Can't execute query<pre>SELECT (hot_wallet_btc - (total_btc * 0.01) - pending_withdrawals - 0.0001) AS surplus FROM status WHERE id = 1</pre>MySQL Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hot_wallet_btc' in 'field list'Debug: Array\r\n(\r\n    [0] => Array\r\n        (\r\n            [file] => /var/www/bitcoiniacs/cron/lib/dblib.php\r\n            [line] => 108\r\n            [function] => db_log_error\r\n            [args] => Array\r\n                (\r\n                    [0] => PDOException Object\r\n                        (\r\n                            [message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hot_wallet_btc' in 'field list'\r\n                            [string:Exception:private] => \r\n                            [code:protected] => 42S22\r\n                            [file:protected] => /var/www/bitcoiniacs/cron/lib/dblib.php\r\n                            [line:protected] => 72\r\n                            [trace:Exception:private] => Array\r\n                                (\r\n        in /var/www/bitcoiniacs/cron/lib/dblib.php on line 378\r\nBeginning Send Bitcoin processing...\r\ndone\r\n`"},"comment":{"url":"https://api.github.com/repos/wlox/wlox/issues/comments/223469247","html_url":"https://github.com/wlox/wlox/issues/74#issuecomment-223469247","issue_url":"https://api.github.com/repos/wlox/wlox/issues/74","id":223469247,"user":{"login":"domgolonka","id":1701220,"avatar_url":"https://avatars.githubusercontent.com/u/1701220?v=3","gravatar_id":"","url":"https://api.github.com/users/domgolonka","html_url":"https://github.com/domgolonka","followers_url":"https://api.github.com/users/domgolonka/followers","following_url":"https://api.github.com/users/domgolonka/following{/other_user}","gists_url":"https://api.github.com/users/domgolonka/gists{/gist_id}","starred_url":"https://api.github.com/users/domgolonka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/domgolonka/subscriptions","organizations_url":"https://api.github.com/users/domgolonka/orgs","repos_url":"https://api.github.com/users/domgolonka/repos","events_url":"https://api.github.com/users/domgolonka/events{/privacy}","received_events_url":"https://api.github.com/users/domgolonka/received_events","type":"User","site_admin":false},"created_at":"2016-06-03T01:33:37Z","updated_at":"2016-06-03T01:33:37Z","body":"Figured why it is bugged, but I am still looking where to change it. The bug occurs because, in wlox/wlox, the database had bitcoin_accountname, bitcoin_passphrase, and bitcoin_username is in the app_configuration table, while in mbassan/wlox uses the 'wallet' table.\r\n\r\nAny suggestions on how to change so frontend reads"}}
{"actor":{"display_login":"domgolonka"}}