problem when clicking "view posts since last visit"

**MLafer** · Joined: 26 Mar 2006 Posts: 464 Location: Canton, MI

Could not insert search results

DEBUG MODE

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

INSERT INTO _search_results (search_id, session_id, search_array) VALUES(295815728, '9a8adf159204663fb627027d1bdc77e4', 'a:7:{s:14:"search_results";s:647:"9, 56, 1561, 1969, 2217, 2251, 2459, 2527, 2675, 2722, 2797, 2832, 2842, 2848, 2854, 3449, 3592, 3689, 3901, 3988, 3998, 4155, 4379, 4463, 4541, 4747, 4748, 4783, 4807, 4817, 4840, 4881, 4904, 4959, 4995, 4999, 5008, 5011, 5052, 5090, 5111, 5118, 5132, 5186, 5195, 5197, 5204, 5229, 5231, 5244, 5251, 5267, 5271, 5275, 5276, 5279, 5299, 5330, 5343, 5362, 5376, 5380, 5381, 5382, 5386, 5389, 5390, 5393, 5394, 5396, 5397, 5398, 5402, 5403, 5404, 5408, 5410, 5411, 5422, 5424, 5425, 5427, 5430, 5431, 5432, 5433, 5434, 5435, 5436, 5437, 5438, 5440, 5441, 5442, 5443, 5444, 5445, 5446, 5448, 5449, 5450, 5451, 5453, 5454, 5455, 5456, 5457, 5459, 5460";s:17:"total_match_count";i:109;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 : 702
File : search.php
_________________

**JCirri** · Joined: 04 Feb 2006 Posts: 4576

Strange.. I'm not sure how it generated a duplicate search id, did you hit refresh or double-click the link before this happened?
_________________

**MLafer** · Joined: 26 Mar 2006 Posts: 464 Location: Canton, MI

I load up scorehero...forums...click the link. I get it every time. It also happens when I refresh and when i double click.

If you mean the first time it happened, i have no idea if i double clicked or refreshed.
_________________

**MLafer** · Joined: 26 Mar 2006 Posts: 464 Location: Canton, MI

logging out and in fixed it. I did have to click "log out" two times, though. I noticed the first time I clicked log out, all of the posts were marked as read (there were many unread before i clicked it) but I was still logged in. Odd behavior going on to say the least.
_________________

**JCirri** · Joined: 04 Feb 2006 Posts: 4576

Sorry I got distracted and forgot to post here, but earlier I deleted the entry in the table that was causing the error for you, so that may have also been what fixed it.

Anyway, you should always use the main site login and logout pages, and not the forum ones. Logging in to the main site should also login to the forums. In fact, people complaining about login problems may be corrupting their cookies by using the forum login instead.

If logging into the main site doesn't login to the forums, then I suggest clearing your SH cookies and trying again.
_________________