Truncated Incorrect Error

[shujjah]

Truncated incorrect DOUBLE value: '1-Gears-Of-War'

I am getting this error on several of my scripts ...So can anyone please tell me what it means and what normally causes this error ? So I can try to solve it myself If I cant then I'll just post the concerned files here since its a mesh of included files and I didnt want to confuse you at first :)Best Regards,

[jeffman]

Just post one of the query strings that generates the error. Chances are good you have the word AND or a + where it doesn't belong.

[shujjah]

Alright this is the code ... when I click on any link that contains "game." in it , it gives me the same errorhere is the code

<? echo "\n\n";?><!------------------ CCMS Game Browser START ------------------><?php	defined('_VALID_INCLUDE') or die('Direct access to this file not allowed.');	$game_info = mysql_query("SELECT * FROM ccms_gameindex WHERE title=\"$linked_game\" AND category='$linked_console' ORDER by id desc limit 1");	while ($ccms = mysql_fetch_assoc($game_info)) {		$g_burl = $ccms[burl];		$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $ccms[title]); 		$title_seo = str_replace(' ', '-', $title_start);		$cheat_count = mysql_query("SELECT * from ccms_cheat where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");		$cheats = mysql_num_rows($cheat_count);		$cheat_url = "cheat-$ccms[id]-$ccms[category].html";		$video_count = mysql_query("SELECT * from ccms_video where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");		$videos = mysql_num_rows($video_count);		$media_count = mysql_query("SELECT * from ccms_screenshots where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");		$medias = mysql_num_rows($media_count);		$article_count = mysql_query("SELECT * from ccms_article where game=\"$ccms[title]\" and cat_id=\"$ccms[category]\"");		$articles = mysql_num_rows($article_count);		$file_count = mysql_query("SELECT * from ccms_file where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");		$files = mysql_num_rows($file_count);		$achievement_count = mysql_query("SELECT * from ccms_achievements where gameid=\"$ccms[id]\"");		$achievements = mysql_num_rows($achievement_count);		$faq_count = mysql_query("SELECT * from ccms_gamefaq where gameid=\"$ccms[id]\"");		$faqs = mysql_num_rows($faq_count);echo "			<table border=\"0\" width=\"459\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">			<tr>				<td height=\"52\" background=\"images/game_nav.gif\" width=\"459\">					<table width=\"459\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">					<tr>						<td style=\"width: 33px; height: 26px;\" align=\"center\"><img src=\"images/consoles/$linked_console.gif\"></td>						<td  style=\"width: 407px; height: 26px;\"><SPAN class=\"game_nav_title\">  <a href=\"game-$ccms[id]-$title_seo.html\" class=\"game_nav_title\">$linked_game</a></SPAN></td>					</tr>					<tr>						<td height=\"26\" colspan=\"2\"><center>						<SPAN class=\"game_nav\"> ";			if ($articles < 1) {				echo " <a class=\"game_nav\">$lang_articles</a> | ";			} else {				echo " <a href=\"game.articles-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_articles</a> | ";			}			if ($faqs < 1) {				echo " <a class=\"game_nav\">$lang_faq</a> | ";			} else {				echo " <a href=\"game.faq-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_faq</a> | ";			}			if ($achievements < 1) {				echo " <a class=\"game_nav\">$lang_acievements</a> | ";			} else {				echo " <a href=\"game.achievements-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_acievements</a> | ";			}			if ($files < 1) {				echo " <a class=\"game_nav\">$lang_files</a> | ";			} else {				echo " <a href=\"game.files-$ccms[id]-1-$title_seo.html\" class=\"game_nav\">$lang_files</a> | ";			}			if ($medias < 1) {				echo " <a class=\"game_nav\">$lang_media</a> | ";			} else {				echo " <a href=\"game.media-$ccms[id]-1-$title_seo.html\" class=\"game_nav\">$lang_media</a> | ";			}			if ($videos < 1) {				echo " <a class=\"game_nav\">$lang_video</a> | ";			} else {				echo " <a href=\"game.video-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_video</a> | ";			}			if ($cheats < 1) {				echo " <a class=\"game_nav\">$lang_cheats</a> | ";			} else {				echo " <a href=\"cheat-$ccms[id]-$ccms[category].html\" class=\"game_nav\">$lang_cheats</a> | ";			}			if ($ccms[burl] == "") {				echo " <a class=\"game_nav\">$lang_boards</a> | ";			} else {				echo " <a href=\"$ccms[burl]\" class=\"game_nav\">$lang_boards</a> | ";			}			if ($ccms[buylink] == "") {				echo "	<a class=\"game_nav\">$lang_buy</a>";			} else {				echo "	<a href=\"$ccms[buylink]\" class=\"game_nav\">$lang_buy</a>";			}echo "						</SPAN></td>					</tr>					</table>				</td>			</tr>			</table>\n";	}?><!------------------ CCMS Game Browser END ------------------><? echo "\n\n";?>

And I am pretty sure that that game. corresponds to this file game.phphttp://rapidshare.com/files/215027497/games.php.html( the file has everything under specific headers so it is easier to search )Thanks for your help ...

[shujjah]

