Inhalte aufrufen

Profilbild

Error of Update Topic in Admin Page

Topic

  • Bitte melden Sie sich an, um eine Antwort zu verfassen.
7 Antworten zu diesem Thema

#1 tkchung23

tkchung23

    Member

  • Members
  • 13 Beiträge

Geschrieben: 13 March 2019 - 13:12

hi all, 

 

I am facing the issue that when I update the topic using admin page (e.g. update the content of topic), it shows error message: Cannot insert duplicate key row in object 'dbo.UrlRecord' with unique index 'IX_UrlRecord_Slug'. The duplicate key value is (xxxxxxx-xxx). The statement has been terminated.

 

I attachment screen capture, can anyone help?
thanks.

  • GalenKa und RidgeOi gefällt das

#2 Marcus Gesing

Marcus Gesing

    SmartStore AG

  • Administrators
  • 3366 Beiträge

Geschrieben: 13 March 2019 - 13:20

According to change log the bug will be fixed with the next version 3.2 (expected at end of month).


Schöne Grüße aus Düsseldorf,
Marcus Gesing


#3 tkchung23

tkchung23

    Member

  • Members
  • 13 Beiträge

Geschrieben: 16 March 2019 - 07:17

OK, thanks.



#4 tkchung23

tkchung23

    Member

  • Members
  • 13 Beiträge

Geschrieben: 28 March 2019 - 10:58

Any work around can do before the new verion release?



#5 Marcus Gesing

Marcus Gesing

    SmartStore AG

  • Administrators
  • 3366 Beiträge

Geschrieben: 28 March 2019 - 17:35

Then you would have to manually find and delete the duplicate UrlRecord. In the backend under CMS > Topics > Edit topic > Tab "Search engines (SEO) > Search engine friendly page name".
Another way to find it is System > SEO names > Object "Topic" > Apply filter. I'm not sure that you can get it away using the UI. Maybe you have to delete the duplicate entry directly in the database, table "UrlRecord", EntityName = Topic.

Schöne Grüße aus Düsseldorf,
Marcus Gesing


#6 tkchung23

tkchung23

    Member

  • Members
  • 13 Beiträge

Geschrieben: 30 March 2019 - 09:38

There are still not working even no duplicate record, it seems to have some problem when the topic has multi-language.



#7 Marcus Gesing

Marcus Gesing

    SmartStore AG

  • Administrators
  • 3366 Beiträge

Geschrieben: 01 April 2019 - 11:43

Yes, here's the corresponding fix. There are duplicate entries in the database because the SEO names of different languages were stored with the same ID. Probably best way is to delete all SEO names for that topic (System > SEO names or directly in database) and re-enter it (without duplicates ;-)).

Schöne Grüße aus Düsseldorf,
Marcus Gesing


#8 tkchung23

tkchung23

    Member

  • Members
  • 13 Beiträge

Geschrieben: 04 April 2019 - 08:40

It seems work!!  Thanks ;)  ;)




Auch markiert mit einem oder mehrerer dieser Schlüsselwörter: Topic