1. sandstorm871
  2. RO CSVI
  3. Wednesday, 26 August 2020
  4.  Subscribe via email
Joomla 3.9.21
CSVi 7.17.0
PHP 7.4.9
Attached CSV, Log & error

I'm testing a product import for J2store, but when importing this in CSVi, I get the error 'Cannot start the import because the import operation Category for the addon categories component com_categories cannot be found'

I've re-installed, run maintenance> available fields, checked other settings and am now a bit lost, so appreciate any help.

Thanks,
Andy
Attachments (3)
Accepted Answer
Accepted Answer Pending Moderation
Hello Andy,
As Roland mentioned in his reply, i am attaching new patch file with the fix. Please try the import with this new patch file and let us know on how it goes.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
Hello Andy,
This is a known issue and have been fixed with the attached patch file. Please load the attached patch file and try the import. This fix will be included in our upcoming RO CSVI release.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, 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
Thanks for your reply. I've installed the patch file you sent over, but now get the error 'error 500'.
I've checked over your supporting error 500 documents ; fixed all file/folder permissions, reinstalled CSVi & Joomla, removed images from the upload, PHP is 7.4.9, set autodetect limiter to on & off, set error reporting to Dev.

I used an older version of CSVi on another j2store/joomla site on the same server, which works well.

I know you say in the error message & supporting error 500 documents that this coule be almost anything and advise contacting host, however, I use an older version of CSVi on another j2store/joomla site on this same server, which works well.

Could this be an issue with the patch file or anything else within CSVi? I attached the log file from the last import I tried,
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
I used an older version of CSVi on another j2store/joomla site on the same server, which works well.

You must be using RO CSVI version which is less than 7.15.0 version then. With RO CSVI 7.15.0 version we built a new feature in J2Store to create categories using Joomla categories import. The error 'Cannot start the import because the import operation Category for the addon categories component com_categories cannot be found' is because of this new feature and will not be seen with versions less than 7.15.0 of RO CSVI.

Could this be an issue with the patch file or anything else within CSVi? I attached the log file from the last import I tried,

There is no log file attached but for 500 error please check your server error logs. You will get details on what is causing 500 error from the server error log. Please post the error here so we can check.
Kind regards,

Tharuna

=========================
If you use CSVI, 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
There is no log file attached but for 500 error please check your server error logs. You will get details on what is causing 500 error from the server error log. Please post the error here so we can check.

I've manually checked all the server logs and the PHP error log and the only thing mentioned in the log is the following:
[27-Aug-2020 13:16:55 Europe/London] PHP Notice: Trying to access array offset on value of type int in /home/concomw1/roots.concom1.co.uk/templates/sandal/warp/src/Warp/Config/Repository.php on line 243
[27-Aug-2020 13:16:55 Europe/London] PHP Notice: Trying to access array offset on value of type int in /home/concomw1/roots.concom1.co.uk/templates/sandal/warp/src/War


I've since deleted the log and tried to run the import a few more times and no error log is produced.
I have also taken a full copy of the site, and put it on a totally dfferent server with a different hosting company, in a different country and we still get the 500 error.
Current site - Host is guru.co.uk
Extra test : roots.andyconnell.co.uk - siteground.com

My hosting company [guru.co.uk] is excellent and the support guys are superb too.
They have logged in and fully tested too. Below is what they have tested and had to say.

We've spent some time testing this and the error doesn't seem to have an obvious cause just yet.

We can see the file being opened for import and the database query being made but it then tries to look for the following files:

22806 stat@SYS("/home/concomw1/roots.concom1.co.uk/plugins/csviaddon/categories/com_categories/model/import/category.php", 0x7ffc2c5840f0)         = 0 <0.000536>
22806 access@SYS("/home/concomw1/roots.concom1.co.uk/plugins/csviaddon/", 00) = 0 <0.000281>
22806 access@SYS("/home/concomw1/roots.concom1.co.uk/plugins/csviaddon/categories/com_categories", 00) = 0 <0.000392>
22806 stat@SYS("/home/concomw1/roots.concom1.co.uk/plugins/csviaddon/categories/com_categories/helper/com_categories.php", 0x7ffc2c583de0) = 0 <0.000545>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/plugins/csviaddon//categories/com_categories/model/import/Category.php", 0x7ffc2c580c10) = -2 <0.000613>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/plugins/csviaddon//categories/com_categories/model/import/Category.php", 0x7ffc2c580c10) = -2 <0.000613>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/cms/document.php", 0x7ffc2c580a90) = -2 <0.000316>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/cms/document/document.php", 0x7ffc2c580a90) = -2 <0.000393>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/joomla/document.php", 0x7ffc2c580a90) = -2 <0.000325>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/joomla/document/document.php", 0x7ffc2c580a90) = -2 <0.000373>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/legacy/document.php", 0x7ffc2c580a90) = -2 <0.000351>
22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/legacy/document/document.php", 0x7ffc2c580a90) = -2 <0.000365>


Some of those files are missing within the installation and shortly after the application opens the error document files as shown below so this could be related.

