how to fix that ? i have reinstall 3 time my mysql and nothing happen still same problem

 

 

Exception in thread "main" com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????????????????????' at line 1
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
  at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
  at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2514)
  at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4112)
  at com.mysql.jdbc.Connection.createNewIO(Connection.java:2762)
  at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
  at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)
  at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
  at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:696)
  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:257)
  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:271)
  at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
  at com.l2jarchid.L2DatabaseFactory.<init>(L2DatabaseFactory.java:100)
  at com.l2jarchid.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:173)
  at com.l2jarchid.gameserver.GameServer.main(GameServer.java:686)

Looks like you put a version of MySQL that his above sql worked

i try everything but nothing happen

Try installing an earlier version of MySQL 5.1-type

 

Sorry my bad English because it is Google tranlation

now im with MySQL client version: 5.0.51a

Test and see if giving Sure

 

Otherwise see what you did before the error

i just export Db from one pc and Import to other pc and write me this error

More on your PC it works right?

yes , only on new pc not work but there i was put 3 time mysql

SQL syntax error, I suppose you removed all "," as it's a following "? ? ? ? ? ? ? ? ? ? ? ? ? ? ?" suit, when it should be "?,?,?,?,..."

 

PS : "? ? ?" = ??? on forum so...

SQL syntax error, I suppose you removed all "," as it's a following "? ? ? ? ? ? ? ? ? ? ? ? ? ? ?" suit, when it should be "?,?,?,?,..."

 

PS : "? ? ?" = ??? on forum so...

 

i dont know what is thath  "?.?.?.?.?.?" i didnt find something like this on my DB

You added something was wrong before in java?

 

So if something is added in relation to PD may be what 's causing the problem.

 

In your java code should be ????? as following sql instead of ?,?,?,?,?, understand?

 

These?? mean that each will have SQl eg

 

Loguin | ID | e tealss | 3 ?,?,? account that there understand?

that are stupid... same DB work fine on PC 1 but on PC2 write error i cant understand that stupid programs..

What version of NAVICAT you use?

What version of NAVICAT you use?

 

i work with linux / phpmyadmin