[help] Olympiad_data
2 ответов63 просмотровСейчас просматривают: 1
· 04.07.2009, 15:38
Сборка: l2jserver last revision
Судя по проблеме у меня не хватает одной таблицы - olympiad_data, если кто-то может скиньте плиз.
Код
Olympiad System: Failed to save olympiad data to database:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'zerg.olympiad_
data' doesn't exist
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:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr
eparedStatement.java:989)
at net.sf.l2j.gameserver.model.olympiad.Olympiad.saveOlympiadStatus(Olym
piad.java:1141)
at net.sf.l2j.gameserver.taskmanager.tasks.TaskOlympiadSave.onTimeElapse
d(TaskOlympiadSave.java:54)
at net.sf.l2j.gameserver.taskmanager.TaskManager$ExecutedTask.run(TaskMa
nager.java:85)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$101(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
runPeriodic(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Olympiad System: Data updated.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'zerg.olympiad_
data' doesn't exist
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:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr
eparedStatement.java:989)
at net.sf.l2j.gameserver.model.olympiad.Olympiad.saveOlympiadStatus(Olym
piad.java:1141)
at net.sf.l2j.gameserver.taskmanager.tasks.TaskOlympiadSave.onTimeElapse
d(TaskOlympiadSave.java:54)
at net.sf.l2j.gameserver.taskmanager.TaskManager$ExecutedTask.run(TaskMa
nager.java:85)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$101(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
runPeriodic(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Olympiad System: Data updated.
0
· 04.07.2009, 15:43
Код
CREATE TABLE IF NOT EXISTS `olympiad_data` (
`id` TINYINT UNSIGNED NOT NULL default 0,
`current_cycle` MEDIUMINT UNSIGNED NOT NULL default 1,
`period` MEDIUMINT UNSIGNED NOT NULL default 0,
`olympiad_end` BIGINT UNSIGNED NOT NULL default 0,
`validation_end` BIGINT UNSIGNED NOT NULL default 0,
`next_weekly_change` BIGINT UNSIGNED NOT NULL default 0,
PRIMARY KEY (`id`)
);
`id` TINYINT UNSIGNED NOT NULL default 0,
`current_cycle` MEDIUMINT UNSIGNED NOT NULL default 1,
`period` MEDIUMINT UNSIGNED NOT NULL default 0,
`olympiad_end` BIGINT UNSIGNED NOT NULL default 0,
`validation_end` BIGINT UNSIGNED NOT NULL default 0,
`next_weekly_change` BIGINT UNSIGNED NOT NULL default 0,
PRIMARY KEY (`id`)
);
You can't feeling! No you can't feeling! And you can't feeling!
— People = Shit
0
Войдите или зарегистрируйтесь чтобы ответить

