Delete account from ./startSQLAccountManager.sh

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
kelam
Posts: 2
Joined: Sun Jan 26, 2014 6:22 am

Delete account from ./startSQLAccountManager.sh

Post by kelam »

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 6367
L2JDP Revision Number: 10152

Hello, pls help me with this error:
lineage@Debian7:~/L2J/login$ ./startSQLAccountManager.sh
Por favor elija una opcion

1 - Crear nueva Cuenta o actualizar una existente
2 - Cambiar Nivel de Acceso
3 - Borrar una Cuenta existente
4 - Listar las Cuentas y Niveles de Acceso
5 - Salir
Su Eleccion: 3
Nombre de Usuario: xxx
Realmente deseas borrar esta Cuenta ? S/N: s
Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jls.characters' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at com.l2jserver.tools.accountmanager.SQLAccountManager.deleteAccount(SQLAccountManager.java:278)
at com.l2jserver.tools.accountmanager.SQLAccountManager.main(SQLAccountManager.java:134)
=================================================================================================

The characters table is in l2jgs db not in l2jls db, someone can correct this in SQLAccountManager.java?
Sorry for my english.
Thx.
User avatar
St3eT
Posts: 961
Joined: Sun Mar 07, 2010 6:50 pm

Re: Delete account from ./startSQLAccountManager.sh

Post by St3eT »

kelam wrote:Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jls.characters' doesn't exist
If i should be black sheep for sure no as punishment
Image
NosBit
L2j Veteran
L2j Veteran
Posts: 314
Joined: Mon Mar 11, 2013 4:19 pm

Re: Delete account from ./startSQLAccountManager.sh

Post by NosBit »

It has been partially reworked in unstable branch you can copy it from there if you want.
Image
kelam
Posts: 2
Joined: Sun Jan 26, 2014 6:22 am

Re: Delete account from ./startSQLAccountManager.sh

Post by kelam »

Nos wrote:It has been partially reworked in unstable branch you can copy it from there if you want.
I got it, ty!!!
Post Reply