When I try to modify an existing home listing I get the following error

user warning: Duplicate entry '238' for key 1 query: INSERT INTO home (hid, vid, home_type, address, city, state, country, zipcode , price , bedrooms , bathrooms , schooldistrict , lotsize , squarefeet , images, latitude, longitude) VALUES ( '238', '614', '5', '7 Oak Grove', 'Hatfield', 'England', 'GB', 'AL10 8', '975', '4', '1', '', '', '0', '', '51.758789', '-0.235443'); in /home/hertslet/public_html/includes/database.mysql.inc on line 172.

This causes a lot of info to be 'forgotten' when amending a property.

I realise this is because I switched 'save revisions' on in the content-types page. I guess the ideal fix is to prevent the 'revisions' field from being enabled for this type of node.

Comments

Michael M’s picture

Michael M commented

Despite the fact that I have a "vid" column, I haven't tested with revisions. I believe the fix may be as easy as changing the "nid" column from a primary key column to just an indexed column.

Michael M’s picture

Michael M commented
Status: Active » Fixed

Fixed and committed. Check the latest release.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.