Categories
View Replies (26)

Resolved Cron job jform

  1. kingnature
    kingnature
  2. RO CSVI
  3. Friday, 15 January 2016
  4.  Subscribe via email
Hi there

We upgraded from CSVI 5.2.1 to CSVI 6.4.3. We created a new template and everything is working except the jform command from the cronjob to have a certain range of date in the export file. We have changed the cronjob accordingly to your website.

Old cronjob (which worked for years):

/usr/local/bin/php /home/xxx/www/xxx/administrator/components/com_csvi/helper/cron.php username="USER" passwd="PW" template_id="1" jform:order:orderdatestart=$(date -v-5d +"\%d-\%m-\%Y";) >/dev/null 2>&1

New cron job:

/usr/local/bin/php /home/xxx/www/xxx/administrator/components/com_csvi/helper/cron.php username="USER" passwd="PW" --key="winter" --template_id="1" jform:order:orderdatestart=$(date -v-5d +"\%d-\%m-\%Y";) >/dev/null 2>&1

The new cron job generate the file but with all orders from the whole database. It looks as the jform command is not working anymore with CSVI 6. Can you give us a hint?
0
Responses (26)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

There is a mistake in the prefix replace, emetal1__virtuemart_orders that should be emetal1_virtuemart_orders. If there is an error, you wouldn't get any orders :)
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. # 21
kingnature
kingnature
Accepted Answer Pending Moderation
Ups, my mistake. I have corrected it.
Now all orders from 14-01-2016 till 25-01-2016 appear.
  1. more than a month ago
  2. RO CSVI
  3. # 22
rolandd
rolandd
Accepted Answer Pending Moderation
Ok, frankly, this makes no sense to me :) CSVI is executing the same query and the export file has all orders. I am out of ideas as to why it would export all orders running the job but only the limited ones when the query is executed via PhpMyAdmin.

As I cannot reproduce it here either, troubleshooting is difficult. If you can provide me access details I can take a look at the system myself and see if I can determine what is happening. You can send them in a private message.
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. # 23
kingnature
kingnature
Accepted Answer Pending Moderation
I will send you access details. Which access do you need?
  1. more than a month ago
  2. RO CSVI
  3. # 24
rolandd
rolandd
Accepted Answer Pending Moderation
Joomla, FTP and a way to trigger the cron job command. I can understand if SSH access can't be provided, but perhaps access to cPanel to trigger the cron job.
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. # 25
kingnature
kingnature
Accepted Answer Pending Moderation
Well done. We have updated to Joomla 3.4.8. and updated also CSVI to 6.5. Now the cron job is running as it should. Thanks for your engagement!
  1. more than a month ago
  2. RO CSVI
  3. # 26
  • Page :
  • 1
  • 2


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