帮忙看看什么问题？

Question

HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /admin/setup/setup3.jsp at line 41: <%@ page contentType="text/html;charset=Gb2312" import="net.ijsp.forum.*"%>
2: <%@include file="common.jsp"%>
3: <%@include file="isok.jsp"%>
4: <%AdminFactory.addConfig(request);%>
5: <title>顺天科技论坛--输入管理员用户名及密码</title>
6: <br>
7: <form action="setup4.jsp" method="post"> 
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause javax.servlet.ServletException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'IpFlag' at row 1
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.admin.setup.setup3_jsp._jspService(setup3_jsp.java:115)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'IpFlag' at row 1
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
net.ijsp.database.DBConnect.executeUpdate(DBConnect.java:146)
net.ijsp.forum.AdminFactory.addConfig(AdminFactory.java:93)
org.apache.jsp.admin.setup.setup3_jsp._jspService(setup3_jsp.java:84)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.18

Answer 1

Out of range value adjusted for column 'IpFlag'
说你IpFlag这个列超出范围了

Answer 2

更新数据库时字段IpFlag超出范围了，

Answer 3

Out of range value adjusted for column 'IpFlag' at row 1 
字段IpFlag超出范围了

Answer 4

CREATE TABLE config (
   ForumName varchar(20) NOT NULL,
   ForumURL varchar(100) NOT NULL,
   CompanyName varchar(40) NOT NULL,
   HostUrl varchar(100) NOT NULL,
   SystemEmail varchar(50),
   TimeAdjust int(10) DEFAULT '0',
   Logo varchar(100),
   Picurl varchar(50),
   EmailFlag int(11) DEFAULT '0' NOT NULL,
   Uploadpic int(11) DEFAULT '0' NOT NULL,
   IpFlag int(3) DEFAULT '0' NOT NULL,
   FromFlag int(3) DEFAULT '0' NOT NULL,
   guestuser int(3) DEFAULT '0' NOT NULL,
   guestlogin int(11) DEFAULT '0' NOT NULL,
   openmsg int(3) DEFAULT '0' NOT NULL,
   badwords varchar(255) NOT NULL,
   AnnounceMaxBytes int(20) DEFAULT '16384',
   MaxAnnouncePerPage int(5) DEFAULT '30',
   Copyright varchar(255) NOT NULL,
   Version varchar(255) NOT NULL,
   TodayNum int(11) DEFAULT '0' NOT NULL,
   UserNum int(11) DEFAULT '0' NOT NULL,
   lastUser varchar(50) DEFAULT 'GUEST' NOT NULL,
   Maxonline int(11) DEFAULT '0' NOT NULL,
   MaxonlineDate varchar(50) DEFAULT '0000-00-00' NOT NULL,
   adminUserName varchar(50) NOT NULL,
   adminUserPass varchar(32) NOT NULL,
   forum_setting varchar(255),
   forum_wealth varchar(255),
   forum_user varchar(255),
   StopReadme varchar(255),
   forum_Pic varchar(255),
   images varchar(255),
   forum_boardPic varchar(255),
   forum_TopicPic varchar(255),
   forum_statePic varchar(255),
   forum_upload varchar(255),
   forum_ubb varchar(255),
   ads2 text,
   ads1 text
);
String forumname = ParamUtils.getString(request,"yangtsename","");
String forumurl = ParamUtils.getString(request,"forumurl","");
String companyname = ParamUtils.getString(request,"companyname","");
String hosturl = ParamUtils.getString(request,"hosturl","");
String adminemail = ParamUtils.getString(request,"adminemail","");
String logo = ParamUtils.getString(request,"logo","");
String imagesURL = ParamUtils.getString(request,"imagesURL","Images/");
String badwrods = ParamUtils.getString(request,"badwrods","");
int ipflag = ParamUtils.getInt(request,"IpFlag",0);
int fromflag = ParamUtils.getInt(request,"fromflag",0);
int guestuser = ParamUtils.getInt(request,"guestuser",0);
int openmsg = ParamUtils.getInt(request,"openmsg",0);
int announcemaxbytes = ParamUtils.getInt(request,"announcemaxbytes",16384);
int maxannounceperpage = ParamUtils.getInt(request,"maxannounceperpage",30);
String ads1 = ParamUtils.getString(request,"ads1","");
String ads2 = ParamUtils.getString(request,"ads2","");
String copyright = ParamUtils.getString(request,"copyright","");
String version = ParamUtils.getString(request,"forumversion","");

