1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Need help with mysqli error

Discussion in 'Troubleshooting and Problems' started by Rho Delta, Mar 7, 2016.

  1. Rho Delta

    Rho Delta Well-Known Member

    Code:
    An exception occurred: Mysqli statement execute error : Duplicate entry '2573752' for key 'PRIMARY' in /home/mike/public_html/library/Zend/Db/Statement/Mysqli.php on line 214
    
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/Model/Search.php at line 77
    XenForo_Model_Search->insertSearch() in XenForo/ControllerPublic/FindNew.php at line 206
    XenForo_ControllerPublic_FindNew->findNewPosts() in XenForo/ControllerPublic/FindNew.php at line 24
    XenForo_ControllerPublic_FindNew->actionPosts() in Waindigo/Thumbnails/Extend/XenForo/ControllerPublic/FindNew.php at line 16
    Waindigo_Thumbnails_Extend_XenForo_ControllerPublic_FindNew->actionPosts() in Hex/Thumbnails/Extend/XenForo/ControllerPublic/FindNew.php at line 16
    Hex_Thumbnails_Extend_XenForo_ControllerPublic_FindNew->actionPosts() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/mike/public_html/index.php at line 13
    This happens when you click the new posts button. Can anyone help me please?
     
  2. Tracy Perry

    Tracy Perry Well-Known Member

    Yeah, try disabling the Waindigo add-on that results in
    Code:
    XenForo_ControllerPublic_FindNew->actionPosts() in Waindigo/Thumbnails/Extend/XenForo/ControllerPublic/FindNew.php at line 16
    Waindigo_Thumbnails_Extend_XenForo_ControllerPublic_FindNew->actionPosts() in Hex/Thumbnails/Extend/XenForo/ControllerPublic/FindNew.php at line 16
    
    the stack trace you provided.. then see if that resolves it.

    Or, make sure you are using the current version - which I think is now here:https://xenforo.com/community/resources/th-thumbnails.4834/
     
  3. Rho Delta

    Rho Delta Well-Known Member

    I uninstalled the thumbnails add on and rebuilt the search index and the error still occurs but now says this:

    Code:
    An exception occurred: Mysqli statement execute error : Duplicate entry '2573752' for key 'PRIMARY' in /home/mike/public_html/library/Zend/Db/Statement/Mysqli.php on line 214
    
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/Model/Search.php at line 77
    XenForo_Model_Search->insertSearch() in XenForo/ControllerPublic/FindNew.php at line 206
    XenForo_ControllerPublic_FindNew->findNewPosts() in XenForo/ControllerPublic/FindNew.php at line 24
    XenForo_ControllerPublic_FindNew->actionPosts() in XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/mike/public_html/index.php at line 13
     
  4. Mike

    Mike XenForo Developer Staff Member

    Can you run this query and show us the output?
    Code:
    SHOW CREATE TABLE xf_search;
     

Share This Page