why no posts?

meshurp · 20 Feb 2005, 01:35

i tried to post a reply to fred on one of his topics (online) i submitted it then went to view my post but it was not there. i have done this twice and nothing happened.

any ideas why?

meshurp · 20 Feb 2005, 01:38

i just checked the previous pageand it appaers to have posted mine on the end of the page before the most recent one and shunted the others along.

R. · 20 Feb 2005, 14:17

phpBB originally uses a huge (and probably slow, because it needs lots of memory) query to pull thread data from the database. As our old server sometimes had performance issues, I replaced that huge query with two smaller ones: one index query and one data query. The index query decides about the topic display order and it assumed that all posts have an ascending, unique post id (regardless of the post time). Your messages however have a post id that is higher than posts that were made later (probably due to delayed writes to the database). That's why your messages were shown on the wrong page.

Anyway, the index query is fixed now and voilà, it works.

20 Feb 2005, 01:35	#1
meshurp Super Loafer Join Date: 20.04.2003 Location: In The World, somewhere... Posts: 444	why no posts? i tried to post a reply to fred on one of his topics (online) i submitted it then went to view my post but it was not there. i have done this twice and nothing happened. any ideas why?

20 Feb 2005, 01:38	#2
meshurp Super Loafer Join Date: 20.04.2003 Location: In The World, somewhere... Posts: 444	i just checked the previous pageand it appaers to have posted mine on the end of the page before the most recent one and shunted the others along.

20 Feb 2005, 14:17	#3
R. You dig. Join Date: 02.04.2002 Location: On the fothermucker Posts: 7,179	phpBB originally uses a huge (and probably slow, because it needs lots of memory) query to pull thread data from the database. As our old server sometimes had performance issues, I replaced that huge query with two smaller ones: one index query and one data query. The index query decides about the topic display order and it assumed that all posts have an ascending, unique post id (regardless of the post time). Your messages however have a post id that is higher than posts that were made later (probably due to delayed writes to the database). That's why your messages were shown on the wrong page. Anyway, the index query is fixed now and voilà, it works.