Project Perfect Mod Forums
:: Home :: Get Hosted :: PPM FAQ :: Forum FAQ :: Privacy Policy :: Search :: Memberlist :: Usergroups :: Register :: Profile :: Log in to check your private messages :: Log in ::


The time now is Thu Apr 18, 2024 11:22 am
All times are UTC + 0
Error when searching
Moderators: Global Moderators
Post new topic   Reply to topic Page 1 of 1 [6 Posts] Mark the topic unread ::  View previous topic :: View next topic
Author Message
Crimsonum
Seth


Joined: 14 Jul 2005
Location: Fineland

PostPosted: Fri Aug 13, 2010 12:38 pm    Post subject:  Error when searching Reply with quote  Mark this post and the followings unread

I've had this error message appearing almost everytime I click the "view posts since last visit". It's nothing especially annoying, because it doesn't loose the search results. I thought I'd report it, nontheless.

Code:
Could not insert search results

DEBUG MODE

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

INSERT INTO ppmhix_search_results (search_id, session_id, search_time, search_array) VALUES(1051663528, '25b8fe085bed92579abbdacd7ba5e8b8', 1281702803, 'a:8:{s:14:"search_results";s:19:"19983, 27903, 28261";s:17:"total_match_count";i:3;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:7:"no_subs";b:0;}')

Line : 879
File : search.php


Note: the Error details are propably not the same in every message; I haven't studied them that closely.

_________________


Back to top
View user's profile Send private message
SMIFFGIG
General


Joined: 03 Mar 2003
Location: Great Britain

PostPosted: Fri Aug 13, 2010 3:01 pm    Post subject: Reply with quote  Mark this post and the followings unread

Yea i get this too
got it more recently

but its appeared on and off for a good few years id say now

Like u said refreshing normally solves it
Still weird tho

_________________

Back to top
View user's profile Send private message Send e-mail Skype Account
Dutchygamer
President


Joined: 18 Jun 2005
Location: Dordrecht, the Netherlands

PostPosted: Fri Aug 13, 2010 5:25 pm    Post subject: Reply with quote  Mark this post and the followings unread

Aye, same here.
From what I understand, it seems 2 users are trying to get the newest post at the same time, resulting in 2 search queries with the same ID. That, or the code is bugged so it sends 2 search queries at the same time once in a while.

Back to top
View user's profile Send private message Send e-mail Skype Account
Aro
Alcohol Fueled


Joined: 10 Sep 2006

PostPosted: Fri Aug 13, 2010 5:33 pm    Post subject: Reply with quote  Mark this post and the followings unread

I get that message at least 4 times every time I visit PPM, but I just ignore it.

Back to top
View user's profile Send private message
Atari2600
Cyborg Cannon


Joined: 05 Mar 2007
Location: Less than 10 minutes from the internet

PostPosted: Fri Aug 13, 2010 6:19 pm    Post subject: Reply with quote  Mark this post and the followings unread

Yeah, Ive gotten it before on a few occasions.

I just make the search again, and move on.

_________________

Back to top
View user's profile Send private message
Deformat
Defense Minister


Joined: 17 Sep 2007

PostPosted: Fri Aug 13, 2010 7:51 pm    Post subject: Reply with quote  Mark this post and the followings unread

I never got it. #Tongue

Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [6 Posts] Mark the topic unread ::  View previous topic :: View next topic
 
Share on TwitterShare on FacebookShare on Google+Share on DiggShare on RedditShare on PInterestShare on Del.icio.usShare on Stumble Upon
Quick Reply
Username:


If you are visually impaired or cannot otherwise answer the challenges below please contact the Administrator for help.


Write only two of the following words separated by a sharp: Brotherhood, unity, peace! 

 
You cannot post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © phpBB Group

[ Time: 0.1545s ][ Queries: 11 (0.0091s) ][ Debug on ]