[Tut] How To Make A v62 MapleStory Private Server!

D

Dexboy

Junior Spellweaver
Joined
Sep 9, 2008
Messages
144
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

This is my error

 
M

Magant

Initiate Mage
Joined
Jan 11, 2009
Messages
1
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

When i try to create a character, even though i pressed "ok", no character is created.

I get this error-

Jan 12, 2009 8:04:35 PM net.sf.odinms.net.channel.ChannelServer run
INFO: Channel 1: Listening on port 7575
Jan 12, 2009 8:04:36 PM net.sf.odinms.net.channel.ChannelServer run
INFO: Channel 2: Listening on port 7576
Jan 12, 2009 8:05:02 PM net.sf.odinms.net.MapleServerHandler sessionOpened
INFO: IoSession with /127.0.0.1:51313 opened
Jan 12, 2009 8:05:13 PM net.sf.odinms.client.MapleCharacter saveToDB
SEVERE: <Admin (cid: 30000)> (Account: admin) [charsave] Error saving character
data
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'marri
ed' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1922)
at net.sf.odinms.client.MapleCharacter.saveToDB(MapleCharacter.java:940)

at net.sf.odinms.net.channel.handler.PlayerUpdateHandler.handlePacket(Pl
ayerUpdateHandler.java:18)
at net.sf.odinms.net.MapleServerHandler.messageReceived(MapleServerHandl
er.java:118)
at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messa
geReceived(AbstractIoFilterChain.java:570)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flus
h(SimpleProtocolDecoderOutput.java:58)
at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Prot
ocolCodecFilter.java:180)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorF
ilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.
run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Unknown Source)
Jan 12, 2009 8:05:35 PM net.sf.odinms.client.MapleCharacter saveToDB
SEVERE: <Admin (cid: 30000)> (Account: admin) [charsave] Error saving character
data
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'marri
ed' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1922)
at net.sf.odinms.client.MapleCharacter.saveToDB(MapleCharacter.java:940)

at net.sf.odinms.client.MapleClient.disconnect(MapleClient.java:591)
at net.sf.odinms.net.MapleServerHandler.sessionClosed(MapleServerHandler
.java:85)
at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.sessi
onClosed(AbstractIoFilterChain.java:550)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextSessionC
losed(AbstractIoFilterChain.java:269)
at org.apache.mina.common.support.AbstractIoFilterChain.access$800(Abstr
actIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.sess
ionClosed(AbstractIoFilterChain.java:633)
at org.apache.mina.filter.codec.ProtocolCodecFilter.sessionClosed(Protoc
olCodecFilter.java:254)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextSessionC
losed(AbstractIoFilterChain.java:269)
at org.apache.mina.common.support.AbstractIoFilterChain.access$800(Abstr
actIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.sess
ionClosed(AbstractIoFilterChain.java:633)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorF
ilter.java:230)
at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.
run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Unknown Source)
Jan 12, 2009 8:07:08 PM net.sf.odinms.net.MapleServerHandler sessionOpened
INFO: IoSession with /127.0.0.1:51333 opened
Jan 12, 2009 8:07:09 PM net.sf.odinms.client.MapleCharacter saveToDB
SEVERE: <Admin (cid: 30000)> (Account: admin) [charsave] Error saving character
data
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'marri
ed' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1922)
at net.sf.odinms.client.MapleCharacter.saveToDB(MapleCharacter.java:940)

at net.sf.odinms.net.channel.handler.PlayerUpdateHandler.handlePacket(Pl
ayerUpdateHandler.java:18)
at net.sf.odinms.net.MapleServerHandler.messageReceived(MapleServerHandl
er.java:118)
at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messa
geReceived(AbstractIoFilterChain.java:570)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flus
h(SimpleProtocolDecoderOutput.java:58)
at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Prot
ocolCodecFilter.java:180)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorF
ilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.
run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Unknown Source)
Jan 12, 2009 8:07:20 PM net.sf.odinms.client.MapleCharacter saveToDB
SEVERE: <Admin (cid: 30000)> (Account: admin) [charsave] Error saving character
data
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'marri
ed' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1922)
at net.sf.odinms.client.MapleCharacter.saveToDB(MapleCharacter.java:940)

