1. jcsl
  2. RO CSVI
  3. Friday, 10 September 2021
  4.  Subscribe via email
I have the following problem when trying to run an import template for my website https://prodromosk5.sg-host.com/. I run through ssh with command : usr/local/php73/bin/php-cli /home/customer/www/prodromosk5.sg-host.com/public_html/administrator/components/com_csvi/helper/cron.php --key="gfXiQnLwngZQgufauwPaitC9" --template_id=1

See attached screenshot of error towards the end of the log file and also I attached the log file.
Attachments (2)
Accepted Answer Pending Moderation
Hello,
Yes i see those entries in debug log. They happen after import of 20 records which is the default number of entries in debug log. Only 20 products are imported with cron? What is weird is the line count shows as 0 for those entries and the time difference between the last 20 line count and the error entry shows around 4+ hours of difference. See the date time copied from the debug log. What happens with your import? Do you get any error with cron?


2021-09-10 05:37:38 20 [DEBUG] Update has fields after all processing
2021-09-10 05:37:38 20 [QUERY] UPDATE `s217e_virtuemart_products` SET `has_categories` = 1 , `has_manufacturers` = 0 , `has_medias` = 1 , `has_prices` = 1 , `has_shoppergroups` = 0 WHERE `virtuemart_product_id` = 110
2021-09-10 09:54:01 0 [DEBUG] Could not find template "isis".
2021-09-10 09:54:01 0 [QUERY] SELECT template, s.params FROM s217e_template_styles as s LEFT JOIN s217e_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = 1 AND home = '1' ORDER BY home
Kind regards,

Tharuna

