Audit Log Free

clarkwinkelmann · Jun 3, 2021

Version 1.4.0 - June 3, 2021

Add compatibility with Flarum 1.0.
Add support for Flarum Nickname extension.
(Pro only) Add separate logs for nickname change requests in FoF Username Request extension.
(Pro only) Add "reason" log for FoF Impersonate extension (visible under raw log).
(Pro only) Fix "edited at" not correctly logged for Author Change extension.
(Pro only) Slug and display name driver settings changes are now logged with their values.

This version can be installed on Flarum 1.0.0 and all future 1.x versions.
It will be automatically installed when you upgrade to Flarum 1.0 by following the official release guide.

HHari · Jun 3, 2021

clarkwinkelmann this was in my watch list .. thanks for updating

Edit :

unable to enable the extension

Error Oops! Something went wrong. Please reload the page and try again.

uninstalled it

clarkwinkelmann · Jun 3, 2021

Hari can you check the Flarum log file at <flarum>/storage/logs or enable debug in config.php before trying again? I need the full error message to understand. Also please explain if you were updating or if this is a new installation of my extension.

In any case, make sure your server meets the requirements https://kilowhat.net/flarum/extensions/audit#requirements There's a required MySQL or MadiaDB version that's higher than Flarum base requirements.

HHari · Jun 3, 2021

clarkwinkelmann Also please explain if you were updating or if this is a new installation of my extension.

New installation of your extension

clarkwinkelmann There's a required MySQL or MadiaDB version that's higher than Flarum base requirements.

Sry, i did not notice that my mySQL is 5.6.51-log

i think we need MySQL 5.7.8+

shall i update MySQL will it cause any other Wordpress problems? (worried)

clarkwinkelmann · Jun 3, 2021

Hari if the other web application on your host are up to date they are most likely already compatible with the latest MySQL version. I can't know for sure though. Always make backups and be ready to revert to the old version if the update fails.

Wadera · Jun 3, 2021

Hari shall i update MySQL will it cause any other Wordpress problems? (worried)

