- Joined
- Jan 18, 2010
- Messages
- 3,109
- Reaction score
- 1,139
There's a solution to getting Windows 8.1 to work, I'll just leave a comment here and edit it later once I remeber the solution. Or maybe I'm just imagining things.
using a redirector is a solution ;p
Lol, I was thinking something of running the Windows in WIndows 7 Compatibility or something like that. Just a thought or random memory that popped.
Linkerzz related to MySQL.
how to Add Gm and close auto register?
i forget how to add gm acc! :?:
And the CMS - Website?
new player star game in maple road map (map id 10000)
how to chg go FM map?
i wan new player in fm map!
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_questdata' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at server.quest.MapleQuest.initQuests(MapleQuest.java:140)
at server.Start.run(Start.java:90)
at server.Start.main(Start.java:148)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_itemdata' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at server.MapleItemInformationProvider.runItems(MapleItemInformationProvider.java:341)
at server.Start.run(Start.java:93)
at server.Start.main(Start.java:148)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_oxdata' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at server.events.MapleOxQuizFactory.initialize(MapleOxQuizFactory.java:64)
at server.events.MapleOxQuizFactory.<init>(MapleOxQuizFactory.java:42)
at server.events.MapleOxQuizFactory.<clinit>(MapleOxQuizFactory.java:39)
at server.Start.run(Start.java:97)
at server.Start.main(Start.java:148)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_mobskilldata' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at server.life.MobSkillFactory.initialize(MobSkillFactory.java:59)
at server.life.MobSkillFactory.<init>(MobSkillFactory.java:44)
at server.life.MobSkillFactory.<clinit>(MobSkillFactory.java:41)
at server.Start.run(Start.java:100)
at server.Start.main(Start.java:148)
Hey.
The SQL included in your source makes this error:
Code:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_questdata' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264) at server.quest.MapleQuest.initQuests(MapleQuest.java:140) at server.Start.run(Start.java:90) at server.Start.main(Start.java:148) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_itemdata' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264) at server.MapleItemInformationProvider.runItems(MapleItemInformationProvider.java:341) at server.Start.run(Start.java:93) at server.Start.main(Start.java:148) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_oxdata' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264) at server.events.MapleOxQuizFactory.initialize(MapleOxQuizFactory.java:64) at server.events.MapleOxQuizFactory.<init>(MapleOxQuizFactory.java:42) at server.events.MapleOxQuizFactory.<clinit>(MapleOxQuizFactory.java:39) at server.Start.run(Start.java:97) at server.Start.main(Start.java:148) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'judoms.wz_mobskilldata' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264) at server.life.MobSkillFactory.initialize(MobSkillFactory.java:59) at server.life.MobSkillFactory.<init>(MobSkillFactory.java:44) at server.life.MobSkillFactory.<clinit>(MobSkillFactory.java:41) at server.Start.run(Start.java:100) at server.Start.main(Start.java:148)
If you could provide a working SQL then that would be great.
Thanks
Okay do you think it's possible to link me to the help thread?
Thanks
DROP TABLE IF EXISTS `wz_itemdata`;
CREATE TABLE `wz_itemdata` (
`itemid` int(11) NOT NULL,
`name` tinytext,
`msg` varchar(4096) DEFAULT NULL,
`desc` varchar(4096) DEFAULT NULL,
`slotMax` smallint(5) NOT NULL DEFAULT '1',
`price` varchar(255) NOT NULL DEFAULT '-1.0',
`wholePrice` int(11) NOT NULL DEFAULT '-1',
`stateChange` int(11) NOT NULL DEFAULT '0',
`flags` smallint(4) NOT NULL DEFAULT '0',
`karma` tinyint(1) NOT NULL DEFAULT '0',
`meso` int(11) NOT NULL DEFAULT '0',
`monsterBook` int(11) NOT NULL DEFAULT '0',
`itemMakeLevel` smallint(6) NOT NULL DEFAULT '0',
`questId` int(11) NOT NULL DEFAULT '0',
`scrollReqs` tinytext,
`consumeItem` tinytext,
`totalprob` int(11) NOT NULL DEFAULT '0',
`incSkill` varchar(255) NOT NULL DEFAULT '',
`replaceid` int(11) NOT NULL DEFAULT '0',
`replacemsg` varchar(255) NOT NULL DEFAULT '',
`create` int(11) NOT NULL DEFAULT '0',
`afterImage` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `wz_mobskilldata`;
CREATE TABLE `wz_mobskilldata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`skillid` int(11) NOT NULL,
`level` int(11) NOT NULL,
`hp` int(11) NOT NULL DEFAULT '100',
`mpcon` int(11) NOT NULL DEFAULT '0',
`x` int(11) NOT NULL DEFAULT '1',
`y` int(11) NOT NULL DEFAULT '1',
`time` int(11) NOT NULL DEFAULT '0',
`prop` int(11) NOT NULL DEFAULT '100',
`limit` int(11) NOT NULL DEFAULT '0',
`spawneffect` int(11) NOT NULL DEFAULT '0',
`interval` int(11) NOT NULL DEFAULT '0',
`summons` varchar(1024) NOT NULL DEFAULT '',
`ltx` int(11) NOT NULL DEFAULT '0',
`lty` int(11) NOT NULL DEFAULT '0',
`rbx` int(11) NOT NULL DEFAULT '0',
`rby` int(11) NOT NULL DEFAULT '0',
`once` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=789 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wz_oxdata`;
CREATE TABLE `wz_oxdata` (
`questionset` smallint(6) NOT NULL DEFAULT '0',
`questionid` smallint(6) NOT NULL DEFAULT '0',
`question` varchar(200) NOT NULL DEFAULT '',
`display` varchar(200) NOT NULL DEFAULT '',
`answer` enum('o','x') NOT NULL,
PRIMARY KEY (`questionset`,`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wz_questdata`;
CREATE TABLE `wz_questdata` (
`questid` int(11) NOT NULL,
`name` varchar(1024) NOT NULL DEFAULT '',
`autoStart` tinyint(1) NOT NULL DEFAULT '0',
`autoPreComplete` tinyint(1) NOT NULL DEFAULT '0',
`viewMedalItem` int(11) NOT NULL DEFAULT '0',
`selectedSkillID` int(11) NOT NULL DEFAULT '0',
`blocked` tinyint(1) NOT NULL DEFAULT '0',
`autoAccept` tinyint(1) NOT NULL DEFAULT '0',
`autoComplete` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`questid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;