at net.sf.odinms.client.MapleClient.disconnect(MapleClient.java:591)
at net.sf.odinms.net.MapleServerHandler.sessionClosed(MapleServerHandler
.java:85)
at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.sessi
onClosed(AbstractIoFilterChain.java:550)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextSessionC
losed(AbstractIoFilterChain.java:269)
at org.apache.mina.common.support.AbstractIoFilterChain.access$800(Abstr
actIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.sess
ionClosed(AbstractIoFilterChain.java:633)
at org.apache.mina.filter.codec.ProtocolCodecFilter.sessionClosed(Protoc
olCodecFilter.java:254)
at org.apache.mina.common.support.AbstractIoFilterChain.callNextSessionC
losed(AbstractIoFilterChain.java:269)
at org.apache.mina.common.support.AbstractIoFilterChain.access$800(Abstr
actIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.sess
ionClosed(AbstractIoFilterChain.java:633)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorF
ilter.java:230)
at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.
run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Unknown Source)
 
J

jordyvdboom

Newbie Spellweaver
Joined
Apr 6, 2008
Messages
31
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

`Unknown column 'married' in 'field list'`

Fill in this field 0
 

lostyms

Newbie Spellweaver
Joined
Oct 17, 2008
Messages
47
Reaction score
2
Re: [Guide] How To Make A v62 MapleStory Private Server!



Thank you ,im trying,will tell you again when im done
 
P

Pooperdude

Newbie Spellweaver
Joined
Dec 16, 2008
Messages
55
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

some of your links are not working
 
G

Genoxa

Newbie Spellweaver
Joined
Oct 15, 2008
Messages
7
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Ok.... I am able to make the server.... but when i make a character it doesn't show up. I thinks its because there is no coloumns in the character db so it gets an error
 
Last edited:
M

MetalicZ

Junior Spellweaver
Joined
Nov 11, 2008
Messages
123
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

@lostyms

ok.

@Pooperdude

If you go to the release section find The Pack topic and download the .zip file there.

@Genoxa

It could be that.., I'm not sure. You can wait for someone else to tell you the missing columns ( I haven't added anything to fix it) or remake the database again.
 
S

simdan

Newbie Spellweaver
Joined
Oct 1, 2008
Messages
9
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

I get this error when trying to go into mySQL query browser. Am i supposed to write anything else appart from the server host? like username and pass? - i also didnt put a password when i did the setup.

At the bottom right corner just shows that my wampserver is on. plz someone tell me how to fix the problem!!:?:


EDIT: Guys i found out how to fix this all you have to do is change the username to root!!! yay
 

Attachments

You must be registered for see attachments list
Last edited:

lostyms

Newbie Spellweaver
Joined
Oct 17, 2008
Messages
47
Reaction score
2
Re: [Guide] How To Make A v62 MapleStory Private Server!



I already got KiKi files in MS v 62 folder and changed ip...so whats the problem?? Please fast... thanks
 
G

Genoxa

Newbie Spellweaver
Joined
Oct 15, 2008
Messages
7
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Ya MetalicZ it was the marriage thing. I added married column into the character db and it work. I was able to make the character and it showed up.
 
L

lanlord

Initiate Mage
Joined
Jan 11, 2009
Messages
3
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

i cant download the repack it has ben removed it stands

where can i download the repack

where have you move it
 

Zaaach

