"WordPress database error Duplicate entry" php logs

  • Resolved andfarr

    (@andfarr)


    12 years, 10 months ago

    My php error log becomes several megabytes big during a backup with errors of the type:

    [27-May-2013 09:30:51 UTC] WordPress database error Duplicate entry ‘/home5/andrexw1/public_html/blog/wp-content/plugins/w3-total-cac’ for key ‘file’ for query INSERT INTO cb1w01b3gd_wpb2d_processed_files (file) VALUES (‘/home5/andrexw1/public_html/blog/wp-content/plugins/w3-total-cache/wp-content/object-cache.php’) made by do_action_ref_array, call_user_func_array, run_dropbox_backup, WP_Backup->execute, WP_Backup->backup_path, WP_Backup_Processed_Files->add_files

    It appears to do this for plugins, themes, uploads, etc. I can not detect a discernible pattern to it. But like I said, the errors are persistent and numerous to the point that the error log becomes megabytes large (last one was ~8mb). I am using the premium zip extension, as well.

    http://wordpress.org/extend/plugins/wordpress-backup-to-dropbox/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    12 years, 10 months ago

    Thanks for letting me know.

    I will take a look at my code and see what I can find.

    Cheers,
    Mikey

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    12 years, 10 months ago

    Can you please let me know if you get the same error log entries from a backup using 1.5.4.

    Cheers,
    Mikey

    Thread Starter andfarr

    (@andfarr)

    12 years, 10 months ago

    Yes, that is a message from 1.5.4. Actually this has been occurring for at least this most recent update and the previous one as well. I just reverted back to 1.4.5 after trying a few backups with each release when I found the error persisted instead of messing with it. 1.4.5 works for me with a smaller sized backup so that is what I have been relying on.

    Let me know if there is anything else I can do to help.

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    12 years, 10 months ago

    Thanks mate. I’ll investigate.

    Apart from filling the logs the warning should not affect the normal operation of a backup.

    Cheers,
    Mikey

    Thread Starter andfarr

    (@andfarr)

    12 years, 10 months ago

    From what I recall, the very first backup (which was manually initiated) following the update of the plugin to the most recent version worked normally without errors. It was subsequent updates that is where the errors began occurring. Not sure if that helps you at all, but that was how I think it went this most recent run at it.

    Thanks Mikey!
    Andrew

    Plugin Contributor Michael De Wildt

    (@michaeldewildt)

    12 years, 10 months ago

    Gday mate,

    After the release of 1.5 I found out that my testing servers had a WP feature turned on that suppressed database errors. I am not sure if this is default for WP but most hosts appear to opt into errors being displayed either way.

    This is why people where seeing dupe errors that do not affect the operation of a backup. I have since made a change to better insure that the value does not exist before inserting ergo fixing the warning.

    Cheers,
    Mikey

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

The topic ‘"WordPress database error Duplicate entry" php logs’ is closed to new replies.