Joomla Extensions Club 20,483 posts

[aksmith Friend aksmithJoin date: October 2010Posts: 1Downloads:27Uploads:0]

#849703

Hello:
Install of latest JA K2 Filter with K2 2.6.9, J 3.4.8:
Update indexing throws a 1062 database error.

See login details below.

Thank you,
Alan

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

#851535

Hi aksmith,

I had fixed the problem.

In the file : components/com_jak2filter/helpers/helper.php line : 325

add the code:

GROUP BY CONCAT(xref.tagID, #__k2_items.id)';

Regards

[ppnilsson Friend ppnilssonJoin date: October 2015Posts: 38Downloads:11Uploads:12 Thanks: 2 Thanked: 1 times in 1 posts]

#876304

Hi I also get a 1062 error:
DUPLICATE ENTRY ’94-72′ FOR KEY ‘TAXONOMY_MAP_ID’ SQL=INSERT INTO AWDUP_JAK2FILTER_TAXONOMY_MAP (NODE_ID,ITEM_ID,LANGUAGE)

around components/com_jak2filter/helpers/helper.php line : 325 I find the following:

        //4. Tag
        $query = "
            SELECT xref.tagID, #__k2_items.id, #__k2_items.language
            FROM #__k2_items
            JOIN #__k2_tags_xref AS xref ON #__k2_items.id = xref.itemID"
            .$whereItem;
        $db->setQuery($query);
        $items = $db->loadObjectList();
        if(count($items)) {

Inserting as mentioned above (within query of course) results in erros.

may you give me a hint?

thx peer

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#876851

Hi,

We have updated the query in above post, please try again and tell us the results.

If it doesn’t work, send us your site admin account, URL account and FTP account.

[fabiojordan Friend fabiojordanJoin date: August 2014Posts: 48Downloads:20Uploads:2 Thanks: 8 Thanked: 5 times in 5 posts]

#876878

Hi there folks.

I’m getting the same error (as shown on image).

1062 Duplicate entry ‘1419-2384’ for key ‘taxonomy_map_id’ SQL=INSERT INTO cafe25_jak2filter_taxonomy_map (node_id, item_id, language) VALUES( ‘1419’, ‘2384’, ”)

By the way, I’ve tried the provided code, but it didnt work as expected… 🙁

What can we do to fix that?

Thanks in advance!

---

Attachments:

1. 

[ppnilsson Friend ppnilssonJoin date: October 2015Posts: 38Downloads:11Uploads:12 Thanks: 2 Thanked: 1 times in 1 posts]

#879182

Hi may you be more specific about where to place groupconcat?
in line 325 I find the following: `
$db->setQuery($query);

which is what is shown in codemirror above (my last post) in line 7 

so where to place your given code?  `
GROUP BY CONCAT(xref.tagID, #__k2_items.id)';

many thanks?

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#883132

Hi,

Please try again by following:
in file

components\com_jak2filter\helpers\helper.php

find for:

//4. Tag
        $query = "
            SELECT xref.tagID, #__k2_items.id, #__k2_items.language
            FROM #__k2_items
            JOIN #__k2_tags_xref AS xref ON #__k2_items.id = xref.itemID"
            .$whereItem;

change to:

//4. Tag
        $query = "
            SELECT xref.tagID, #__k2_items.id, #__k2_items.language
            FROM #__k2_items
            JOIN #__k2_tags_xref AS xref ON #__k2_items.id = xref.itemID"
            .$whereItem
            .' GROUP BY CONCAT(xref.tagID, #__k2_items.id)';

[fabiojordan Friend fabiojordanJoin date: August 2014Posts: 48Downloads:20Uploads:2 Thanks: 8 Thanked: 5 times in 5 posts]

#890488

Hello Luna, how are you?

I followed exactly what you posted, but the message still appears on some items.

Any other hint?

Thanks again!

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#890681

Hi Fabio,

The problem only happens with the data was imported thru Database, then some duplicated items will be inserted without checking, in this case it was Tag. When being indexed, duplicate item will cause the error. I don’t understand where did you get this error on some items, it only appear when you try to index JA K2 Filter.

Could you describe more the problem you get and post your site info: Site URL, admin account and FTP account in private reply so I can check it for you.

[reylogrono Friend reylogronoJoin date: August 2008Posts: 3Downloads:5Uploads:1]

#891087

Hi, It worked for me. Please just make sure you remove the " ; " from the end of .$whereItem;

Check if the code is exactly as this:

    //4. Tag
            $query = "
                SELECT xref.tagID, #__k2_items.id, #__k2_items.language
                FROM #__k2_items
                JOIN #__k2_tags_xref AS xref ON #__k2_items.id = xref.itemID"
                .$whereItem
                .' GROUP BY CONCAT(xref.tagID, #__k2_items.id)';

[fabiojordan Friend fabiojordanJoin date: August 2014Posts: 48Downloads:20Uploads:2 Thanks: 8 Thanked: 5 times in 5 posts]

#893509

This reply has been marked as private.

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#893898

Hi Fabio,

Thanks for the info, but After login to Administrator >> K2 >> Item, I get this message: Not Acceptable! An appropriate representation of the requested resource could not be found on this server.
Could you check the login info again?

[fabiojordan Friend fabiojordanJoin date: August 2014Posts: 48Downloads:20Uploads:2 Thanks: 8 Thanked: 5 times in 5 posts]

#894588

Hi Luna, thats strange. I’ve just logged in with the same credentials and its working. Maybe it has something problem with your timezone, try to change it in the User Settings, it’s the first user on the list. Lets see if it works. Thanks again!

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#894697

Hi Fabio,

We have checked Item ‘Little Boy – Além do Impossível | Trailer legendado e sinopse’, In extra field Elenco – type Searchable Label, you inserted two words with same value ‘David Henrie’, it makes duplicated id to index table. If you remove one value, you won’t see the error anymore after saving.

[fabiojordan Friend fabiojordanJoin date: August 2014Posts: 48Downloads:20Uploads:2 Thanks: 8 Thanked: 5 times in 5 posts]

#894856

Hi Luna,

Wow, haha, I would never thought that a simple mistake would present that error. Thanks a bunch for the help and its great to see thats no big deal.

Thanks again and have a great weekend!

1 user says Thank You to fabiojordan for this useful post

1. Luna Garden

[Author]

Posts