Error to update Currencies

[yoksito]

Hello Oscommerce comunity

 

i have few problems since i migrated of server and website name from: .pe to .net.

and i hope can help me.

 

1. cant update currencies.

error, when i click to: update currencies.
 

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=PEN&format=CSV&dest=Get+Table&sel_list=PEN): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 14

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 18

Warning: file(http://www.xe.net/ucc/convert.cgi?Amount=1&From=PEN&To=PEN): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 28

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 32

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=MXN&format=CSV&dest=Get+Table&sel_list=PEN): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 14

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 18

Warning: file(http://www.xe.net/ucc/convert.cgi?Amount=1&From=PEN&To=MXN): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 28

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 32

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=CLP&format=CSV&dest=Get+Table&sel_list=PEN): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 14

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 18

Warning: file(http://www.xe.net/ucc/convert.cgi?Amount=1&From=PEN&To=CLP): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 28

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 32

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=USD&format=CSV&dest=Get+Table&sel_list=PEN): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 14

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 18

Warning: file(http://www.xe.net/ucc/convert.cgi?Amount=1&From=PEN&To=USD): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 28

Warning: implode(): Invalid arguments passed in /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php on line 32

Warning: Cannot modify header information - headers already sent by (output started at /home3/y8m8a0o0/public_html/yoku/includes/functions/localization.php:14) in /home3/y8m8a0o0/public_html/yoku/includes/functions/general.php on line 38

2. Google XML Sitemap admin

when i click to: Create/Update your XML Sitemap now
got an error(deprecaed) message:
 

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home3/y8m8a0o0/public_html/googlesitemap/sitemap.class.php on line 83
Write /home3/y8m8a0o0/public_html/sitemapproducts.xml

Generated Google Product Sitemap Successfully

Write /home3/y8m8a0o0/public_html/sitemapcategories.xml
Generated Google Category Sitemap Successfully

Write /home3/y8m8a0o0/public_html/sitemapindex.xml
Generated Google Sitemap Index Successfully

CONGRATULATIONS! All files generated successfully.

If you have not already submitted the sitemap index to Google click the link below.
Before you do I HIGHLY recommend that you view the XML files to make sure the data is correct.

http://www.google.com/webmasters/sitemaps/ping?sitemap=https%3A%2F%2Fwww.website.net%2Fsitemapindex.xml

For your convenience here is the CRON command for your site:
php /home3/y8m8a0o0/public_html/googlesitemap/index.php

Here is your sitemap index: https://www.website.net/sitemapindex.xml
Here is your product sitemap: https://www.website.net/sitemapproducts.xml
Here is your category sitemap: https://www.website.net/sitemapcategories.xml

thanks in advance

Yok

[yoksito]

Almost forgot:
working with: oscommerce 2.3.4 no BS

[♥raiwa]

Hello @@yoksito,

 

for 1:

http://www.oscommerce.com/forums/topic/410498-oanda-failure-in-localizationphp/

 

for 2:

search in your Google XML Sitemap file for:

mysql_connect

and replace by:

tep_db_connect

Probably you will need to update more database functions.

try to replace everywhere it says:

"mysql..."

by

"mysqli..."

 

however the first "mysql_connect" function requires one more parameter for the sqli_connect equivalent. That's why it's easier to use the oscommerce function "tep_db_connect".

 

It might be also better to replace all other native sql functions by  the correspondaent oscommerce "tep_db..." functions.

 

If you have more difficulties, please post in the support topic for the Google Sitemap add-on or post the file.

 

rgds

Rainer

[yoksito]

Thanks for the help raiwa.

 

1. i made all steps, and dont get the error, but... i have another problem, the currencies still wont update.

 

The exchange rate for U.S. Dollar (USD) was not updated via fixer.  Is this a valid currency code?

 

2. still testing

[♥raiwa]

Buenos días @@yoksito,

 

If it works for one currency, it should work for all.

Please check if the currency codes are clean without extra spaces, just the 3 letter code.

Then try several times to update, the server may fail if you try only once.

 

Otherwise please post in the referenced topic and try to get help from the author of the update (burt).

 

Un saludo

Rainer

[zahir2619]

hi every one:

 

I just replace in functions/localization.php

$page = file('https://www.xe.net/ucc/convert.cgi?Amount=1&From=' . $from . '&To=' . $to);    to

$page = file('http://www.xe.com/currencyconverter/convert/?Amount=1&From=' . $from . '&To=' . $to);

 

and at application_top.php made change as

//   define('CURRENCY_SERVER_PRIMARY', 'oanda');                      comment out this line.
   define('CURRENCY_SERVER_PRIMARY', 'xe');                              change to primary.

 

worked perfect for me. Now the currency updates without a problm.

The exchange rate for U.S. Dollar (USD) was updated successfully via xe.

The exchange rate for Euro (EUR) was updated successfully via xe.

The exchange rate for Pounds Sterling (GBP) was updated successfully via xe.