Public Forums 71,145 posts

[trevorellis Friend trevorellisJoin date: August 2016Posts: 83Downloads:61Uploads:9 Thanks: 7 Thanked: 1 times in 1 posts]

#991257

When I import into K2 all of my items had JSON errors. I had to delete the content in the MetaData column in the Joomla content table ({"robots":"","author":"","rights":"","xreference":""}) which was causing the problem.

Once I had done this I had to delete all the K2 Content and Reimport successfully. I am not sure what effect this will have to future searchability of my site?

Has the issue now been fixed in K2 2.7.1 ?

I am using Uber with K2.

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#991539

Hi,

Correct me if I’m wrong but JA K2 Data migration extension helps to import K2 items to com_content. While you import com_content to K2 and face that issue, is that correct?

Regards

[trevorellis Friend trevorellisJoin date: August 2016Posts: 83Downloads:61Uploads:9 Thanks: 7 Thanked: 1 times in 1 posts]

#1006539

Just imported Data into K2 in another site and got the same problem. I cannot open any of the Items I imported as I get a JSON error: "0 Error decoding JSON data: Syntax error "
I have deleted the content in the Metatable as before, deleted the Items and then re-imported successfully.

I am still not sure what effect this will have to future searchability of my site?

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#1007452

Hi,

The JA K2 Data Migration plugin only imports data from k2 to Joomla content. Which component you open when you get the error JSON…. Please provide URL and admin login info.

I’ll take a look

Regards

[itmnetcom Friend itmnetcomJoin date: March 2016Posts: 3Downloads:19Uploads:4]

#1017587

Hi,

Did you guys ever figure this out.

Just to be clear, this happens when you import from joomla content to K2. (from K2)

Thanks

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#1018398

Hi,

Pls note that JA K2 Dat Migration plugin import data from K2 content to Joomla content only, NOT from Joomla to K2.

If you experience any issue, you can provide the URL and admin login info so I will take a look.

[alainperron Friend alainperronJoin date: April 2017Posts: 5Downloads:4Uploads:5 Thanked: 1 times in 1 posts]

#1025873

This reply has been marked as private.

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#1025880

Hi,

You probably assign the same tag more than once into 1 item. For example, you have tag called: movie, sport… and you add ‘movie’ tag twice into 1 item.

If possible, put your site online and share me the credentials so I will check.

If not, you can take a backup of your site (use Akeeba backup) and send me the backup file, I will investigate in my local.

Regards

[alainperron Friend alainperronJoin date: April 2017Posts: 5Downloads:4Uploads:5 Thanked: 1 times in 1 posts]

#1026035

This reply has been marked as private.

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#1026366

You can try to run this sql query in phpmyadmin to find out duplicate tag.

select distinct id, tagID, itemID
  from prefix_k2_tags_xref t1
 where exists (select * 
                 from jfe18d_k2_tags_xref t2 
                where t2.id <> t1.id
                  and t2.tagID = t1.tagID
                  and t2.itemID = t1.itemID
               )

And you can run this query to delete all the duplicate row (will remain 1 row)

DELETE x 
FROM prefix_k2_tags_xref x
JOIN prefix_k2_tags_xref y
ON y.tagID= x.tagID
AND y.itemID = x.itemID
AND y.id > x.id;

Change the "prefix" to your table prefix.
REMEMBER : BACKUP BEFORE HAND.

[alainperron Friend alainperronJoin date: April 2017Posts: 5Downloads:4Uploads:5 Thanked: 1 times in 1 posts]

#1026611

I work with your sql and the result is no record.
I try also the sql for delete and no surprise, no record was deleted.
I remove the sh404 extension and try to merge tags with an external extension from joomla works "merge tags" but does not work at all.
So I delete all tags without any exception.
After that I use your extension and import the k2 elements in content and all the categories and elements were imported. All works fine and I deinstall all k2 elements. I must reorganise my menus but that’s ok.
I work on my local test with a backup of the production site. Backup made with akeebabackup.
Thank you for your help. I can do that on the production site later at the mid june.

[Author]

Posts