Find the answer to your Linux question:
Results 1 to 2 of 2
I just got this when clicking the link to "view my posts" Could not insert search results DEBUG MODE SQL Error : 1062 Duplicate entry '484095172' for key 1 INSERT ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Banned Richard_The_Lionhearted's Avatar
    Join Date
    Feb 2005
    Location
    Here, where else?
    Posts
    379

    General Error


    I just got this when clicking the link to "view my posts"

    Could not insert search results

    DEBUG MODE

    SQL Error : 1062 Duplicate entry '484095172' for key 1

    INSERT INTO search_results (search_id, session_id, search_array) VALUES(484095172, '8cd962e04126bec6e6c134c82e19f42d', 'a:7:{s:14:"search_results";s:1297:"2659, 2919, 6841, 31223, 34041, 34192, 34964, 34968, 34971, 35819, 35825, 35874, 35924, 36006, 36029, 36095, 36097, 36133, 36152, 36158, 36282, 36401, 36450, 36465, 36946, 37015, 37016, 37088, 37089, 37110, 37137, 37196, 37212, 37223, 37269, 37277, 37296, 37314, 37347, 37359, 37366, 37375, 37378, 37390, 37402, 37405, 37415, 37417, 37422, 37474, 37483, 37485, 37490, 37512, 37520, 37523, 37524, 37569, 37577, 37588, 37596, 37597, 37601, 37605, 37607, 37840, 37957, 38002, 38025, 38068, 38113, 38161, 38178, 38213, 38215, 38343, 38384, 38401, 38402, 38409, 38459, 38509, 38525, 38530, 38634, 38635, 38658, 38740, 38808, 38846, 38857, 38933, 38951, 38952, 38955, 39197, 39800, 39870, 39872, 39890, 39894, 39913, 39918, 40019, 40143, 40239, 40270, 40480, 41427, 41693, 41816, 41902, 42089, 42101, 42102, 42130, 42146, 42147, 42159, 42203, 42204, 42212, 42339, 42384, 42543, 42842, 42927, 43098, 43405, 43567, 43575, 43583, 43878, 44066, 44426, 44438, 44495, 44497, 44500, 44538, 44573, 44590, 44619, 44801, 44902, 44973, 45187, 45274, 45342, 45345, 45350, 45472, 45480, 45541, 45652, 45658, 45692, 45732, 45760, 45777, 45804, 45841, 45845, 45866, 45878, 45881, 46088, 46164, 46180, 46182, 46188, 46213, 46217, 46284, 46287, 46388, 46392, 46441, 46635, 46828, 46832, 46851, 46855, 46865, 46873, 46892";s:17:"total_match_count";i:186;s:12:"split_ search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DE SC";s:12:"show_results";s:6:"topics";s:12:"return_ chars";i:200;}')

    Line : 746
    File : search.php

    Hope this helps you to fix the problem.

  2. #2
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    I've looked into this error in the past, I think it's a bug in phpbb when 2 people search at the same time, just use the refresh button and the search should work.

    http://www.linuxforums.org/forum/topic-33306.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •