@Admins: Search Forum Section Bug !

Zentoo

I didn't know really where i could put it:

i was looking for something in the forums, get, in advanced search and type "PAM XAUTHORITY" , press return and BANG:

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(843540288, '94dfcb6bf57b85f63bb8d5798174abe8', 'a:7:{s:14:"search_results";s:703:"5175, 38417, 72893, 76111, 83111, 90198, 100978, 108718, 111094, 131175, 135452, 151482, 161982, 168405, 178791, 181378, 212792, 214455, 218531, 220179, 232780, 239606, 242292, 246413, 249287, 249344, 249655, 249744, 249882, 250063, 250272, 250546, 250557, 250600, 250607, 250609, 250737, 251059, 251203, 251453, 251987, 252084, 252093, 252317, 252744, 252926, 253305, 253692, 253902, 254824, 255100, 255574, 255675, 256972, 257657, 258788, 258886, 259867, 260659, 260821, 261194, 261274, 261444, 261718, 262190, 262327, 262552, 262562, 262623, 263432, 264920, 266708, 266984, 269999, 270477, 271679, 271767, 272094, 272167, 272627, 273769, 274703, 275380, 276432, 276574, 277256, 278885, 279197, 279300";s:17:"total_match_count";i:89;s:12:"split_search";a:2:{i:0;s:3:"pam";i:1;s:10:"xauthority";}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;}')

Line : 543
File : /var/www/forums.gentoo.org/htdocs/search.php

Hope that could help ...

ian! · Posted: Sat Jan 15, 2005 8:41 am Post subject:

It's a bug in phpBB that occurs every now and then. It's a known bug. We'll try to fix that problem in the next update.
_________________
"To have a successful open source project, you need to be at least somewhat successful at getting along with people." -- Daniel Robbins

Zentoo · Posted: Sat Jan 15, 2005 12:53 pm Post subject:

Ok... good to know you're aware about it yet...

Good work by the way to make Gentoo forums alive with so many account and so many posts.

What's the size of the database and how many users on it ? (really curious about the whole damn thing!)

ian! · Posted: Sat Jan 15, 2005 5:32 pm Post subject:

pjp · Administrator Joined: 16 Apr 2002 Posts: 20067

Fortunately, it doesn't break search permanently.

Searching for 'DEBUG MODE SQL Error Duplicate entry' in Duplicates or Feedback would've turned up this thread.
_________________
Quis separabit? Quo animo?