[wp-trac] [WordPress Trac] #63240: footnotes problem

[WordPress Trac]

#63240: footnotes problem
--------------------------+------------------------------
 Reporter:  kamago        |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  6.7.2
 Severity:  major         |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------
Description changed by sabernhardt:

Old description:

> Hi,
>
> There's a problem with footnotes, everytime we updates footnotes and save
> the post, the footnotes are not up to date. In fact, i managed to find
> something, maybe it will help and i don't know if it's correlated or not,
> you'll tell.
>
> I saw in phpmyadmin, everytime we save the post, a new line in table
> "postmeta" appear, that contain a new "post_id" with
> "meta_key"-"footnotes" is created. This new line does not contain the
> original id of the post, a new id for the post is associated.
>
> Exemple in database, table "postmeta" :
> meta_id     post_id     meta_key    meta_value
> 1769        1595        footnotes   [{whatever...}]
> 1770        1596        footnotes   [{whatever2...}]
> and so on.
>
> And everytime we edit the post, it seems it loads the footnotes with
> original post_id, and not the last saved. So, maybe there's a problem
> incrementing post_id in this table. (and maybe it can collide with other
> posts ??)
>
> (i hope i'm clear, i'm sorry for my english if it is not clear)

New description:

 Hi,

 There's a problem with footnotes, everytime we updates footnotes and save
 the post, the footnotes are not up to date. In fact, i managed to find
 something, maybe it will help and i don't know if it's correlated or not,
 you'll tell.

 I saw in phpmyadmin, everytime we save the post, a new line in table
 `postmeta` appear, that contain a new `post_id` with
 `meta_key`-"footnotes" is created. This new line does not contain the
 original id of the post, a new id for the post is associated.

 Example in database, table "postmeta" :

 ||= meta_id =||= post_id =||= meta_key =||= meta_value     =||
 || 1769      || 1595      || footnotes  || [{whatever...}]  ||
 || 1770      || 1596      || footnotes  || [{whatever2...}] ||

 and so on.

 And everytime we edit the post, it seems it loads the footnotes with
 original `post_id`, and not the last saved. So, maybe there's a problem
 incrementing `post_id` in this table. (and maybe it can collide with other
 posts ??)

 (i hope i'm clear, i'm sorry for my english if it is not clear)

--

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