FrontAccounting forum — FA2.4.2 error getting exchange rate from Google

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Sun, 17 Dec 2017 06:51:27 +0000

At the moment the extremes seem to be Kuwaiti Dinar (KWD) to the Iranian Rial (IRR) if that works they all will. Not sure if your need extra decimal places

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (apmuthu) — Sun, 17 Dec 2017 04:53:33 +0000

Bloomberg seems to provide USD based rates only. Will check on Google decimal digits since inverted value is available for reverse rates.

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Sat, 16 Dec 2017 20:54:50 +0000

I've also found a problem with bloomberg

Directly accessing:-

https://www.bloomberg.com/quote/GBPCOP:CUR

gives:-

The search for GBPCOP:CUR produced no matches. Try the symbol search.

and

https://www.bloomberg.com/quote/CADCOP:CUR

The search for CADCOP:CUR produced no matches. Try the symbol search.

???????

Whilst:

https://www.bloomberg.com/quote/USDCOP:CUR

gives the exchange rate.

So... does anyone else get the same results as me for the above url's?

If you are then Bloomberg does not give full currency exchange rates, if not there is probably regional restrictions.

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Sat, 16 Dec 2017 20:17:03 +0000

For google only:-

File: \gl\includes\db\gl_db_rates.inc

219:         if (empty($val) || $val+0 <= 0.00001) {

changed to

219:         if (empty($val) || $val+0 <= 0.1) {

works for all currencies tested before

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (apmuthu) — Sat, 16 Dec 2017 18:46:01 +0000

document.write is used only in lines 1438 and 1439 in includes/ui/ui_view.inc.
This affects the js_cache which you may choose to purge from the company folder.

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Sat, 16 Dec 2017 17:54:52 +0000

?????

I created a non ssl directory, still getting same results.

Not sure if relevant; but in network, I'm getting this error in firefox:-

An unbalanced tree was written using document.write() causing data from the network to be reparsed. For more information https://developer.mozilla.org/en/Optimizing_Your_Pages_for_Speculative_Parsing
exchange_rates.php:6

Nothing similar in chrome

~~in ie 10:-~~

DOM7011: The code on this page disabled back and forward caching. For more information, see: http://go.microsoft.com/fwlink/?LinkID=291337
File: exchange_rates.php
HTML1300: Navigation occurred.
File: exchange_rates.php
HTML1524: Invalid HTML5 DOCTYPE. Consider using the interoperable form "".
File: exchange_rates.php, Line: 1, Column: 1
HTML1512: Unmatched end tag.
File: exchange_rates.php, Line: 6, Column: 541
HTML1514: Extra "" tag found. Only one "" tag should exist per document.
File: exchange_rates.php, Line: 7, Column: 1
HTML1423: Malformed start tag. Attributes should be separated by whitespace.
File: exchange_rates.php, Line: 19, Column: 299
HTML1409: Invalid attribute name character. Attribute names should not contain ("),('),(<), or (=).
File: exchange_rates.php, Line: 19, Column: 299

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (apmuthu) — Sat, 16 Dec 2017 02:45:24 +0000

Then Google must be playing random tricks for your IP range....
Their search results have become very diluted in the last 6 months or so.
Time for a brand new human vetted one sans corporate control.
I will revert when I ave a new test OpenVZ install ready.
You can PM me a temporary PPTP VPN for your ISP for me to test.

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Fri, 15 Dec 2017 18:34:54 +0000

Open ssl would affect all exchange rates? Its working for some, but not for others?

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (apmuthu) — Fri, 15 Dec 2017 16:58:23 +0000

OpenSSL issue?

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Fri, 15 Dec 2017 16:57:05 +0000

So, if your installations are functioning, it would seem I have additional setup issues with my servers, any ideas on fault finding?

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Thu, 14 Dec 2017 19:07:09 +0000

Done that, php info is giving the following:-

Directive Local Value Master Value
allow_url_fopen On On
allow_url_include Off Off

so fopen is enabled

fopen faults now do not appear

But I'm am still getting the same results

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (apmuthu) — Thu, 14 Dec 2017 17:32:50 +0000

Looks like you have a php.ini issue as well.

Set in php.ini: allow_url_fopen=1 and restart your webserver.
It works well in PHP 5.3.1, 5.3.3 and 5.5.

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Thu, 14 Dec 2017 14:46:21 +0000

For v7.1.12

I'm getting these faults for CAD & GBP using Bloomberg and the exchange rate is blank:- (Obviously the currency code changes accordingly in the fault)

file_get_contents(): https:// wrapper is disabled in the server configuration by allow_url_fopen=0 in file: /gl/includes/db/gl_db_rates.inc at line 161
file_get_contents(https://www.bloomberg.com/quote/CADCOP:CUR): failed to open stream: no suitable wrapper could be found in file: /gl/includes/db/gl_db_rates.inc at line 161
number_format() expects parameter 2 to be integer, float given in file: /includes/current_user.inc at line 319

For CLP, euro, MXN, PEN & USD using Bloomberg these faults, but the correct exchange rate:-(Obviously the currency code changes accordingly in the fault)

file_get_contents(): https:// wrapper is disabled in the server configuration by allow_url_fopen=0 in file: /gl/includes/db/gl_db_rates.inc at line 161
file_get_contents(https://www.bloomberg.com/quote/CLPCOP:CUR): failed to open stream: no suitable wrapper could be found in file: /gl/includes/db/gl_db_rates.inc at line 161

Google gives the same results, under 1000 working fine, over gives weird rates as above

I only have access to change PHP versions to:

v5.6.32
v7.0.26
v7.1.12

Although I can go backwards, but don't think thats applicable - unless you tell me otherwise?

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (poncho1234) — Thu, 14 Dec 2017 12:56:35 +0000

Only v5.6.32,

I'll test some other versions as well..

Re: FA2.4.2 error getting exchange rate from Google

null@example.com (apmuthu) — Thu, 14 Dec 2017 04:16:31 +0000

What versions of PHP did you check earlier?