| Shattered Kingdoms https://shatteredkingdoms.org/forums/ |
|
| Forum search https://shatteredkingdoms.org/forums/viewtopic.php?f=26&t=20788 |
Page 1 of 1 |
| Author: | dufelt [ Mon Nov 15, 2010 4:24 am ] |
| Post subject: | Forum search |
Not sure if this should be placed here or not: Could not insert search results DEBUG MODE SQL Error : 1062 Duplicate entry '540297108' for key 1 INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(540297108, '29e5a56df69cc04fb089e1b68a9b2c25', 1289823765, 'a:7:{s:14:"search_results";s:212:"3341, 5686, 9715, 10088, 13421, 13788, 14615, 14661, 14738, 15597, 15626, 16116, 16245, 16373, 16846, 17412, 17775, 18780, 18853, 18927, 19012, 19567, 19593, 19957, 19995, 20103, 20109, 20175, 20390, 20479, 20782";s:17:"total_match_count";i:31;s:12:"split_search";a:1:{i:0;s:11:"oathbreaker";}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 : 708 File : search.php |
|
| Author: | Viltrax [ Wed Nov 17, 2010 11:53 am ] |
| Post subject: | |
What were your search parameters? Just the word 'oathbreaker' or something else as well? |
|
| Author: | dufelt [ Wed Nov 17, 2010 12:50 pm ] |
| Post subject: | |
Just 'oathbreaker'. I know these scripts fail sometimes, but I'm sure we should never see mysql errors. (They're considered a security risk) |
|
| Author: | the_me [ Wed Nov 17, 2010 1:00 pm ] |
| Post subject: | |
dufelt wrote: Just 'oathbreaker'.
I know these scripts fail sometimes, but I'm sure we should never see mysql errors. (They're considered a security risk) Not just security risks, but a duplicate entry on a key is never good, especially if it is a primary one. Although phpBB is not without it's faults, nor MySQL. Could just have been a weird, random error. |
|
| Page 1 of 1 | All times are UTC - 8 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|