Not a bug MySQL query error [1062]: Duplicate entry '1597117-79' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217

R

rdn

Well-known member
Affected version
2.1.4
Code: 
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '1597117-79' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 4:00 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'message', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(16) "/forums/79/watch"
  ["referrer"] => string(36) "https://domain.com/forums/79/watch"
  ["_GET"] => array(1) {
    ["/forums/79/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(7) "message"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
Code: 
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '777446-250' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 3:11 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'thread', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(17) "/forums/250/watch"
  ["referrer"] => string(37) "https://domain.com/forums/250/watch"
  ["_GET"] => array(1) {
    ["/forums/250/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(6) "thread"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
Code: 
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '777446-250' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 3:11 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'message', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(17) "/forums/250/watch"
  ["referrer"] => string(37) "https://domain.com/forums/250/watch"
  ["_GET"] => array(1) {
    ["/forums/250/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(7) "message"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
Code: 
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '777446-134' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 3:10 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'thread', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(17) "/forums/134/watch"
  ["referrer"] => string(37) "https://domain.com/forums/134/watch"
  ["_GET"] => array(1) {
    ["/forums/134/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(6) "thread"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}
 

Similar threads

HomieHunter
  • Locked
Not a bug XF\Db\Exception: MySQL query error [1364]: Field 'ap_ss_ignored_user_style' doesn't have a default value src/XF/Db/AbstractStatement.php
Replies
1
Views
67
Jeremy P
Jeremy P
btmgreg
  • Question Question
XF 2.2 ACP Error - Job XF:Feeder: MySQL query error [1062]: Duplicate entry '4-1641832730903322626' for key 'PRIMARY'
Replies
5
Views
706
btmgreg
btmgreg
V
XF\Db\InvalidQueryException: MySQL statement prepare error [1176]: Key 'PRIMARY' doesn't exist in table 'topics' in src/XF/Db/AbstractStatement.php at
Replies
0
Views
84
Vintage175
V
craigForo
Fixed XF\Db\Exception: MySQL query error [1366]: Incorrect string value:
Replies
13
Views
297
XF Bug Bot
XF Bug Bot
N
  • Question Question
XF 2.2 XF\Db\Exception: MySQL query error [1048]: Column 'ip_id' cannot be null in src/XF/Db/AbstractStatement.php at line 230
Replies
2
Views
232
nathanw
N
Back
Top Bottom