MySQL Forums
Forum List  »  Newbie

Re: Wordpress Database Problem
Posted by: White Brandon
Date: October 19, 2015 03:19PM

I just browsed my DB to check those records by timeline. Here is the data (I omit the data after time coz there are too many). Before Oct 10th, every data entry in DB is organized by timeline. The newest post was stored at the end of wp_posts table (bottom).

After Oct 10th, the data entry looks random. The new post will be inserted into the table in a random order, other than at the bottom of the table it was supposed to be. I have been running my site for over 4 years, and I check my wp_posts table regularly. How come it suddenly changed like that after Oct 10th? I don't get it.



Before Oct 10th
-----------------------------
2015-10-01 15:10:13
2015-10-01 18:54:59
2015-10-01 21:05:43
2015-10-01 22:10:09
2015-10-02 16:38:09
2015-10-02 18:00:42
2015-10-02 22:15:10
2015-10-03 01:33:01
2015-10-03 13:14:29
2015-10-03 14:21:49
2015-10-03 14:21:50
2015-10-03 18:30:02
2015-10-03 18:30:12
2015-10-03 20:29:54
2015-10-03 20:31:01
2015-10-04 00:15:50
2015-10-04 14:55:22
2015-10-04 15:49:09
2015-10-04 15:49:12
2015-10-04 17:00:19
2015-10-05 00:10:45
2015-10-05 01:24:21
2015-10-05 14:12:34
2015-10-06 00:43:49
2015-10-06 03:48:40
2015-10-06 11:28:53
2015-10-06 11:28:55
2015-10-06 11:28:57
2015-10-06 11:28:59
2015-10-06 11:59:03
2015-10-06 12:06:12
2015-10-07 12:46:33
2015-10-07 15:27:42
2015-10-07 15:52:43
2015-10-07 15:58:49
2015-10-08 01:10:01
2015-10-08 20:13:30
2015-10-08 20:38:16



After Oct 10th
-----------------------------
2015-10-02 16:38:09
2015-10-18 20:25:48
2015-10-13 21:02:58
2015-10-04 15:49:09
2015-10-14 00:34:58
2015-10-12 00:10:31
2015-10-11 06:30:41
2015-10-05 14:12:34
2015-10-10 14:49:35
2015-10-07 15:27:42
2015-10-08 20:38:16
2015-10-10 14:55:32
2015-10-09 16:44:05

Options: ReplyQuote


Subject
Written By
Posted
October 19, 2015 12:15PM
Re: Wordpress Database Problem
October 19, 2015 03:19PM
October 30, 2015 05:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.