yeiij Posted July 16, 2014 Posted July 16, 2014 Help please with error ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot All files are properly poured, at character creation, this error. import /authserver/sql/install/*.sql to db newcore Quote
Cray-Z Posted July 22, 2014 Posted July 22, 2014 Why do u thing u will get the files for free ? High Five too.Also no sources = useless Quote
SpirakosDafuq™ Posted July 22, 2014 Posted July 22, 2014 Why do u thing u will get the files for free ? High Five too. Also no sources = useless true that.. Quote
kassane Posted July 22, 2014 Posted July 22, 2014 I would really like to have the valiance version! :-[ Quote
hanzo Posted July 23, 2014 Posted July 23, 2014 (edited) I have Error :/ Starting GameServer. [19:26:01] INFO ================================================= [19:26:01] INFO Project Revision: ........ L2s [8508] [19:26:01] INFO Build Revision: .......... 'F:\tools' doesn't exist [19:26:01] INFO Update: .................. Chapter 3: Lindvior [19:26:01] INFO Build date: .............. 2013.10.02 23:27 [19:26:01] INFO Compiler version: ........ 23.21-b01 (Oracle Corporation) [19:26:01] INFO ================================================= Exception in thread "main" java.lang.NoClassDefFoundError: l2s/gameserver/utils/ Clients at l2s.gameserver.GameServer.<init>(GameServer.java:158) at l2s.gameserver.GameServer.main(GameServer.java:399) Caused by: java.lang.ClassNotFoundException: l2s.gameserver.utils.Clients at java.net.URLClassLoader$1.run(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) ... 2 more Server terminated abnormaly ... Server terminated ... Press any key to continue . . . exact the same issue .... Solved -=C/Paste the gameserver into libs=- Cheers Edited July 23, 2014 by hanzo Quote
Nightw0lf Posted July 24, 2014 Posted July 24, 2014 Why do u thing u will get the files for free ? High Five too. Also no sources = useless true that.. its java you can make source :poker face: and about the error lol i didnt tryed and i wont because i am on interlude mostly but for newbies i have to say dont use packs that you dont know who coded them and what he coded inside. packs like this are only for ripping porpuses :dat: Quote
Epyhon Posted October 10, 2014 Posted October 10, 2014 Server works only in local when trying online gserver gives this err [10.10.14 23:04:04:188] ERROR dao.CharacterDAO:com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot be nullat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)at java.lang.reflect.Constructor.newInstance(Unknown Source)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:1041)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)at l2s.gameserver.dao.CharacterDAO.insert(CharacterDAO.java:79)at l2s.gameserver.model.Player.create(Player.java:4820)at l2s.gameserver.network.l2.c2s.CharacterCreate.runImpl(CharacterCreate.java:64)at l2s.gameserver.network.l2.c2s.L2GameClientPacket.run(L2GameClientPacket.java:49)at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:39)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)at java.lang.Thread.run(Unknown Source) Quote
TheMark147 Posted October 17, 2014 Posted October 17, 2014 that's works fine but i dont know how to set access level because i try add to character acc lvl 100,1000,1 and this acc lvls dont works u know how this works? or u knows this values for admin privileges? Quote
Eurytus Posted November 8, 2014 Posted November 8, 2014 that's works fine but i dont know how to set access level because i try add to character acc lvl 100,1000,1 and this acc lvls dont works u know how this works? or u knows this values for admin privileges? can you share the newcore db please becouse im stuck at char creation problem after inporting , ,,, Quote
Eurytus Posted November 8, 2014 Posted November 8, 2014 import /authserver/sql/install/*.sql to db newcore Same error here Quote
Stereotype Posted November 25, 2014 Posted November 25, 2014 Help please with error ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot Same error. And i added login sqls also from Install and such... Quote
mircowwwa Posted November 25, 2014 Posted November 25, 2014 (edited) "ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot be null" Go to database and with PHPMyAdmin or Navicat or other software that you are using(i use PHPMyAdmin) and search 'characters' table...open table structure and where there is 'account_name' field modify it with NOT NULL; after it should work :P Edited November 25, 2014 by mircowwwa Quote
mircowwwa Posted November 25, 2014 Posted November 25, 2014 xception in thread "main" java.lang.NoClassDefFoundError: l2s/gameserver/utils/ Clients at l2s.gameserver.GameServer.<init>(GameServer.java:158) at l2s.gameserver.GameServer.main(GameServer.java:399) Caused by: java.lang.ClassNotFoundException: l2s.gameserver.utils.Clients at java.net.URLClassLoader$1.run(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) ... 2 more This is a class modify error,class has been editated with notepad XD,L2Script use this class,Clients.java,for save Server "License" IP,so with this control one IP per Pack,you need to extrat .class form jar modify only an existing ip string and re-put into jar...easy :D this is from another shared L2Script-Hi5 Pack package l2s.gameserver.utils; import java.util.ArrayList; import java.util.List; import org.slf4j.Logger; import org.slf4j.LoggerFactory; public class Clients { private static final Logger _log = LoggerFactory.getLogger(Clients.class); private static List<String> _knownIps = new ArrayList(); private static String client1 = "178.32.250.206"; private static String client2 = "127.0.0.1"; private static String client3 = "127.0.0.1"; private static String client4 = "176.99.5.239"; private static String client5 = "195.211.222.28"; private static String client6 = "127.0.0.1"; private static String client7 = "83.69.139.146"; private static String client8 = "23.92.221.138"; private static String client9 = "173.238.156.79"; private static String client10 = "186.2.165.168"; private static String client11 = "178.32.56.74"; private static String client12 = "62.140.234.96"; private static String client13 = "127.0.0.1"; private static String client14 = "127.0.0.1"; private static String client15 = "94.198.109.166"; public static void Load() { _knownIps.add(client1); _knownIps.add(client2); _knownIps.add(client3); _knownIps.add(client4); _knownIps.add(client5); _knownIps.add(client6); _knownIps.add(client7); _knownIps.add(client8); _knownIps.add(client9); _knownIps.add(client10); _knownIps.add(client11); _knownIps.add(client12); _knownIps.add(client13); _knownIps.add(client14); _knownIps.add(client15); } public static List<String> getIps() { return _knownIps; } } Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.