What I did

• I have tried using this plugin with PHP 7.1.11 and a dedicated mysql datasource. Basic db logging works.
• Even if I add syntax errors to my controller action, it works.
• However if I add syntax/fatal errors to my .ctp templates, it does not show up neither in the database log (nor potential file logs).

Can you confirm? Any idea why?

Running CakePHP v3.3.16 I've noticed a very strange issue with logging manually (i.e. using Log::write() from a controller or a view)

It seems that logs are being written to the database twice. After several testing I've noticed that the issue is due to the config in the app.php file;

'Log' => [ 'debug' => [ 'className' => 'DatabaseLog.Database' ], 'error' => [ 'className' => 'DatabaseLog.Database' ], ],

With the above config, the logged will save two records in the table. But the following config will save only one record: 'Log' => [ 'debug' => [ 'className' => 'DatabaseLog.Database' ] ],

Hi. I'm having trouble using the plugin with the friendsofcake/upload plugin. I'm getting the error below.

Fatal error: Allowed memory size of 2151677952 bytes exhausted (tried to allocate 20480 bytes) in /var/www/mydevsys/vendor/cakephp/cakephp/src/ORM/Marshaller.php on line 75

I tried increasing the memory limit but this increased the execution time and the error persisted. I'm using MySql to log the messages. Please assist.

With this patch it is possible to overwrite pagination options from the child classes. For example:

<?php
namespace App\Controller;

use DatabaseLog\Controller\Admin\LogsController as BaseController;

class LogsController extends BaseController
{
    public function initialize()
    {
        parent::initialize();
        $this->paginate['limit'] = 5;
    }
}

I have test connection configured only in my dev environment.

On production where there is no test connection defined I get an error:

Error: The datasource configuration test was not found in config/app.php

which is caused by DatbaseLogsTable::ensureTables() method. I think this (ensuring tables) should be at least optional.

Running version 3.0.0 of this plugin on CentOS 7 in CakePHP 4.1.3. Followed the installation/configuration instructions. Plugin is loaded with 'routes' => true option. The Friends of Cake "Search" plugin is also loaded. When I try to load localhost/admin/database-log/logs, I get the following error:

DatabaseLog.LogsController could not be found

The LogsController is present, however.

When I just load localhost/admin/database-log, I can see the error log entries. I cannot , however, use any of the filters or any of the actions (Remove Duplicates, Reset Logs) without getting the following error:

Search.PrgComponent could not be found.

I'm guessing that's because I should be loading admin/database-log/logs instead of admin/database-log. Can you suggest what I should look for to fix this?

JavaScript DataTables plugin uses GET request by default to perform AJAX calls for loading table content. In certain occassions it started hitting VARCHAR(255) column limits.

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uri'

As a quick fix, we can alter 'uri' column into text, that will let us store longer URI's in the table.

Hello there,

nice plugin. I am curious how can it be used with AuthComponent. In Plugin/DatabaseLog/Controllers I added a befreFilter function with $this->Auth->allow();

If I update the plugin through composer, won't these files be overwritten? Is there a way not to do so?

I'm getting depreciation errors.

CakePHP 3.6.x

Deprecated: DatabaseLog\Model\Table\DatabaseLogsTable::displayField() is deprecated. Use setDisplayField()/getDisplayField() instead. - 
C:\xampp\htdocs\pos-certificados\vendor\dereuromark\cakephp-databaselog\src\Model\Table\DatabaseLogsTable.php, line: 46

and

Deprecated: DatabaseLog\Model\Table\DatabaseLogsTable::connection() is deprecated. Use setConnection()/getConnection() instead. - 
C:\xampp\htdocs\pos-certificados\vendor\dereuromark\cakephp-databaselog\src\Model\Table\LazyTableTrait.php, line: 56

Hi!

I use this plugin and a slightly altered version of the cakephp-app template and the testMissingTemplateInDebug() https://github.com/cakephp/app/blob/master/tests/TestCase/Controller/PagesControllerTest.php#L75 test fails on me.

I think it might be because a missingTemplate Exception is thrown (deliberately), which starts this database log plugin, but it's looking for a test-log datasource configuration: Cake\Datasource\Exception\MissingDatasourceConfigException: The datasource configuration "test_database_log" was not found. That config doesn't seem to exist.

How can we fix that, how can we ensure the test_database_log config does indeed exist? We could add the test_database_log connection in your bootstrap.php, just like we do with database_log, but I'm not sure that is the way to go. Do you have any insight on this? Except Disabling databaselog for testing https://github.com/dereuromark/CakePHP-DatabaseLog/tree/master/docs#disabling-for-tests. :)

We tried using the plugin with just the default settings (loading the plugin and changing the entries in config/app.php as described in README.md). It didn't work, kept telling me that "datasource configuration "database_log" was not found." I figured out that we would need to add said datasource configuration and that this is done in your bootstrap file, which therefore should be included when loading the plugin.