this is how it works ...... when I have opened a game it shows the different things like articles and files and media that are related to that game in that gamebar.php ... but all those links that contain "game." in the start of the link dont work !And If I remove the game. from those links it leads to white blank pages ( since those pages usually don't exist ) Thanks in advance for your help

[justsomeguy]

Truncated incorrect DOUBLE value: '1-Gears-Of-War'

A double is a numeric type, you're sending a string.

[shujjah]

hm.. so how can it be solved ? and exactly where am I sending a string ?

[justsomeguy]

I don't know, print the query causing that error. You're putting a string value into a query for a field defined as a number.

[shujjah]

ok so heres one thing currently the urls look something like xyz.com/game.media-1-1-Gears-Of-War-2.htmlIf I remove both 1's in the url then I get no error but the default page with no values that is ....another example this game.faq-1-Gears-Of-War-2.htmlgives me Truncated incorrect DOUBLE value: '1-Gears-Of-War'but If I remove the 1 again I get no error but the default template of the page with no values ..

[justsomeguy]

What is the query causing the error? And what are the htaccess rules?

[shujjah]

I don't know, print the query causing that error. You're putting a string value into a query for a field defined as a number.

I gave the script in my first post .. should I echo the variables or what ? sorry for my annoying questions but I really don't know ..... actually I dont know which part of the script is causing this error .. is this the echoing of the link or the selecting of data in the mysql query? or is it something else ? Thanks again !

[shujjah]

ok so after some googling .. there are many people who got the same error and apparently most of them had a syntax error in their query..

[justsomeguy]

Yeah, step 1 is to figure out which of the 8 queries in your code is triggering the error. You can check for that yourself by checking if the query returns false, and printing the error message.

[jeffman]

I googled when you first posted. Like I said then, almost all the queries generating this error were putting values together incorrectly with AND or +. What I think is the AND errors are happening mostly in SET or INSERT statements, where values need to be linked by a comma. So I think the error has something to do with joining, adding, or otherwise concatenating values. Like saying INSERT 5-1 when you mean INSERT 4.It seems like all your data contains numbers and the - symbol. I think maybe that symbol is getting interpreted as a MINUS operator, not as a character, but not in a legal context.But I'm not sure because I can't duplicate the error.

[shujjah]

Ok I inserted the mysql error function in my scriptwhich made the first part of the script look something like

	defined('_VALID_INCLUDE') or die('Direct access to this file not allowed.');	 $game_info = mysql_query("SELECT * FROM ccms_gameindex WHERE title=\"$linked_game\" AND category='$linked_console' ORDER by id desc limit 1");	if (!$game_info)  {  die('Error: ' . mysql_error());  }while ($ccms = mysql_fetch_assoc($game_info)) {		$g_burl = $ccms[burl];		$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $ccms[title]); 		$title_seo = str_replace(' ', '-', $title_start);		$cheat_count = mysql_query("SELECT * from ccms_cheat where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$cheat_count)  {  die('Error: ' . mysql_error());  }		$cheats = mysql_num_rows($cheat_count);		$cheat_url = "cheat-$ccms[id]-$ccms[category].html";		$video_count = mysql_query("SELECT * from ccms_video where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$video_count)  {  die('Error: ' . mysql_error());  }		$videos = mysql_num_rows($video_count);		$media_count = mysql_query("SELECT * from ccms_screenshots where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$media_count)  {  die('Error: ' . mysql_error());  }		$medias = mysql_num_rows($media_count);		$article_count = mysql_query("SELECT * from ccms_article where game=\"$ccms[title]\" and cat_id=\"$ccms[category]\"");	if (!$article_count)  {  die('Error: ' . mysql_error());  }		$articles = mysql_num_rows($article_count);		$file_count = mysql_query("SELECT * from ccms_file where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$file_count)  {  die('Error: ' . mysql_error());  }		$files = mysql_num_rows($file_count);		$achievement_count = mysql_query("SELECT * from ccms_achievements where gameid=\"$ccms[id]\"");	if (!$achievement_count)  {  die('Error: ' . mysql_error());  }		$achievements = mysql_num_rows($achievement_count);		$faq_count = mysql_query("SELECT * from ccms_gamefaq where gameid=\"$ccms[id]\"");	if (!$faq_count)  {  die('Error: ' . mysql_error());  }		$faqs = mysql_num_rows($faq_count);

and strangely I still get the same errorTruncated incorrect DOUBLE value: '1-Gears-Of-War'Could it be that there isnt anything wrong with the link but something wrong with the script ( included it in my first post ) that uses the values in the link ?Thanks again for your help!

[jeffman]

Adding the error function just gives you a report -- it doesn't correct errors. Nothing strange about this behavior.Yes, there could be something strange about your values, especially if they contain quotation marks (including marks used as apostrophes) and things that look like SQL operators. The easiest way to tell would be to echo all your query statements and see what you're actually telling your database to do. The part you're getting in the error message is out of context. You need to see the whole thing.

[justsomeguy]

You can also add a line number so you can figure out which of the queries is causing the error. We already know what the error is, but it's taking a while to figure out which of the 8 queries is responsible.die('Line ' . __LINE__ . ': Error: ' . mysql_error());

[shujjah]

Ok So I have echoed nearly all the variables in the scriptwhich made the script look something like

<? echo "\n\n";?><!------------------ CCMS Game Browser START ------------------><?php	defined('_VALID_INCLUDE') or die('Direct access to this file not allowed.');	 $game_info = mysql_query("SELECT * FROM ccms_gameindex WHERE title=\"$linked_game\" AND category='$linked_console' ORDER by id desc limit 1");	if (!$game_info)  {  die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }while ($ccms = mysql_fetch_assoc($game_info)) {		$g_burl = $ccms[burl];		$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $ccms[title]); 		$title_seo = str_replace(' ', '-', $title_start);		$cheat_count = mysql_query("SELECT * from ccms_cheat where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$cheat_count)  { die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }		$cheats = mysql_num_rows($cheat_count);		$cheat_url = "cheat-$ccms[id]-$ccms[category].html";		$video_count = mysql_query("SELECT * from ccms_video where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$video_count)  { die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }		$videos = mysql_num_rows($video_count);		$media_count = mysql_query("SELECT * from ccms_screenshots where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$media_count)  { die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }		$medias = mysql_num_rows($media_count);		$article_count = mysql_query("SELECT * from ccms_article where game=\"$ccms[title]\" and cat_id=\"$ccms[category]\"");	if (!$article_count)  {die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }		$articles = mysql_num_rows($article_count);		$file_count = mysql_query("SELECT * from ccms_file where game=\"$ccms[title]\" and platform=\"$ccms[category]\"");	if (!$file_count)  { die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }		$files = mysql_num_rows($file_count);		$achievement_count = mysql_query("SELECT * from ccms_achievements where gameid=\"$ccms[id]\"");	if (!$achievement_count)  {  die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }		$achievements = mysql_num_rows($achievement_count);		$faq_count = mysql_query("SELECT * from ccms_gamefaq where gameid=\"$ccms[id]\"");	if (!$faq_count)  { die('Line ' . __LINE__ . ': Error: ' . mysql_error());   }		$faqs = mysql_num_rows($faq_count);echo "linked game = $linked_game";echo "<br />";echo "linked console = $linked_console";echo "<br />";echo "ccms title = $ccms[title]";echo "<br />";echo "ccms category = $ccms[category]";echo "<br />";echo "ccms id = $ccms[id]";echo "<br />";echo "queries";echo "<br />";echo "Cheat Count = $cheat_count";echo "<br />";echo "Video Count = $video_count";echo "<br />";echo "Media Count = $media_count";echo "<br />";echo "Article Count = $article_count";echo "<br />";echo "File Count = $file_count";echo "<br />";echo "Achiement Count = $achievement_count";echo "<br />";echo "Faq Count = $faq_count";echo "<br />";echo "			<table border=\"0\" width=\"459\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">			<tr>				<td height=\"52\" background=\"images/game_nav.gif\" width=\"459\">					<table width=\"459\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">					<tr>						<td style=\"width: 33px; height: 26px;\" align=\"center\"><img src=\"images/consoles/$linked_console.gif\"></td>						<td  style=\"width: 407px; height: 26px;\"><SPAN class=\"game_nav_title\">  <a href=\"game-$ccms[id]-$title_seo.html\" class=\"game_nav_title\">$linked_game</a></SPAN></td>					</tr>					<tr>						<td height=\"26\" colspan=\"2\"><center>						<SPAN class=\"game_nav\"> ";			if ($articles < 1) {				echo " <a class=\"game_nav\">$lang_articles</a> | ";			} else {				echo " <a href=\"game.articles-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_articles</a> | ";			}			if ($faqs < 1) {				echo " <a class=\"game_nav\">$lang_faq</a> | ";			} else {				echo " <a href=\"game.faq-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_faq</a> | ";			}			if ($achievements < 1) {				echo " <a class=\"game_nav\">$lang_acievements</a> | ";			} else {				echo " <a href=\"game.achievements-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_acievements</a> | ";			}			if ($files < 1) {				echo " <a class=\"game_nav\">$lang_files</a> | ";			} else {				echo " <a href=\"game.files-$ccms[id]-1-$title_seo.html\" class=\"game_nav\">$lang_files</a> | ";			}			if ($medias < 1) {				echo " <a class=\"game_nav\">$lang_media</a> | ";			} else {				echo " <a href=\"game.media-$ccms[id]-1-$title_seo.html\" class=\"game_nav\">$lang_media</a> | ";			}			if ($videos < 1) {				echo " <a class=\"game_nav\">$lang_video</a> | ";			} else {				echo " <a href=\"game.video-$ccms[id]-$title_seo.html\" class=\"game_nav\">$lang_video</a> | ";			}			if ($cheats < 1) {				echo " <a class=\"game_nav\">$lang_cheats</a> | ";			} else {				echo " <a href=\"cheat-$ccms[id]-$ccms[category].html\" class=\"game_nav\">$lang_cheats</a> | ";			}			if ($ccms[burl] == "") {				echo " <a class=\"game_nav\">$lang_boards</a> | ";			} else {				echo " <a href=\"$ccms[burl]\" class=\"game_nav\">$lang_boards</a> | ";			}			if ($ccms[buylink] == "") {				echo "	<a class=\"game_nav\">$lang_buy</a>";			} else {				echo "	<a href=\"$ccms[buylink]\" class=\"game_nav\">$lang_buy</a>";			}echo "						</SPAN></td>					</tr>					</table>				</td>			</tr>			</table>\n";	}?><!------------------ CCMS Game Browser END ------------------><? echo "\n\n";?>

