WordPress.org

Forums

User Access Manager
[resolved] Plugin is duplicating posts in the database (14 posts)

  1. hypeon
    Member
    Posted 2 years ago #

    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/

  2. Graucho Marx
    Member
    Posted 2 years ago #

    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

  3. Jhosmorwen
    Member
    Posted 2 years ago #

    i have the same problem, please, help us...

  4. alfredo49
    Member
    Posted 2 years ago #

    the same... real alternative to this plugin?.. is definitely abandoned

  5. Nigel D
    Member
    Posted 2 years ago #

    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?

  6. GM_Alex
    Member
    Plugin Author

    Posted 2 years ago #

    Could somebody with this error list the plugins which he uses or better send me a database dump.

  7. alfredo49
    Member
    Posted 2 years ago #

    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

  8. alfredo49
    Member
    Posted 2 years ago #

    ) 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

  9. GM_Alex
    Member
    Plugin Author

    Posted 2 years ago #

    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.

  10. Nigel D
    Member
    Posted 2 years ago #

    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.

  11. GM_Alex
    Member
    Plugin Author

    Posted 2 years ago #

    New version is released, please give it a try and give feedback. Thanks.

  12. alfredo49
    Member
    Posted 2 years ago #

    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

  13. GM_Alex
    Member
    Plugin Author

    Posted 2 years ago #

    Hey new version is out, could you check again? Thanks.

  14. alfredo49
    Member
    Posted 2 years ago #

    Everything seems ok! no error returned for the moment when i updated a post.

    Thxs for support!

    Regards

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • User Access Manager
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic