Resolved Cron Job: key set doesn't match

Hello Teresa,

Template SD2000-OA
The key was given but this does not match the key set in the template

The error shows that your cron is not able to read the parameters passed through cron URL. If its a wrong key value then message would have been "The key XXXX was given but this does not match the key set in the template". Note XXXX is missing in your case so key value is empty though it is passed in URL. Can you check for the CLI PHP version on your server?. Could be an older PHP version so parameters are not read properly.

Hello Tharuna,

figured out the correct php and now the following error comes up:

/opt/php-7.0/bin/php /var/www/vhosts/http://sektkellerei.de/test.winzersekt.de/administrator/components/com_csvi/helper/cron.php --key="123456" --template_id="10"
Use --help to see the help information
Processing started...
Template SD2000-OA
Error displaying the error page: Could not find template "isis".: Call to a member function add() on nullroot@server4:~#

Kind regards,

Teresa

Hello Teresa,
Can you paste the full error please? There should be a line number shown in the error where the execution breaks. We would need that to trace the error.

Hello Tharuna,

that is the full error when I test on console.

Tried it with wget and following error:

wget: Unbekannte Option »--key=123456«
Syntax: wget [OPTION]... [URL]...

»wget --help« gibt weitere Informationen.

Kind regards,

Teresa

Hello Teresa,
A user trabica recently came up with same type of error and here is the link to the post. The actual error was something else and it was not getting in logs. Roland had posted him a patch file so we get to know the actual error. Can you try loading the same patch file Roland had posted and see if you see the actual error? Can you post it here?

Hello Tharuna,

installed the patch_cli_20161108 and here is the result via console:

root@server4:~# /opt/php-7.0/bin/php /var/www/vhosts/http://sektkellerei.de/test.winzersekt.de/administrator/components/com_csvi/helper/cron.php --key="123456" --template_id="10"
Use --help to see the help information
Processing started...
Template SD2000-OA
Unknown column 'ChampagneTAX' in 'field list' SQL=SELECT `#__virtuemart_orders`.`virtuemart_order_id`,
`grade`,
`address_1`,
`address_2`,
`address_type`,
`address_type_name`,
`agreed`,
`city`,
`company`,
`user_info1`.`virtuemart_country_id`,
`coupon_code`,
`coupon_discount`,
`#__virtuemart_orders`.`created_by`,
`#__virtuemart_orders`.`created_on`,
`customer_note`,
`customer_number`,
(`order_discount` / `order_total`) * 100 AS `discount_percentage`,
`user_info1`.`email`,
`fax`,
`first_name`,
`user_info1`.`first_name`,
`user_info1`.`middle_name`,
`user_info1`.`last_name`,
`invoice_number`,
`ip_address`,
`last_name`,
`#__virtuemart_orders`.`locked_by`,
`#__virtuemart_orders`.`locked_on`,
`middle_name`,
`#__virtuemart_orders`.`modified_by`,
`#__virtuemart_orders`.`modified_on`,
`order_billDiscountAmount`,
`order_billTax`,
`order_billTaxAmount`,
`order_create_invoice_pass`,
`order_currency`,
`order_discount`,
`order_discountAmount`,
`order_item_currency`,
`order_item_name`,
`order_item_sku`,
`order_language`,
`order_number`,
`order_pass`,
`order_payment`,
`order_payment_tax`,
`order_salesPrice`,
`order_shipment`,
`order_shipment_tax`,
`#__virtuemart_orders`.`order_status`,
`order_status_name`,
`order_subtotal`,
`order_tax`,
`order_total`,
`payment_currency_id`,
`payment_currency_rate`,
`#__virtuemart_orders`.`virtuemart_paymentmethod_id`,
`payment_name`,
`phone_1`,
`phone_2`,
`product_attribute`,
`product_basePriceWithTax`,
`product_discountedPriceWithoutTax`,
`product_final_price`,
`product_item_price`,
`product_priceWithoutTax`,
`product_item_price` * `product_quantity` AS `product_price_total`,
`product_quantity`,
`product_subtotal_discount`,
`product_subtotal_with_tax`,
`product_tax`,
`#__virtuemart_orders`.`virtuemart_shipmentmethod_id`,
`shipping_mail`,
`user_info1`.`virtuemart_state_id`,
`title`,
`tos`,
`#__virtuemart_orders`.`virtuemart_user_id`,
`#__virtuemart_orders`.`user_currency_id`,
`user_currency_id`,
`user_currency_rate`,
`virtuemart_order_item_id`,
`virtuemart_order_userinfo_id`,
`#__virtuemart_order_items`.`virtuemart_product_id`,
`virtuemart_state_id`,
`#__virtuemart_orders`.`virtuemart_vendor_id`,
`zip`,
`ChampagneTAX`,
`orderPaymentTax`,
`orderShipmentTax`,
`orderTaxValue`,
`productDiscountPercentage`,
`subSKU`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_de_de` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_de_de`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods_de_de` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods_de_de`.`virtuemart_shipmentmethod_id`
WHERE `#__virtuemart_orders`.`created_on` > '2016-11-14 12:25:01'
GROUP BY `virtuemart_order_item_id`
root@server4:~#

