phpBB.nl

Code: Selecteer alles

Algemene Fout 
Skateforum Forum Index » Algemene Fout 
Algemene Fout 

Could not insert search results 

DEBUG MODE 

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

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1737255384, '8caefdfc747c39f7588de4ed49553c9e', 'a:7:{s:14:"search_results";s:177:"17, 32, 54, 361, 1095, 1256, 1281, 1323, 1370, 1407, 1542, 1647, 1685, 1695, 1714, 1724, 1730, 1732, 1736, 1737, 1742, 1743, 1745, 1749, 1750, 1753, 1754, 1755, 1756, 1757, 1758";s:17:"total_match_count";i:31;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 : 679 
File : /home/thurmanl/public_html/forum/search.php 

Code: Selecteer alles

$sql = "UPDATE " . SEARCH_TABLE . " 
			SET search_id = $search_id, search_array = '" . str_replace("\'", "''", $result_array) . "'
			WHERE session_id = '" . $userdata['session_id'] . "'";
		if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() )
		{
			$sql = "INSERT INTO " . SEARCH_TABLE . " (search_id, session_id, search_array) 
				VALUES($search_id, '" . $userdata['session_id'] . "', '" . str_replace("\'", "''", $result_array) . "')";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not insert search results', '', __LINE__, __FILE__, $sql);
			}
		}
	}
	else
	{
		if ( intval($search_id) )