and the result of which I got thislinked game = Gears Of War 2linked console = x360ccms title = Gears Of War 2ccms category = x360ccms id = 1queriesCheat Count = Resource id #51Video Count = Resource id #52Media Count = Resource id #53Article Count = Resource id #54File Count = Resource id #55Achiement Count = Resource id #56Faq Count = Resource id #57Thanks for your help ....

[shujjah]

Alright found the part of script in games.php which deals with this...here it is everything is under headers so it is easier to searchand just one more thing that I get that error whether I am requesting faq or files or media or articles or achievements or achievements..

//===================================================================================================// 	GAME SUB PAGES//-------------------------------------------------------------------------------------------------------------------------------	if ($_REQUEST[show] == 'files') {//===================================================// 	SUB PAGE > GAME FILES//-----------------------------------------------------------------		$divtitle = "$lang_files";		include "templates/$skin/divtitle.php";		$gamefiles = mysql_query("SELECT * from ccms_file where game=\"$gtitle\" and platform=\"$category\"");echo "	<img src=\"images/spacer2.gif\">	<table align=center width=98% $tablereg>	<tr>		<td width=\"60%\" $tdreg3><SPAN class=\"headertitle\"> $lang_file</td>		<td width=\"25%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_added</td> 		<td width=\"15%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_hits</td> 	</tr>\n";		$c = 1;		while($row = mysql_fetch_array($gamefiles)) {		if ($odd = $c%2 ) { 			$style = "$tdreg2";		} else { 			$style = "$tdreg";		}		$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $row[title]); 		$title_seo = str_replace(' ', '-', $title_start);		$title = $row[title];		$rdate = $row[date];		$ftimestamp = $row[timestamp];		$fid = $row[id];		$hits = $row[hits];echo "	<tr>		<td width=\"60%\" $style><SPAN class=\"content\">";//===================================================// 	FILE TYPE ICONS//-----------------------------------------------------------------			$ext_1 = strrchr($row[dl_url],'.');			if ($ext_1 == ".gif" || $ext_1 == ".jpeg" || $ext_1 == ".png" || $ext_1 == ".jpg") {echo "			<img src=\"images/icon_img.gif\" align=\"absmiddle\" hspace=\"4\" alt=\"Image - .jpg, .gif, .png\" /> ";			}			if ($ext_1 == ".rar" || $ext_1 == ".zip" || $ext_1 == ".tar" || $ext_1 == ".gzip") {echo "			<img src=\"images/icon_archive.gif\" align=\"absmiddle\" hspace=\"4\" alt=\"Archive - .rar, .zip\" /> ";			}			if ($ext_1 == ".mpg" || $ext_1 == ".mpeg" || $ext_1 == ".mov" || $ext_1 == ".avi") {echo "			<img src=\"images/icon_video.gif\" align=\"absmiddle\" hspace=\"4\" alt=\"Video - .mpeg, .mov, .avi\" /> ";			}			if ($ext_1 == ".txt" || $ext_1 == ".doc" || $ext_1 == ".rtf" || $ext_1 == ".word") {echo "			<img src=\"images/icon_doc.gif\" align=\"absmiddle\" hspace=\"4\" alt=\"Text Document - .txt, .doc, .word, .rtf\" /> ";			}			if ($ext_1 == ".pdf") {echo "			<img src=\"images/icon_pdf.gif\" align=\"absmiddle\" hspace=\"4\" alt=\"PDF File\" /> ";			}//===================================================		echo "<a class=\"content\" href=\"file-$fid-$title_seo.html\">$title</a></td>		<td width=\"25%\" $style><center><SPAN class=\"content\">";//===================================================// 	DATE & TIME DISPLAY//-----------------------------------------------------------------			// Display date if timestamp doesn't exist			if (!$ftimestamp || $ftimestamp == "0") {				echo "$rdate";			// Display time stamp			} else {				echo date("$time_an", $ftimestamp);			}//===================================================echo "		</td>		<td width=\"15%\" $style><center><SPAN class=\"content\">"; echo number_format($hits); echo "</td>	</tr>\n";		$c++;		}echo "	</table>	<img src=\"images/spacer2.gif\">\n";	}	if ($_REQUEST[show] == 'media') {//===================================================// 	SUB PAGE > GAME MEDIA//-----------------------------------------------------------------		$divtitle = "$lang_media";		include "templates/$skin/divtitle.php";		$res = mysql_query("SELECT * from ccms_screenshots where game=\"$glob_game\" and platform=\"$glob_console\" order by id desc") or die("SQL error: ".mysql_error());  		$resc = mysql_num_rows($res);		$mcounter = mysql_query("SELECT * from ccms_screenshots WHERE game=\"$glob_game\" and platform=\"$glob_console\""); 		$mediacount = mysql_num_rows($mcounter);		if (!$mediacount) {		} else {			$i=0;			if (mysql_num_rows($res) > 0) {echo "	<table border=\"0\" cellspacing=\"5\" cellpadding=\"1\" align=\"center\">	<tr>\n";				while ($row = mysql_fetch_assoc($res)) {					if (!($i%4))					echo ($i!=0 ? "</tr>" : "")."<tr>";	 echo "		<td valign=\"top\"><center><a href=\"media-". $row['id'] .".html\"><img width=\"100\" height=\"75\" border=\"0\" src=\"thumbnailer.php?image=" .$row['url'] ."&type=Media\" border=\"0\"></a></td>\n";				$i++;  				}    			for ($cnt=$i;$cnt%4>0;$cnt++) echo "		<td> </td>\n"; echo "	</tr>	</table>\n";  			}		}	}	if ($_REQUEST[show] == 'articles') {//===================================================// 	SUB PAGE > GAME ARTICLES//-----------------------------------------------------------------		$divtitle = "$lang_articles";		include "templates/$skin/divtitle.php";		$gamearticles = mysql_query("SELECT * from ccms_article where game=\"$glob_game\"  and cat_id=\"$glob_console\" order by date asc");echo "		<img src=\"images/spacer2.gif\">		<table width=\"98%\" align=\"center\" $tablereg>		<tr>			<td width=\"45%\" colspan=\"2\" $tdreg3><SPAN class=\"headertitle\"> $lang_title</SPAN></td>			<td width=\"25%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_date</SPAN></td>			<td width=\"15%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_author</SPAN></td>			<td width=\"15%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_views</SPAN></td>		</tr>\n";			$c = 1;			while ($row = mysql_fetch_assoc($gamearticles)) {				$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $row[title]); 				$title_seo = str_replace(' ', '-', $title_start);				if ($odd = $c%2 ) { 					$style = "$tdreg2";				} else { 					$style = "$tdreg";				}				$title = $row[title];				$date = $row[date]; 				$atimestamp = $row[timestamp];				$tfid = $row[id];				$platform = $row[cat_id];				$views = $row[views];			 echo "<tr>\n";				if (!$platform) {echo "			<td width=\"5%\" $style><img src=\"images/consoles/null.gif\"></td>";				} else {echo "			<td width=\"5%\" $style><img src=\"images/consoles/$platform.gif\"></td>"; 				}echo "			<td width=\"40%\" $style><SPAN class=\"content\"> <a class=\"content\" href=\"article-$tfid-$title_seo.html\">$title</a></SPAN></td>			<td width=\"25%\" $style><center><SPAN class=\"content\">\n";//===================================================// 	DATE & TIME DISPLAY//-----------------------------------------------------------------				// Display date if timestamp doesn't exist				if (!$atimestamp || $atimestamp == "0") {					echo "$date";				// Display time stamp				} else {						echo date("$time_an", $atimestamp);				}//===================================================echo "			</SPAN></td>			<td width=\"15%\" $style><center><a class=\"content\" href=\"profile-$row[author].html\">$row[author]</a></td>			<td width=\"15%\" $style><center><SPAN class=\"content\">"; echo number_format($row[views]); echo "</td>		</tr>\n";			$c++;			}echo "		</table>		<img src=\"images/spacer2.gif\">\n";//===================================================	}	if ($_REQUEST[show] == 'achievements') {//===================================================// 	SUB PAGE > GAME ACHIEVEMENTS//-----------------------------------------------------------------		$divtitle = "$lang_achievements";		include "templates/$skin/divtitle.php";		$gameach = mysql_query("SELECT * from ccms_achievements where gameid=\"$_REQUEST[id]\" order by id asc");echo "		<img src=\"images/spacer2.gif\">		<table width=\"98%\" align=\"center\" $tablereg>		<tr>			<td width=\"80%\" colspan=\"2\" $tdreg3><SPAN class=\"headertitle\"> $lang_achievement</SPAN></td>			<td width=\"20%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_points</SPAN></td>		</tr>\n";			$c = 1;			while ($row = mysql_fetch_assoc($gameach)) {				$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $row[title]); 				$title_seo = str_replace(' ', '-', $title_start);				if ($odd = $c%2 ) { 					$style = "$tdreg2";				} else { 					$style = "$tdreg";				}			 echo "<tr>\n";echo "			<td width=\"1%\" $style><img src=\""; if (!$row[image]) { echo "images/default_ach.gif"; } else { echo "$row[image]"; } echo "\" width=\"46\" height=\"46\"></td>			<td width=\"79%\" $style><DIV class=\"padding10\"><SPAN class=\"content\"><strong>$c. $row[title]</strong><br />			$row[description]			</SPAN></td>			<td width=\"10%\" $style><center><SPAN class=\"content\">$row[points]</SPAN></td>		</tr>\n";			$c++;			}echo "		</table>		<img src=\"images/spacer2.gif\">\n";//===================================================	}	if ($_REQUEST[show] == 'faq') {//===================================================// 	SUB PAGE > GAME FAQ//-----------------------------------------------------------------		$divtitle = "$lang_faq";		include "templates/$skin/divtitle.php";		$gamearticles = mysql_query("SELECT * from ccms_gamefaq where gameid=\"$_REQUEST[id]\" order by id asc");echo "		<img src=\"images/spacer2.gif\">		<table width=\"98%\" align=\"center\" $tablereg>		<tr>			<td width=\"45%\" colspan=\"2\" $tdreg3><SPAN class=\"headertitle\"> $lang_title</SPAN></td>			<td width=\"25%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_date</SPAN></td>			<td width=\"15%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_author</SPAN></td>			<td width=\"15%\" $tdreg3><SPAN class=\"headertitle\"><center>$lang_views</SPAN></td>		</tr>\n";			$c = 1;			while ($row = mysql_fetch_assoc($gamearticles)) {				$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $row[title]); 				$title_seo = str_replace(' ', '-', $title_start);				if ($odd = $c%2 ) { 					$style = "$tdreg2";				} else { 					$style = "$tdreg";				}				$title = $row[title];				$atimestamp = $row[dateline];				$tfid = $row[id];				$platform = $row[cat_id];				$views = $row[views];			 echo "<tr>\n";echo "			<td width=\"5%\" $style><img src=\"images/consoles/$glob_console.gif\"></td>			<td width=\"40%\" $style><SPAN class=\"content\"> <a class=\"content\" href=\"faq-$tfid-$title_seo.html\">$title</a></SPAN></td>			<td width=\"25%\" $style><center><SPAN class=\"content\">\n";//===================================================// 	DATE & TIME DISPLAY//-----------------------------------------------------------------				// Display date if timestamp doesn't exist				if (!$atimestamp || $atimestamp == "0") {					echo "$date";				// Display time stamp				} else {						echo date("$time_an", $atimestamp);				}//===================================================echo "			</SPAN></td>			<td width=\"15%\" $style><center><a class=\"content\" href=\"profile-$row[author].html\">$row[author]</a></td>			<td width=\"15%\" $style><center><SPAN class=\"content\">"; echo number_format($row[views]); echo "</td>		</tr>\n";			$c++;			}echo "		</table>		<img src=\"images/spacer2.gif\">\n";//===================================================	}	if ($_REQUEST[show] == 'video') {//===================================================// 	SUB PAGE > GAME VIDEO//-----------------------------------------------------------------		$divtitle = "$lang_video";		include "templates/$skin/divtitle.php";		$gamevid = mysql_query("SELECT * from ccms_video where game=\"$glob_game\" and platform=\"$glob_console\" order by id asc");echo "		<img src=\"images/spacer2.gif\">		<table width=\"98%\" align=\"center\" $tablereg>		<tr>			<td width=\"99%\" colspan=\"2\" $tdreg3><SPAN class=\"headertitle\"> $lang_video</SPAN></td>		</tr>\n";			$c = 1;			while ($row = mysql_fetch_assoc($gamevid)) {				$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $row[title]); 				$title_seo = str_replace(' ', '-', $title_start);				if ($odd = $c%2 ) { 					$style = "$tdreg2";				} else { 					$style = "$tdreg";				}			 echo "<tr>\n";echo "			<td width=\"1%\" $style><img src=\"$row[image]\" width=\"46\" height=\"46\"></td>			<td width=\"99%\" $style><DIV class=\"padding10\"><SPAN class=\"content\"><strong><a class=\"content\" href=\"video-$row[id]-$title_seo.html\">$row[title]</a></strong><br />			$row[description]			</SPAN></td>		</tr>\n";			$c++;			}echo "		</table>		<img src=\"images/spacer2.gif\">\n";//===================================================	}

