12 days later
17 days later

Does anyone know what conditions can lead to this bug?
FriendsOfFlarum/webhooks37

I am trying to figure out if there is a way I can workaround the issue by avoiding doing whatever causes it.

5 days later

1.0.1

  • Fix not all tags being available in dropdown
  • Improve error handling & reporting of both request & event issues
    • Events should now be reported to e.g. Sentry
    • Errors in the Flarum log file will now have a tiny bit more information

I've not been able to reproduce the Closure bug (FriendsOfFlarum/webhooks37) locally yet. 🤔

    DursunCan did you ever create this column manually (like I did a long time ago), or did you run the migrate after extension updated?

    datitisev
    ctml

    You could rename the column temporarily, tag_id_temp, run the migrate, enable extension, if all good then remove the newly created tag_id column and then rename the old one back to tag_id.

            How we can solve this problem?

            ctml
            Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'czayonli_banasor.fl_webhooks' doesn't exist in /home/czayonli/banasor.web.tr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

                czayorijinal Are you able to access the DB? If so, check if there are any rows in the migrations table (fl_migrations in your case) where extension column equals fof-webhooks... if not, then try disabling & enabling the extension 🤔 might have to do so by editing enabled_extensions row in settings table if you can't access the admin page without error...

                    czayorijinal no shell access with that provider? I don't know if it would be allowed by the provider, but maybe a bash script under a cronjob to execute this periodically, or even a one time php script to execute it when you hit it from browser (remove php script after).

                        ctml The command runs when enabling & disabling extensions, so it's not completely necessary to have access for that, but it would help in debugging the issue. Access to the DB is more necessary to resolve it.

                            fl_migrations : 2020_12_24_create_webhooks_table
                            fof-webhooks

                            This table was deleted because of my fault or for some other reason, what should I do to get it back?

                              czayorijinal If you're getting the error, that means the extension is currently enabled, right? In that case, fof-webhooks should already be in there. I mentioned it because to perform migrations you will have to re-enable an extension, and with the error you're getting I assume that's not currently possible from the website.

                              But first you should check the migrations table for rows that have the extension column equal to fof-webhooks.

                                  czayorijinal If that's the only row for fof-webhooks in migrations, delete the row. Then, remove fof-webhooks from extensions_enabled, and enable it from the forum admin side as you normally would.

                                      datitisev

                                      DEBUG:
                                      POST https://<domain>/api/extensions/fof-webhooks

                                      PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'czayonli_banasor.fl_webhooks' doesn't exist in

                                        datitisev ah gotcha, I didn't realize that was the case. Silly me, I've always been running them after installing extensions! Lol