douhuxi4145 2018-04-17 13:01
浏览 86

修复WordPress数据库错误对于查询INSERT INTO的键'PRIMARY'重复输入'0'

On Wordpress 4.9.5, I am getting this error on the admin panel when I enable the Simple Error Log plugin.

Here is the error that we get:

WordPress database error Duplicate entry '0' for key 'PRIMARY' for query INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, post_type, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES (14, '2018-04-17 18:24:27', '0000-00-00 00:00:00', '', '', 'Auto Draft', '', 'auto-draft', 'post', 'open', 'open', '', '', '', '', '2018-04-17 18:24:27', '0000-00-00 00:00:00', 0, 0, '', '') made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_quick_press, get_default_post_to_edit, wp_insert_post

I have tried repair this table from PHPMYADMIN, also tried this https://blog.sqlauthority.com/2016/09/12/mysql-fix-error-wordpress-database-error-duplicate-entry-key-primary-query-insert-wp_options/ and https://wordpress.stackexchange.com/questions/165277/new-posts-defaulting-to-0-primary-key but it doesn't resolve.

Pls advise what could be wrong and how to fix that.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥15 cmd cl 0x000007b
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line