1. steve@defeye.co.uk
  2. RO CSVI
  3. Thursday, 29 January 2015
  4.  Subscribe via email
Hi,

I have been trying to create a cron job on daily.co.uk but they don't have the same options as per your instructions. Apologies as I have not set cron jobs up before. Attached is the screenshot of the cron job input boxes. The one at the bottom says "URL" and does not allow me to input spaces. I'm assuming the way this is set up is slightly different then other web hosting providers. Other things I have tried are

putting in the url:
administrator/components/com_csvi/helpers/cron.php?username=xxx&passwd=xxx&template_id=22

making a php file which calls the command produced by the "cron command" button in CSVI. php file looks like this:
<?php
include 'http://www.xxx.co.uk/xxx/administrator/components/com_csvi/helpers/cron.php?username=xxx&passwd=xxx&template_name=xxx';
?>

Other things to note are that the template I'm trying to run connects via ftp to a site to access a txt file. I assumed the cron.php file would also do this? Any help would be very much appreciated.
Accepted Answer Pending Moderation
Hello,

The one at the bottom says "URL" and does not allow me to input spaces. I'm assuming the way this is set up is slightly different then other web hosting providers.
Your cron job system is not a real cron job. Knowing that you will need to keep in mind that your import is most likely limited by the maximum exeuction time.

putting in the url:
administrator/components/com_csvi/helpers/cron.php?username=xxx&passwd=xxx&template_id=22
That is correct but you need to add your domain name as well of course.

Other things to note are that the template I'm trying to run connects via ftp to a site to access a txt file. I assumed the cron.php file would also do this?
Yeah, that will all be done by the template.

So what happens when your run the cron job? Since you are using a URL you can test it simply by putting the URL into your browser.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
When I put the url in my web browser I get a blank/empty html page.

http://www.xxx.co.uk/administrator/components/com_csvi/helpers/cron.php?username=xxx&passwd=xxx&template_name=xxx

Not sure where to go from there?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
The user account used needs to have backend access, make sure that works. A blank page is usually an internal server error. You can start by setting the error reporting to Maximum in Joomla to see if you can see the error. Otherwise you will have to ask your hosting provider for what is in the server error log. Once you know the error, it makes it easier to know where to look.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Of-course. Did not remember you can turn error logging on. Doh!

Here's what it says:
Warning: require_once(/mnt/vol4/home/d/e/xxx/public_html/folder/libraries/joomla/environment/request.php): failed to open stream: No such file or directory in /mnt/vol4/home/d/e/xxx/public_html/folder/administrator/components/com_csvi/helpers/cron.php on line 37 Fatal error: require_once(): Failed opening required '/mnt/vol4/home/d/e/xxx/public_html/folder/libraries/joomla/environment/request.php' (include_path='.:/usr/share/pear:/usr/share/php') in /mnt/vol4/home/d/e/xxx/public_html/folder/administrator/components/com_csvi/helpers/cron.php on line 37

I've had a look and sure enough 'request.php' is not in this folder. The files in this folder are:
browser.php
index.html
response.php

I am running Joomla 3.2.7. Is this file meant to be there? I'm assuming the rest of the errors are because this file is not there?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
That file should only be loaded if you are running a Joomla version lower than 3.0. Somehow the JVERSION being reported is lower than 3.0. Let's start why you are not running Joomla 3.3.6? That would be the first thing to do, bring Joomla up-to-date.

I'm assuming the rest of the errors are because this file is not there?
Correct.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
My web hosting provider is not running PHP 5.3.10 and so cannot upgrade Joomla to 3.3.x
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
My web hosting provider in not using PHP 5.3.10 or later and so I cannot upgrade Joomla past version 3.2.7
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hey Steve,

I am not surprised with a host that doesn't offer a real cron uses a PHP version that is no longer supported. This raises some serious concern over when and if the cronjob gets to work if you can import your file.

How long does a manual import take? The whole import proces using the URL will have to be completed within 30 seconds. Is that going to work with your import list?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hi Roland,

I beginning to regret going with this hosting provider. But thankfully, upon a helpdesk ticket request, they have moved my hosting to a more up-to-date server and I'm now on PHP 5.4. I have now updated Joomla to the latest 3.3.6

Now the error has changed slightly when I use the URL for the cronjob (attached).

When I run the import from the process button in the backend of Joomla it takes 24 seconds (other attachment).
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,

Glad to hear they gave you a better server. Now something else I noticed in the error you posted, it says the error is on line 37, however if I look at the cron file that should be line 39. Which version of CSVI Pro are you running?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hi, just checked the version which says it is up-to-date, but is version 5.16 (screenshot attached), but looking on your site the latest is 5.20.

As it thinks it is the latest version I there is no "update" button available. Shall I do a manual update? Not sure how to do this?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,

You might be missing the credentials, anyway, you can download version 5.20 from the website and install it using the Joomla Extension manager. No need to uninstall, you can just install the new version on top of it.

Let me know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Thanks for all your help so far. I did put in my subscription code but it still didn't register for the newest version. Manual update worked fine.

After updating to the latest CSVI the url is now working from within the browser giving me this message:

Processing started: 2nd February 2015, 12:48 pm Template name: xxx Results for xxx.txt ================================== Total Result Status 134 Success Updated Processing finished: 2nd February 2015, 12:48 pm Process ran for 11 seconds User has been logged out

Only problem now is adding it as a cronjob to my hosting 'daily.co.uk'. When I put in this url it returns with this error:

We found the file for your cron job but it did not return an 'OK' response, it returned code '500'

I'm assuming this is a problem with the maximum time it is allowed to run for? If so I'll ask my hosting provider.
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
I think the problem is not the import but rather that CSVI doesn't return any specific status and the server complains abou that. You can check the Logs in CSVI to see if your cron import processed all records or not.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hi, I've checked the database and it did import all the records. Only issue now is adding it to daily.co.uk. I'll see what they say.

Thanks for all the help.
  1. more than a month ago
  2. RO CSVI
  3. # 15
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!