[NothingWorksMS]

In my account column theres... id name password salt loggedin lastlogin
createdat birthday banned tempban greason banreason gm email
emailcode forumaccid macs lastpwemail. I hope this is what you asked for if not refer the question. Thanks~

[kaiwennn]

Originally Posted by Garvorious

Urg.....I swear...we're going to need some professional help.

I agree..
This error is so annoying ..

[kevin2how]

when i make character on server rigte after i press ok the character isnt there

[xbtxsniper]

jdk1.6.0_10

jre1.6.0

jre6

those are the folders and i have the us policy and local policy both placed in the respected folders that they are supposed to be in and i even went through removed and replaced them again still character vanishes

[blvosh2]

my problem is some characters try to llogin and its work fine and have some that login and get a dc and then it tell me like that.."warning:try to dubel login"

[osquan]

Quote:

SEVERE: Exception during processing packet: net.sf.odinms.net.channel.handler.Pl ayerLoggedinHandler: Loading the Char Failed (char not found) java.lang.RuntimeException: Loading the Char Failed (char not found) at net.sf.odinms.client.MapleCharacter.loadCharFromDB (MapleCharacter.jav a:215) 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(ThreadPoolExec utor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor .java:908) at org.apache.mina.util.NamePreservingRunnable.run(Na mePreservingRunnabl e.java:51) at java.lang.Thread.run(Thread.java:619)

help me

[xtremewave]

Well, My Server Is Up~! Thanks Andy! You Rock~ I Love You!(Just Kidding)

[xxandycxx]

Originally Posted by DarkSanity

I looked at this whole thread and i saw a few people ask this question but nobody seemed to answer it... but like a few people asked before i can log on my account and once i go to create my character i input all the stuff and make then i hit ok to create the char and it just auto d/ces me. PLEASE someone reply to this post so i know what is the problem

After you hit 'OK' To make your character, minimize and look for errors in login.bat/channel.bat It should say something about `unknown column`

[xxandycxx]

Originally Posted by NothingWorksMS

In my account column theres... id name password salt loggedin lastlogin createdat birthday banned tempban greason banreason gm email emailcode forumaccid macs lastpwemail. I hope this is what you asked for if not refer the question. Thanks~

Your missing the columns that are added by the CashShop sqls.

T.T

[amir233]

andy how long do you think it would take u to upload your java?

[Ejdertoft]

Okay i've got two problems

1st My chars i create dispear... adn when i create a new account and try to log in it says "incorrect password" what should i do?

tysm for answer

[tkdx]

Hi, would appreciate if anyone could help me with this.

I've tried all the steps i.e.

- Copying all the files in dist to the java folders[/jre]/lib/ext
- Copyied the JCE strength files to the java folders/lib/security
- Executed all the SQL files given in the SeanPack 5.9 repack as well as RE-EXECUTING the greasons/tempban/skills/masterylevel/etc... till i get the error duplicate column
- No ports are blocked and there are no firewall.
- Run the server without starter (ran individually, 15 secs break in between running each .bat)

I am using SeanPack 5.9 and able to run the server but unable to get to the Maps.
Everytime i select my character, it redirects me to the login page saying

" Unable to connect to Game Server. Please try again later. "

Also my server screen shows NO ERROR whatsoever but only this

