Inhalte aufrufen

  • Mitglieder
  • Marketplace
  • Blogs
Profilbild

Error of Update Topic in Admin Page

Eröffnet von tkchung23 , Mar 13 2019 01:12
Topic

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

#1 tkchung23

tkchung23

    Member

  • Members
  • PunktPunkt
  • 16 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
  • 3831 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).


Marcus Gesing

Smartstore AG

#3 tkchung23

tkchung23

    Member

  • Members
  • PunktPunkt
  • 16 Beiträge

Geschrieben: 16 March 2019 - 07:17

OK, thanks.


#4 tkchung23

tkchung23

    Member

  • Members
  • PunktPunkt
  • 16 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
  • 3831 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.

Marcus Gesing

Smartstore AG

#6 tkchung23

tkchung23

    Member

  • Members
  • PunktPunkt
  • 16 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
  • 3831 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 ;-)).

Marcus Gesing

Smartstore AG

#8 tkchung23

tkchung23

    Member

  • Members
  • PunktPunkt
  • 16 Beiträge

Geschrieben: 04 April 2019 - 08:40

It seems work!!  Thanks ;)  ;)


Zurück zu General Smartstore

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

  1. Smartstore Community
  2. → Smartstore (English)
  3. → General Smartstore
  4. Datenschutzerklärung
  5. Smartstore - Forum - Blogs - Marketplace (SCM) AGB ·