Title: Plugin is duplicating posts in the database
Last modified: August 20, 2016

---

# Plugin is duplicating posts in the database

 *  Resolved [hypeon](https://wordpress.org/support/users/hypeon/)
 * (@hypeon)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/)
 * I have installed the plugin for the latest WordPress 3.5. When I Update/Publish
   a post I get this error:
 *     ```
       WordPress database error Duplicate entry '962-post-1' for key 'PRIMARY' for query INSERT INTO wpi_uam_accessgroup_to_object (
                   		group_id,
                   		object_id,
                   		object_type
                   	) VALUES (
                   		'1',
                   		'962',
                   		'post'
                   	) made by edit_post, wp_update_post, wp_insert_post, do_action('pre_post_update'), call_user_func_array, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), call_user_func_array, UserAccessManager->savePostData, UserAccessManager->_saveObjectData, UamUserGroup->save
       WordPress database error Duplicate entry '976-post-1' for key 'PRIMARY' for query INSERT INTO wpi_uam_accessgroup_to_object (
                   		group_id,
                   		object_id,
                   		object_type
                   	)
       ```
   
 * Looked into the database and found my post had been duplicated multiple times.
   The plugin works in the frontend.
 * Also when I ammend the User’s Group details it generates this:
 *     ```
       WordPress database error Duplicate entry '611-post-1' for key 'PRIMARY' for query INSERT INTO wpi_uam_accessgroup_to_object (
                   		group_id,
                   		object_id,
                   		object_type
                   	) VALUES (
                   		'1',
                   		'611',
                   		'post'
       ```
   
 * Installed 3.3.2 on the same server and it works fine.
 * Overall apart from the above, the plugin is exactly what I needed, I would also
   like to know if it was possible to make the tick boxes in the User panel visible
   to the user, as I want them to be able to change select the group themselves,
   but I do not want to change them to an admin role.
 * Any help or suggestions appreciated.
 * [http://wordpress.org/extend/plugins/user-access-manager/](http://wordpress.org/extend/plugins/user-access-manager/)

Viewing 13 replies - 1 through 13 (of 13 total)

 *  [Graucho Marx](https://wordpress.org/support/users/graucho-marx/)
 * (@graucho-marx)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352913)
 * I have just seen this plugin, indeed, duplicates all database’s posts entries.
   
   Is there any way to solve this? Is this a big problem?
 * Thanks
 *  [Jhosmorwen](https://wordpress.org/support/users/jhosmorwen/)
 * (@jhosmorwen)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352918)
 * i have the same problem, please, help us…
 *  [alfredo49](https://wordpress.org/support/users/alfredo49/)
 * (@alfredo49)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352921)
 * the same… real alternative to this plugin?.. is definitely abandoned
 *  [Nigel D](https://wordpress.org/support/users/nigeldyer/)
 * (@nigeldyer)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352922)
 * I am running UAM on two sites with WP 3.5.1 and don’t appear to have duplicated
   posts. I certainly don’t get error messages, the post revision list appears sane,
   and I have checked using phpMyAdmin on one site when I update a post and the 
   database entries looks OK. I suspect that there may be an interaction between
   this plugin and another plugin. I do wonder whether it is something else that
   inserts multiple posts (which normally goes undetected), and both inserts trigger
   UAM to do an identical database insert, and the second one fails. Do the duplicate
   post entries stop happening when UAM is no not active?
 *  Plugin Author [gm_alex](https://wordpress.org/support/users/gm_alex/)
 * (@gm_alex)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352925)
 * Could somebody with this error list the plugins which he uses or better send 
   me a database dump.
 *  [alfredo49](https://wordpress.org/support/users/alfredo49/)
 * (@alfredo49)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352926)
 * in my case the active plugins are:
    Adrotate bbpress breadcrumb navxt contact
   form 7 event organiser image widget link library list category post login with
   ajax member list pagelinks user avatar wp e-commerce
 *  [alfredo49](https://wordpress.org/support/users/alfredo49/)
 * (@alfredo49)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352927)
 * ) realizada por edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’),
   call_user_func_array, UserAccessManager->savePostData, UserAccessManager->_saveObjectData,
   UamUserGroup->save
    [02-May-2013 07:57:06] Error Duplicate entry ‘8577-post-1’
   for key ‘PRIMARY’ de la base de datos de WordPress para la consulta INSERT INTO
   wp_uam_accessgroup_to_object ( group_id, object_id, object_type ) VALUES ( ‘1’,‘
   8577’, ‘post’ ) realizada por edit_post, wp_update_post, wp_insert_post, do_action(‘
   save_post’), call_user_func_array, UserAccessManager->savePostData, UserAccessManager-
   >_saveObjectData, UamUserGroup->save
 *  Plugin Author [gm_alex](https://wordpress.org/support/users/gm_alex/)
 * (@gm_alex)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352928)
 * I created a new version which optimize the sql in the save function. At the moment
   there is an sql insert query for each item, in the new version it’s only one,
   maybe this will solve this. It will be released within the next days. Than I 
   will give a note here and you can test again.
 *  [Nigel D](https://wordpress.org/support/users/nigeldyer/)
 * (@nigeldyer)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352929)
 * I am running the same theme, same content and same plugins on two different sites
   and neither has the duplicated posts problem. I have noticed however that the
   same operation results in different numbers of SQL queries, possibly as a result
   of different versions of PHP (5.3.14/5.3.24) or mySQL. It could be that it is
   differences at this level that explains why it is only seen on some sites.
 *  Plugin Author [gm_alex](https://wordpress.org/support/users/gm_alex/)
 * (@gm_alex)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352930)
 * New version is released, please give it a try and give feedback. Thanks.
 *  [alfredo49](https://wordpress.org/support/users/alfredo49/)
 * (@alfredo49)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352931)
 * The error still happening:
 * [03-May-2013 07:34:35] Error Duplicate entry ‘1430-post-1’ for key ‘PRIMARY’ 
   de la base de datos de WordPress para la consulta INSERT INTO wp_uam_accessgroup_to_object(
   
   group_id, object_id, object_type ) VALUES (‘1’, ‘1430’, ‘post’), (‘1’, ‘1432’,‘
   post’), (‘1’, ‘1439’, ‘post’), (‘1’, ‘1442’, ‘post’), (‘1’, ‘1444’, ‘post’), (‘
   1’, ‘1447’, ‘post’), (‘1’, ‘1449’, ‘post’), (‘1’, ‘1452’, ‘post’), (‘1’, ‘1454’,‘
   post’), (‘1’, ‘1456’, ‘post’), (‘1’, ‘1458’, ‘post’), (‘1’, ‘1461’, ‘post’), (‘
   1’, ‘1465’, ‘post’), (‘1’, ‘1467’, ‘post’), (‘1’, ‘1469’, ‘post’), (‘1’, ‘1471’,‘
   post’), (‘1’, ‘1473’, ‘post’), (‘1’, ‘1475’, ‘post’), (‘1’, ‘1477’, ‘post’), (‘
   1’, ‘1479’, ‘post’), (‘1’, ‘1481’, ‘post’), (‘1’, ‘1483’, ‘post’), (‘1’, ‘1485’,‘
   post’), (‘1’, ‘1487’, ‘post’), (‘1’, ‘1489’, ‘post’), (‘1’, ‘1491’, ‘post’), (‘
   1’, ‘1493’, ‘post’), (‘1’, ‘1496’, ‘post’), (‘1’, ‘1498’, ‘post’), (‘1’, ‘1500’,‘
   post’), (‘1’, ‘1503’, ‘post’), (‘1’, ‘1505’, ‘post’), (‘1’, ‘1507’, ‘post’), (‘
   1’, ‘1509’, ‘post’), (‘1’, ‘1511’, ‘post’), (‘1’, ‘1513’, ‘post’), (‘1’, ‘1515’,‘
   post’), (‘1’, ‘1518’, ‘post’), (‘1’, ‘1528’, ‘post’), (‘1’, ‘1568’, ‘post’), (‘
   1’, ‘1570’, ‘post’), (‘1’, ‘1572’, ‘post’), (‘1’, ‘1574’, ‘post’), (‘1’, ‘1577’,‘
   post’), (‘1’, ‘1579’, ‘post’), (‘1’, ‘1581’, ‘post’), (‘1’, ‘1583’, ‘post’), (‘
   1’, ‘1585’, ‘post’), (‘1’, ‘1587’, ‘post’), (‘1’, ‘1589’, ‘post’), (‘1’, ‘1591’,‘
   post’), (‘1’, ‘1593’, ‘post’), (‘1’, ‘1595’, ‘post’), (‘1’, ‘1597’, ‘post’), (‘
   1’, ‘1599’, ‘post’), (‘1’, ‘1603’, ‘post’), (‘1’, ‘1605’, ‘post’), (‘1’, ‘1609’,‘
   post’), (‘1’, ‘1611’, ‘post’), (‘1’, ‘1613’, ‘post’), (‘1’, ‘1615’, ‘post’), (‘
   1’, ‘1617’, ‘post’), (‘1’, ‘1619’, ‘post’), (‘1’, ‘1625’, ‘post’), (‘1’, ‘1627’,‘
   post’), (‘1’, ‘1629’, ‘post’), (‘1’, ‘1631’, ‘post’), (‘1’, ‘1633’, ‘post’), (‘
   1’, ‘1635’, ‘post’), (‘1’, ‘1637’, ‘post’), (‘1’, ‘1639’, ‘post’), (‘1’, ‘1643’,‘
   post’), (‘1’, ‘1645’, ‘post’), (‘1’, ‘1647’, ‘post’), (‘1’, ‘1649’, ‘post’), (‘
   1’, ‘1655’, ‘post’), (‘1’, ‘1657’, ‘post’), (‘1’, ‘1659’, ‘post’), (‘1’, ‘1661’,‘
   post’), (‘1’, ‘1665’, ‘post’), (‘1’, ‘1667’, ‘post’), (‘1’, ‘1669’, ‘post’), (‘
   1’, ‘1673’, ‘post’), (‘1’, ‘1675’, ‘post’), (‘1’, ‘1677’, ‘post’), (‘1’, ‘1679’,‘
   post’), (‘1’, ‘1681’, ‘post’), (‘1’, ‘1683’, ‘post’), (‘1’, ‘1685’, ‘post’), (‘
   1’, ‘1687’, ‘post’), (‘1’, ‘1689’, ‘post’), (‘1’, ‘1691’, ‘post’), (‘1’, ‘1693’,‘
   post’), (‘1’, ‘1698’, ‘post’), (‘1’, ‘1700’, ‘post’), (‘1’, ‘1702’, ‘post’), (‘
   1’, ‘1704’, ‘post’), (‘1’, ‘1707’, ‘post’), (‘1’, ‘1709’, ‘post’), (‘1’, ‘1711’,‘
   post’), (‘1’, ‘1713’, ‘post’), (‘1’, ‘1716’, ‘post’), (‘1’, ‘1718’, ‘post’), (‘
   1’, ‘1720’, ‘post’), (‘1’, ‘1722’, ‘post’), (‘1’, ‘1724’, ‘post’), (‘1’, ‘1726’,‘
   post’), (‘1’, ‘1728’, ‘post’), (‘1’, ‘1730’, ‘post’), (‘1’, ‘1732’, ‘post’), (‘
   1’, ‘1734’, ‘post’), (‘1’, ‘1736’, ‘post’), (‘1’, ‘1738’, ‘post’), (‘1’, ‘1740’,‘
   post’), (‘1’, ‘1742’, ‘post’), (‘1’, ‘1744’, ‘post’), (‘1’, ‘1746’, ‘post’), (‘
   1’, ‘1748’, ‘post’), (‘1’, ‘1750’, ‘post’), (‘1’, ‘1752’, ‘post’), (‘1’, ‘1754’,‘
   post’), (‘1’, ’17
 *  Plugin Author [gm_alex](https://wordpress.org/support/users/gm_alex/)
 * (@gm_alex)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352932)
 * Hey new version is out, could you check again? Thanks.
 *  [alfredo49](https://wordpress.org/support/users/alfredo49/)
 * (@alfredo49)
 * [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352933)
 * Everything seems ok! no error returned for the moment when i updated a post.
 * Thxs for support!
 * Regards

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘Plugin is duplicating posts in the database’ is closed to new replies.

 * ![](https://ps.w.org/user-access-manager/assets/icon.svg?rev=1563783)
 * [User Access Manager](https://wordpress.org/plugins/user-access-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-access-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-access-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/user-access-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-access-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-access-manager/reviews/)

## Tags

 * [boxes](https://wordpress.org/support/topic-tag/boxes/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [duplicate](https://wordpress.org/support/topic-tag/duplicate/)
 * [post](https://wordpress.org/support/topic-tag/post/)
 * [select](https://wordpress.org/support/topic-tag/select/)
 * [tick](https://wordpress.org/support/topic-tag/tick/)

 * 13 replies
 * 6 participants
 * Last reply from: [alfredo49](https://wordpress.org/support/users/alfredo49/)
 * Last activity: [13 years ago](https://wordpress.org/support/topic/plugin-is-duplicating-posts-in-the-database/#post-3352933)
 * Status: resolved