[OzzModz] Login Log 2.1.0 Patch Level 3

[Ozzy47]

Ozzy47 submitted a new resource:

[OzzModz] Login Log - Log logins to the site

Requirements:
XenForo 2.2+

Description:
This small addon will add a login log on your site. You can set how long to store the entries for. There are user permissions as to who can see the log, I suggest admins and mods only.

Link:
View attachment 299739

Example List:
View attachment 299740

Options:
View attachment 299741

Permissions:
View attachment 299742

Read more about this resource...

 

[Fulminata]

XF\Db\InvalidQueryException: xf_ozzmodz_login_log: MySQL statement prepare error [1101]: BLOB, TEXT, GEOMETRY or JSON column 'username' can't have a default value in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 158
XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 191
XF\Db\SchemaManager->createTable() in src/addons/OzzModz/LoginLog/Setup.php at line 24
OzzModz\LoginLog\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 62
OzzModz\LoginLog\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 29
OzzModz\LoginLog\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 419
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
XF\App->run() in src/XF.php at line 524
XF::runApp() in admin.php at line 13

 

[Ozzy47]

Was that on install? If it was, did the addon install at all?

 

[Ozzy47]

Ozzy47 updated [OzzModz] Login Log with a new update entry:

[OzzModz] Login Log for XenForo 2.2+ Update 2.0.0 Patch Level 2

2.0.0 Patch Level 2
Fix: TEXT column can't have a default value on MySQL when strict mode enabled

Read the rest of this update entry...

 

[Ozzy47]

XF\Db\InvalidQueryException: xf_ozzmodz_login_log: MySQL statement prepare error [1101]: BLOB, TEXT, GEOMETRY or JSON column 'username' can't have a default value in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 158
XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 191
XF\Db\SchemaManager->createTable() in src/addons/OzzModz/LoginLog/Setup.php at line 24
OzzModz\LoginLog\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 62
OzzModz\LoginLog\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 29
OzzModz\LoginLog\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 419
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
XF\App->run() in src/XF.php at line 524
XF::runApp() in admin.php at line 13

Uninstall the addon if it installed, delete the files, and install Patch level 2

 

[Ozzy47]

Ozzy47 updated [OzzModz] Login Log with a new update entry:

[OzzModz] Login Log for XenForo 2.2+ Update 2.0.0 Patch Level 3

2.0.0 Patch Level 3
Fixed issues with cron job.

Read the rest of this update entry...

 

[Fulminata]

Template Compilation Error
public:ozzmodz_login_log - Column 'display_style_group_id' is unknown in /var/www/*/data/*/src/XF/Mvc/Entity/Entity.php:612

do you know how to write code?

 

[Ozzy47]

Template Compilation Error
public:ozzmodz_login_log - Column 'display_style_group_id' is unknown in /var/www/*/data/*/src/XF/Mvc/Entity/Entity.php:612

do you know how to write code?

Don’t use the addon.

 

[Ozzy47]

Ozzy47 updated [OzzModz] Login Log with a new update entry:

[OzzModz] Login Log for XenForo 2.2+ Update 2.1.0

WARNING, WARNING, WARNING!!!!!!!!!!!

Now That Ive got your attention:
Before installing this version, uninstall any previous version you have installed!!!!!

2.1.0
Renamed the database table and template to avoid conflicts with Login Spaminator

Read the rest of this update entry...

 

[Ozzy47]

Ozzy47 updated [OzzModz] Login Log with a new update entry:

[OzzModz] Login Log for XenForo 2.2+ Update 2.1.0 Patch Level 2

2.1.0 Patch Level 2
Fixed: Column 'display_style_group_id' is unknown src/XF/Mvc/Entity/Entity.php
Fixed: Avoid N+1 queries
Changed: Table structure and some columns

Read the rest of this update entry...

 

[Ozzy47]

Ozzy47 updated [OzzModz] Login Log with a new update entry:

[OzzModz] Login Log for XenForo 2.2+ Update 2.1.0 Patch Level 3

2.1.0 Patch Level 3:

• Code cleanup
• Properly convert IP addresses on addon upgrade
• Database table structure & query optimizations
• Set correct route section context
• Log page layout fixes

Read the rest of this update entry...

 

[christisking]

This mod has a bug.

When viewing the logs and clicking on next page, I get an error:

Oops! We ran into some problems.​

The requested page could not be found.

The problem is in the file src/addons/OzzModz/LoginLog/_data/templates.xml on line 41:

 39 </div>
 40
 41 <xf:pagenav link="loginlogsx" page="{$page}" perpage="{$perPage}" total="{$total}"
 42                         wrapperclass="block-outer block-outer--after" />]]></template>
 43 </templates>

It should be "loginlogs" instead of "loginlogsx" which causes the URL to render incorrectly as for example: https://site.domain/loginlogsx/?page=3

I removed the extra "x" and rebuilt the addon, ignored the warning and now I am able to see beyond page 1.