[Tut]How to fix Not registered ID/Cant pass Char Select/Chars dispear/Login Stick - Page 3 - RaGEZONE

xxandycxx · 06-28-2008

Originally Posted by Jayson

I logged in my account but all my characters gone ~_~

Code:

ALTER TABLE `odinms`.`characters` ADD COLUMN `guildid` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `jobRankMove`,
 ADD COLUMN `guildrank` INTEGER UNSIGNED NOT NULL DEFAULT 5 AFTER `guildid`;

Jordann · 06-28-2008

Hi. After I run all of the sql files , I on my server and gone into it . I created my character . I dc-ed . Then , I gone into my account again . No character are at the character selection pages but there is character in MySQL. I am using NubStory Repack.

-DeAn- · 06-28-2008

when i press on my char it gives me error on channel bat what should i do

donotshoutz · 06-28-2008

ALTER TABLE `skills` ADD COLUMN `masterlevel` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `skilllevel`;

May i know how do i carry out this step in detail?

ehddn2380 · 06-28-2008

[ INFO ]

1. MAPLESTORY LOGIN

2. CHANNEL LOGIN

3. CHARACTER LOGIN [ERROR, Channel.bat] :

Quote:
2008. 6. 28 오후 8:03:04 net.sf.odinms.net.channel.ChannelServer run
정보: Channel 1: Listening on port 7575
2008. 6. 28 오후 8:03:04 net.sf.odinms.net.channel.ChannelServer run
정보: Channel 2: Listening on port 7576
2008. 6. 28 오후 8:03:51 net.sf.odinms.net.MapleServerHandler sessionOpened
정보: IoSession with /5.210.143.42:3001 opened
2008. 6. 28 오후 8:03:52 net.sf.odinms.net.channel.handler.PlayerLoggedinHa ndler
handlePacket
심각: Loading the char failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown 칼럼 'masterl
evel' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 36)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:
1885)
at net.sf.odinms.client.MapleCharacter.loadCharFromDB (MapleCharacter.jav
a:397)
at net.sf.odinms.net.channel.handler.PlayerLoggedinHa ndler.handlePacket(
PlayerLoggedinHandler.java:59)
at net.sf.odinms.net.MapleServerHandler.messageReceiv ed(MapleServerHandl
er.java:150)
at org.apache.mina.common.support.AbstractIoFilterCha in$TailFilter.messa
geReceived(AbstractIoFilterChain.java:570)
at org.apache.mina.common.support.AbstractIoFilterCha in.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterCha in.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterCha in$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.codec.support.SimpleProtoco lDecoderOutput.flus
h(SimpleProtocolDecoderOutput.java:58)
at org.apache.mina.filter.codec.ProtocolCodecFilter.m essageReceived(Prot
ocolCodecFilter.java:180)
at org.apache.mina.common.support.AbstractIoFilterCha in.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterCha in.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterCha in$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.pro cessEvent(ExecutorF
ilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter$Pro cessEventsRunnable.
run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at org.apache.mina.util.NamePreservingRunnable.run(Na mePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Unknown Source)
2008. 6. 28 오후 8:03:52 net.sf.odinms.net.MapleServerHandler messageReceived
심각: (Account: kimfine1203) Exception during processing packet: net.sf.odinms.n
et.channel.handler.PlayerLoggedinHandler: null
java.lang.NullPointerException
at net.sf.odinms.net.channel.handler.PlayerLoggedinHa ndler.handlePacket(
PlayerLoggedinHandler.java:64)
at net.sf.odinms.net.MapleServerHandler.messageReceiv ed(MapleServerHandl
er.java:150)
at org.apache.mina.common.support.AbstractIoFilterCha in$TailFilter.messa
geReceived(AbstractIoFilterChain.java:570)
at org.apache.mina.common.support.AbstractIoFilterCha in.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterCha in.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterCha in$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.codec.support.SimpleProtoco lDecoderOutput.flus
h(SimpleProtocolDecoderOutput.java:58)
at org.apache.mina.filter.codec.ProtocolCodecFilter.m essageReceived(Prot
ocolCodecFilter.java:180)
at org.apache.mina.common.support.AbstractIoFilterCha in.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterCha in.access$1100(Abst
ractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterCha in$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.pro cessEvent(ExecutorF
ilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter$Pro cessEventsRunnable.
run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at org.apache.mina.util.NamePreservingRunnable.run(Na mePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Unknown Source)
2008. 6. 28 오후 8:03:52 net.sf.odinms.net.MapleServerHandler messageReceived
정보: Got unhandeled Message (44) 16 00 32 75 00 00 24 00 37 41 2D 37 39 2D 30
35 2D 44 32 2D 38 46 2D 32 41 2C 20 30 30 2D 31 33 2D 37 37 2D 31 38 2D 37 35 2D
46 44
..2u..$.7A-79-05-D2-8F-2A, 00-13-77-18-75-FD

MY CHARACTER IS MARATONER !!!!!

HELP . HELP ME PLEASE ....!!!!

MY PACK : SEANS 5.8

Hotaku · 06-28-2008

I think you haven't configured the db.properties , channel.properties login.properties and channel.properties

And you haven't disabled you're firewall ...

vintagez · 06-28-2008

can u help me? how to resolve the problem " An existing connection was forcibly closed by the remote host " ? please help.

FlowMotion · 06-28-2008

Yeah im having the same problem on the server im helping with Im totally lost im not sure if its a setting mistake or if its a bad code some where.

But the channel.bat gives the same error when you try to login to the server to get in the game so you just hang or d/c when you go to login the game.

joey255 · 06-28-2008

i still cant pass Char selection o.0 ,,
and i see this (dont know what this mean)

----------------

cann someone help me? o.0
yes, all Jave files ar correct :)

joey255 · 06-28-2008

~srry doublepost~~

Sora1221 · 06-28-2008

I did everything... I still get ID Not registered, and I have a public server with over 3k members waiting to play! They already have accounts because it worked earlier but it just stopped working one day.

xxandycxx · 06-28-2008

For all you who don't know how to run this, here is a noob step...

Open a new script tab in MySQL Query browser and paste this in

Code:

ALTER TABLE `odinms`.`characters` ADD COLUMN `guildid` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `jobRankMove`,
 ADD COLUMN `guildrank` INTEGER UNSIGNED NOT NULL DEFAULT 5 AFTER `guildid`;

This will get rid of the Chars disapearing glitch.
As for you ehddn2380,

Code:

ALTER TABLE `skills` ADD COLUMN `masterlevel` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `skilllevel`;

ehddn2380 This is at the start of the thread, follow all the steps next time!

amir233 · 06-28-2008

what about me?

xxandycxx · 06-28-2008

Amir, are you using hamachi? Or are you connecting via your WANIP?

mono528 · 06-28-2008

Im using seanpack 5.8,
It say my id not registered???
can tell me how to check my ID n pass?

xxandycxx · 06-28-2008

Run all the .sqls I included in the mediafire link on my first post.

amir233 · 06-28-2008

Originally Posted by xxandycxx

Amir, are you using hamachi? Or are you connecting via your WANIP?

Hamachi

xxandycxx · 06-28-2008

Change the ip in channel, login, and world.properties to your hamachi ip, make sure they're are no spaces between = and the IP.

amir233 · 06-29-2008

already done - any other suggestion?

thanks for trying to help

Sora1221 · 06-29-2008

And me...?

pmpblazer7 · 06-29-2008

I've tried everything in this guide and im still stuck at the login screen.

Im currently using Odinmsrev932

Any idea what the problem could be?

wedoboop · 06-29-2008

even with the unlimted it still didnt let me log in.....

pmpblazer7 · 06-29-2008

Also here my error here http://s304.photobucket.com/albums/n...ourceerror.jpg

wedoboop · 06-29-2008

wat do u mean when u say "Make sure you have your dist files from the dist folder in ur odinms folder in these folders "

xxandycxx · 06-29-2008

The 6 Files from the 'dist' folder in your REpack/Odinms folder.