Most likely not updating it will cause more problems in future (assuming you don't have very old WordPress extensions, it won't be an issue), but backup (or snapshot if it's VPS or you have that ability on storage level) is your friend.

HHari · Jun 3, 2021

clarkwinkelmann Wadera I'm in cloudways, i will learn how to take a snapshot. I have too many folders and different installations I have to list them all thanks a lot for your tips. recently upgraded to the latest WordPress version/latest plugins but I do also have some custom codes to save data in MySQL I will test

Justman10000 · Jul 9, 2021

I just wanted to call the aim ACP plugin, but then this came up:

TypeError: n[0] is undefined
header AuditPage.js:19
view ExtensionPage.js:48
e extend.js:78
s render.js:30
c render.js:155
c render.js:160
c render.js:66
u render.js:50
c render.js:103
c render.js:62
h render.js:487
h render.js:419
f render.js:302
exports render.js:964
s mount-redraw.js:14
g router.js:114
mount-redraw.js:15:23
s mount-redraw.js:15
g router.js:114

clarkwinkelmann · Jul 9, 2021

Justman10000 are you running the latest Flarum and extension version?

Justman10000 · Jul 9, 2021

clarkwinkelmann

Hmm... I should have to look later... It could actually be that the version I have is out of date (I haven't thought about it yet )!

clarkwinkelmann · Jul 9, 2021

Justman10000 I'm saying that because an error very similar to yours was fixed in one of the recent release. If that's the same one then you just need to update. Otherwise I'll investigate ️

Justman10000 · Jul 10, 2021

clarkwinkelmann

I ran composer update! This plugin was not included in the update! Is therefore up to date!

clarkwinkelmann · Jul 21, 2021

Version 1.4.1 - July 21, 2021

Fix IP address not logged for login and signup.

custom_user · Jul 23, 2021

Extension page is showing blank page is it expected behaviour or some issue

HHari · Jul 23, 2021

custom_user Check MySQL compatibility, It should be 5.7+ as far I remember. Goto first post you will find system requirements link

You can see your current MySQL version info in your flarum dashboard

custom_user · Jul 23, 2021

Yes I see it's showing v 8.0.2 on dashboard

custom_user · Jul 23, 2021

This issue was caused by Asirem theme in my flarum I am having 4 extensions websockets, Asirem, best answer so I disabled one by one and got the issue that as per the modifications of Asirem theme audit log is showing blank admin page.

HHari · Aug 20, 2021

Hari I've recently updated mySQL to 5.7.35 and installed the extension. works like a charm!

thanks flarum doctor

clarkwinkelmann · Aug 25, 2021

Version 1.4.2 - August 25, 2021

Fix Flarum boot error if Flags extension has been uninstalled via Composer.

jslirola · Nov 2, 2021

clarkwinkelmann Hi Clark,

I tried to install this extension after upgrading my forum to the version 1.1.0. When I click on "Enable" I´m getting this error:

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json null, `created_at` datetime not null) default character set utf8mb4 collate' at line 1 (SQL: create table `kilowhat_audit_log` (`id` int unsigned not null auto_increment primary key, `actor_id` int unsigned null, `client` varchar(255) not null, `ip_address` varchar(255) null, `action` varchar(255) not null, `payload` json null, `created_at` datetime not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /home2/myuser/flarum_base/vendor/illuminate/database/Connection.php:703
Stack trace:
#0 /home2/myuser/flarum_base/vendor/illuminate/database/Connection.php(663): Illuminate\Database\Connection->runQueryCallback('create table `k...', Array, Object(Closure))
#1 /home2/myuser/flarum_base/vendor/illuminate/database/Connection.php(493): Illuminate\Database\Connection->run('create table `k...', Array, Object(Closure))
#2 /home2/myuser/flarum_base/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('create table `k...')
#3 /home2/myuser/flarum_base/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /home2/myuser/flarum_base/vendor/illuminate/database/Schema/Builder.php(228): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /home2/myuser/flarum_base/vendor/kilowhat/flarum-ext-audit-free/migrations/2020_06_12_create_log_table.php(22): Illuminate\Database\Schema\Builder->create('kilowhat_audit_...', Object(Closure))
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#7 /home2/myuser/flarum_base/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#8 /home2/myuser/flarum_base/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration(Array)
#9 /home2/myuser/flarum_base/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp('/home2/myuser...', '2020_06_12_crea...', Object(Flarum\Extension\Extension))
#10 /home2/myuser/flarum_base/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList('/home2/myuser...', Array, Object(Flarum\Extension\Extension))
#11 /home2/myuser/flarum_base/vendor/flarum/core/src/Extension/Extension.php(503): Flarum\Database\Migrator->run('/home2/myuser...', Object(Flarum\Extension\Extension))
#12 /home2/myuser/flarum_base/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#13 /home2/myuser/flarum_base/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#14 /home2/myuser/flarum_base/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable('kilowhat-audit-...')
#15 /home2/myuser/flarum_base/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle(Object(Flarum\Extension\Command\ToggleExtension))
#16 /home2/myuser/flarum_base/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}(Object(Flarum\Extension\Command\ToggleExtension))
#17 /home2/myuser/flarum_base/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Flarum\Extension\Command\ToggleExtension))
#18 /home2/myuser/flarum_base/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#19 /home2/myuser/flarum_base/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow(Object(Flarum\Extension\Command\ToggleExtension))
#20 /home2/myuser/flarum_base/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch(Object(Flarum\Extension\Command\ToggleExtension))
#21 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Laminas\Diactoros\ServerRequest))
#22 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Laminas\Diactoros\ServerRequest), Array)
#23 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Closure))
#24 /home2/myuser/flarum_base/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#25 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#26 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#27 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#28 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#29 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#30 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#31 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#32 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#33 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#34 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#35 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#36 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#37 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#38 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#39 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#40 /home2/myuser/flarum_base/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#41 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#42 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#43 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#44 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#45 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#46 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#47 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#48 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#49 /home2/myuser/flarum_base/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#50 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#51 /home2/myuser/flarum_base/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#52 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#53 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#54 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#55 /home2/myuser/flarum_base/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#56 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#57 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#58 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#59 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#60 /home2/myuser/flarum_base/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
#61 /home2/myuser/flarum_base/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
#62 /home2/myuser/flarum_base/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#63 /home2/myuser/domain.com/forum/index.php(26): Flarum\Http\Server->listen()
#64 {main}

Environment:

Flarum core 1.1.1
PHP version: 7.4.25
MySQL version: 5.6.41-84.1

Any idea how to fix it? Thank you.