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. What is an ORM, how does it work, and how should I use one? [closed]
  22. What is the difference between an ORM and an ODM?
  23. What is this JavaScript “require”?
  24. Rename a table in MySQL
  25. How should I tackle –secure-file-priv in MySQL?
  26. What is this JavaScript “require”?
  27. What is “Advanced” SQL?
  28. What’s the difference between identifying and non-identifying relationships?
  29. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  30. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  31. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  32. What are the differences between B trees and B+ trees?
  33. MySQL SELECT increment counter
  34. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  35. Example of a strong and weak entity types
  36. Oracle SQL query for Date format
  37. phpMyAdmin – Error > Incorrect format parameter?
  38. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  39. Difference between partition key, composite key and clustering key in Cassandra?
  40. How SID is different from Service name in Oracle tnsnames.ora
  41. What is a relation in database terminology?
  42. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  43. Database vs File system storage
  44. Can I have multiple primary keys in a single table?
  45. Exclude Statement in SQL
  46. How do you query for “is not null” in Mongo?
  47. What is a file based database?
  48. Is it fine to have foreign key as primary key?
  49. Storing Images in DB – Yea or Nay?
  50. Using wpdb to connect to a separate database
  51. how to Optimize WordPress database for 10 million post? [duplicate]
  52. MySQL Database User: Which Privileges are needed?
  53. Why is my database import losing text widget data?
  54. Database synchronization between dev/staging and production
  55. Keeping WP database synced across multiple developers using git
  56. WPDB Insert or if exists Update
  57. Multiple developers / editors working on a site in progress
  58. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  59. get_results using wpdb
  60. Will it break my site if I delete all transient records in wp_options table?
  61. Checking if Database Table exists
  62. Why WordPress choose data serialization over json_encode?
  63. What’s the simplest way to backup my WordPress database?
  64. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  65. $wpdb won’t insert NULL into table column
  66. Relaunch 4.2 utf8mb4 database upgrade
  67. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  68. Safest way to bulk delete post revisions
  69. Please explain how WordPress works with MySQL character set and collation at a low level
  70. Solution for database version control and deployment?
  71. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  72. How many users can WordPress handle?
  73. Get error messages when $wpdb->insert() returns false?
  74. Detecting errors generated by $wpdb->get_results()
  75. Staging sites, how do you manage synchronising updates in the DB?
  76. Does dbDelta delete columns as well?
  77. How to get the post publish date outside the loop?
  78. MariaDB as a backend database
  79. wpdb update add current timestamp not working
  80. Site stuck in “Database Update Required” loop
  81. How to fetch Data in WordPress using MySQLi or $wpdb
  82. WordPress Database lost auto increment
  83. Count & Display Database Queries
  84. Connect to database using wordpress wp-config file
  85. How can I make a WordPress database portable and url independent?
  86. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  87. wpdb->insert multiple record at once
  88. How to migrate a HTTPS WordPress installation to localhost?
  89. Two WordPress sites sharing the same content
  90. How to integrate custom database table in WordPress and using WordPress functions
  91. Reset Post IDs to less than 64bit integer
  92. WP Multisite: load content from site X on site Y
  93. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  94. Custom form that store input in database
  95. Restoring WordPress posts from database only
  96. What is the purpose of the option name hack_file in the options table?
  97. Where can I find the database changes between WordPress versions?
  98. Automate WordPress Database Upgrade
  99. Database connection close
  100. WordPress database error with latest WP – “WP_termmeta doesn’t exist”
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)