No announcement yet.

1062 Duplicate entry Error Please Help

  • Filter
  • Time
  • Show
Clear All
new posts

  • 1062 Duplicate entry Error Please Help

    I keep getting the following database error error:

    Database error in vBulletin 5.5.4:

    Invalid SQL:

    SELECT routenew.*
    FROM forum2routenew AS routenew
    WHERE routenew.prefix IN ('forum/message-board/general-discussion-with-sub-forms-for-recent-purchase-looking-at-to-buy-pets/235410-your-opinion-Â -a-c-running-while-towingÂ…','forum/message-board/general-discussion-with-sub-forms-for-recent-purchase-looking-at-to-buy-pets','forum/message-board','forum') OR ishomeroute = 1


    MySQL Error : Illegal mix of collations for operation ' IN '
    Error Number : 1271
    Request Date : Tuesday, October 15th 2019 @ 01:54:32 PM
    Error Date : Tuesday, October 15th 2019 @ 01:54:32 PM
    Script :
    Referrer :
    IP Address :
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :

    Stack Trace:
    #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
    #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
    #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 576
    #3 vB_Database->query_read() called in [path]/vb/db/result.php on line 144
    #4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 68
    #5 vB_dB_Result->__construct() called in [path]/vb/db/query/stored.php on line 104
    #6 vB_dB_Query_Stored->execSQL() called in [path]/vb/db/assertor.php on line 301
    #7 vB_dB_Assertor->assertQuery() called in [path]/vb/api/route.php on line 163
    #8 vB_Api_Route->getRoute() called in [path]/vb/api/wrapper.php on line 197
    #9 vB_Api_Wrapper->__call() called in /home/nroacom/public_html/forum/includes/api/interface/collapsed.php on line 101
    #10 Api_Interface_Collapsed->callApi() called in /home/nroacom/public_html/forum/includes/vb5/frontend/routing.php on line 121
    #11 vB5_Frontend_Routing->setRoutes() called in /home/nroacom/public_html/forum/includes/vb5/frontend/application.php on line 21
    #12 vB5_Frontend_Application::init() called in /home/nroacom/public_html/forum/index.php on line 48

    I have tried changing all the collations in the database and it seems like everything has been changed to utf8_general_ci except in the phrase table. I get everything changed except the varname row which stays at latin1_bin. When I try to change the collation on that row I get the following sql error:

    #1062 - Duplicate entry 'common.langDirLtr--1' for key 'name_lang_type'

    Can someone please help me with a way to fix this? I am getting 50 emails a day about this error.


Related Topics