Resolved Error on export K2 categories multi lingual site.

Hello Rachel,
With RO CSVI 9.0.0 version we stopped support for K2 addon.

But when I run the template I get this error for all category ID's: Cannot load the category path for category ID 9 and language *

The cause could be that In #__k2_categories table language field is empty but RO CSVI looks for language with value * in export query. Since that row is not found you are seeing the error on export.

To solve this
1. Run custom table export of #__k2_categories table with template fields id, name, parent, language.
2. In the export file update the language column value to * for all rows.
3. Create RO CSVI Custom table import template.
4. On Options tab set the table to k2_categories and import based on field to id.
5. Run the import with updated file.
6. Run K2 categories export after that.

Try and let me know on how that goes.

Hi Tharuna,

I'm using version 8 with the K2 plugin. My language fields in the database are filled with nl-NL, en-GB and fr-FR.

Does that change things?

Regards, Rachel

Hello Rachel,
In that case you can select a language in export template on Options tab. Do that and save the template and run the export. See if that helps.

If you still have issues, post export debug log to check. To get the debug log see How to collect debug information? document.

Hi Tharuna,

That did the trick in that it exported the dutch categories. Do I need to export each language seperately? Also do I need to do the same for the items later on?

Hello Rachel,
Yes you can set each language and export categories and do the same for items as well.