Invalid argument supplied for foreach()

FBioCS1

The problem: When I log in to the forum as admin, everything is normal, I can see the content of the post and post a reply. But when I log out the administrator account, all the posts on the website cannot be viewed. After logging in as a non-administrator, an error will be displayed

Flarum: 1.0.4
PHP: 7.4.20
MySQL: 8.0.18

My forum is upgraded from beta16
My database is upgraded from MySQL 5.6

Warning: Invalid argument supplied for foreach() in /www/wwwroot/myweb.com/vendor/flarum/core/src/Forum/Content/Discussion.php on line 90

Fatal error: Uncaught Laminas\HttpHandlerRunner\Exception\EmitterException: Output has been emitted previously; cannot emit response in /www/wwwroot/myweb.com/vendor/laminas/laminas-httphandlerrunner/src/Exception/EmitterException.php:24 Stack trace: #0 /www/wwwroot/myweb.com/vendor/laminas/laminas-httphandlerrunner/src/Emitter/SapiEmitterTrait.php(40): Laminas\HttpHandlerRunner\Exception\EmitterException::forOutputSent() #1 /www/wwwroot/myweb.com/vendor/laminas/laminas-httphandlerrunner/src/Emitter/SapiEmitter.php(27): Laminas\HttpHandlerRunner\Emitter\SapiEmitter->assertNoPreviousOutput() #2 /www/wwwroot/myweb.com/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(98): Laminas\HttpHandlerRunner\Emitter\SapiEmitter->emit() #3 /www/wwwroot/myweb.com/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run() #4 /www/wwwroot/myweb.com/public/index.php(26): Flarum\Http\Server->listen() #5 {main} thrown in /www/wwwroot/myweb.com/vendor/laminas/laminas-httphandlerrunner/src/Exception/EmitterException.php on line 24

and

Warning: Invalid argument supplied for foreach() in /www/wwwroot/myweb.com/storage/views/903126650910ebd7a932ca0551b541ebb5a660f2.php on line 7

clarkwinkelmann

FBioCS1 is your PHP version on the web the same as the command line?

You can disable PHP warnings in the PHP config file. Generally the warnings should be disabled in production.

I'm not sure if that warning is supposed to happen in normal Flarum operation though. It's this line https://github.com/flarum/core/blob/v1.0.4/src/Forum/Content/Discussion.php#L90 and if included isn't an array it might indicate there was another error behind the scenes that prevented the discussion from being retrieved.

FBioCS1

clarkwinkelmann

PHP 7.4.20 (cli) (built: Jul 8 2021 18:27:19) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.20, Copyright (c), by Zend Technologies

and I disabled PHP warnings, but it still doesn't work...

clarkwinkelmann

FBioCS1 is there any error in the Flarum log file at <flarum>/storage/logs ?

FBioCS1

clarkwinkelmann

BTW: This issue only occurs when i enbled flarum/tags

flarum.ERROR: PDOException: SQLSTATE[HY000] [2002] Connection refused in /www/wwwroot/myweb.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [2002] Connection refused in /www/wwwroot/myweb.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] Connection refused (SQL: select * from discussions where id = 28 and (discussions.id not in (select discussion_id from discussion_tag where tag_id not in (select tags.id from tags where (tags.id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and perm_tags.id in (16, 2, 4)) or perm_tags.is_restricted = 0) and (tags.parent_id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and perm_tags.id in (16, 2, 4)) or perm_tags.is_restricted = 0) or tags.parent_id is null))))) and (discussions.is_private = 0 or (((discussions.is_approved = 0 and (discussions.user_id = 0 or ((discussions.id not in (select discussion_id from discussion_tag where tag_id not in (select tags.id from tags where (tags.id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and 0 = 1)) and (tags.parent_id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and 0 = 1)) or tags.parent_id is null))))) and exists (select * from tags inner join discussion_tag on tags.id = discussion_tag.tag_id where discussions.id = discussion_tag.discussion_id))))))) and (discussions.hidden_at is null or discussions.user_id = 0 or ((discussions.id not in (select discussion_id from discussion_tag where tag_id not in (select tags.id from tags where (tags.id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and 0 = 1)) and (tags.parent_id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and 0 = 1)) or tags.parent_id is null))))) and exists (select * from tags inner join discussion_tag on tags.id = discussion_tag.tag_id where discussions.id = discussion_tag.discussion_id))) and (discussions.comment_count > 0 or discussions.user_id = 0 or ((discussions.id not in (select discussion_id from discussion_tag where tag_id not in (select tags.id from tags where (tags.id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and 0 = 1)) and (tags.parent_id in (select perm_tags.id from tags as perm_tags where (perm_tags.is_restricted = 1 and 0 = 1)) or tags.parent_id is null))))) and exists (select * from tags inner join discussion_tag on tags.id = discussion_tag.tag_id where discussions.id = discussion_tag.discussion_id))) limit 1) in /www/wwwroot/myweb.com/vendor/illuminate/database/Connection.php:692