Neil_Boekend wrote:I kinda prefer a fast forum over having a post number.

Do you mean post count? Because no one was talking about post count, and post IDs are kinda important.

Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.---If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

Thesh was talking about finding page by post ID, which happens to also involve getting a post number but would need to be done without that.

(I'm not using that theme, so I didn't know displaying the number of a post within its thread was even a thing.)

Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.---If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

davean wrote:So ... when you load a thread, phpbb is now selecting a list of every post id in said thread, ordered. So, whats the solution? Well, making sure it all just fits in memory works wonders. I have no idea why they programmed it like that though.

Aww, that was the second part of my second hypothesis.

Thesh wrote:My guess is that they wanted an efficient way to find page number by post id, without having to store the relative post number in the database (which would have to be updated every time a post is deleted), since MySQL doesn't have a row_number function like PostgreSQL, SQL Server, or Oracle.

Note, that even that's not a good excuse if that's the case since you can just do a count where the post id is less than or equal to that value and it's in a particular thread.

I vaguely remember something in CFT about how a lot of programming people don't know how to write efficient queries. Is that a good excuse?

[edit]

Neil_Boekend wrote:and only to place that number on the screen

It would indeed be that number, which can then be divided by posts-per-page to find out which page of a thread has to be served. Wait, that's kind of what gmalivuk said too.

I can't talk for everyone, but the both new post listings (new posts and unread posts) and egosearch look right to me. A couple simple searches also seemed to work properly. Thanks for upgrade and fixing things!

Possible problem: when I just searched through 'my posts', the number of results was about a quarter of what it used to be. Flicky also claimed to have had around 60k posts (including forum games) before Chocolate Chips, and that figure's now around 23k. Still, given that searching with keywords doesn't seem to have an issue, I think it's just a minor problem.

██████████████████████████████████████████████████████████████████████████████████████████████████████ ← approximately how gay I am."a nebulous cloud of different combinations of styling bodily features""on either side of a wrought iron fence made of tigers"

davean wrote:So does the search index rebuild fix everyones problems? And give you a pony?

It fixes the problem of not being able to search, but I haven't seen anything about a pony yet. Maybe one of my roommates signed for the delivery?

Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.---If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

SourceUsual disclaimer: Does not understand activity's calculation or its units. May or may not be accurate.

_____________

For davean:

hendusoone wrote:Thanks, davean! It's close, at least. But there's still the right-side avatars/info (Allan Style - SUBSILVER is still a prosilver-based style). Would it be possible to try out the actual prosilver2 style? Though, I think it might break some plugins/add-ons. Not sure if we're using any of those.

The search is not 100%. For example, I posted in the "energy currency?" thread is SB, and it doesn't show up on my egosearch. Everything I posted in before and while search was disabled seems to show up.

Noticed an anomaly. Remarked about "pony" appearing fourth, now fifth. Double-checked out of neuroticism. Failed to come up. Tried "search". Remained absent. Worked with "searched". Saw it under Search User's Posts too. Chalked it up to caching or something.

Attempted it again now. Resisted efforts, even with variations (with quotes, without quotes, and with quotes and a period). Listed new entries for "search", however. Monkeyed around. Gave different results depending on log-in status.

Returned 2522 results for pony while logged in. Showed davean's initial post about the search index rebuild at the top. Logged out. Matched 2470 results for pony. Displayed three posts higher than davean's initial post, including the one in question.

Edit1: 2522 and 2470 immediately afterwards. Will check again later. Does not display this or the graphs post under Search User's Posts, though. Sounds similar to Thesh's issue.Edit2: Matched anomaly. Same numbers otherwise. Could have been correct initially.Edit3: ~34 hour edit. Same numbers.

Well now I noticed a thing with egosearch - this thread is not there, unless I change the "Display posts from previous" option to something else than "All results" from the bottom of the egosearch results.

Ubik wrote:Well now I noticed a thing with egosearch - this thread is not there, unless I change the "Display posts from previous" option to something else than "All results" from the bottom of the egosearch results.

If, like me, you rely on favicons to find your way around tabs and bookmarks, a quick 'n' dirty manual repair for the missing favicon (for Chrome at least) is to right-click anywhere on the page, select 'inspect element', then in the element inspector screen, right click the line of HTML that says

> <head>...</head>

Then select 'Edit as HTML'. An editable box should show up. Under the line that says

Until you mentioned this fix, I didn't actually notice, but (here on Firefox), there's a FavIcon now featuring (again, I presume - it appears I'm just generally unobservant), after the recent noticeable "No special icon here" icon that I had been seeing during the height of the forum migration hiccups (although, as before, only after someone mentioned it...)

TL;DR; it's working again for me, without needing the 'fix' (on the forums.xkcd.com domain URI, for reference) but I've no idea even when it came back.

(Still, the 'fix' idea is noted, to add to the many and various handy things that might be useful in the future.)

Which means default egosearch is going to become increasingly useless as time goes on.

Unless stated otherwise, I do not care whether a statement, by itself, constitutes a persuasive political argument. I care whether it's true.---If this post has math that doesn't work for you, use TeX the World for Firefox or Chrome

No thread that I know about is absent from my Egosearch. That includes 1669 back to 1659 in the Comics thread, at least, when I have a quick look at the up-to-two pages of Egoworthy threads I have so far accumulated, which demonstrably covers the whole time of the Migration onwards. At least for thread-start, if not the moment I decided to start contributing and thus made it Egorelevant in the first place.

(PPE: Erm. Scratch that bit I've struck out. I am 99% sure that 1169's thread, i.e. today's, had showed up on the Egolist, ever since I contributed my own so-far-unremarked contribution to the conversation, but when I just now double-double-check in an adjacent tab to this very composition page it only shows up if I use a time period cut-off option on it. And find that there's definitely a (newer) new message since I last visited, mere moments ago. However, I can still find every other other thread in the default "All results" display, as well as in any suitably long "from previous <timescale>" option. Go figure...)