View Old Forum Thread

Old Forum Index » Baseball Beta Testing » Short Term League Talk » Can't transfer Manager Preferences

tworoosters

---

Can't transfer Manager Preferences

August 25, 2010 at 03:49PM View BBCode

Tried to trnasfer my regulat beta prferences to the ASL team and got this:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 29 in the jsp file: /managercopy.jsp
Duplicate local variable stmt2
26: Statement stmt2 = con.createStatement();
27:
28: if(rset.next()) {
29: Statement stmt2 = changeDatabase(rset.getString("league_database");
30: query = "select * from manager where manager_team_id = " + copyteamid;
31: rset = stmt2.executeQuery(query);
32: rset.next();


An error occurred at line: 29 in the jsp file: /managercopy.jsp
Syntax error, insert ")" to complete VariableInitializer
26: Statement stmt2 = con.createStatement();
27:
28: if(rset.next()) {
29: Statement stmt2 = changeDatabase(rset.getString("league_database");
30: query = "select * from manager where manager_team_id = " + copyteamid;
31: rset = stmt2.executeQuery(query);
32: rset.next();


Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:349)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:327)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:314)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:589)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
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.26 logs.
Apache Tomcat/6.0.26

Admin

---

August 25, 2010 at 04:46PM View BBCode

Can you try this again?

Thanks,
Tyson

tworoosters

---

August 25, 2010 at 05:00PM View formatted

Tried again and got this:

query: insert into managerdef (`managerdef_manager_id`, `managerdef_runner1`, `managerdef_runner2`, `managerdef_runner3`, `managerdef_inning`, `managerdef_homeoraway`, `managerdef_tieorwin`, `managerdef_outs`, `managerdef_action`) values (46753, 0, 0 , 1 , 7 ,'h','t', 0 ,'i') Message: Operation not allowed after ResultSet closed

Hamilton2

---

August 25, 2010 at 05:09PM View BBCode

I just tried this and got the same thing:

query: insert into managerdef (`managerdef_manager_id`, `managerdef_runner1`, `managerdef_runner2`, `managerdef_runner3`, `managerdef_inning`, `managerdef_homeoraway`, `managerdef_tieorwin`, `managerdef_outs`, `managerdef_action`) values (5, 0, 0 , 1 , 7 ,'h','t', 0 ,'i') Message: Operation not allowed after ResultSet closed

Admin

---

August 25, 2010 at 05:21PM View BBCode

Thanks for posting. This is a tricky page with the multi-database thing. Give it another try.

Tyson

tm4559

---

August 25, 2010 at 05:30PM View BBCode

yeah, works ok now.

tworoosters

---

August 25, 2010 at 05:37PM View BBCode

Yeah, worked for me as well .

tm4559

---

August 25, 2010 at 06:39PM View BBCode

ha wait. the menus at the top don't show.

tm4559

---

August 25, 2010 at 06:40PM View BBCode

for any of my beat teams, i mean to say.

thatrogue

---

It looks like Roosters broke beta...

August 25, 2010 at 06:56PM View BBCode

(Figures)

tm4559

---

August 25, 2010 at 07:06PM View BBCode

troublemaker.

(roosters. a troublemaker.)

((maximum hugs though.))

Admin

---

August 25, 2010 at 08:40PM View BBCode

I've fixed that.

If you guys see problems like this in the future, just create a new thread here so we can take a look.

Thanks!
Tyson

tworoosters

---

August 25, 2010 at 11:31PM View BBCode

Breaking beta is what we're supposed to do, it's kind of the whole reason for beta's existence.

So.............................yea me.