We've been using views natural sort on many sites without issues for a couple of years, but with the most recent upgrade to views, upon saving any node we the admin gets a warning message, which is also repeated x the number of nodes if one chooses the rebuild title index option on the views natural sort settings page:

For example:
user warning: Duplicate entry '692-title' for key 'PRIMARY' query: INSERT INTO views_natural_sort (nid, field, content) VALUES (692, 'title', 'WINDS CHANGE ARE BLOWING') in /var/www/vhosts/website-express.co.uk/httpdocs/includes/common.inc on line 3538.
user warning: Duplicate entry '693-title' for key 'PRIMARY' query: INSERT INTO views_natural_sort (nid, field, content) VALUES (693, 'title', 'SINSINAPO') in /var/www/vhosts/website-express.co.uk/httpdocs/includes/common.inc on line 3538.
user warning: Duplicate entry '694-title' for key 'PRIMARY' query: INSERT INTO views_natural_sort (nid, field, content) VALUES (694, 'title', 'Eat the Change Christmas Fair') in /var/www/vhosts/website-express.co.uk/httpdocs/includes/common.inc on line 3538.

The module still seems to work and doesn't present errors to casual users of the site, but something is clearly not quite right now...

Comments

generalredneck’s picture

generalredneck
him/his
Primary language English
Location Texas, USA 🇺🇸
commented

Sorry about the late reply, I just recently took co-maintainership on this module. I'll be looking into this shortly. I'll give you any update I might find.

Just incase I need more info:
Have you noticed any other issues that may be symptoms? Also is this only isolated to drupal installs where views was upgraded and not installed directly at 2.16? If so, can you provide what version you were upgrading from?

generalredneck’s picture

generalredneck
him/his
Primary language English
Location Texas, USA 🇺🇸
commented
Status: Active » Closed (cannot reproduce)