Arch Linux

tomk

Forum Fellow

From: Ireland

Registered: 2004-07-21

Posts: 9,839

SQL Error on Forum Search

It looks like this:

General Error

Could not insert search results

DEBUG MODE

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(631837813, '61457bea1ccfdcb41ffb89b146a42777', 'a:7:{s:14:"search_results";s:110:"18975, 20269, 20367, 20385, 20451, 20488, 20497, 20503, 20516, 20518, 20523, 20526, 20530, 20532, 20533, 20534";s:17:"total_match_count";i:16;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;}')

Line : 714
File : search.php

(except that it's all nice and neat and centered).

cactus

Taco Eater

From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰

Registered: 2004-05-25

Posts: 4,622

Website

Re: SQL Error on Forum Search

yeah. phpbb has some issues every once in a while.
who knows. Maybe after the main site is redesigned, a better forum solution can be proposed.

I would push for postgres instead of mysql..but..heh..
I think enough people hide from me whenever I talk about postgres as it is.

---

"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

tomk

Forum Fellow

From: Ireland

Registered: 2004-07-21

Posts: 9,839

Re: SQL Error on Forum Search

Fixed now.

dtw

Forum Fellow

From: UK

Registered: 2004-08-03

Posts: 4,439

Website

Re: SQL Error on Forum Search

The upgrade that is due may fix it