Search Function.. Screwed !!

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
dahia
Registered User
Posts: 334
Joined: Tue Jan 18, 2005 3:26 pm
Location: Earth

Search Function.. Screwed !!

Post by dahia »

i wake up this morning to find my board search function not working properly
givig out this error :?

Code: Select all

General Error
 
Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1910216141, '31f72957f38a66ebe72cf5630e386bde', 'a:9:{s:14:"search_results";s:567:"624, 690, 716, 739, 757, 758, 759, 765, 768, 769, 770, 772, 773, 774, 776, 777, 778, 781, 793, 794, 796, 797, 798, 799, 800, 802, 804, 806, 807, 808, 809, 810, 812, 813, 814, 816, 817, 819, 821, 829, 830, 833, 835, 836, 837, 838, 839, 840, 841, 842, 843, 847, 850, 851, 853, 856, 867, 871, 872, 876, 877, 878, 880, 881, 882, 883, 887, 889, 892, 898, 901, 906, 908, 924, 931, 934, 935, 936, 937, 938, 939, 941, 944, 949, 951, 953, 959, 960, 963, 964, 965, 967, 970, 972, 973, 974, 975, 979, 981, 982, 986, 989, 990, 1000, 1007, 1008, 1009, 1012, 1016, 1018, 1024, 1040";s:17:"total_match_count";i:112;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;s:8:"draft_on";N;s:7:"no_subs";b:0;}')

Line : 928
File : search.php

any idea what happended & how to fix !

User avatar
dahia
Registered User
Posts: 334
Joined: Tue Jan 18, 2005 3:26 pm
Location: Earth

Post by dahia »

this error appears for all search functions on board :?
how to fix it !
any idea :?

User avatar
dahia
Registered User
Posts: 334
Joined: Tue Jan 18, 2005 3:26 pm
Location: Earth

Post by dahia »

:? help

Taipo
Registered User
Posts: 174
Joined: Fri Jan 07, 2005 9:25 pm
Contact:

Post by Taipo »

What mods have you added in the last wee while?

User avatar
dahia
Registered User
Posts: 334
Joined: Tue Jan 18, 2005 3:26 pm
Location: Earth

Post by dahia »

none
i had NOT change any single file or db process for 10 days :?

Locked

Return to “2.0.x Support Forum”