Resolved Error 500 when importing tag via csv

Hello Marc,

[05-Mar-2024 16:35:18 Europe/Berlin] PHP Warning: Undefined variable $saveOrderingUrl in .../administrator/components/com_csvi/views/templates/tmpl/default.php on line 117

This is a warning and should not be responsible for 500 error you are having. Load the attached patch file and see if this warning is gone.

As of 500 error please read through the 500 Internal server error document for possible causes. See if the document helps to solve the error.

Hi Tharuna,

the warning is gone, but the error 500 still remains?! I have tried a lot of things from the your doc page without success.

Here is a small piece of the apache access logs, when I try to import that file.

Any idea, why this import doesn't work!?

Kind Regards,
Marc

staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:27 +0100] "GET /administrator/index.php?option=com_csvi&task=imports.selectsource&csvi_template_id=21 HTTP/2.0" 303 396 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:27 +0100] "GET /administrator/index.php?option=com_csvi&task=importsource.source&runId=102 HTTP/2.0" 200 9346 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:27 +0100] "GET /media/com_jchoptimize/core/images/loader.gif HTTP/2.0" 304 85 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importsource.source&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:27 +0100] "GET /index.php?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 301 124 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importsource.source&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:28 +0100] "GET /media/system/images/favicon.ico HTTP/2.0" 304 80 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importsource.source&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:28 +0100] "GET /de/?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 200 63 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importsource.source&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:31 +0100] "POST /administrator/index.php?option=com_csvi&view=importsource HTTP/2.0" 303 149 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importsource.source&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:31 +0100] "GET /administrator/index.php?option=com_csvi&task=importpreview.preview&runId=102 HTTP/2.0" 200 9656 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importsource.source&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:31 +0100] "GET /media/com_jchoptimize/core/images/loader.gif HTTP/2.0" 304 57 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importpreview.preview&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:31 +0100] "GET /media/system/images/favicon.ico HTTP/2.0" 304 34 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importpreview.preview&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:31 +0100] "GET /index.php?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 301 98 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importpreview.preview&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:31 +0100] "GET /de/?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 200 39 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importpreview.preview&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:33 +0100] "POST /administrator/index.php?option=com_csvi&view=import HTTP/2.0" 200 5581 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&task=importpreview.preview&runId=102"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:33 +0100] "GET /index.php?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 301 98 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=import"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:33 +0100] "GET /media/system/images/favicon.ico HTTP/2.0" 304 34 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=import"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:33 +0100] "GET /administrator/components/com_csvi/rantai/rantai.php?task=import&runId=102&_=1709718273307 HTTP/2.0" 500 20838 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=import"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:33 +0100] "GET /de/?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 200 39 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=import"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:40 +0100] "POST /administrator/index.php?option=com_csvi&view=imports HTTP/2.0" 303 133 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=import"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:40 +0100] "GET /administrator/index.php?option=com_csvi&view=templates HTTP/2.0" 200 12684 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=import"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:40 +0100] "GET /media/com_jchoptimize/core/images/loader.gif HTTP/2.0" 304 57 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:40 +0100] "GET /index.php?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 301 98 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:40 +0100] "GET /media/system/images/favicon.ico HTTP/2.0" 304 34 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.118 - - [06/Mar/2024:10:44:40 +0100] "GET /de/?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 200 39 "https://staging.glow2b.com/administrator/index.php?option=com_csvi&view=templates"; "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.112 - - [06/Mar/2024:10:45:18 +0100] "GET /index.php?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 301 392 "https://staging.glow2b.com/de/catalog" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.112 - - [06/Mar/2024:10:45:18 +0100] "GET /de/?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 200 101 "https://staging.glow2b.com/de/catalog" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.112 - - [06/Mar/2024:10:46:20 +0100] "GET /index.php?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 301 392 "https://staging.glow2b.com/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"
staging.glow2b.com 0 45.129.35.112 - - [06/Mar/2024:10:46:21 +0100] "GET /de/?option=com_ajax&format=raw&plugin=RunSchedulerLazy&group=system HTTP/2.0" 200 124 "https://staging.glow2b.com/administrator/index.php" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"

Hello Marc,

Here is a small piece of the apache access logs, when I try to import that file.

Access log won't help in this case, we should check server error logs to get details of the error. In Joomla global configuration page set Error reporting to maximum and run the import. See if you get any details on the error. Post a screenshot on what you see.

Hi Tharuna,

I have tried this before, but there no more infos than the screenshot I have posted before.

And since I have upload your patch the php error log shows no warning or error.

Attached you'll find the http-error log, but there is also no error related to import process.

Any another idea what to check oder change?

Kind regards,
Marc

Hi Tharuna, your last patch file has fixed the problem! :-)

THX!

Kind Regards,
Marc

Hi Tharuna,

short question: Are the patches involved, when a new release comes out?

I have installed three patched (2 of you and 1 of Roland) and I wonder if I have to load the patches also on the live site?

Kind Regards,
Marc

Hello Marc,
Yes patches will be included in new release but the two patch files sent to you in this forum are not included with RO CSVI 8.10.0 version so you need to load these patch files on live site too. May I know the details of the issue for which Roland sent the patch file?

Hi Tharuna,

okay. Roland patchfile fixed automatic creation of a mapping based for my csv-file.

We talked about that in the following threat, which is now locked:
https://rolandd.com/support/ro-csvi/ignoring-including-fields

Kind regards,
Marc

Hello Marc,
Ok, Roland's patch is not included with RO CSVI 8.10.0 version. You need to load the patch file on live site.