WordPress database error Duplicate entry

  • chiefme

    (@matasdipolislt)


    2 years, 12 months ago

    There is php errors related to this plugnin.
    Example:
    [31-Mar-2022 11:31:03 UTC] WordPress database error Duplicate entry 'EE90001' for key 'parcelshop_id' for query INSERT INTO 'w254p_dpd_terminals' ('parcelshop_id', 'company', 'country', 'city', 'pcode', 'street', 'email', 'phone', 'distance', 'longitude', 'latitude', 'cod', 'mon', 'tue', 'wed', 'thu', 'fri', 'sat', 'sun') VALUES ('EE90001', 'Automaat Tallinna ?ism?e Maxima XX', 'EE', 'Tallinn', '13512', '?ism?e tee 46', NULL, NULL, '0', '24.64727', '59.411726', '1', '00:01-12:00|12:00-23:59', '00:01-12:00|12:00-23:59', '00:01-12:00|12:00-23:59', '00:01-12:00|12:00-23:59', '00:01-12:00|12:00-23:59', '00:01-12:00|12:00-23:59', '00:01-12:00|12:00-23:59') made by do_action_ref_array('dpd_parcels_country_update'), WP_Hook->do_action, WP_Hook->apply_filters, Dpd_Baltic_Admin::country_parcels_list, Dpd_Baltic_Admin::update_parcels_list

    • This topic was modified 2 years, 12 months ago by chiefme.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author dpdbaltics

    (@dpdbaltics)

    @matasdipolislt Hello,
    From the error i can see that you have small problem with our plugin database. This problem is very rare and this happen’s because of DPD plugin connection with other plugins for example: Woocommerce. Sometimes database getting some bugs. To fix this bug first of all you need to try to create your website backup and after that you need to clean your database with specific plugin (wp-rocket plugin), but don’t forget to do your website backup to save current data in one file before clearing. If it help’s (it should), let us know.

    Thread Starter chiefme

    (@matasdipolislt)

    Hello,
    the problem is on almost all of our client websites that have Woocommerce.
    If you are already familiar with that problem, may you be able to suggest a manual solution to the problem, for example witch tables to delete/drop/truncate or maybe there are other ways.

    Hi, I get the same error on all websites that use this plugin. Cleaning / optimising the DB with WP-Sweep did NOT solve the issue.

    Is there another way? Are you addressing this in the next release?

    Same problem for my clients too. Please fix this, because log file is full and we can’t track other problems.

    Thank you!

    Plugin Author dpdbaltics

    (@dpdbaltics)

    @andrius @rydelhouse @chiefme
    Hello,
    Thank you for informing that issue still exists. We will look as deep as possible into this problem. If wp-rocket plugin not helping with that for now you need to try to verify and update database. You can do that by pressing *WooCommerce* -> *Status* then in menu choose *Tools*. After you can see a lot of options below, but try to find *Update Database* and *Verify base database tables* so try to update and verify them it could help. And do not forget to create a backup. Let us know if it helps.

    @dpdbaltics neither the update nor the verification solve the issue. The error log is full of entries by the DPD plugin.

    Plugin Author dpdbaltics

    (@dpdbaltics)

    Hello everyone,

    This issue is currently under review and should be fixed with the upcoming update. Sorry for the inconvenience

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WordPress database error Duplicate entry’ is closed to new replies.