Currency Update (Automatic)

[globalmemory]

Hello,

I am with Justhost and i can't seem to get this working properly? The cron command used is usr/bin/php followed by the location of the file. When i do a manual update the currencies update but then they stay the same and do not automatically update according to the schedule? I have executed the file through the web browser and it just comes up with a blank page and a message at the bottom saying 'done'. Is this normal? Also the cron logs show that the file is being executed at the times specified but the log contains no information about any errors? Has anybody got an idea of what's going wrong?

[timdwyer42]

THis doesn't seem to work for me either. THis is just the error message from visiting the link with my web browser


Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 65

Warning: file(http://www.xe.net/ucc/convert.cgi?Am...rom=EUR&To=USD) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 65

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 67

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 54

Warning: file(http://www.oanda.com/convert/fxdaily...e&sel_list=EUR) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 54

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 56

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 65

Warning: file(http://www.xe.net/ucc/convert.cgi?Am...rom=EUR&To=GBP) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 65

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 67

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 54

Warning: file(http://www.oanda.com/convert/fxdaily...e&sel_list=EUR) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 54

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 56

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 65

Warning: file(http://www.xe.net/ucc/convert.cgi?Am...rom=EUR&To=CAD) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 65

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 67

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 54

Warning: file(http://www.oanda.com/convert/fxdaily...e&sel_list=EUR) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 54

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 56

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 65

Warning: file(http://www.xe.net/ucc/convert.cgi?Am...rom=EUR&To=AUD) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 65

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 67

Warning: file() [function.file]: URL file-access is disabled in the server configuration in /home/lowprice/public_html/currency_update.php on line 54

Warning: file(http://www.oanda.com/convert/fxdaily...e&sel_list=EUR) [function.file]: failed to open stream: no suitable wrapper could be found in /home/lowprice/public_html/currency_update.php on line 54

Warning: implode() [function.implode]: Invalid arguments passed in /home/lowprice/public_html/currency_update.php on line 56

[charals]

Can anyone help me

My cron job looks like (got this from my hosting provider): /ramdisk/bin/php5 -q/home7/xaralamb/public_html/currency_update_curled.php

Then my currency_update_curled.php looks like:

// This describes the path from the location where you install this file to the root directory of your Zen Cart
// and is normally the only line that you will need to edit
$location = '/home7/xaralamb/public_html/'; // location of zen-cart install

// Define currency servers
define('CURRENCY_SERVER_PRIMARY', 'xe');
define('CURRENCY_SERVER_BACKUP', 'oanda');

// Get Zen Cart configuration data
require_once($location.'includes/configure.php');
require_once($location.'includes/database_tables.php');

AND now I get this error:

Cannot bind/listen socket - [2] No such file or directory.
Couldn't create FastCGI listen socket on port /public_html/currency_update_curled.php

[charals]

I am having path problems, my currency_update.php is in the same directory as config.php all in the includes directory and I get this error mail message.
<br />
<b>Warning</b>: require_once(./includes/configure.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/home7/xaralamb/public_html/includes/currency_update.php</b> on line <b>21</b><br />
<br />
<b>Fatal error</b>: require_once() [<a href='function.require'>function.require</a>]: Failed opening required './includes/configure.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in <b>/home7/xaralamb/public_html/includes/currency_update.php</b> on line <b>21</b><br />

[charals]

Once the cron is running properly are the emails supposed to stop coming through? Before I was getting lots of error messages but now they have gone away entirely no emails at all... I can't tell if i have succeeded in finding the correct paths or if I have wrecked something alltogether.... this stuff is so fun sometimes!! Anyone have any insigt as to what to expect or how to check if all is well?

[kuroi]

Your origonal problem appears to be that you gave the mod the path from the root of your server to the update file, rather than that from the file to the root of your Zen Cart. If you've stopped getting warning messages from your server, then that suggests that either the CRON job has been disabled, or the file is now being found.

Testing something that should happen silently in the background can be a little challenging, but simply checking the values of your currencies in the Admin ? Localization menu just before and just after it runs is usually enough. It's rare that exactly the same values come back, especially if you have several currencies enabled.

[charals]

This is what I am getting now, I am not sure what the path in the currency_update.php is supposed to look like, I've tried everything but I must have something backwards.

How do i write the path from the currency_update.php file to the root of the zencart ?

I have even tried to put the currency_update.php in the includes directory with no luck. I do have the cron working , that's one good step.


<br />
<b>Warning</b>: require_once(includes/configure.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/home7/xaralamb/public_html/includes/currency_update.php</b> on line <b>20</b><br />
<br />
<b>Fatal error</b>: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/configure.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in <b>/home7/xaralamb/public_html/includes/currency_update.php</b> on line <b>20</b><br />

[kuroi]

Ah. I think I see the problem. The mod is designed to allow cron jobs to be run from outside the web space on your server. So it's looking for a path from the currency script down to the config file and then down to the database_tables file.

To locate the file where you have it, you could try changing these lines

// Get Zen Cart configuration data
require_once(PATH_TO_STORE_ROOT . 'includes/configure.php');
require_once(PATH_TO_STORE_ROOT . 'includes/database_tables.php');

to this

// Get Zen Cart configuration data
require_once('configure.php');
require_once('database_tables.php');

[charals]

Your origonal problem appears to be that you gave the mod the path from the root of your server to the update file, rather than that from the file to the root of your Zen Cart. If you've stopped getting warning messages from your server, then that suggests that either the CRON job has been disabled, or the file is now being found.

Testing something that should happen silently in the background can be a little challenging, but simply checking the values of your currencies in the Admin ? Localization menu just before and just after it runs is usually enough. It's rare that exactly the same values come back, especially if you have several currencies enabled.

Thanks for the assistance, you are very helpful. I will try this.
Also what email response would i get if all is working well as I read there is no indication and I also read you do get an email message for successful crons?

I used info from post#127 - do you agree with that information as well?

Thanks from Charals in Canada!

[kuroi]

There is no email confirmation built into the mod. Maybe your web host has something built into their CRON installation, but you'd have to ask them about that.

Post #127 looks broadly OK to me, but I haven't used that version of the mod or checked the post in detail.