=========================
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
I get the following and it seems that it imports more than 4000 products since I see more than that number of products in the backend enabled. ( The Template first disables all products and when it updates or creates it enables them.

baseos | u98-seyse40c8bl0@c5761.sgvps.net:~/www/prodromosk5.sg-host.com/public_html$ /usr/local/php73/bin/php-cli /home/customer/www/prodromosk5.sg-host.com/public_html/administrator/components/com_csvi/helper/cron.php --key="gfXiQnLwngZQgufauwPaitC9" --template_id=1
Use --help to see the help information
Processing started...
Template JCSL Import from XML
Processed 5478 lines
Total Result Status
Could not find template "isis".
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
PLEASE HAVE A LOOK INTO THIS https://rolandd.com/support/ro-csvi/error-could-not-find-template-isis-after-update-to-7-11-0 seems to be relevant. Am I having same issue. What should I do ?
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Could not find template "isis".

It is possible that there is a 500 Internal server error in your import and it does not show up. Please check server error logs and see if you can find any error related to RO CSVI Import. Post it here so we can check.

PLEASE HAVE A LOOK INTO THIS https://rolandd.com/support/ro-csvi/error-could-not-find-template-isis-after-update-to-7-11-0 seems to be relevant. Am I having same issue. What should I do ?

We are not sure if you have the same error. We need the details on the error so we can see what is stopping the import.
Kind regards,

Tharuna

=========================
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. # 4
Accepted Answer Pending Moderation
The server team says it is the applications error and points to the error log in
public_html-->administrator-->logs-->com_csvi.log.16.php ( I already sent it ... I attach it again ). Also please note that the same template runs well with older version of the csvi ( that is in another configuration of another website). The answer of the server team below :

I have ran the import for you, the process was not terminated and it ran for about 3 hours. In the end it returned the following error:

baseos | u98-seyse40c8bl0@c5761.sgvps.net:~/www/prodromosk5.sg-host.com/public_html$ /usr/local/php73/bin/php-cli /home/customer/www/prodromosk5.sg-host.com/public_html/administrator/components/com_csvi/helper/cron.php --key="gfXiQnLwngZQgufauwPaitC9" --template_id=1
Use --help to see the help information
Processing started...
Template JCSL Import from XML
Processed 5478 lines
Total Result Status
Could not find template "isis".


The error is recorded in this log file:

administrator/logs/com_csvi.log.16.php


Since it is application related issue and no server errors or limitations were encountered in the process, my recommendation is to contact your website developer to resolve the application issue and then the import should be able to complete successfully.

If there is anything that we can help with on server side, please do not hesitate to get back to us. We will be more than happy to assist with anything within our reach.

Best Regards,
Iliya Pirgov
Technical Support Team
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Sending you also server log on the relevant date that the template was run if you think that might help.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Also please note that the same template runs well with older version of the csvi ( that is in another configuration of another website).

As you said the template runs on another configuration so there is something on this server which is stopping the import. Are you seeing this problem after RO CSVI Update?

I have ran the import for you, the process was not terminated and it ran for about 3 hours. In the end it returned the following error:

We understand there is an error on import but without the actual error it is difficult for us to help.

Since it is application related issue and no server errors or limitations were encountered in the process, my recommendation is to contact your website developer to resolve the application issue and then the import should be able to complete successfully.

The actual error will tell us if it is application related issue or server related issue. There should be details on what the actual error is in server error logs. If you can send us the error logs we can check for the error.
Kind regards,

Tharuna

=========================
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. # 7
Accepted Answer Pending Moderation
Hi Tharuna....

1. Template runs well on same server but another website .. Only difference is the version of the csvi. In the configuration with the problem we are running the latest csvi configuration.
2. I have attached the server log in the previous post... Iam attaching once again.

Question: If I install a previous version of csvi over the latest version will that work or do I need to un-install and install again ?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
1. Template runs well on same server but another website .. Only difference is the version of the csvi. In the configuration with the problem we are running the latest csvi configuration.

In such a case, can you please send us the template XML and import file to check? We will run the import on our test server with RO CSVI 8.0.0 version and see if we can reproduce the error. You can go to Templates list page, select the import template and click on Backup templates button to get backup of the template. You can post it here.

2. I have attached the server log in the previous post... Iam attaching once again.

Our messages overlapped. The log you posted is the access log but the real error is written to the servers error log. The access log has no details on errors and it only tell us which URL has been accessed with the status. If you can check the error log that would be helpful.

Question: If I install a previous version of csvi over the latest version will that work or do I need to un-install and install again ?

We recommend you to uninstall and install the needed RO CSVI version. Writing on top of latest version may create conflicts but before doing that send us the template and import file as requested and we can see if we can find the actual error.
Kind regards,

Tharuna

=========================
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. # 9
Accepted Answer Pending Moderation
Please find attached the backup of the template... note it has rules which can be found by login to the site ( credentials already sent ).
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
Thank you for the template. I did start the import on my local test site using cron and in last few hours around 500 products are imported. Looks like it is going to take quite a lot of time in importing 5000+ products. As of now there is no error and import is still running. Is it the same file imported in previous RO CSVI version and takes less time?
Kind regards,

Tharuna

=========================
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. # 11
Accepted Answer Pending Moderation
No it takes about 4 hours to complete
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
and the error is towards the end.
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,
Processed 5478 lines

Import stops at 5478 lines so i was trying to find if there is any problem after 5478 lines in import file. I tried to run the part of import file with few records before and after line 5478 from XML and it seems to go without any issue. Can you please make the debug log entries as 6000 records and run the import again? That will get us details on import in the debug log. To increase the debug log entries, go to RO CSVI Templates page click on Options button on the right, on Site tab set Number of lines in log file field to 6000, save the configuration. Run the import and send me the debug log.
Kind regards,

Tharuna

=========================
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
I have started the import ... will let you know as soon as It finishes and send you the log.
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
I got the same exact error... see error log and below the repsond from the ssh shell

baseos | u98-seyse40c8bl0@c5761.sgvps.net:~/www/prodromosk5.sg-host.com/public_html$ /usr/local/php73/bin/php-cli /home/customer/www/prodromosk5.sg-host.com/public_html/administrator/components/com_csvi/helper/cron.php --key="gfXiQnLwngZQgufauwPaitC9" --template_id=1
Use --help to see the help information
Processing started...
Template JCSL Import from XML
Processed 5567 lines
Total Result Status
Could not find template "isis".

error Log file is 120MB so I can not upload. Please login to my site and download it.
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
I have unistalled the beta version and installed the 7.2 version. Trying again to perform import... will let you know if this works ok.
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello,
Processed 5567 lines

Thank you for the import and debug log. The debug log shows same error but the number of lines imported was 5567 lines than last time with 5478 lines. I don't think there is any problem with import file or import but i am guessing that server is closing the connection after the long import time.

I have unistalled the beta version and installed the 7.2 version. Trying again to perform import... will let you know if this works ok.

Ok let us know on how that goes.
Kind regards,

Tharuna

=========================
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. # 18
Accepted Answer Pending Moderation
Import now runs without previous isis tempalte error. It finishes ok but it does not create subdirectories ( it puts everything as fist level directory ) . It seems as if combine rule is not working ?
Also it only imports very few products and gives the following output. Error log attached.

Total Result Status
Categories Added: 115
Category translations Updated: 115
Medias Added: 5553
Product media relations Added: 5553
Product prices Updated: 45
Product prices Added: 5508
Product translations Updated: 5553
Products Skipped: 19
Products Added: 5508
Products Incorrect: 2248
Products Updated: 45
Import has finished
baseos | u98-seyse40c8bl0@c5761.sgvps.net:~/www/prodromosk5.sg-host.com/public_html$
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello,
Import now runs without previous isis tempalte error.

Your import file keeps changing? In this import total products seems to be 5553 and the count was different in your previous posts.

It finishes ok but it does not create subdirectories ( it puts everything as fist level directory ) . It seems as if combine rule is not working ?

In import preview page, do you see the categories combined? If the rule does not work then import preview will not load the correct category_path. Also check if combine rule plugin is enabled. By default rules are disabled in RO CSVI on new installation.

Also it only imports very few products and gives the following output. Error log attached.
Products Skipped: 19
Products Added: 5508
Products Incorrect: 2248
Products Updated: 45

Log shows 5508 products are added and 45 products are updated. Checking the import on your site shows 19 products which are skipped does not have SKU in import file and hence skipped. The 2248 products which shows incorrect are because thumbnails were not created. The error for these incorrect product is copied from your site is pasted below. I see there are 5508 products in VirtueMart in your site. May i know what you mean by only few products are imported?


Cannot create thumbnail because the thumbnail is bigger than the maximum size set for creating thumbnails. The maximum width is set to 1300 and the maximum height is 1300 but the image has a width of 1499 and a height of 1500. To change these settings edit your import template and go to the Image tab and make sure the advanced button is clicked to show these options. You can change the Maximum width resize and the Maximum height resize.
Kind regards,

Tharuna

=========================
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. # 20
  • Page :
  • 1
  • 2


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