Newbie Spellweaver
Joined
Oct 3, 2008
Messages
5
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Please help with this problem!
SEVERE: Error initializing loginserver
java.lang.RuntimeException: Could not connect to world server.
at net.sf.odinms.net.login.LoginServer.run<LoginServer.java:209>
at net.sf.odinms.net.login.LoginServer.main<LoginServer.java:261>
Caused by: java.lang.NumberFormatException: For input string: '<number of characters 1 account can have>"
at java.lang.NumberFormatException.forInputString<Unknown Source>
at java.lang.Inter.parseInt<Unknown Source>
at java.lang.Inter.parseInt<Unknown Source>
at net.sf.odinms.net.login.LoginServer.run<LoginServer.java:199>
. . . 1 more

What in the world is that supposed to mean? If you know how to fix it PLEEAASSEE tell me ASAP!!!!!!!!!!!!
 
E

Eibwen

Newbie Spellweaver
Joined
Jan 4, 2009
Messages
5
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Help me please.
This is the error I get when I open the channel server.
Thank you.

I also had another problem. When I open the world server, it's blank. No text in it.
 
S

simdan

Newbie Spellweaver
Joined
Oct 1, 2008
Messages
9
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

i think the world server is supposed to be like that and i got the nearly the same error eibwen so i guess we have to wait for someone with the answer. well this is my error:

Exception in thread "main" java.lang.RuntimeException: Loading WZ File failed
at net.sf.odinms.provider.MapleDataProviderFactory.getWZ(MapleDataProvid
erFactory.java:41)
at net.sf.odinms.provider.MapleDataProviderFactory.getDataProvider(Maple
DataProviderFactory.java:54)
at net.sf.odinms.net.channel.ChannelServer.<init>(ChannelServer.java:102
)
at net.sf.odinms.net.channel.ChannelServer.newInstance(ChannelServer.jav
a:306)
at net.sf.odinms.net.channel.ChannelServer.main(ChannelServer.java:621)
Caused by: java.io.FileNotFoundException: wz\Map.wz (The system cannot find the
path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at net.sf.odinms.provider.wz.WZFile.<init>(WZFile.java:67)
at net.sf.odinms.provider.MapleDataProviderFactory.getWZ(MapleDataProvid
erFactory.java:39)
... 4 more
Press any key to continue . . .
 
D

DercyT

Initiate Mage
Joined
Jul 29, 2008
Messages
3
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Eibwen said:
Help me please.
This is the error I get when I open the channel server.

Thank you.

I also had another problem. When I open the world server, it's blank. No text in it.
Click to expand...

Make sure that you have all of the .wz files in your repack.
You have to add some extra folders that I got from a different WZ download.
String, List, and another one.
 
E

Eibwen

Newbie Spellweaver
Joined
Jan 4, 2009
Messages
5
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Alright, thank you. I did all of that. But when I try to make a character, I get to the character page and there's no character that I made. D:
 
D

DercyT

Initiate Mage
Joined
Jul 29, 2008
Messages
3
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Eibwen said:
Alright, thank you. I did all of that. But when I try to make a character, I get to the character page and there's no character that I made. D:
Click to expand...

Do you have any errors in your bat?
Make sure that you executed all of the scripts in the repack using MYSQL.
 
E

Eibwen

Newbie Spellweaver
Joined
Jan 4, 2009
Messages
5
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

I did upload all SQLs. The server isn't connecting to the database, perhaps?

EDIT: I am uninstalling Wampserver and installing it again. Then I'll upload all SQLs... Again.
 
D

DercyT

Initiate Mage
Joined
Jul 29, 2008
Messages
3
Reaction score
0
Re: [Guide] How To Make A v62 MapleStory Private Server!

Eibwen said:
I did upload all SQLs. The server isn't connecting to the database, perhaps?

EDIT: I am uninstalling Wampserver and installing it again. Then I'll upload all SQLs... Again.
Click to expand...

Well, when i was trying to make a character, it wasn't apearin.
So I went and re-executed all of the scripts in the repack and it worked fine.
Now I'm fixing the "character won't save" problem.
 
You must log in or register to reply here.