somerset wrote:
It's probably just me but the search members posts facility seems to have stopped on 29 January.
Apologies if this has already been mentioned.
Apologies if this has already been mentioned.
Thanks!
OP
|
UTC
quote
somerset wrote: It's probably just me but the search members posts facility seems to have stopped on 29 January. Apologies if this has already been mentioned. Thanks! |
OP
|
UTC
quote
somerset wrote: It's probably just me but the search members posts facility seems to have stopped on 29 January. Additionally, somerset, for finding and reporting this forum bug, I hereby award you the MV Entomologist badge. Wear it with pride.
Positive
|
Addicted
![]() 2019 Honda - The Monkey 2023 Honda - The Super Cub
Joined: UTC
Posts: 647 Location: Somerset England |
UTC
quote
Wow. Firstly thank you for the quickest response in solving a problem that I have come across on the Internet.
It's a useful tool that I use to keep up to date with my 'favourite' posters in particular. Secondly, the last time I won an award of any description was for winning a darts competition about 25 years ago. I feel privileged. somerset
Positive
|
OP
|
OP
|
UTC
quote
Side note, unrelated to above post:
While doing some testing using a copy of the real database and a newly-registered user account, I noticed a performance problem that only seems to occur for new-ish accounts. Trying to load a forum index (e.g. General Discussion) is several orders of magnitude slower for a new account than an established account (e.g. my own). This is something of a surprise to me -- I would have expected the opposite to be true, given the large number of cross-referenced database entries that an established user has. Digging a little deeper, I did some SQL EXPLAINs on the queries, and the database is using significantly different optimized plans to carry out the queries for me vs. a new user. Which is really odd, because the queries are identical. The sticking point seems to be related to the "replied topics" table, the one that tracks every single reply in every single topic for every single user. This is what allows the forum to show the visual clue that you've replied to a topic -- the little dog-ear mark near the delta button to the left of the topic name. When building a list of topics to show on any give page of a forum, we cross-reference the list with the "replied topics" table in order to show that mark. Which is apparently a bridge too far. For new users. Or something. I don't really know why at this point, only that the performance is abominable -- something like 25 seconds to load the page. Egads! So I'm probably going to push a change later today to turn off that little dog-ear, at least until I figure out what's going on. Sorry for the service degradation. |
OP
|
UTC
quote
I just pushed another new piece of the forum rewrite to the main server. Today it's the Login page, which gets a new look and an entirely new foundation.
This was a gnarly change, and touched much more of the forum than I would have expected. I've tested it extensively, and yet... there are still probably some edge cases I haven't considered. I'm especially concerned about legacy usernames with ampersands and apostrophes, but those users should be able to use their email addresses instead. ![]() |
Veni, Vidi, Posti
![]() LX190 Friday afternoon special, [s]Primavera[/s], S50, too many pushbikes
Joined: UTC
Posts: 10816 Location: Hermit Kingdom |
UTC
quote
The little corner tab denoting "replied to" is gone from the main page.
It's still on the replied to page which isn't that helpful. Also… does search work for attachment names? ![]() ![]() |
OP
|
UTC
quote
znomit wrote: The little corner tab denoting "replied to" is gone from the main page. znomit wrote: Also… does search work for attachment names? |
|
UTC
quote
jess wrote: Side note, unrelated to above post: While doing some testing using a copy of the real database and a newly-registered user account, I noticed a performance problem that only seems to occur for new-ish accounts. Trying to load a forum index (e.g. General Discussion) is several orders of magnitude slower for a new account than an established account (e.g. my own). This is something of a surprise to me -- I would have expected the opposite to be true, given the large number of cross-referenced database entries that an established user has. Digging a little deeper, I did some SQL EXPLAINs on the queries, and the database is using significantly different optimized plans to carry out the queries for me vs. a new user. Which is really odd, because the queries are identical. The sticking point seems to be related to the "replied topics" table, the one that tracks every single reply in every single topic for every single user. This is what allows the forum to show the visual clue that you've replied to a topic -- the little dog-ear mark near the delta button to the left of the topic name. When building a list of topics to show on any give page of a forum, we cross-reference the list with the "replied topics" table in order to show that mark. Which is apparently a bridge too far. For new users. Or something. I don't really know why at this point, only that the performance is abominable -- something like 25 seconds to load the page. Egads! So I'm probably going to push a change later today to turn off that little dog-ear, at least until I figure out what's going on. Sorry for the service degradation. If it could make a comeback, I'd greatly appreciate it. I use it to keep up with the threads/topics that I participate the most in. Without it, I have to actually read every topic title to see if I want to read it. Lazy of me, I know.
Positive
|
Moderaptor
![]() The Hornet (GT200, aka Love Bug) and 'Dimples' - a GTS 300
Joined: UTC
Posts: 44570 Location: Pleasant Hill, CA |
OP
|
UTC
quote
monogodo wrote: If it could make a comeback, I'd greatly appreciate it. I use it to keep up with the threads/topics that I participate the most in. Without it, I have to actually read every topic title to see if I want to read it. Lazy of me, I know. jimc wrote: ^^^^ This!!! I miss it. The main problem I think is that the replied table is just far too large. It currently has 1,330,125 records in it, and it has to search that entire table every time you pull up a list of topics. For contrast, there are only 174,313 topics in the entire database. My own synthetic Replied forum is extra slow, just because of how many replies I have made and how many entries it has to sift through. I suspect Jim's Replied synthetic forum is similarly sluggish. One approach would be to prune records of replies after some amount of time -- a year? two years? That would greatly reduce the size of the table. This has some significant downsides, though -- the record of who has replied to what topics is what allows the Replied synthetic forum to be useful, and I'd hate to give that up. Another approach would be to remove records of replies of any member who hasn't logged in for some amount of time. Again, a year? Two years? At some point, it's fairly likely that a user won't be back. I like this idea a little more, but I also still hate to lose valuable data that could be put to better use in the future. And finally, there's the enduring mystery of why the database uses a different plan to perform the queries. I believe that it is choosing not to use the table index for new users, but I have no idea why this would be the case. Further investigation is probably needed.
Positive
|
|
UTC
quote
So I thought I'd Favorite the topics that I always check, but I can't find where that list of Favorite Topics is, so that I can check it.
While looking for that list, I did find the Replied list, which does seem to work for me to see the topics I always look for. I can check that list for activity, participate if necessary, then go to the General forum and check new topics. Not too much additional work on my part, but it will work for now. |
Moderaptor
![]() The Hornet (GT200, aka Love Bug) and 'Dimples' - a GTS 300
Joined: UTC
Posts: 44570 Location: Pleasant Hill, CA |
UTC
quote
A thought on this - does it go through every reply? I would hope that once it spots I (for example) have made a reply to a topic, it would move onto the next topic, not look for any extra replies from me in that topic. But perhaps it doesn't work anything like that anyway.
(It took nearly 11 seconds for my replied-to synthetic topic - which is why I've never bothered to use it). For the main page in say GD, I only want to see if I have replied to a topic where there are new posts since I last 'marked all read'. This should be very speedy to accomplish. Perhaps the 'flag' can be restricted to just those topics? Rarely more than 40 of them. |
OP
|
UTC
quote
monogodo wrote: So I thought I'd Favorite the topics that I always check, but I can't find where that list of Favorite Topics is, so that I can check it. monogodo wrote: While looking for that list, I did find the Replied list, which does seem to work for me to see the topics I always look for. I can check that list for activity, participate if necessary, then go to the General forum and check new topics. Not too much additional work on my part, but it will work for now. ![]() ⚠️ Last edited by jess on UTC; edited 1 time
|
OP
|
UTC
quote
jimc wrote: A thought on this - does it go through every reply? I would hope that once it spots I (for example) have made a reply to a topic, it would move onto the next topic, not look for any extra replies from me in that topic. But perhaps it doesn't work anything like that anyway. (It took nearly 11 seconds for my replied-to synthetic topic - which is why I've never bothered to use it). For new users, the database chooses to scan the entire table looking for matches. I'm not sure why. jimc wrote: For the main page in say GD, I only want to see if I have replied to a topic where there are new posts since I last 'marked all read'. This should be very speedy to accomplish. Perhaps the 'flag' can be restricted to just those topics? Rarely more than 40 of them. |
![]() UTC
Veni, Vidi, Posti
2007 GTS
Joined: UTC
Posts: 22823 Location: Harriman, Tennessee, Tn |
|
|
UTC
quote
jess wrote: I just pushed another new piece of the forum rewrite to the main server. Today it's the Login page, which gets a new look and an entirely new foundation. This was a gnarly change, and touched much more of the forum than I would have expected. I've tested it extensively, and yet... there are still probably some edge cases I haven't considered. I'm especially concerned about legacy usernames with ampersands and apostrophes, but those users should be able to use their email addresses instead.
Positive
|
OP
|
UTC
quote
monogodo, jimc, and anyone else that cares.
I have a potential solution to the missing replied-to dogear feature. (The following exists on a test server -- I haven't changed anything on the main server yet) I've rewritten the SQL query to get a "bare" list of topics first -- without reference to which user is querying -- and this does in fact prove to be highly performant for both new users (with no post history) and established users (with lots of post history). Only then does it join that list of topics with all the other tables (including the dreaded replied-to table) to finish out all the bits of information needed to render a forum index. But, naturally, there's a problem. In order to structure the query this way, I have to omit any query conditions that involve the time of the last post, since the topic record itself does not actually contain the time of the last post -- that's a function of the last post itself, which we can only use if we join the posts table to the topic table, which we deliberately are not doing in that first-pass attempt of retrieving the "bare" topic list. Which means the "Display topics from previous N days" feature would be kaput. I have opinions about whether this is a fair tradeoff or not, but I'll let others speak their own opinions before I bias them with mine. Thoughts? ![]() Doomed
|
OP
|
UTC
quote
I guess the thundering silence is a sign that nobody cares about the doomed control mentioned above.
Doomed. |
|
UTC
quote
jess wrote: I guess the thundering silence is a sign that nobody cares about the doomed control mentioned above. Doomed. |
Molto Verboso
![]() '07 GTS250, '07 LX150, '81 P200E, '78 P200E, '74 VBC1, '64 V90 and 3 Ciaos
Joined: UTC
Posts: 1441 Location: Tucson, AZ |
UTC
quote
jess wrote: I guess the thundering silence is a sign that nobody cares about the doomed control mentioned above. Doomed. ![]()
Positive
|
OP
|
UTC
quote
monogodo wrote: Still trying to wrap my head around what it is that is happening. The central question is really just: is the ability to see only topics in the last N days a useful feature (or not)? It's actually one of the original features of phpBB, upon which this forum was (once) based. |
|
UTC
quote
jess wrote: I guess the thundering silence is a sign that nobody cares about the doomed control mentioned above. Doomed. I am obviously not a frequent poster. That said, if the N days is short, the juice may not be worth the squeeze. If I am misunderstanding, well then feel free to disregard. I am thankful for all you do to maintain the site, even more with the number of aggravations. |
|
UTC
quote
jess wrote: I don't know that you need to wrap your head around the SQL problem. I mean, it's SQL, invented by sadists, or possibly proselytizing masochists. The central question is really just: is the ability to see only topics in the last N days a useful feature (or not)? It's actually one of the original features of phpBB, upon which this forum was (once) based. If that's the case, then nah, I don't see how it would be useful. The topics are already sorted chronologically (at least, they are for me), so it's easy enough to simply stop scrolling.
Positive
|
OP
|
UTC
quote
marret wrote: I assume you are referring to the "dog ear" on the left column of a topic when a sub-forum is displayed, and whether an N time is useful in order to have the dog ear as opposed to not having the dog ear at all any longer? If this is the correct dog ear, I do miss it, but I can click on the replies icon to check as well.\ The dog-ear visual reply cue is currently turned off because it causes major delays for new users (for reasons that I'm not entirely sure of). I have a fix that will allow me to turn the dog-ear feature back on, but it means sacrificing a different feature -- the control I attached in a post a few up from here. |
|
UTC
quote
jess wrote: Not quite. You're crossing the beams of two different features, though to be fair we are discussing them both because they are probably mutually exclusive. The dog-ear visual reply cue is currently turned off because it causes major delays for new users (for reasons that I'm not entirely sure of). I have a fix that will allow me to turn the dog-ear feature back on, but it means sacrificing a different feature -- the control I attached in a post a few up from here.
Positive
|
|
UTC
quote
jess wrote: Not quite. You're crossing the beams of two different features, though to be fair we are discussing them both because they are probably mutually exclusive. The dog-ear visual reply cue is currently turned off because it causes major delays for new users (for reasons that I'm not entirely sure of). I have a fix that will allow me to turn the dog-ear feature back on, but it means sacrificing a different feature -- the control I attached in a post a few up from here. The dog-ear (which I absolutely LOVE) slows things down for new users. By removing the "Show Posts from N Days" feature, the dog-ear can come back and work properly. The thing is, the General Forum, for example, currently shows 50 topics, in reverse chronological order. The oldest topic is from 3 days ago. To me, it makes no sense to have the Show Posts from N Days feature, because we'd be limited to what can fit on the page anyway, which in my case is 3 days. If I want to only check posts from the last 1 day, I can simply stop reading when I reach "2 days ago" on the list. |
OP
|
UTC
quote
monogodo wrote: The thing is, the General Forum, for example, currently shows 50 topics, in reverse chronological order. The oldest topic is from 3 days ago. To me, it makes no sense to have the Show Posts from N Days feature, because we'd be limited to what can fit on the page anyway, which in my case is 3 days. If I want to only check posts from the last 1 day, I can simply stop reading when I reach "2 days ago" on the list. |
|
UTC
quote
jess wrote: I never said it was a good feature. But one thing I've learned about software is that people rarely use it as it was intended to be used by the people that designed it. I've been repeatedly surprised to find people being adversely affected by changes that I didn't think were significant. Which is why I'm treading carefully this time. I wasn't aware of the "Show posts from last N Days" feature before yesterday. I only really access MV from work. So I generally miss all of the activity on the weekends. When I check it on Monday, I click on the General forum, then go to page 3, and check to see if the most recent topic on that page is at least 3 days old. If it is, I scroll down until I see 4 days old, and start checking topic titles to see if I want to read them, working my way back to the top. Then I check page 2, starting from the bottom, then on to page 1. If the topics on page 3 are older than 3 days, I go to page 2. It works for me, but I understand that not everyone functions the way I do. |
OP
|
UTC
quote
monogodo wrote: I only really access MV from work. So I generally miss all of the activity on the weekends. When I check it on Monday, I click on the General forum, then go to page 3, and check to see if the most recent topic on that page is at least 3 days old. If it is, I scroll down until I see 4 days old, and start checking topic titles to see if I want to read them, working my way back to the top. Then I check page 2, starting from the bottom, then on to page 1. If the topics on page 3 are older than 3 days, I go to page 2. It works for me, but I understand that not everyone functions the way I do. May I introduce you to the wonders of the "New" synthetic forum? |
OP
|
UTC
quote
The dog-ear reply cue has been restored.
Also, I've substantially rewritten the password reset process to incorporate it into the new Login module. |
Atypical Canadian
![]() 2009 Vespa S50(LX150 motor swap), 2006 Vespa GTS250ie
Joined: UTC
Posts: 2319 Location: Toronto, Canada |
UTC
quote
Oi jess, another one that's more of a suggestion than a 'fix'
Making links more noob friendly, or just, human-friendly in general. I spend a lot of time on here and still had to scratch my head to remember how to turn text into a link. The buttons up top work quite well for highlighting a text to modify it, but maybe there's something that could be done to make linking more intuitive? No idea if this is an easy job or PITA not worth the effort, but, food for thought: ![]() |
OP
|
UTC
quote
adri wrote: No idea if this is an easy job or PITA not worth the effort, but, food for thought: I am currently re-writing large parts of the forum -- mostly invisibly. The posting page will probably be the most obvious change. |
Atypical Canadian
![]() 2009 Vespa S50(LX150 motor swap), 2006 Vespa GTS250ie
Joined: UTC
Posts: 2319 Location: Toronto, Canada |
Veni, Vidi, Posti
![]() GTS300 Super (Mustard) GTS250 Super (Bulger)
Joined: UTC
Posts: 5011 Location: Tempe, AZ |
UTC
quote
Thanks, Jess, for the 'Start of unread posts' thing, but I have also noticed the RIP flags for those who have passed. That is a nice reminder.
Positive
|
![]() UTC
Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7668 Location: Madison, Wisconsin |
|
Veni, Vidi, Posti
![]() MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7668 Location: Madison, Wisconsin |
UTC
quote
I just went to the Corona Virus topic, clicking on the widget at the left end to bring me to the most recent read, and it put me on page ~85 of 137.
Turns out I had made one of the comments on page 137. ![]() |
OP
|
UTC
quote
Madison Sully wrote: I just went to the Corona Virus topic, clicking on the widget at the left end to bring me to the most recent read, and it put me on page ~85 of 137. Turns out I had made one of the comments on page 137. ![]() |
![]() UTC
Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7668 Location: Madison, Wisconsin |
|
Veni, Vidi, Posti
![]() MP3 500, GTS 250 (both 2008 MY), 2013 Piaggio BV 350, 2014 Can Am Spyder RT
Joined: UTC
Posts: 7668 Location: Madison, Wisconsin |
UTC
quote
jess wrote: Wait, how did that happen?
Positive
|
OP
|
UTC
quote
Madison Sully wrote: I have no idea. And unfortunately cannot replicate. There is also a forum-wide line-in-the-sand that represents the one-year pruning mark, and any posts older than that mark are considered already read by default. It might be that the tracking data for that topic had been pruned (since it was old) but the "marked all read" value was still in effect, giving you the appearance of a partially-read topic that you had in fact read (and posted to) further along than the forum was representing. I will have to revisit the pruning logic to see if I still agree with it all these dozen or so years later. |
Molto Verboso
![]() 2009 GTS250, Ducati Monster M900, KTM 390 Adventure, Honda CR125
Joined: UTC
Posts: 1790 Location: Oceanside, CA |
UTC
quote
jess wrote: Things are afoot. Easily could have posted this in the 'what's cheering you up today' section.' |
OP
|
UTC
quote
Shebalba wrote: Your handwriting (in the notebook photo) is just like how my dad wrote. I always tried to copy it as a kid, but it was never the same. Easily could have posted this in the 'what's cheering you up today' section.' Years later, I discovered that the typography people call this "small caps". (And that photo is an especially untidy version, written hastily and at a bad angle). |
Modern Vespa is the premier site for modern Vespa and Piaggio scooters. Vespa GTS300, GTS250, GTV, GT200, LX150, LXS, ET4, ET2, MP3, Fuoco, Elettrica and more.