Shattered Kingdoms

Where Roleplay and Tactics Collide
VOTE NOW!
It is currently Mon Dec 23, 2024 2:46 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Forum search
PostPosted: Mon Nov 15, 2010 4:24 am 
Offline
Mortal

Joined: Thu Nov 04, 2010 1:05 am
Posts: 141
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


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Wed Nov 17, 2010 11:53 am 
Offline
Webadmin

Joined: Thu Feb 28, 2002 4:00 pm
Posts: 2732
Location: Australia
SK Character: Viltrax
What were your search parameters? Just the word 'oathbreaker' or something else as well?


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Wed Nov 17, 2010 12:50 pm 
Offline
Mortal

Joined: Thu Nov 04, 2010 1:05 am
Posts: 141
Just 'oathbreaker'.

I know these scripts fail sometimes, but I'm sure we should never see mysql errors. (They're considered a security risk)


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Wed Nov 17, 2010 1:00 pm 
Offline
Gold Donor

Joined: Sat May 24, 2008 11:20 pm
Posts: 2109
Location: Edmonton, Alberta
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.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 126 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group