Page 1 of 1

Delete account from ./startSQLAccountManager.sh

Posted: Mon Jan 27, 2014 10:04 pm
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.

Re: Delete account from ./startSQLAccountManager.sh

Posted: Mon Jan 27, 2014 10:14 pm
by St3eT
kelam wrote:Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jls.characters' doesn't exist

Re: Delete account from ./startSQLAccountManager.sh

Posted: Mon Jan 27, 2014 10:16 pm
by NosBit
It has been partially reworked in unstable branch you can copy it from there if you want.

Re: Delete account from ./startSQLAccountManager.sh

Posted: Tue Jan 28, 2014 1:27 am
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!!!