Kind regards,

Teresa

Hello Teresa,

Do you get this error also when you run the export via the browser? I don't think I saw this when I made the latest changes as I was able to get an export file. In case you created a new template, make sure that you have selected the override to use the override export routine.

Hello Roland,

I get this error in browser too - override is selected. Try it on test.winzersekt.de and use the "Export" Link.

Kind regards,

Teresa

Hello Teresa,
I fixed the issue on your site and Exports link is working now. The export file has no records as it looks like you have set a filter on options tab to get records from Last run date. Can you check front end export removing this filter? Also please check the cron url export from CLI too.

Hello Tharuna,

Export link works fine. However the cron is with the same error:

root@server4:~# /opt/php-7.0/bin/php /var/www/vhosts/http://sektkellerei.de/test.winzer http://sekt.de/administrator/components/com_csvi/helper/cron.php --key="123456" --templ ate_id="10"
Use --help to see the help information
Processing started...
Template SD2000-OA
[color=#ff0000]Unknown column 'ChampagneTAX' in 'field list' SQL=SELECT [/color]`#__virtuemart_orders`. `virtuemart_order_id`,
`grade`,
`address_1`,
`address_2`,
`address_type`,
`address_type_name`,
`agreed`,
`city`,
`company`,
`user_info1`.`virtuemart_country_id`,
`coupon_code`,
`coupon_discount`,
`#__virtuemart_orders`.`created_by`,
`#__virtuemart_orders`.`created_on`,
`customer_note`,
`customer_number`,
(`order_discount` / `order_total`) * 100 AS `discount_percentage`,
`user_info1`.`email`,
`fax`,
`first_name`,
`user_info1`.`first_name`,
`user_info1`.`middle_name`,
`user_info1`.`last_name`,
`invoice_number`,
`ip_address`,
`last_name`,
`#__virtuemart_orders`.`locked_by`,
`#__virtuemart_orders`.`locked_on`,
`middle_name`,
`#__virtuemart_orders`.`modified_by`,
`#__virtuemart_orders`.`modified_on`,
`order_billDiscountAmount`,
`order_billTax`,
`order_billTaxAmount`,
`order_create_invoice_pass`,
`order_currency`,
`order_discount`,
`order_discountAmount`,
`order_item_currency`,
`order_item_name`,
`order_item_sku`,
`order_language`,
`order_number`,
`order_pass`,
`order_payment`,
`order_payment_tax`,
`order_salesPrice`,
`order_shipment`,
`order_shipment_tax`,
`#__virtuemart_orders`.`order_status`,
`order_status_name`,
`order_subtotal`,
`order_tax`,
`order_total`,
`payment_currency_id`,
`payment_currency_rate`,
`#__virtuemart_orders`.`virtuemart_paymentmethod_id`,
`payment_name`,
`phone_1`,
`phone_2`,
`product_attribute`,
`product_basePriceWithTax`,
`product_discountedPriceWithoutTax`,
`product_final_price`,
`product_item_price`,
`product_priceWithoutTax`,
`product_item_price` * `product_quantity` AS `product_price_total`,
`product_quantity`,
`product_subtotal_discount`,
`product_subtotal_with_tax`,
`product_tax`,
`#__virtuemart_orders`.`virtuemart_shipmentmethod_id`,
`shipping_mail`,
`user_info1`.`virtuemart_state_id`,
`title`,
`tos`,
`#__virtuemart_orders`.`virtuemart_user_id`,
`#__virtuemart_orders`.`user_currency_id`,
`user_currency_id`,
`user_currency_rate`,
`virtuemart_order_item_id`,
`virtuemart_order_userinfo_id`,
`#__virtuemart_order_items`.`virtuemart_product_id`,
`virtuemart_state_id`,
`#__virtuemart_orders`.`virtuemart_vendor_id`,
`zip`,
`ChampagneTAX`,
`orderPaymentTax`,
`orderShipmentTax`,
`orderTaxValue`,
`productDiscountPercentage`,
`subSKU`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_orde r_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orde rs`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.` virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_produ ct_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers` .`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufa cturer_id`
LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_cou ntry_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_i d` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_de_de` ON `#__virtuemart_orders`.`virtue mart_paymentmethod_id` = `#__virtuemart_paymentmethods_de_de`.`virtuemart_paymen tmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods_de_de` ON `#__virtuemart_orders`.`virtu emart_shipmentmethod_id` = `#__virtuemart_shipmentmethods_de_de`.`virtuemart_shi pmentmethod_id`
GROUP BY `virtuemart_order_item_id`
root@server4:~#

Hello Teresa,
Can you please give the cron export one more try now and let me know?

Hello Tharuna,

here again ;-)
Kind regards,