if(forumname.equals("") || forumurl.equals("") || companyname.equals("") || hosturl.equals("") || adminemail.equals("") || copyright.equals("") || version.equals(""))
{
errMsg=errMsg+"<li>您输入的信息不完整，<font color='#ff0000'>**</font> 是必填项目。<br>";
foundErr=true;
}
String psw="21232F297A57A5A743894A0E4A801FC3";
if(!foundErr)
{
try{
DBConnect dbc=new DBConnect();
dbc.prepareStatement("insert into config ( ForumName,ForumURL,CompanyName,HostUrl,SystemEmail,Logo,Picurl,IpFlag,FromFlag,guestuser,openmsg,badwords,AnnounceMaxBytes,MaxAnnouncePerPage,ads1,ads2,Copyright,Version,lastUser,MaxonlineDate,adminUserName,adminUserPass,forum_setting,forum_user,StopReadme,forum_Pic,images,forum_boardPic,forum_TopicPic,forum_statePic,forum_upload,forum_ubb,forum_wealth ) values( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
dbc.setBytes(1,forumname.getBytes("GB2312"));
dbc.setBytes(2,forumurl.getBytes("GB2312"));
dbc.setBytes(3,companyname.getBytes("GB2312"));
dbc.setBytes(4,hosturl.getBytes("GB2312"));
dbc.setBytes(5,adminemail.getBytes("GB2312"));
dbc.setBytes(6,logo.getBytes("GB2312"));
dbc.setBytes(7,imagesURL.getBytes("GB2312"));
dbc.setBytes(8,badwrods.getBytes("GB2312"));
dbc.setInt(9,ipflag);
dbc.setInt(10,fromflag);
dbc.setInt(11,guestuser);
dbc.setInt(12,openmsg);
dbc.setInt(13,announcemaxbytes);
dbc.setInt(14,maxannounceperpage);
dbc.setBytes(15,ads1.getBytes("GB2312"));
dbc.setBytes(16,ads2.getBytes("GB2312"));
dbc.setBytes(17,copyright.getBytes("GB2312"));
dbc.setBytes(18,version.getBytes("GB2312"));
dbc.setBytes(19,"admin".getBytes("GB2312"));
dbc.setBytes(20,"0000-00-00 00:00:00".getBytes("GB2312"));
dbc.setBytes(21,"admin".getBytes("GB2312"));
dbc.setBytes(22,psw.getBytes("GB2312"));
dbc.setBytes(23,"0,300,1,1,0,0,1,1,20,0,0,20,10,16384,1,1,0,1,0,0,10,0,30,0,1,0,500,1,1,1,1,1,1,100,1,0,1,1,1,10,18,28,1,10,face,em,1,1,0,1,1,0,0,0,60,0".getBytes("GB2312"));
dbc.setBytes(24,"1,新手上路,0,levle1.gif,2,论坛游民,200,levle2.gif,3,论坛游侠,500,levle3.gif,4,业余侠客,1000,levle4.gif,5,职业侠客,2000,levle5.gif,6,江湖大佬,4000,levle6.gif,7,贵宾,,levle7.gif,8,版主,,levle8.gif,9,总版主,,levle9.gif".getBytes("GB2312"));
dbc.setBytes(25,"论坛在进行调整".getBytes("GB2312"));
dbc.setBytes(26,"ao1.gif,ao.gif,gb(1).gif,messages1.gif,messages2.gif,ifolder.gif,foldernew.gif,folderall.gif,folderallnew.gif,follow.gif,follownew.gif,jinghua.gif,jinghua.gif,lock_b.gif,lock_l.gif,ifolder.gif,foldernew.gif,ifolder.gif,foldernew.gif".getBytes("GB2312"));
dbc.setBytes(27,"foldernew.gif,foldernew.gif,folderallnew.gif,follownew.gif,lock_l.gif,jinghua.gif,ifolder.gif,ifolder.gif,folderall.gif,follow.gif,follow.gif,shareforum.gif".getBytes("GB2312"));
dbc.setBytes(28,"shareforum.gif,post.gif,newpoll.gif,newxzb.gif,newreply1.gif,help_b.gif,gohome.gif,closedfold.gif,openfold.gif,newmail.gif,mybbs.gif,treeview.gif,flatview.gif,nextthread.gif,prethread.gif,refresh.gif,gb.gif".getBytes("GB2312"));
dbc.setBytes(29,"saveas.gif,report.gif,printpage.gif,pag.gif,fav_add.gif,emailtofriend.gif,fav_add1.gif,message.gif,find.gif,profile.gif,email.gif,oicq.gif,icq.gif,msn.gif,homepage.gif,reply.gif,edit.gif,delete.gif,copy.gif,jing.gif,ip.gif,friend.gif".getBytes("GB2312"));
dbc.setBytes(30,"folder.gif,hotfolder.gif,lockfolder.gif,istop.gif,isbest.gif,newtopic.gif,userlist1.gif,top1.gif,time.gif,pmlogin.gif,born.gif,inboxnonew.gif,closedb.gif".getBytes("GB2312"));
dbc.setBytes(31,"gif,jpg,bmp,zip,png,swf,doc,txt,htm,html".getBytes("GB2312"));
dbc.setBytes(32,"bold.gif,italicize.gif,underline.gif,center.gif,url1.gif,email1.gif,image.gif,swf.gif,Shockwave.gif,rm.gif,mp.gif,qt.gif,quote1.gif,fly.gif,move.gif,glow.gif,shadow.gif".getBytes("GB2312"));
dbc.setBytes(33,"100,2,3,1,5,0,1,2,1,3,30,1,2,1,3".getBytes("GB2312"));
dbc.executeUpdate();
dbc.prepareStatement("insert into counter (createDate, todayDate) values (?,?)");
dbc.setBytes(1,GetDate.getStringDate().getBytes("GB2312"));
dbc.setBytes(2,GetDate.getStringDate().getBytes("GB2312"));
dbc.executeUpdate();
dbc.prepareStatement("INSERT INTO log (userName,url,content,addTime) VALUES (?,?,?,?)");
dbc.setBytes(1,"锋网(http://www.ijsp.net)".getBytes("GB2312"));
dbc.setBytes(2,"欢迎大家来到锋网论坛".getBytes("GB2312"));
dbc.setBytes(3,"感谢您选用锋网论坛。".getBytes("GB2312"));
我看不出来啊 怎么越界了？