Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
L2JForge.live Interlude Premium Emulator
  • 0

mysql problem

Bobi

Asked by Bobi,

 Share

Question

Bobi Newbie

Bobi

Posted
Posted

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)

17 answers to this question

Recommended Posts

  • 0
Tryskell Rising Star

Tryskell

Posted
Posted

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

 

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

  • 0
Bobi Newbie

Bobi

Posted
  • Author
Posted

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

  • 0
bobzih Newbie

bobzih

Posted
Posted

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?

  • 0
Bobi Newbie

Bobi

Posted
  • Author
Posted

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

  • 0
Astald Newbie

Astald

Posted
Posted

this say you to replace the serial fields with characters using the isolation ","

 

etc in .sql file need to use like this  xxx,xxx,xxx,x,x,x

 

I think yours problem is wrong datapack

Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • Litch
      Lin2Guard Antibot Guard - L2J & PTS (l2off)

      By Litch · Posted

      Yeah, for sure. Hardly anyone doesn't use it yet, but those few are gonna give in soon. I'm not judging anyone who uses it – that's not the point. The point is that people do use it. I use it, you use it, we all use it. These days, it's just NORMAL. And it's gonna keep getting more and more normal. But like I said, you still gotta know what you're actually doing.
    • aguy
      Lin2Guard Antibot Guard - L2J & PTS (l2off)

      By aguy · Posted

      Then that's the problem. Server owners are as bad as they used to be in 2005, 2010 and so on.    This scene has technically mature developers, always money-hungry server owners, but what both these groups lack, is some creativity ... I would never play in a server that needs 7 layers of anti-bot. If it needs 7 layers of anti-bot, it means its a bot friendly server and not something worth playing. 
    • Splicho
      Lin2Guard Antibot Guard - L2J & PTS (l2off)

      By Splicho · Posted

      Lineage just has a giga boring quest line / lore and since server owners are not reinventing the wheel, players are forced to F1 F2 spam by server design.
    • aguy
      Lin2Guard Antibot Guard - L2J & PTS (l2off)

      By aguy · Posted

      Players say: We don't have time, please add auto-farm to the server, after all, farming in L2 is the most repetitive and boring thing, it gives no enjoyment.    Then players say: OMG your server is full of auto-farmers with adrenaline. Use anti-cheat guards.    Excluding the hilarious fact that an auto-farm player is essentiall botting without botting software ...   Noone stops to ask the simple question: If nobody likes farming to that extend that they go as far as building complex bots and ask for server-side bot programs and then for no apparent reason have to build anti-bot guards ... MAYBE the problem is that "farming" is an outdated feature that has to be removed from your servers ?   What you people are building here is software that protects a game feature, nobody likes and nobody wants to use.   Has the mental capacity of server owners and developers fallen so many IQ points the last decade ? One comes back to see the same server setups of a decade ago, with zero innovation, zero creativity and a huge amount of time and resources protecting a game feature nobody wants to even use ... The other dissappointing thing one sees here, is that a lot of GREAT developers who now work full time jobs in corporate, come back here, to bash the work of others because they find their current job tasks not as fullfilling as when they would develope game related code for Lineage 2...   Talking about life choices eh ? 😛
    • Out of Time
      High Five L2j

      By Out of Time · Posted

      Have u seen the message i sent you?

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..