[3.0]: Search returns no results in MySQL

[Oldiesmann]

Basic Information

Searching for posts/topics no longer works in MySQL/MariaDB

Steps to reproduce

1. Make some posts/topics
2. Try searching for something that appears in the subject or body of a post

Expected result

Posts containing relevant search terms are displayed

Actual result

No results returned

Version/Git revision

16fdbf2

Database Engine

MySQL

Database Version

No response

PHP Version

8.4.14

Logs

Additional Information

Search method and settings don't seem to matter here. I've tried searching with both fulltext and parsed indexes, toggling the "match whole words only" and "force the use of a search index" settings, and nothing changed. Also interesting is that it matches "Welcome" in exactly one post but not "Markdown" in multiple posts.

[Oldiesmann]

Update: Instead of not getting results now, I get an error.

DateTimeZone::__construct(): Unknown or bad timezone ()
/var/www/vhosts/oldiesmann.us/smf3.oldiesmann.us/Sources/Time.php
Line 195
URL of page causing the error
https://...index.php?action=search2



    #0: SMF\Time->__construct()
    Called from /.../Sources/Time.php on line 760
    #1: SMF\Time::create()
    Called from /.../Sources/User.php on line 1081
    #2: SMF\User->format()
    Called from /.../Sources/Search/SearchResult.php on line 189
    #3: SMF\Search\SearchResult->format()
    Called from /.../Sources/Actions/Search2.php on line 173
    #4: SMF\Actions\Search2->prepareSearchContext()
    Called from /.../Themes/default/Search.template.php on line 364
    #5: template_results()
    Called from /.../Sources/Theme.php on line 527
    #6: SMF\Theme::loadSubTemplate()
    Called from /.../Sources/Theme.php on line 485
    #7: SMF\Theme::loadSubTemplates()
    Called from /.../Sources/Utils.php on line 2324
    #8: SMF\Utils::obExit()
    Called from /.../Sources/Forum.php on line 476
    #9: SMF\Forum->execute()
    Called from /.../index.php on line 149

Timezone is set to "[UTC-05:00 Eastern Time (EST/EDT)" in my profile

[sbulen]

I am not seeing this with current code, refreshed as of today.

[Oldiesmann]

I am not seeing this with current code, refreshed as of today.

I'm still getting the error with DateTimeZone::__construct

[sbulen]

Took another try, still not seeing this particular issue.

New install, today's GH; made a bunch of posts; set forum timezone to Eastern, utc-5. No issues with searching new posts.

Set my personal timezone to western, utc-8, no issues searching new posts.

Set my personal timezone to eastern, utc-5, no issues searching new posts.

Possibly an issue with the time change? Not sure, but cannot reproduce.

My install is wamp, mysql 8.4.4, php 8.4.5.

[jdarwood007]

Not able to reproduce. #9037 might be your timezone bug, though

[Oldiesmann]

Testing things again...

No search index: "Your search returned no results" every time.
Fulltext index: Works as expected. No problems.
Parsed index still doesn't work (as I reported in another issue, it stays stuck at "partially completed").

We should still be getting some results even when no search index exists, especially on small forums (this one has 13 posts in 7 topics and only two users). I'm not getting the DateTimeZone error anymore though.