Thanks again

[justsomeguy]

So have we figured out which query is causing the error yet? We need to see the actual SQL code that's causing that error, you need to figure out which query it is and print it out.

[shujjah]

Ok so firstly I have echoed all the variables used in the queries in game.php and I got thisgtitle = Gears Of War 2category = x360glob_game = Gears Of War 2glob_console = x360Game id = 1which shows that there's nothing wrong with them..then I inserted that Mysql error line with every mysql query and I still got the same error and nothing new I am really confused and dont know what to do!Is there any other debugging tool I can use to find the cause of the error ?

[justsomeguy]

This was the original error:Truncated incorrect DOUBLE value: '1-Gears-Of-War'I don't see that value in the variables you're printing out, where is that coming from?

[shujjah]

ok heres the deal ... on the game display page from where I click on the links I get these variables ( from game.php )gtitle = Gears Of War 2category = x360glob_game = Gears Of War 2glob_console = x360Game id = 1 now when I click on any link like game.faq-1-Gears-Of-War-2.htmlI get this errorTruncated incorrect DOUBLE value: '1-Gears-Of-War'now If I remove the 1 from the link and just replace it with game.faq--Gears..The page loads fine ( but is ofcouse empty/default with no values ) and I get these variablesgtitle = category = glob_game = glob_console = Game id = -Gears-Of-WarIf I change it to game.faq-0-Gears...I get thisgtitle = category = glob_game = glob_console = Game id = 0-Gears-Of-Warand these are the variables I am printing out echo "gtitle = $gtitle";echo "category = $category";echo "glob_game = $glob_game";echo "glob_console = $glob_console";echo "Game id = $_REQUEST[id] ";the over variables apart from Game Id are assigned by this query