Teresa

root@server4:~# /opt/php-7.0/bin/php /var/www/vhosts/http://sektkellerei.de/test.winzersekt.de/administrator/components/com_csvi/helper/cron.php --key="123456" --template_id="10"
Use --help to see the help information
Processing started...
Template SD2000-OA
Unknown column 'ChampagneTAX' in 'field list' SQL=SELECT `#__virtuemart_orders`.`virtuemart_order_id`,
`grade`,
`address_1`,
`address_2`,
`address_type`,
`address_type_name`,
`agreed`,
`city`,
`company`,
`user_info1`.`virtuemart_country_id`,
`coupon_code`,
`coupon_discount`,
`#__virtuemart_orders`.`created_by`,
`#__virtuemart_orders`.`created_on`,
`customer_note`,
`customer_number`,
(`order_discount` / `order_total`) * 100 AS `discount_percentage`,
`user_info1`.`email`,
`fax`,
`first_name`,
`user_info1`.`first_name`,
`user_info1`.`middle_name`,
`user_info1`.`last_name`,
`invoice_number`,
`ip_address`,
`last_name`,
`#__virtuemart_orders`.`locked_by`,
`#__virtuemart_orders`.`locked_on`,
`middle_name`,
`#__virtuemart_orders`.`modified_by`,
`#__virtuemart_orders`.`modified_on`,
`order_billDiscountAmount`,
`order_billTax`,
`order_billTaxAmount`,
`order_create_invoice_pass`,
`order_currency`,
`order_discount`,
`order_discountAmount`,
`order_item_currency`,
`order_item_name`,
`order_item_sku`,
`order_language`,
`order_number`,
`order_pass`,
`order_payment`,
`order_payment_tax`,
`order_salesPrice`,
`order_shipment`,
`order_shipment_tax`,
`#__virtuemart_orders`.`order_status`,
`order_status_name`,
`order_subtotal`,
`order_tax`,
`order_total`,
`payment_currency_id`,
`payment_currency_rate`,
`#__virtuemart_orders`.`virtuemart_paymentmethod_id`,
`payment_name`,
`phone_1`,
`phone_2`,
`product_attribute`,
`product_basePriceWithTax`,
`product_discountedPriceWithoutTax`,
`product_final_price`,
`product_item_price`,
`product_priceWithoutTax`,
`product_item_price` * `product_quantity` AS `product_price_total`,
`product_quantity`,
`product_subtotal_discount`,
`product_subtotal_with_tax`,
`product_tax`,
`#__virtuemart_orders`.`virtuemart_shipmentmethod_id`,
`shipping_mail`,
`user_info1`.`virtuemart_state_id`,
`title`,
`tos`,
`#__virtuemart_orders`.`virtuemart_user_id`,
`#__virtuemart_orders`.`user_currency_id`,
`user_currency_id`,
`user_currency_rate`,
`virtuemart_order_item_id`,
`virtuemart_order_userinfo_id`,
`#__virtuemart_order_items`.`virtuemart_product_id`,
`virtuemart_state_id`,
`#__virtuemart_orders`.`virtuemart_vendor_id`,
`zip`,
`ChampagneTAX`,
`orderPaymentTax`,
`orderShipmentTax`,
`orderTaxValue`,
`productDiscountPercentage`,
`subSKU`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_de_de` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_de_de`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods_de_de` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods_de_de`.`virtuemart_shipmentmethod_id`
GROUP BY `virtuemart_order_item_id`
root@server4:~#