22806 lstat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/src/Document/ErrorDocument.php", 0x7ffc2c580ab0)     = 0 <0.000417>
22806 access@SYS("/home/concomw1/roots.concom1.co.uk/libraries/src/Document/ErrorDocument.php", 00) = 0 <0.000379>
22806 stat@SYS("/home/concomw1/roots.concom1.co.uk/libraries/src/Document/ErrorDocument.php", 0x7ffc2c583810) = 0 <0.000468>
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Andy,
I've manually checked all the server logs and the PHP error log and the only thing mentioned in the log is the following:

These are PHP notices and cannot be a cause for 500 error.

I have also taken a full copy of the site, and put it on a totally dfferent server with a different hosting company, in a different country and we still get the 500 error.

Two things to check
1. Check if you have the file category.php in the location /plugins/csviaddon/categories/com_categories/model/import/category.php.
2. Did the patch install without any error?

Some of those files are missing within the installation and shortly after the application opens the error document files as shown below so this could be related.

Those files are from Joomla installation and not related to RO CSVI. You can try installing RO CSVI and the patch file on a fresh Joomla installation and see if you still see 500 error.
Kind regards,

Tharuna

=========================
If you use CSVI, 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
Two things to check
1. Check if you have the file category.php in the location /plugins/csviaddon/categories/com_categories/model/import/category.php.
2. Did the patch install without any error?

Hi Tharuna,
1 - I confirm that file category.php is in the location /plugins/csviaddon/categories/com_categories/model/import/category.php
2 - Patch installed OK - see screenshot

3 - I installed a clean version of Joomla here https://www.csvi.concom1.co.uk/
Installed J2Store, CSVi 7.17.0, CSVi J2Store Plugin 7.17.0, updated available field, set up identical j2store import template & attempted the import - Once again, presented with the 500 error - see screenshot.

So this has been tried on the original test site, a copy of that site on a different server/host and now in a clean install of Joomla.

I've included screenshots and log from the clean Joomla site.
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Andy,
Yes i see the 500 error on the site. I tried to import your file in my local server and it went good. So i tried to reinstall RO CSVI and RO CSVI J2Store addon on your site, reset tasks, updated available fields and again 500 error. I even tried to set Error reporting to maximum to check if there are any details on the error but no. Unless we get the details on the 500 error it is difficult to find what is causing the error. Can you please post the server error log here from your new Joomla site? I will check it and see if i can find any details.
Kind regards,

Tharuna

=========================
If you use CSVI, 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
Very Odd?
I have nothing showing up for the new site in the PHP error_log or the error log that's visible within cPanel > Metrics > Errors

Attached are the only other logs I can see 'RAW' logs - is this correct? If not I can contact Host for whatever you need to check.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Andy,
The attached are the access logs and won't give us any information on the error. We are looking into the issue by doing testing on your site. We will let you know on what we find.
Kind regards,

Tharuna

=========================
If you use CSVI, 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
If you need cPanel or any other access please let me know.

I asked host to look for further error logs and this is what they say;
I cannot see anything being produced in the server log when the error occurs, I have tried watching them in real time and there re not entries as the error is happening being written.
I am escalating this issue to one of our senior support team who may be able to provide more insight.
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
My host guys have looked deeper into this and think that its something to do with the file category.php having a capital letter in the name?

Here's what they say;

It would appear that, shortly before your PHP process begins to load in the ErrorDocument.php files, it attempts to find Category.php as mentioned by my colleague Andrew.

However, it would seem that category.php (with a lower case C does exist) which I suspect is related to the error.

To test, I've copied category.php to Category.php (as I'm fairly confident the code references both the upper case and lower case files) which looks to resolve the import issue.

I've left the above "fix" in place as you may wish to try the import on your end to confirm this is working as expected.

For the developers reference, the path to this file is /home/concomw1/roots.concom1.co.uk/plugins/csviaddon/categories/com_categories/model/import/category.php

NOTE: This may work on Windows based environments due to case-insensitive paths which may explain why your developer is having trouble replicating the issue
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Andy,

We are also at the point it has something to do with the category.php/Category.php. However I am unable to connect to any of the two sites. Well I manage to connect to grp4.myukcloud.com but only with passive mode off. However I cannot get a directory listing, most likely due to passive mode being off. The other domain cannot be resolved so that is where it ends.

I tried it with 3 different programs and PhpStorm on 2 different machines but all the same result.

Please advise how I can connect to the server.
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
Hey Roland,
Awesome to hear from you. Hope you and the family are all well :)

I changed the FTP Password & tested, all seems OK.
Let me know how you get on & if needed I can just send over cPanel login.
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Andy,

All is well here, I hope for you too on the other side of the channel :D

So I have a clear picture what is going on. When you are running the import at some point the code is looking the class

categories\com_categories\model\import\Category
Notice the capital C at the Category word. When Joomla is searching for the file at some point it looks for Category.php and this is where your sites break. This is still baffling to me because we haven't had anybody else have this issue nor can we reproduce it on other Linux systems. I guess the other systems just returns false when the file doesn't exist and yours throws a tantrum :p

We will create a new patch file and send it to you tomorrow.
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
Patch file uploads OK and now allows me to import my CSV file - Thanks ;)
  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!