[DBTech] DragonByte Security

[DBTech] DragonByte Security [Paid] 5.1.2

No permission to buy (€14.95)
Overview Updates (52) Reviews (3) History Discussion
Full Error:

Code: 
XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:230
Ekleyen: UnkownTecho 3 Nisan 2025 06:35

>Yığın Takibi

            -- XFDB=noForceAllWrite
            INSERT INTO xf_dbtech_security_session
                (session_id, user_id, start_date, last_activity_date, user_agent)
            VALUES
                (?, ?, ?, ?, ?)
            ON DUPLICATE KEY UPDATE
                user_id = VALUES(user_id),
                start_date = VALUES(start_date),
                last_activity_date = VALUES(last_activity_date),
                user_agent = VALUES(user_agent)
        
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/addons/DBTech/Security/Repository/SessionRepository.php(144): XF\Db\AbstractAdapter->query('
            -- XFDB=noF...', Array)
#4 src/addons/DBTech/Security/XF/Session/Session.php(133): DBTech\Security\Repository\SessionRepository->updateSessionLastActive(Object(DBTech\Security\Entity\Session))
#5 src/XF/Pub/App.php(517): DBTech\Security\XF\Session\Session->save()
#6 src/XF/App.php(2829): XF\Pub\App->complete(Object(XF\Http\Response))
#7 src/XF.php(806): XF\App->run()
#8 index.php(23): XF::runApp('XF\\Pub\\App')
#9 {main}
>Talep Yeri
array(4) {
  ["url"] => string(30) "/sosyal/index.php?tags/suggest"
  ["referrer"] => string(54) "https://techolay.net/sosyal/bolum/kasa.205/post-thread"
  ["_GET"] => array(1) {
    ["tags/suggest"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}
 
Recep Baltaş said:
Full Error:

Code: 
XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:230
Ekleyen: UnkownTecho 3 Nisan 2025 06:35

>Yığın Takibi

            -- XFDB=noForceAllWrite
            INSERT INTO xf_dbtech_security_session
                (session_id, user_id, start_date, last_activity_date, user_agent)
            VALUES
                (?, ?, ?, ?, ?)
            ON DUPLICATE KEY UPDATE
                user_id = VALUES(user_id),
                start_date = VALUES(start_date),
                last_activity_date = VALUES(last_activity_date),
                user_agent = VALUES(user_agent)
       
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/addons/DBTech/Security/Repository/SessionRepository.php(144): XF\Db\AbstractAdapter->query('
            -- XFDB=noF...', Array)
#4 src/addons/DBTech/Security/XF/Session/Session.php(133): DBTech\Security\Repository\SessionRepository->updateSessionLastActive(Object(DBTech\Security\Entity\Session))
#5 src/XF/Pub/App.php(517): DBTech\Security\XF\Session\Session->save()
#6 src/XF/App.php(2829): XF\Pub\App->complete(Object(XF\Http\Response))
#7 src/XF.php(806): XF\App->run()
#8 index.php(23): XF::runApp('XF\\Pub\\App')
#9 {main}
>Talep Yeri
array(4) {
  ["url"] => string(30) "/sosyal/index.php?tags/suggest"
  ["referrer"] => string(54) "https://techolay.net/sosyal/bolum/kasa.205/post-thread"
  ["_GET"] => array(1) {
    ["tags/suggest"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}
Click to expand...
That’s not the delete query.
 
DragonByte Tech updated [DBTech] DragonByte Security with a new update entry:

5.1.0 Patch Level 1

Update highlights​

This version fixes a regression from v5.0.x causing active forums to receive a MySQL error message saying "lock wait timeout exceeded".

Additionally, further optimisations have been made to the session update code to improve performance.


Complete Change Log​

Fix: The isExpired check now uses the new settings
Fix: Fix regression causing MySQL errors
Click to expand...

Read the rest of this update entry...
 
@DragonByte Tech

Got this error trying to upgrade from 5.0.1 to 5.1.0.1 on our dev site running XF 2.3.6 and PHP 8.3.19.

Code: 
An exception occurred: [ErrorException] [E_WARNING] Undefined array key "dbtechSecurityLoggedInSessionPrune" in src/XF/Options.php on line 29

    XF::handlePhpError()
    ArrayObject->offsetGet() in src/XF/Options.php at line 29
    XF\Options->offsetGet() in src/addons/DBTech/Security/Entity/Session.php at line 75
    DBTech\Security\Entity\Session->isExpired() in src/addons/DBTech/Security/XF/Session/Session.php at line 123
    DBTech\Security\XF\Session\Session->save() in src/XF/Admin/App.php at line 118
    XF\Admin\App->complete() in src/XF/App.php at line 2829
    XF\App->run() in src/XF.php at line 806
    XF::runApp() in admin.php at line 15
 
Joe Link said:
@DragonByte Tech

Got this error trying to upgrade from 5.0.1 to 5.1.0.1 on our dev site running XF 2.3.6 and PHP 8.3.19.

Code: 
An exception occurred: [ErrorException] [E_WARNING] Undefined array key "dbtechSecurityLoggedInSessionPrune" in src/XF/Options.php on line 29

    XF::handlePhpError()
    ArrayObject->offsetGet() in src/XF/Options.php at line 29
    XF\Options->offsetGet() in src/addons/DBTech/Security/Entity/Session.php at line 75
    DBTech\Security\Entity\Session->isExpired() in src/addons/DBTech/Security/XF/Session/Session.php at line 123
    DBTech\Security\XF\Session\Session->save() in src/XF/Admin/App.php at line 118
    XF\Admin\App->complete() in src/XF/App.php at line 2829
    XF\App->run() in src/XF.php at line 806
    XF::runApp() in admin.php at line 15
Click to expand...
Can you try disabling the addon before updating it? I'll update this for the future, but for now disabling the addon should allow it to upgrade.
 
@DragonByte Tech

There seems to be a conflict with Xon's Password Tools. As mentioned in this post:

Joe Link said:
@Xon

Odd bug here. With Minimum password length set to 15, trying to use either Send password reset or Security lock: Locked: User must reset password from the ACP user edit screen throws this error:

View attachment 327174

If I set it to 10 the error goes away and I can proceed. Happens with both XF 2.2 and 2.3.
Click to expand...

If I try after disabling [DragonByte] Security the error goes away.
 
To answer it here as well in case others run into the same issue; DragonByte Security has its own "Minimum password length" setting which must match the setting in Password Tools, since the permission controls the length of the automatically generated passwords when using those options.
 
DragonByte Tech updated [DBTech] DragonByte Security with a new update entry:

5.1.2

Update highlights​

This version improves compatibility with future versions of XenForo by moving certain code calls out of templates. This update is recommended to avoid compatibility issues with the upcoming XenForo v2.3.8 & newer.

Furthermore, a new "Maintenance" page has been added, providing easy access to the various rebuild tasks available in this addon.

Lastly, a template error that could occur when viewing the "your logged in sessions" list has been fixed...
Click to expand...

Read the rest of this update entry...
 
DragonByte Tech said:
To answer it here as well in case others run into the same issue; DragonByte Security has its own "Minimum password length" setting which must match the setting in Password Tools, since the permission controls the length of the automatically generated passwords when using those options.
Click to expand...

Awesome, thanks for the quick response. I thought it had it's own setting, just couldn't find it :)
 
You must log in or register to reply here.

Similar threads

jjasko11
Croatian translation for DragonByte Security 4.7.0
Replies
0
Views
5
jjasko11
jjasko11
DragonByte Tech
[DBTech] DragonByte Bluesky Poster
2 3
Replies
42
Views
566
lutish
lutish
jjasko11
Croatian translation for DragonByte Security 4.7.0
Replies
0
Views
7
jjasko11
jjasko11
VisEntities
DBTech DragonByte eCommerce vs XFA RM Marketplace?
Replies
0
Views
108
VisEntities
VisEntities
DragonByte Tech
[DBTech] DragonByte Stripe Checkout
2
Replies
35
Views
969
DragonByte Tech
DragonByte Tech
Back
Top Bottom