INFO: Got unhandeled Message  (7) 11 00 01 F6 45 03 10
...?E..
Jul 2, 2008 5:27:39 AM net.sf.odinms.net.login.handler.CharlistRequestHandler handlePacket
INFO: Client is connecting to server 0 channel 1
Jul 2, 2008 5:27:39 AM net.sf.odinms.net.login.LoginWorker run
INFO: Possible logins: 100 (Waiting: 0)
Jul 2, 2008 5:27:40 AM net.sf.odinms.net.login.LoginWorker run
INFO: Possible logins: 100 (Waiting: 0)
Jul 2, 2008 5:27:40 AM net.sf.odinms.net.login.LoginWorker run
INFO: Possible logins: 100 (Waiting: 0)
Jul 2, 2008 5:27:41 AM net.sf.odinms.net.login.LoginWorker run
INFO: Possible logins: 100 (Waiting: 0)
Jul 2, 2008 5:27:41 AM net.sf.odinms.net.MapleServerHandler sessionOpened
INFO: IoSession with /218.186.110.215:50647 opened
Jul 2, 2008 5:27:41 AM net.sf.odinms.net.login.LoginWorker run
INFO: Possible logins: 100 (Waiting: 0)
Jul 2, 2008 5:27:42 AM net.sf.odinms.net.login.LoginWorker run
INFO: Possible logins: 100 (Waiting: 0)
Jul 2, 2008 5:27:42 AM net.sf.odinms.net.MapleServerHandler sessionOpened
INFO: IoSession with /218.186.110.215:50648 opened
Jul 2, 2008 5:27:42 AM net.sf.odinms.net.login.LoginWorker run
INFO: Possible logins: 100 (Waiting: 0)

Please help me with this. Your help will be greatly appreciated !

[xxandycxx]

Originally Posted by tkdx

Hi, would appreciate if anyone could help me with this. I've tried all the steps i.e. - Copying all the files in dist to the java folders[/jre]/lib/ext - Copyied the JCE strength files to the java folders/lib/security - Executed all the SQL files given in the SeanPack 5.9 repack as well as RE-EXECUTING the greasons/tempban/skills/masterylevel/etc... till i get the error duplicate column - No ports are blocked and there are no firewall. - Run the server without starter (ran individually, 15 secs break in between running each .bat) I am using SeanPack 5.9 and able to run the server but unable to get to the Maps. Everytime i select my character, it redirects me to the login page saying " Unable to connect to Game Server. Please try again later. " Also my server screen shows NO ERROR whatsoever but only this INFO: Got unhandeled Message (7) 11 00 01 F6 45 03 10 ...?E.. Jul 2, 2008 5:27:39 AM net.sf.odinms.net.login.handler.CharlistRequestHandler handlePacket INFO: Client is connecting to server 0 channel 1 Jul 2, 2008 5:27:39 AM net.sf.odinms.net.login.LoginWorker run INFO: Possible logins: 100 (Waiting: 0) Jul 2, 2008 5:27:40 AM net.sf.odinms.net.login.LoginWorker run INFO: Possible logins: 100 (Waiting: 0) Jul 2, 2008 5:27:40 AM net.sf.odinms.net.login.LoginWorker run INFO: Possible logins: 100 (Waiting: 0) Jul 2, 2008 5:27:41 AM net.sf.odinms.net.login.LoginWorker run INFO: Possible logins: 100 (Waiting: 0) Jul 2, 2008 5:27:41 AM net.sf.odinms.net.MapleServerHandler sessionOpened INFO: IoSession with /218.186.110.215:50647 opened Jul 2, 2008 5:27:41 AM net.sf.odinms.net.login.LoginWorker run INFO: Possible logins: 100 (Waiting: 0) Jul 2, 2008 5:27:42 AM net.sf.odinms.net.login.LoginWorker run INFO: Possible logins: 100 (Waiting: 0) Jul 2, 2008 5:27:42 AM net.sf.odinms.net.MapleServerHandler sessionOpened INFO: IoSession with /218.186.110.215:50648 opened Jul 2, 2008 5:27:42 AM net.sf.odinms.net.login.LoginWorker run INFO: Possible logins: 100 (Waiting: 0) Please help me with this. Your help will be greatly appreciated !

Tell me what columns your characters table has (i.e id, name, level etc)

[xxandycxx]

Originally Posted by xtremewave

Well, My Server Is Up~! Thanks Andy! You Rock~ I Love You!(Just Kidding)

No problem.

[NothingWorksMS]