$gameinfo = mysql_query("SELECT * from ccms_gameindex where id='$_REQUEST[id]'");	while ($row = mysql_fetch_assoc($gameinfo)) {		$id = $row[id];		$gameid = $row[id];		$title = $row[title];		$gtitle = $row[title];		$date_na = $row[date];		$rdate = $row[rdate];		$boards = $row[burl];		$box = $row[box];		$description = $row[description];		$gamespecs = strip_tags ($row[gamespecs], '<strong><b><p>');		$developer = $row[developer];		$publisher = $row[publisher];		$esrb = $row[esrb];		$gviews = $row[views];		$genre = $row[genre];		$rank = $row[rank];		$rating = $row[rating];		$category = $row[category];		$glob_console = $row[category];		$glob_game = $row[title];		$release_uk = $row[release_uk];		$release_jp = $row[release_jp];		$aka = $row[aka];		$allow_rating = $row[allow_rating];		$linked_console = $row[category];		$linked_game = $row[title];		$glob_bid = $row[bid];		$rank = $row[rank];		$msrp = $row[price];		$title_start = preg_replace('/[^a-zA-Z0-9 *]/', '', $row[title]); 		$title_seo_glob = str_replace(' ', '-', $title_start);

so now I am guessing there is something wrong with this $_REQUEST[id] ? I just checked my db and in it the game id values are like 1, 2, 3, 4 and the title is like Gears Of War 2you can check it yourself will make things a lot easier all the variables are echoed in the pagesthe gamehttp://gamerzgalore.net/CCMS/game-1-Gears-Of-War-2.htmlorhttp://gamerzgalore.net/CCMS/game-4-Halo-3.htmlthen click a link from the gamebar ... and you'll see that error and then replace the values ( like I did ) and see the result that you get THANKS A TON for helping me!

[justsomeguy]

What are the htaccess rules doing the URL rewriting?This is taking a lot of posts to figure out, but apparently the htaccess file has some rules set up to rewrite the URL, the data I see in the URL is going into some set of variables, and you're trying to use the variables in some database query. Obviously one of the variables has the wrong value in it, probably because of the htaccess rules, but maybe the PHP code is just wrong.Also, any time you refer to an associative array element it needs to go in quotes:$id = $row['id'];

[shujjah]

well this is my .htaccess if that helps though

RewriteEngine On RewriteRule ^vote-([0-9]*).html index.php?page=Vote&id=$1 [L,NS]RewriteRule ^poll-([0-9]*).html index.php?page=Poll&id=$1 [L,NS]RewriteRule ^poll-([0-9]*)-(.*).html index.php?page=Poll&id=$1 [L,NS]RewriteRule ^poll.reportcomment.([0-9]*)-([0-9]*).html index.php?page=Poll&id=$2&op=reportcomment&commentid=$1 [L,NS]RewriteRule ^polls.html index.php?page=Polls [L,NS]RewriteRule ^login.html index.php?page=Login [L,NS]RewriteRule ^changepw.html index.php?page=Password [L,NS]RewriteRule ^activate/(.*) activate.php?key=$1 [L,NS]RewriteRule ^archive-([^/]*)-([^/]*).html index.php?page=Archive&archive_month=$1&tag=$2 [L,NS]RewriteRule ^archive-([^/]*).html index.php?page=Archive&archive_month=$1 [L,NS]RewriteRule ^archive.html index.php?page=Archive [L,NS]RewriteRule ^faq-([0-9]*)-(.*).html index.php?page=FAQ&id=$1 [L,NS]RewriteRule ^articles.html index.php?page=Articles [L,NS]RewriteRule ^article-([0-9]*).html index.php?page=Articles&action=showarticle&id=$1 [L,NS]RewriteRule ^article-([0-9]*)-(.*).html index.php?page=Articles&action=showarticle&id=$1 [L,NS]RewriteRule ^articlenav-(.*)-page-(.*).html index.php?page=Articles&action=showarticle&id=$1&nav=$2 [L,NS]RewriteRule ^articletype-(.*)-(.*).html index.php?page=Articles&action=cat&type=$1&p=$2 [L,NS]RewriteRule ^articlesearch.html index.php?page=Search&exec=Search&t=articles [L,NS]RewriteRule ^articles-(.*).html index.php?page=Articles&action=cat&type=$1 [L,NS]RewriteRule ^([^/]*)-([0-9]*)-articlenav.html index.php?page=Articles&action=cat&type=$1&nav=$2 [L,NS]RewriteRule ^([^/]*)-([0-9]*)-articlenav-(.*).html index.php?page=Articles&action=cat&type=$1&nav=$2&p=$3 [L,NS]RewriteRule ^article.reportcomment.([0-9]*)-([0-9]*).html index.php?page=Articles&action=showarticle&id=$2&op=reportcomment&commentid=$1 [L,NS]RewriteRule ^cheats.html index.php?page=Cheats [L,NS]RewriteRule ^cheatlist-(.*)-(.*)-(.*).html index.php?page=Cheats&start=$1&cat=$2&nav=$3 [L,NS]RewriteRule ^cheat-([0-9]*)-(.*).html index.php?page=Cheats&action=show&game=$1&platform=$2 [L,NS]RewriteRule ^companylist-(.*)-(.*).html index.php?page=Companies&start=$1&nav=$2 [L,NS]RewriteRule ^company-(.*).html index.php?page=Companies&action=show&t=$1 [L,NS]RewriteRule ^companies.html index.php?page=Companies [L,NS]RewriteRule ^linklist-([0-9]*)-([0-9]*).html index.php?page=Links&action=cat&cat_id=$1&nav=$2 [L,NS]RewriteRule ^link-([0-9]*).html index.php?page=Links&action=out&id=$1 [L,NS]RewriteRule ^links.html index.php?page=Links [L,NS]RewriteRule ^linkcat-([0-9]*).html index.php?page=Links&action=cat&cat_id=$1 [L,NS]RewriteRule ^linknav-([0-9]*)-([0-9]*).html index.php?page=Links&action=cat&cat_id=$1&nav=$2 [L,NS]RewriteRule ^([0-9]*)-([0-9]*)-linknav-(.*).html index.php?page=Links&action=cat&cat_id=$1&nav=$2&orderby=$3 [L,NS]RewriteRule ^linksearch.html index.php?page=Search&exec=Search&t=links [L,NS]RewriteRule ^videolist-(.*)-(.*).html index.php?page=Video&action=cat&cat_id=$1&nav=$2 [L,NS]RewriteRule ^video-([0-9]*).html index.php?page=Video&action=showvideo&id=$1 [L,NS]RewriteRule ^video-([0-9]*)-(.*).html index.php?page=Video&action=showvideo&id=$1 [L,NS]RewriteRule ^video.html index.php?page=Video [L,NS]RewriteRule ^videos.html index.php?page=Video [L,NS]RewriteRule ^videocat-([0-9]*).html index.php?page=Video&action=cat&cat_id=$1 [L,NS]RewriteRule ^([0-9]*)-([0-9]*)-videonav.html index.php?page=Video&action=cat&cat_id=$1&nav=$2 [L,NS]RewriteRule ^video.reportcomment.([0-9]*)-([0-9]*).html index.php?page=Video&action=showvideo&id=$2&op=reportcomment&commentid=$1 [L,NS]RewriteRule ^videosearch.html index.php?page=Search&exec=Search&t=video [L,NS]RewriteRule ^([0-9]*)-([0-9]*)-videonav-(.*).html index.php?page=Video&action=cat&cat_id=$1&nav=$2&orderby=$3 [L,NS]RewriteRule ^medialist-(.*)-(.*).html index.php?page=Media&action=cat&cat_id=$1&nav=$2 [L,NS]RewriteRule ^media-(.*).html index.php?page=Media&action=showfile&id=$1 [L,NS]RewriteRule ^media.html index.php?page=Media [L,NS]RewriteRule ^mediacat-(.*).html index.php?page=Media&action=cat&cat_id=$1 [L,NS]RewriteRule ^([0-9]*)-([0-9]*)-medianav.html index.php?page=Media&action=cat&cat_id=$1&nav=$2 [L,NS]RewriteRule ^media.reportcomment.([0-9]*)-([0-9]*).html index.php?page=Media&action=showfile&id=$2&op=reportcomment&commentid=$1 [L,NS]RewriteRule ^mediasearch.html index.php?page=Search&exec=Search&t=screenshots [L,NS]RewriteRule ^gamestatadd-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&add=$2 [L,NS]RewriteRule ^gamestatrem-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&remove=$2 [L,NS]RewriteRule ^gamemedia-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=Media&nav=$2 [L,NS]RewriteRule ^gamelist-([^/]*)-([^/]*)-([0-9]*)-([^/]*).html index.php?page=Games&start=$1&cat=$2&nav=$3&genre=$4 [L,NS]RewriteRule ^games.html index.php?page=Games [L,NS]RewriteRule ^game-([0-9]*).html index.php?page=Games&action=showgame&id=$1 [L,NS]RewriteRule ^game-([0-9]*)-(.*).html index.php?page=Games&action=showgame&id=$1 [L,NS]RewriteRule ^game.articles-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=articles [L,NS]RewriteRule ^game.faq-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=faq [L,NS]RewriteRule ^game.achievements-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=achievements [L,NS]RewriteRule ^game.files-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=files [L,NS]RewriteRule ^game.media-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=media [L,NS]RewriteRule ^game.video-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=video [L,NS]RewriteRule ^game.cheats-(.*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=cheats [L,NS]RewriteRule ^topgames.html index.php?page=Top+Games [L,NS]RewriteRule ^topgames-(.*).html index.php?page=Top+Games&cat=$1 [L,NS]RewriteRule ^upcoming-(.*).html index.php?page=Upcoming+Games&cat=$1 [L,NS]RewriteRule ^upcoming.html index.php?page=Upcoming+Games [L,NS]RewriteRule ^members.html index.php?page=Members [L,NS]RewriteRule ^memberlist-(.*)-([0-9]*)-(.*).html index.php?page=Members&start=$1&nav=$2&country=$3 [L,NS]RewriteRule ^system-(.*) index.php?page=Console&p=$1 [L,NS]RewriteRule ^online.html index.php?page=Online [L,NS]RewriteRule ^usercp.html index.php?page=User+CP [L,NS]RewriteRule ^editprofile-do.html index.php?page=Edit+Profile&edit=do [L,NS]RewriteRule ^editprofile.html index.php?page=Edit+Profile [L,NS]RewriteRule ^inbox.html index.php?page=User+CP&action=messages [L,NS]RewriteRule ^myblog.html index.php?page=User+CP&action=blog [L,NS]RewriteRule ^myblog-edit-([0-9]*).html index.php?page=User+CP&action=blog&op=edit&id=$1 [L,NS]RewriteRule ^myblog-remove-([0-9]*).html index.php?page=User+CP&action=blog&op=remove&id=$1 [L,NS]RewriteRule ^myblog-removeyes-([0-9]*).html index.php?page=User+CP&action=blog&op=remove&id=$1&exec=remove [L,NS]RewriteRule ^myblog-add.html index.php?page=User+CP&action=blog&op=add [L,NS]RewriteRule ^search.html index.php?page=Search&exec=Search [L,NS]RewriteRule ^gamesearch.html index.php?page=Search&exec=Search&t=games [L,NS]RewriteRule ^cheatsearch.html index.php?page=Search&exec=Search&t=cheats [L,NS]RewriteRule ^filesearch.html index.php?page=Search&exec=Search&t=file [L,NS]RewriteRule ^forumsearch.html index.php?page=Search&exec=Search&t=forums [L,NS]RewriteRule ^contact.html index.php?page=Contact [L,NS]RewriteRule ^contact-thanks.html index.php?page=Contact&action=thanks [L,NS]RewriteRule ^logout.html index.php?page=Logout [L,NS]RewriteRule ^logout-yes.html index.php?page=Logout&logmeout=1 [L,NS]RewriteRule ^profile-(.*).html index.php?page=User+Profile&u=$1 [L,NS]RewriteRule ^allshouts.html shoutbox_all.php [L,NS]RewriteRule ^company-(.*).html index.php?page=Company&action=show&t=$1 [L,NS]RewriteRule ^register.html index.php?page=Register [L,NS]RewriteRule ^pages.html index.php?page=Page [L,NS]RewriteRule ^page-(.*).html index.php?page=Page&action=showpage&id=$1 [L,NS]RewriteRule ^page-(.*)-(.*).html index.php?page=Page&action=showpage&id=$1 [L,NS]RewriteRule ^pagenav-(.*).html index.php?page=Page&orderby=$1 [L,NS]RewriteRule ^blognav-([0-9]*).html index.php?page=Blogs&nav=$1 [L,NS]RewriteRule ^blogs.html index.php?page=Blogs [L,NS]RewriteRule ^blog-([0-9]*).html index.php?page=Blogs&action=show&id=$1 [L,NS]RewriteRule ^blog-([0-9]*)-(.*).html index.php?page=Blogs&action=show&id=$1 [L,NS]RewriteRule ^forums.html forums.php?page=Forums [L,NS]RewriteRule ^forums-allread.html forums.php?page=Forums&op=allread [L,NS]RewriteRule ^forum-(.*).html forums.php?page=Forums&show=forum&id=$1 [L,NS]RewriteRule ^thread-(.*).html forums.php?page=Forums&show=thread&id=$1 [L,NS]RewriteRule ^newthread-(.*).html forums.php?page=Forums&show=newthread&fid=$1 [L,NS]RewriteRule ^reply-(.*)-(.*).html forums.php?page=Forums&show=reply&id=$1&fid=$2 [L,NS]RewriteRule ^threadnav-(.*)-(.*).html forums.php?page=Forums&show=forum&id=$1&nav=$2 [L,NS]RewriteRule ^postnav-(.*)-(.*).html forums.php?page=Forums&show=thread&id=$1&nav=$2 [L,NS]RewriteRule ^reply.quote-([0-9]*)-([0-9]*)-([0-9]*).html forums.php?page=Forums&show=reply&id=$2&fid=$3&quote=$1 [L,NS]RewriteRule ^post.report-([0-9]*)-([0-9]*).html forums.php?page=Forums&show=report&id=$1&return_thread=$2 [L,NS]RewriteRule ^video-([0-9]*).html video.php?id=$1 [L,NS]RewriteRule ^files.html index.php?page=Files [L,NS]RewriteRule ^filecat-([0-9]*).html index.php?page=Files&action=cat&cat_id=$1 [L,NS]RewriteRule ^file-([0-9]*).html index.php?page=Files&action=showfile&id=$1 [L,NS]RewriteRule ^file-([0-9]*)-(.*).html index.php?page=Files&action=showfile&id=$1 [L,NS]RewriteRule ^([0-9]*)-([0-9]*)-filenav.html index.php?page=Files&action=cat&cat_id=$1&nav=$2 [L,NS]RewriteRule ^([0-9]*)-([0-9]*)-filenav-(.*).html index.php?page=Files&action=cat&cat_id=$1&nav=$2&orderby=$3 [L,NS]RewriteRule ^file.reportcomment.([0-9]*)-([0-9]*)-(.*).html index.php?page=Files&action=showfile&id=$2&op=reportcomment&commentid=$1 [L,NS]RewriteRule ^submitreview-(.*).html index.php?page=Submit&type=Article&ratingid=$1 [L,NS]RewriteRule ^submit-news.html index.php?page=Submit+News [L,NS]RewriteRule ^submit-file.html index.php?page=Submit&type=File [L,NS]RewriteRule ^submit-article.html index.php?page=Submit&type=Article [L,NS]RewriteRule ^submitcheat-(.*)-(.*).html index.php?page=Submit&type=Cheats&game=$1&platform=$2 [L,NS]RewriteRule ^submit-media.html index.php?page=Submit&type=Media [L,NS]RewriteRule ^submit-link.html index.php?page=Submit&type=Links [L,NS]RewriteRule ^game.cheats-([0-9]*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=Cheats [L,NS]RewriteRule ^game.media-([0-9]*)-([0-9*]*).html index.php?page=Games&action=showgame&id=$1&show=Media&nav=$3 [L,NS]RewriteRule ^game.articles-([0-9]*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=Articles [L,NS]RewriteRule ^game.faq-([0-9]*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=FAQ [L,NS]RewriteRule ^game.achievements-([0-9]*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=Achievements [L,NS]RewriteRule ^game.files-([0-9]*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=Files [L,NS]RewriteRule ^game.video-([0-9]*)-(.*).html index.php?page=Games&action=showgame&id=$1&show=Video [L,NS]RewriteRule ^story-([0-9]*).html index.php?page=Story&id=$1 [L,NS]RewriteRule ^story-([0-9]*)-(.*).html index.php?page=Story&id=$1 [L,NS]RewriteRule ^story.reportcomment.([0-9]*)-([0-9]*)-(.*).html index.php?page=Story&id=$2&op=reportcomment&commentid=$1 [L,NS]RewriteRule ^notepad.html index.php?page=User+CP&action=notepad [L,NS]RewriteRule ^sig.jpg sig.php [L,NS]RewriteRule ^rss.xml rss.php [L,NS]RewriteRule ^rss-articles.xml rss-articles.php [L,NS]

Thanks!

[justsomeguy]

Add a line to the page with the error to print $_GET['id'].