• Resolved hypeon

    (@hypeon)


    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.

    https://www.ads-software.com/extend/plugins/user-access-manager/

Viewing 13 replies - 1 through 13 (of 13 total)
  • 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

    i have the same problem, please, help us…

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

    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

    (@gm_alex)

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

    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

    ) 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

    (@gm_alex)

    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.

    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

    (@gm_alex)

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

    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

    (@gm_alex)

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

    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.