1.0.0 Can't register

ljy1003

Hello,my new flarum 1.0.0 can't register and show this message

Warning: Invalid argument supplied for foreach() in /flarumpath/e5103a39025b36badcbf2b08ef3641d9d85b424a.php on line 7

luceos

ljy1003 can you post the output of php flarum info please?

ljy1003

luceos Flarum core 1.0.0
PHP version: 7.4.11
Loaded extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bcmath, ctype, curl, dom, filter, ftp, gd, gettext, hash, iconv, intl, json, mbstring, SPL, session, pcntl, standard, PDO, mysqlnd, pdo_sqlite, Phar, posix, Reflection, pdo_mysql, shmop, SimpleXML, soap, sockets, sodium, mysqli, sysvsem, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, zip, pdo_pgsql, fileinfo, exif, memcached, ionCube Loader
+-------------------------------+---------+--------+
| Flarum Extensions | | |
+-------------------------------+---------+--------+
| ID | Version | Commit |
+-------------------------------+---------+--------+
| flarum-flags | v1.0.0 | |
| ffans-lang-simplified-chinese | v1.0.1 | |
| fof-links | 1.0.0 | |
| flarum-tags | v1.0.0 | |
| flarum-suspend | v1.0.0 | |
| flarum-subscriptions | v1.0.0 | |
| flarum-sticky | v1.0.0 | |
| flarum-statistics | v1.0.0 | |
| flarum-mentions | v1.0.0 | |
| flarum-markdown | v1.0.0 | |
| flarum-lock | v1.0.0 | |
| flarum-likes | v1.0.0 | |
| flarum-lang-english | v1.0.0 | |
| flarum-emoji | v1.0.0 | |
| flarum-bbcode | v1.0.0 | |
| flarum-approval | v1.0.0 | |
| fof-profile-image-crop | 1.0.0 | |
+-------------------------------+---------+--------+

luceos

ljy1003 /flarumpath/e5103a39025b36badcbf2b08ef3641d9d85b424a.php on line 7

Can you copy what is in that file on line 1 - 15?

[deleted]

ljy1003 e5103a39025b36badcbf2b08ef3641d9d85b424a.php

More to the point, why is the filename like that ? Looks to me like it's been renamed by something

luceos

[deleted] because it is a file in storage/views, which is the cache directory for parsed templates.

[deleted]

luceos Ok, but unless flarmpath in the OP is indeed storage/views, it's a concern 🙂

ljy1003

luceos ok

<?php $url = app('Flarum\Http\UrlGenerator'); ?>

<div class="container">
    <h2><?php echo e($translator->trans('core.views.index.all_discussions_heading')); ?></h2>

    <ul>
        <?php $__currentLoopData = $apiDocument->data; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $discussion): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
            <li>
                <a href="<?php echo e($url->to('forum')->route('discussion', [
                    'id' => $discussion->attributes->slug
                ])); ?>">
                    <?php echo e($discussion->attributes->title); ?>

                </a>
            </li>

luceos

ljy1003 do you see anything in storage/logs, if a file exists can you post the last few lines here?

head -n 30 storage/logs/flarum.log

ljy1003

luceos
#80 /www/flarum/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#81 /www/flarum/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#82 /www/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#83 /www/flarum/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#84 /www/flarum/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#85 /www/flarum/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#86 /www/flarum/public/index.php(26): Flarum\Http\Server->listen()
#87 {main}

luceos

ljy1003 okay we'll need the lines prefixed by #0 to #15 and the line above #0, are you able to publish those here?

ljy1003

luceos
#0 /www/flarum/vendor/illuminate/database/Connection.php(759): Illuminate\Database\Connection->runQueryCallback()
#1 /www/flarum/vendor/illuminate/database/Connection.php(739): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#2 /www/flarum/vendor/illuminate/database/Connection.php(648): Illuminate\Database\Connection->handleQueryException()
#3 /www/flarum/vendor/illuminate/database/Connection.php(353): Illuminate\Database\Connection->run()
#4 /www/flarum/vendor/illuminate/database/Query/Builder.php(2351): Illuminate\Database\Connection->select()
#5 /www/flarum/vendor/illuminate/database/Query/Builder.php(2595): Illuminate\Database\Query\Builder->runSelect()
#6 /www/flarum/vendor/illuminate/database/Query/Builder.php(2905): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#7 /www/flarum/vendor/illuminate/database/Query/Builder.php(2597): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /www/flarum/vendor/illuminate/database/Eloquent/Builder.php(754): Illuminate\Database\Query\Builder->pluck()
#9 /www/flarum/vendor/flarum/tags/src/Filter/HideHiddenTagsFromAllDiscussionsPage.php(27): Illuminate\Database\Eloquent\Builder->pluck()
#10 /www/flarum/vendor/illuminate/database/Query/Builder.php(335): Flarum\Tags\Filter\HideHiddenTagsFromAllDiscussionsPage->Flarum\Tags\Filter{closure}()
#11 /www/flarum/vendor/illuminate/database/Query/Builder.php(952): Illuminate\Database\Query\Builder->createSub()
#12 /www/flarum/vendor/illuminate/database/Query/Builder.php(998): Illuminate\Database\Query\Builder->whereIn()
#13 /www/flarum/vendor/flarum/tags/src/Filter/HideHiddenTagsFromAllDiscussionsPage.php(28): Illuminate\Database\Query\Builder->whereNotIn()
#14 /www/flarum/vendor/flarum/core/src/Foundation/ContainerUtil.php(30): Flarum\Tags\Filter\HideHiddenTagsFromAllDiscussionsPage->__invoke()
#15 /www/flarum/vendor/flarum/core/src/Filter/AbstractFilterer.php(73): Flarum\Foundation\ContainerUtil::Flarum\Foundation{closure}()

luceos

ljy1003 And the line above #0?

ljy1003

luceos Sorry,i sleep away.
Next Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] Connection refused (SQL: select id from tags where is_hidden = 1) in /www/flarum/vendor/illuminate/database/Connection.php:685
Stack trace:

luceos

ljy1003 connection refused means your database server isn't responding. Can you verify your database server is working properly?

ljy1003

luceos Yes,mysql is working

ljy1003

luceos This error log could be have entered the wrong database password when I installed flarum.

luceos

ljy1003 sorry but connection refused has nothing to do with Flarum. This is entirely an issue with the database server or its credentials.

katos

ljy1003 Are you using a .env file at all?

Can you try changing your database host from DB_HOST=127.0.0.1 to DB_HOST=localhost (if hosted on the same server as your webhost). I've seen this elsewhere before.

ljy1003

katos OK,I try to modify,thankyou