Topic Rating Bar

[Bugo]

No, look at other modifications for queries "thank, post, message".

I also have a paid modification on the same topic: https://ko-fi.com/s/37278cd45d

[Lucarella]

Hi guys I have a problem with this mod, at least I think so.
Today I left the forum perfectly working, but tonight I find it offline and the browser gives me HTTP ERROR 500.
From the error log I saw that it is full of errors related to this mod, as you can see

Code Select Expand

[23-Jan-2025 19:12:06 Europe/Berlin] PHP Fatal error:  Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, null given in /home/ddcrewne/public_html/forum/Sources/Class-TopicRatingBar.php:204
Stack trace:
#0 /home/ddcrewne/public_html/forum/Sources/Class-TopicRatingBar.php(204): mysqli_fetch_assoc()
#1 /home/ddcrewne/public_html/forum/Sources/Class-TopicRatingBar.php(369): TopicRatingBar::prepareBestTopic()
#2 /home/ddcrewne/public_html/forum/Sources/Subs.php(5787): TopicRatingBar->showBestTopic()
#3 /home/ddcrewne/public_html/forum/Sources/Subs.php(5592): call_integration_hook()
#4 /home/ddcrewne/public_html/forum/Sources/Subs.php(4357): setupMenuContext()
#5 /home/ddcrewne/public_html/forum/Sources/Subs.php(4514): setupThemeContext()
#6 /home/ddcrewne/public_html/forum/Sources/Subs.php(4157): template_header()
#7 /home/ddcrewne/public_html/forum/Sources/Errors.php(389): obExit()
#8 /home/ddcrewne/public_html/forum/Sources/Errors.php(176): setup_fatal_error_context()
#9 /home/ddcrewne/public_html/forum/Sources/Subs-Db-mysql.php(719): fatal_error()
#10 /home/ddcrewne/public_html/forum/Sources/Subs-Db-mysql.php(494): smf_db_error()
#11 /home/ddcrewne/public_html/forum/Sources/FirstTopicImage.php(221): smf_db_query()
#12 /home/ddcrewne/public_html/forum/Sources/FirstTopicImage.php(133): FirstTopicImage::loadImages()
#13 /home/ddcrewne/public_html/forum/Sources/Subs.php(5787): FirstTopicImage::block()
#14 /home/ddcrewne/public_html/forum/Sources/Load.php(2714): call_integration_hook()
#15 /home/ddcrewne/public_html/forum/index.php(227): loadTheme()
#16 /home/ddcrewne/public_html/forum/index.php(184): smf_main()
#17 {main}
  thrown in /home/ddcrewne/public_html/forum/Sources/Class-TopicRatingBar.php on line 204

How can I solve it, considering that I can't see the forum?
Thanks
The forum is: SMF 2.1.4 - php 8.1

[Bugo]

Rename Sources/Class-TopicRatingBar.php to determine if it is the source of the problem or if it is related to the database.

[Lucarella]

I tried as you say, on chrome it always gives me error 500 but on FF the forum appears but it says database error and I can't go any further....
What can I do?
Thanks

[Bugo]

As I see it, your site is already accessible. Have you figured out the reason?

[Lucarella]

Hi Bugo, sorry but yesterday evening it got late and I forgot to update this topic.
The problem was caused by database corruption because it was originally 1.6 GB, while when I went to check it was about 670 MB.
I ran a repair table and, fortunately, everything was back in order and the forum works correctly.

I don't know why this damage to the DB happened, but I'm sure that everything came from the hosting because a few dozen minutes before even the cpanel was not reachable, so I deduce that the entire server was crashing and the damage to my DB was generated.
When I contacted them, before writing here, obviously they attributed the problem to the SMF code, not to their crash...

Anyway, everything was resolved well, just a little fear at the beginning.

Thank you for your help and interest.