Discussion Forum: Thread 372311

 Author: Autism_And_I View Messages Posted By Autism_And_I
 Posted: Sep 4, 2025 22:09
 Subject: Searching "backpack" gives Error
 Viewed: 115 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Autism_And_I (211)

Location:  United Kingdom, England
Member Since Contact Type Status
Jan 31, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Autistic Bricks
Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).
 Author: Autism_And_I View Messages Posted By Autism_And_I
 Posted: Sep 4, 2025 22:12
 Subject: Re: Searching "backpack" gives Error
 Viewed: 41 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Autism_And_I (211)

Location:  United Kingdom, England
Member Since Contact Type Status
Jan 31, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Autistic Bricks
In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).
 
 Author: peregrinator View Messages Posted By peregrinator
 Posted: Sep 4, 2025 22:16
 Subject: Re: Searching "backpack" gives Error
 Viewed: 38 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

peregrinator (1101)

Location:  USA, New Jersey
Member Since Contact Type Status
Jan 21, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Faber Family Bricks
In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).

FWIW I can't reproduce but not great to have the specific error shown to
end users.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Sep 5, 2025 02:35
 Subject: Re: Searching "backpack" gives Error
 Viewed: 46 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1207)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Yorbricks
In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).

I can confirm the same error if searched with 'all items'. If you are
looking for something, try switching to 'catalog items' instead as the
search works there.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 5, 2025 02:41
 Subject: Re: Searching "backpack" gives Error
 Viewed: 37 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Technical Issues, yorbrick writes:
  In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).

I can confirm the same error if searched with 'all items'. If you are
looking for something, try switching to 'catalog items' instead as the
search works there.

It Works For Me™
 Author: Stellar View Messages Posted By Stellar
 Posted: Sep 5, 2025 03:15
 Subject: Re: Searching "backpack" gives Error
 Viewed: 48 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Stellar (4152)

Location:  Spain, Comunidad Valenciana
Member Since Contact Type Status
Sep 24, 2015 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Stellar Bricks
BrickLink Inventories Administrator (?)
In Technical Issues, SylvainLS writes:
  In Technical Issues, yorbrick writes:
  In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).

I can confirm the same error if searched with 'all items'. If you are
looking for something, try switching to 'catalog items' instead as the
search works there.

It Works For Me™

Working too:
 
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Sep 5, 2025 05:20
 Subject: Re: Searching "backpack" gives Error
 Viewed: 38 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1207)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Yorbricks
In Technical Issues, SylvainLS writes:
  In Technical Issues, yorbrick writes:
  In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).

I can confirm the same error if searched with 'all items'. If you are
looking for something, try switching to 'catalog items' instead as the
search works there.

It Works For Me™

Still failing for me for "all items" search, on android phone and tablet
(both Opera and Brave), Windows 11 (Chrome and Edge) and Fedora (Firefox and
Brave).
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 5, 2025 05:44
 Subject: Re: Searching "backpack" gives Error
 Viewed: 31 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Technical Issues, yorbrick writes:
  […]
  It Works For Me™

Still failing for me for "all items" search, on android phone and tablet
(both Opera and Brave), Windows 11 (Chrome and Edge) and Fedora (Firefox and
Brave).

Works on the same browsers as the other thread (though updated a bit since) and
on Chrome, Samsung browser, & DuckDuckGo on Android.

So I’d say it’s not a browser problem but something in the middle.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Sep 5, 2025 06:01
 Subject: Re: Searching "backpack" gives Error
 Viewed: 38 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1207)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Yorbricks
In Technical Issues, SylvainLS writes:
  In Technical Issues, yorbrick writes:
  […]
  It Works For Me™

Still failing for me for "all items" search, on android phone and tablet
(both Opera and Brave), Windows 11 (Chrome and Edge) and Fedora (Firefox and
Brave).

Works on the same browsers as the other thread (though updated a bit since) and
on Chrome, Samsung browser, & DuckDuckGo on Android.

So I’d say it’s not a browser problem but something in the middle.

Yeah, no doubt.

Interesting that putting some terms in front changes the outcome:
Blue Backpack- works
Legs Backpack - works
Molded Backpack - works
Minifigure Backpack- fails
 Author: Turez View Messages Posted By Turez
 Posted: Sep 5, 2025 05:07
 Subject: Re: Searching "backpack" gives Error
 Viewed: 52 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Turez (47)

Location:  Germany, Niedersachsen
Member Since Contact Type Status
Sep 18, 2012 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Zerut
BrickLink Catalog Administrator (?)
In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).

Also mentioned here:
https://www.bricklink.com/messageThread.asp?ID=357259
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 5, 2025 05:09
 Subject: Re: Searching "backpack" gives Error
 Viewed: 30 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Technical Issues, Turez writes:
  In Technical Issues, Autism_And_I writes:
  Searching backpack in the main search bar results in an Error message.

SP Error : Cannot insert duplicate key row in object 'dbo.tbProductSearchItemCache'
with unique index 'cidxProductSearchItemCache'. The duplicate key value
is (3, 141, -99, Sep 5 2025 2:08AM).

Also mentioned here:
https://www.bricklink.com/messageThread.asp?ID=357259

Oh yeah, that was the backpack already.
 Author: qwertyboy View Messages Posted By qwertyboy
 Posted: Sep 5, 2025 08:34
 Subject: (Cancelled)
 Viewed: 25 times
 Topic: Technical Issues
Cancel Message
Cancel
BrickLink
ID Card

qwertyboy (8631)

Location:  Canada, Alberta
Member Since Contact Type Status
Apr 9, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Maple Bricks
(Cancelled)