Request-URI Too Large怎么解决
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML><HEAD>
<TITLE>414 Request-URI Too Large</TITLE>
</HEAD><BODY>
<H1>Request-URI Too Large</H1>
The requested URL's length exceeds the capacity
limit for this server.<P>
request failed: URI too long<P>
<HR>
<ADDRESS>Apache/1.3.29 Server at localhost Port 80</ADDRESS>
</BODY></HTML>
在把数据内容上传到mysql里时出现了问题。
$Sql="INSERT INTO ". $tTableName ." set ".
//"tTitle='标题" . date("H:i:s") . "',".
//"tText='内容" . date("H:i:s") . "',".
"tTitle='".$tTitle."'," .
"tText='".$tText."'," .
"tUser='".$_SESSION["ZhangHu"]."'," .
"tBKId='".$BKId."'," .
"tDateTime ='". date("Y-m-d H:i:s") ."'";
mysql_query($Sql);//执行添加操作
在未传值时用代码 alert(tText.length) 知道tText有三万多的长度
因为$tText太大了,
要怎么修改服务器设置才可以存大内容到mysql里呢?
网上说和这个有关
这是在php.ini里的内容
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096 RequestURI?Too?Large Request URI Too Large
[解决办法]
TEXT < pow(2, 16) = 64K
MEDIUMTEXT < pow(2, 24) = 16M
LONGTEXT < pow(2, 32) = 4096M