[wp-trac] [WordPress Trac] #29917: All posts show as (no title) after migration

[WordPress Trac]

#29917: All posts show as (no title) after migration
--------------------------+----------------------
 Reporter:  mark.waters   |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.0
 Severity:  normal        |  Resolution:  invalid
 Keywords:                |     Focuses:
--------------------------+----------------------
Changes (by johnbillion):

 * keywords:  reporter-feedback =>
 * status:  new => closed
 * focuses:  multisite =>
 * resolution:   => invalid
 * milestone:  Awaiting Review =>


Comment:

 Replying to [comment:6 mark.waters]:
 > Is there a way to get around this ?
 On a 32 bit system, no. If you need to maintain such high post IDs, then
 you'll need to move back to a 64 bit system.

 That said, I would do some investigation into why you have 4.8 billion
 rows in your posts table without knowing about it. I suspect something
 incremented the `auto_increment` value at some point so it's jumped right
 up (and you don't actually have billions of rows). If not, then you may
 have a runaway process on the site which is populating the posts table
 (visitor hits, tweets, spam, etc).

 Closing as invalid based on this. Hope you get it sorted!

--
Ticket URL: <https://core.trac.wordpress.org/ticket/29917#comment:7>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform