[DBTech] DragonByte Security [Paid] 5.1.0.1

[Recep Baltaş]

Full Error:

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) {
  }
}

 

[DragonByte Tech]

Full Error:

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) {
  }
}

That’s not the delete query.

 

[Recep Baltaş]

This is the whole error message:




We can provide you admin access if you 'd like to look deeper into the issue.

 

[DragonByte Tech]

This is the whole error message:

View attachment 321070

That’s also not the delete query, but I think I see what’s happening regardless. I’ll put out a PL1 later today.

 

[Recep Baltaş]

We can provide you admin access if you 'd like to look deeper into the issue.

 

[DragonByte Tech]

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

Read the rest of this update entry...

 

[Joe Link]

@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.

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

 

[DragonByte Tech]

@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.

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

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.