large number (bigint) for post ID issue in database

The ID field in the wp_post table should be an UNSIGNED BIGINT in MySQL.

That means it can store values from 0 to 18,446,744,073,709,551,615 ((2^64)-1).

See the MySQL documentation article for that.

Your value of 796,978,707,878,960,002 is a not bigger than the allowed maximum value.
So in theory it should be able to handle that ID value, but the database clearly cannot handle values that big.

Check on the database: which version are you using, is it really an UNSIGNED BIGINT on your end?

Related Posts:

  1. Issue with wp_insert_post and post_content field error Could not update post in the database
  2. Importing posts from old website to new conflicting post ID’s?
  3. Using table lock with wp_insert_post?
  4. Get all tags not just first 10 with wp api 2.0
  5. What is the proper way to validate and sanitize JSON response from REST API?
  6. Insert post in another database
  7. Data storage for JS app using WP REST API
  8. How to combine multiple wp_insert_post into one in order to gain better performance
  9. Sending posts from Python to WordPress
  10. Custom Post Type not showing anything added by code anymore?
  11. How can I query the db to access current post information?
  12. How to access a table in a wordpress database using REST API?
  13. How to rerieve comments and their replies from DB
  14. Call to a member function insert()
  15. Get id from database
  16. Using class id from array for query
  17. Create hundreds of users with just ID in phpMyAdmin
  18. WordPress API standard compliance and specification for external database [closed]
  19. If an Application Password is accidentally revoked, is there any way to restore it?
  20. How is better to store at DB 1-side relationsip from CPT to many Taxonomies Terms ID’s?
  21. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  22. Oracle SQL query for Date format
  23. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  24. Can I have multiple primary keys in a single table?
  25. Using wpdb to connect to a separate database
  26. How can I make a WordPress database portable and url independent?
  27. Database connection close
  28. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  29. Exporting revisions
  30. WP_Options ID high
  31. How to use multiple database in wordpress?
  32. Is removing orphaned wp_postmeta records safe?
  33. What ALL can cause “Another update is currently in progress.”? [closed]
  34. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  35. Set Display Name to first and last name (phpmyadmin SQL Query)
  36. How to fix unchanged URLs in Database after running serialized search and replace script?
  37. Trigger Plugin database update after git pull
  38. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  39. Cannot update custom database table row
  40. SQL Error wp_commentmeta – incorrect table definition
  41. WordPress database error – Error in SQL syntax – I can’t identify any error?
  42. Change WordPress prefix for only one table?
  43. Two websites one database, administrator not working on second website
  44. Select two sums with single get_var statement
  45. How to get the SQL of the changes made to the database from an update or upgrade?
  46. Merging two wp_posts tables while avoiding duplicates
  47. How can i add custom fields into the contact form 7 [closed]
  48. Store partial database to an archive database time to time
  49. Move out of sync posts from one database to another
  50. MS Access to manage WordPress Database
  51. Migration: Copying database content to a different server
  52. Remove empty rows from the database
  53. Custom WordPress Table wpdb
  54. Check if post id exist in table than only update instead of inserting new row
  55. Detail explanation of wordpress database fields and metatag list [closed]
  56. CreateOrUpdate in WordPress
  57. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  58. How to get a list of WordPress default database tables?
  59. Can local WordPress installs share /wp-content/ folder and database?
  60. how to encyrpt DB_PASSWORD in wp-config
  61. Choosing http or https during manual installation of WordPress and database
  62. Stringing together content from different databases
  63. Backing up WordPress database and files
  64. Safely store code(html/js..) into database
  65. Why does wp_links still exist in the db schema?
  66. Creating and Using Tables in the WordPress Database
  67. can’t upgrade wordpress or install plugins, it seems to “think” it’s still on a local installation
  68. Compare User meta_value with Product meta_value
  69. Storing user’s data on external database on other server
  70. How to insert a value to decimal type field using wpdb->prepare?
  71. Sql query to get all metadata for a post
  72. Where do I put my create_new_table function()?
  73. How to import products in host instead of database on wordpress?
  74. Having all “non-PHP” files on a different server
  75. syntax error for changing user role from database
  76. Finding a page holding a specific string/URL that is used in the content
  77. “wordpress error in establishing database connection” and missing tables
  78. get_option() does unserialize and don’t remove \
  79. Adding last value from Database as text in WordPress Page
  80. Want to update value in database. But it says update() on null
  81. Merging development site with live site
  82. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  83. I have a WordPress 4.6 database dump – how do I use it in a new install?
  84. Checking if the data already exsis in the wp database – custom plugin
  85. live site do not update after importing sql database
  86. Transforming an wp_options database array into a javascript obect?
  87. Selecting NULL value from the database
  88. How can I retrieve data from alternate database using wpdb class?
  89. Database connection close
  90. WordPress Database Charset/Collate
  91. User accounts for saving form data?
  92. Print output of Table Creation
  93. Trying to edit a WP site locally using MAMP
  94. How to delete field using WPDB?
  95. Log IP of users who click a button? [closed]
  96. DROP TABLE IF EXISTS `wp_options` error?
  97. Problem with form database connectivity
  98. Server database problem
  99. Best way to search and replace within serialized database strings?
  100. Sharing plugin tables between 2 sites in the same database
deneme bonusu veren sitelerbahis casinomakrobetceltabetpinbahispolobetpolobet girişpinbahis girişmakrobet girişpulibet girişmobilbahis girişkolaybet giriş