Hello Teresa,
Thank you so much for sending me your site access details. I have fixed the issue with cron, can you please test and let me know?

Hello Tharuna,

you are welcome! Thanks a lot for your assistance! Seems to be working now.

Where do you made the changes? Overrides? I ask you, because for going live end of this week. Will I get a patch file?

Or should I move all csvi files to the live domain?

Kind regards,

Teresa

Hello Teresa,
Glad to know it is all working now. I have attached the patch file which has all the changes. You can load this patch file from CSVI maintenance menu on your live site. If you find any issue you can post it here.


patch_override_2016_11_16.zip

Hello again Tharuna,

still trouble with cron jobs. Tried to import order status and order item status fails with following errors:

root@server4:~# /opt/php-7.0/bin/php /var/www/vhosts/http://sektkellerei.de/test.winzer http://sekt.de/administrator/components/com_csvi/helper/cron.php --key="xxxxx" --t emplate_id="14"
Use --help to see the help information
Processing started...
Template Order Status IMPORT
Processed 1 lines
Total Result Status

Fatal error: require_once(): Failed opening required '/var/www/vhosts/sektkeller http://ei.de/test.winzersekt.de/administrator/administrator/components/com_csvi/models/ logdetails.php' (include_path='.:/opt/php-7.0/lib/php') in /var/www/vhosts/sektk http://ellerei.de/test.winzersekt.de/administrator/components/com_csvi/rantai/model.php on line 272
root@server4:~#

AND

root@server4:~# /opt/php-7.0/bin/php /var/www/vhosts/http://sektkellerei.de/test.winzerhttp://sekt.de/administrator/components/com_csvi/helper/cron.php --key="xxxxxxx" --template_id="19"
Use --help to see the help information
Processing started...
Template Order Item Status IMPORT
Processed 0 lines
Total Result Status

Fatal error: require_once(): Failed opening required '/var/www/vhosts/http://sektkellerei.de/test.winzersekt.de/administrator/administrator/components/com_csvi/models/logdetails.php' (include_path='.:/opt/php-7.0/lib/php') in /var/www/vhosts/http://sektkellerei.de/test.winzersekt.de/administrator/components/com_csvi/rantai/model.php on line 272
root@server4:~#

Kind regards,

Teresa

Hello Teresa,

The error indicates a mistake in the path as it has /administrator/administrator. So I made a change to the cron file, can you run the job again?

Hello Roland,

now nothing happens when call the cron via console.

All cronjobs are no longer working

Send you the root for testing.

Kind regards,

Teresa

Hello Teresa,

That it did not work was my mistake, there was a ) too many. :dry:

So to be sure it would run I checked further and the import still did not run as supposed to be. I found that the XML file that is being imported was incorrect, some of the XML tags were not renamed to their new names. Fixed the XML nodes to all have the same names and then added the fields to the template so it would know what to do with it. After that the import ran.

Please check and let me know if it works as you expect.

Hello Roland,

thanks again! Regarding the XML tags, I'm played around with different settings in XML files AND/OR CSVI...... and forgot at least re-enter the correct names. Sorry!

One more issue found: When running the cron for imports and loading the files from server, the XML files are not deleted after the run. Delete after import is set to YES. When manual runnig the same import from CSVI backend, the files are deleted.

Could you please check it?

Kind regards,

Teresa