[3.0]: Unknown or bad timezone

[dragomano]

Basic Information

DateTimeZone::__construct(): Unknown or bad timezone ()

Steps to reproduce

1. Go to the member list (?action=mlist)

Expected result

No response

Actual result

No response

Version/Git revision

2ed6754

Database Engine

MySQL

Database Version

11.8.3-MariaDB

PHP Version

8.2.29

Logs

Additional Information

Possible fix:

User.php, replace

'local_time' => Time::create('now', $this->timezone)->format(null, false),

with

'local_time' => Time::create()->format(),

[Oldiesmann]

This only seems to happen with MariaDB/MySQL. Memberlist works on my PostgreSQL test board.

[sbulen]

I'm seeing this also - mysql.

[jdarwood007]

Must be more to it. i can't reproduce it. I'm on MySQL. But I am using PHP 8.4

[sbulen]

I'm seeing this on mysql 8.4.4 & php 8.4.5.

Fresh install. Navigate to memberlist. Only user is the admin.

Under the covers, when formatting rows for displaying the memberlist, if not passed, timezone defaults to null. For some reason the admin user's timezone is formatted as an empty string, so it gets passed, overwriting the nulls up & down the stack. It's not liking that empty string.

[jdarwood007]

Ahh, that's the key to reproducing it. Needs to be a empty space

UPDATE `smf_members` SET `timezone` = ' ' WHERE `smf_members`.`id_member` = 10; 

Seems we could do a trim() when loading the data.

[sbulen]

But I didn't have to do any edits.... It was set to an empty string when the admin user was added.

I literally just installed, & went to the memberlist.

EDIT: This is the user memberlist, mlist. The admin memberlist works fine.