so i had a question brought up from one or my servers players and he asked if it was possible to get his faction back after he deleted hit toon that made the faction, he tried to just make it and the name was taken, meaning that factions name is still stored somewhere, now somehow his toon has to have an identifier that states he is in faction id blank with rank of blank...right? is it possible to move him into his old faction and give him leadership?
anyone?
i know that in order to put up a faction icon, we use an # to describe the faction, has anyone messed with it?
Character names and faction names are stored in the uniquenamed database. The name still exists in there which is why they can't recreate the faction. You could clear the database so they can remake it but its probably not the best idea since it will clear all names. There may be a way to delete just that particular faction name using the dbtools but idk how.
I think the faction a character is in is possibly stored on the character xml. It would be a good idea to run some tests. Make a new character and have it make a new faction. Check pwAdmin to find out where the faction is. Leave the faction then try adding it again via pwAdmin. If it works then do it to their character (backup first). If not then you might not be able to do what you want easily so they will have to make a new faction with a different name.
ok ill do some digging, i just found out i cant change faction icons anymore, i use to be able to, now i get an error messege
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Table 'dbo.roles' doesn't exist
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
javax.servlet.ServletException: Table 'dbo.roles' doesn't exist
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.addons.Faction_0020Icons.index_jsp._jspService(index_jsp.java:473)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dbo.roles' doesn't exist
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
org.apache.jsp.addons.Faction_0020Icons.index_jsp._jspService(index_jsp.java:404)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.
i could have sworn their was roles their, but after looking its not, what do i need to do to make the table?
You need the sql to create the tables, or create them by yourself which is a lot of work :) I think the sql is floating around somewhere here, you can, as far as my noob memory serves me, use an 1.4.4 sql which is included in all major 1.4.4 releases.
by any chance is their a link floting around for this mysql file? im doing some digging over in the 1.4.4 sections like you said, so far i have not found a link itsself, so im downloading one of the servers to see if it is inside
ok so this is a new part to me, with hrace009's release i did not need to add anything into db0, now i do, i downloaded a server 1.4.4 and found the mysql files uploaded it into the db0 and now i have roles, now im getting a new error
org.apache.jasper.JasperException: Unknown column 'role_name' in 'field list'
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
and i checked the files even after creating a new faction nothing updated, what am i doing wrong?
has anyone had some experience with hrace009's server to know exactly what i need to do?
Originally Posted by slayer200230
This error is related to the database. It seems that you do not have role_name column in your table. Please check it. Let me know, if I can help you any more.
Jwalant
Do not think he needs your help. Latest he posted on this thread was 14-04-12 and last time he was on was in May. Probably gave up or already found that out.
Reply With Quote