Okay I'm really pissed that I didn't know I needed the Cash shop Sql's. Well I have them and now I see my Admin guy. I can create a character successfully and get into the game and start playing. Thank you so much xxandycxx I hope no more problems will occur. Thanks again =D

[hongjoo]

how do i fix this

[xxandycxx]

Originally Posted by hongjoo

how do i fix this

Configure your db.properties

[mdm5]

02-Jul-2008 16:55:35 net.sf.odinms.net.channel.ChannelServer run
INFO: Channel 1: Listening on port 7575
02-Jul-2008 16:55:35 net.sf.odinms.net.channel.ChannelServer run
INFO: Channel 2: Listening on port 7576
02-Jul-2008 16:57:41 net.sf.odinms.net.MapleServerHandler sessionOpened
INFO: IoSession with /5.21.75.76:3845 opened
02-Jul-2008 16:57:49 net.sf.odinms.net.channel.handler.PlayerLoggedinHa ndler han
dlePacket
SEVERE: Loading the char failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'maste
rlevel' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstruct
orAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:513)
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(ThreadPoolExec
utor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:908)
at org.apache.mina.util.NamePreservingRunnable.run(Na mePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Thread.java:619)
02-Jul-2008 16:57:49 net.sf.odinms.net.MapleServerHandler messageReceived
SEVERE: (Account: admin) Exception during processing packet: net.sf.odinms.net.c
hannel.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(ThreadPoolExec
utor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor
.java:908)
at org.apache.mina.util.NamePreservingRunnable.run(Na mePreservingRunnabl
e.java:51)
at java.lang.Thread.run(Thread.java:619)





My account columns are:

id, name, password, salt, loggedin, lastlogin, createdat, birthday, banned, tempban, greason, banreason, gm, email, emailcode, forumaccid, macs, lastpwemail, nxCash, mPoints, gTokens

[xxandycxx]

Originally Posted by mdm5

02-Jul-2008 16:55:35 net.sf.odinms.net.channel.ChannelServer run INFO: Channel 1: Listening on port 7575 02-Jul-2008 16:55:35 net.sf.odinms.net.channel.ChannelServer run INFO: Channel 2: Listening on port 7576 02-Jul-2008 16:57:41 net.sf.odinms.net.MapleServerHandler sessionOpened INFO: IoSession with /5.21.75.76:3845 opened 02-Jul-2008 16:57:49 net.sf.odinms.net.channel.handler.PlayerLoggedinHa ndler han dlePacket SEVERE: Loading the char failed com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'maste rlevel' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstruct orAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingC onstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Construc tor.java:513) 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(ThreadPoolExec utor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor .java:908) at org.apache.mina.util.NamePreservingRunnable.run(Na mePreservingRunnabl e.java:51) at java.lang.Thread.run(Thread.java:619) 02-Jul-2008 16:57:49 net.sf.odinms.net.MapleServerHandler messageReceived SEVERE: (Account: admin) Exception during processing packet: net.sf.odinms.net.c hannel.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(ThreadPoolExec utor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor .java:908) at org.apache.mina.util.NamePreservingRunnable.run(Na mePreservingRunnabl e.java:51) at java.lang.Thread.run(Thread.java:619) My account columns are: id, name, password, salt, loggedin, lastlogin, createdat, birthday, banned, tempban, greason, banreason, gm, email, emailcode, forumaccid, macs, lastpwemail, nxCash, mPoints, gTokens

Run this Which was on the first post btw! x]

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

[mdm5]

Oh crap, it worked, sorry and thanks!

[xxandycxx]

No problem, Read closer next time though.

[Ejdertoft]

okey i post it again >.< just cause u dont answer :O i make a cha and it dispear what should i do >.>

[xxandycxx]

Originally Posted by Ejdertoft

okey i post it again >.< just cause u dont answer :O i make a cha and it dispear what should i do >.>

Run the SQL's.

[Ejdertoft]

already did it still dosent work :O

[xxandycxx]

Asoon as you hit `OK` To create your character, minmize and look at login/channel.bat for errors.