Seems to work right now, I see you enabled bot filtering, I guess it would help as the bot will maybe slow down when they get errors 429.
There are still improvements that I have to do to increase performance. Now that I have finished all the unicode & title stuff I'll try to work on that.

Every time I try to search for comments it takes a while and it ends up with that error message:

Fatal error: Uncaught mysqli_sql_exception: Query execution was interrupted (max_statement_time exceeded) in /var/www/imcdb/yourcomments.php:193 Stack trace: #0 /var/www/imcdb/yourcomments.php(193): mysqli->query(' SELECT SQL_CAL...') #1 {main} thrown in /var/www/imcdb/yourcomments.php on line 193

That happens to me yesterday when I did the search for comments. Sometimes it succeed the search engine. Probably gotten too busy

"max_statement_time exceeded" is when the query is too heavy and took too much time.
The comments table becomes too big and at some moments a search across the whole table is sometimes too heavy.
Hence my comment above, one of the things to improve is that by default the search should not be done on the whole table but just on recent comments (with possibility of searching in older ones, of courses), as most of the time we only need the newest ones.

Antp, I just encountered this problem when I tried to quote and reply other user's message
Edit: I can't even add any comments now

Warning: include_once(comment-utils-post.php): Failed to open stream: No such file or directory in /var/www/imcdb/addcomment.php on line 4 Warning: include_once(): Failed opening 'comment-utils-post.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/imcdb/addcomment.php on line 4 Fatal error: Uncaught Error: Call to undefined function FilterComment() in /var/www/imcdb/addcomment.php:37 Stack trace: #0 {main} thrown in /var/www/imcdb/addcomment.php on line 37

I just tried a test quote and got the same thing

Fixed, sorry
That explains why nobody was posting messages after the update

Everytime when i find comments & set the search range to since the beginning, this pops up

I hope antp fixes this soon...

Agree - I've had same issue, and said a few naughty words. I think the issue is that you've set the search range too high for the site hamsters to reach with their pedalling - try a shorter search range.

Please can we have more hamsters. Or better hamsters. Or both.

I'm having the bottom ad problem again.

same here but says time expired or something like that . I tried to scare the hamsters with my cat so they go faster but unless i'm looking for something that had a few occurences only, same result..

Hence why by default it searches only on recent comments. It is very heavy for the site to search through the entire comments table.
So at times the site is more loaded (peak hours) it is often impossible.
There isn't really something to "fix".

I have a small improvement I made some time ago that I still have to finish testing before putting it on the public site, I'll probably do that in the next days but it won't solve all these issues anyway.
The best solution would probably be to move the site to a newer / more powerful server I'll probably do that some day.



I see you enabled the bots filter a few before posting that message, but that filter is only enabled for one hour. So if it is again too slow some time later, you can enable it again




It is annoying. I suppose you tried clearing the cache? (not cookies and all stuff like that, just the cache)

What happened to the forum yesterday?

Was it down? I didn't notice something. I can ask (as it is not managed by me)

It was inaccessible for several hours in the night here, so morning there.

even as early as 9:something PM, Baube's time

The site is so slow today. Even enabling the bot blocker hasn't helped.

Unreachable a few minutes ago, now back.

I don't see much special except that crap of Bytespider bot as often.
Maybe I should rather block it completely. I should make different bot categories: Google & Bing are much less a nuisance than some others, for example.

From the log you enabled it only two minutes after that post Maybe servers aren't perfectly in sync
After enabling it, it may take a few minutes to really be effective: the crappy bot was still fetching all thumbnail images from the movie pages it requested before the block (the block is for pages only, not images, and not the vehicle pages as these are less heavy)

It was also enabled a few hours before, but when enabled it is only for one hour anyway.