Bug MySQL query error [1062]: Duplicate entry

Status
Not open for further replies.

Nirjonadda

Customer
Getting Server error log.

Code:
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'e62e8042ba12ced2b766a9408c1533a4-805' for key 'fingerprint_user_id' src/XF/Db/AbstractStatement.php:217

Generated by: habijabi.ajgubi May 1, 2019 at 3:14 AM

Stack trace

INSERT  INTO `xf_dbtech_security_fingerprint_log` (`user_id`, `fingerprint`, `ipaddress`, `components`, `fingerprint_log_id`, `dateline`) VALUES (?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_dbtech_secur...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/DBTech/Security/Watcher/NewFingerprint.php(70): XF\Mvc\Entity\Entity->save()
#7 src/addons/DBTech/Security/Watcher/AbstractHandler.php(172): DBTech\Security\Watcher\NewFingerprint->preCheck(Array, Object(Datio\AllowedEmails\XF\Entity\User))
#8 src/addons/DBTech/Security/Pub/Controller/Fingerprint.php(37): DBTech\Security\Watcher\AbstractHandler->trigger(Array, Object(Datio\AllowedEmails\XF\Entity\User))
#9 src/XF/Mvc/Dispatcher.php(321): DBTech\Security\Pub\Controller\Fingerprint->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('DBTech\\Security...', 'Index', Object(XF\Mvc\RouteMatch), Object(DBTech\Security\Pub\Controller\Fingerprint), NULL)
#11 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(DBTech\Security\Pub\Controller\Fingerprint), NULL)
#12 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#14 src/XF.php(390): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}

Request state

array(4) {
  ["url"] => string(38) "/index.php?dbtech-security/fingerprint"
  ["referrer"] => string(36) "/search/42622/"
  ["_GET"] => array(1) {
    ["dbtech-security/fingerprint"] => string(0) ""
  }
  ["_POST"] => array(6) {
    ["fingerprint"] => string(32) "e62e8042ba12ced2b766a9408c1533a4"
    ["components"] => array(23) {
      [0] => array(2) {
        ["key"] => string(10) "user_agent"
        ["value"] => string(131) "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 OPR/58.0.3135.132"
      }
      [1] => array(2) {
        ["key"] => string(8) "language"
        ["value"] => string(5) "en-US"
      }
      [2] => array(2) {
        ["key"] => string(11) "color_depth"
        ["value"] => string(2) "24"
      }
      [3] => array(2) {
        ["key"] => string(13) "device_memory"
        ["value"] => string(1) "8"
      }
      [4] => array(2) {
        ["key"] => string(20) "hardware_concurrency"
        ["value"] => string(1) "4"
      }
      [5] => array(2) {
        ["key"] => string(10) "resolution"
        ["value"] => array(2) {
          [0] => string(4) "1280"
          [1] => string(3) "800"
        }
      }
      [6] => array(2) {
        ["key"] => string(20) "available_resolution"
        ["value"] => array(2) {
          [0] => string(4) "1280"
          [1] => string(3) "763"
        }
      }
      [7] => array(2) {
        ["key"] => string(15) "timezone_offset"
        ["value"] => string(4) "-360"
      }
      [8] => array(2) {
        ["key"] => string(15) "session_storage"
        ["value"] => string(1) "1"
      }
      [9] => array(2) {
        ["key"] => string(13) "local_storage"
        ["value"] => string(1) "1"
      }
      [10] => array(2) {
        ["key"] => string(10) "indexed_db"
        ["value"] => string(1) "1"
      }
      [11] => array(2) {
        ["key"] => string(13) "open_database"
        ["value"] => string(1) "1"
      }
      [12] => array(2) {
        ["key"] => string(9) "cpu_class"
        ["value"] => string(7) "unknown"
      }
      [13] => array(2) {
        ["key"] => string(18) "navigator_platform"
        ["value"] => string(5) "Win32"
      }
      [14] => array(2) {
        ["key"] => string(15) "regular_plugins"
        ["value"] => array(3) {
          [0] => string(82) "Chromium PDF Plugin::Portable Document Format::application/x-google-chrome-pdf~pdf"
          [1] => string(42) "Chromium PDF Viewer::::application/pdf~pdf"
          [2] => string(66) "News feed handler::::application/atom+xml~,application/rss+xml~rss"
        }
      }
      [15] => array(2) {
        ["key"] => string(6) "canvas"
        ["value"] => string(33971) "canvas winding:yes~canvas "
      }
      [16] => array(2) {
        ["key"] => string(12) "webgl_vendor"
        ["value"] => string(76) "Google Inc.~ANGLE (Intel(R) Iris(TM) Graphics 5100 Direct3D11 vs_5_0 ps_5_0)"
      }
      [17] => array(2) {
        ["key"] => string(7) "adblock"
        ["value"] => string(5) "false"
      }
      [18] => array(2) {
        ["key"] => string(18) "has_lied_languages"
        ["value"] => string(5) "false"
      }
      [19] => array(2) {
        ["key"] => string(19) "has_lied_resolution"
        ["value"] => string(5) "false"
      }
      [20] => array(2) {
        ["key"] => string(11) "has_lied_os"
        ["value"] => string(5) "false"
      }
      [21] => array(2) {
        ["key"] => string(16) "has_lied_browser"
        ["value"] => string(5) "false"
      }
      [22] => array(2) {
        ["key"] => string(13) "touch_support"
        ["value"] => array(3) {
          [0] => string(1) "0"
          [1] => string(5) "false"
          [2] => string(5) "false"
        }
      }
    }
    ["_xfRequestUri"] => string(14) "/search/42622/"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
Hello @Nirjonadda,

We hope your ticket regarding DragonByte Security has been addressed to your satisfaction. This ticket has now been closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.
 
Status
Not open for further replies.

DragonByte Security

XenForo 1.5.3+ XenForo 2.0.x XenForo 2.1.x XenForo 2.2.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
2,200
Customer rating
5.00 star(s) 1 ratings
Top