Forum database error

[tggzzz]

Looks like the forum can't tolerate popular threads...

There are 2²⁴-1 views, so trying to view the TEA thread causes

General Error
SQL ERROR [ mysqli ]
Out of range value for column 'topic_views' at row 1 [1264]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Not sure how that could be corrected. I would be content with starting a new (continuation) thread, but that won't affect the "views" count. Maybe poking the specific database entry is possible?

Perhaps https://www.phpbb.com/community/viewtopic.php?t=2659984

[synx508]

Ah, you've spotted it already! I'm in anti-awe that software this old has such basic design flaws. The current version *does* use a much bigger integer for topic_views but I'm still annoyed that it logs views the way it does. Ideally you want that table to fit easily in RAM and having "other stuff" in it is bad.

[tggzzz]

Ah, you've spotted it already! I'm in anti-awe that software this old has such basic design flaws. The current version *does* use a much bigger integer for topic_views but I'm still annoyed that it logs views the way it does. Ideally you want that table to fit easily in RAM and having "other stuff" in it is bad.

I'm sure it passed the unit tests and showed a green light on the devops console.

No, I'm not a fan of TDD, even though I acknowledge its good points. Good tests are harder to write than the code they are testing, especially when integrating subsystems.

And then there is the even bigger problem of "doing the thing right" (which is the most TDD can hope to do) vs "doing the right thing".

Bah, humbug.