Skip to content
La2Base
Home
DownloadsWikiForumFAQ
ruen
Sign up Login
HomeFilesWikiLogin
  • Home
  • Downloads
  • Wiki
  • FAQ
  • Contact Us
  • About
  • Rules
  • Privacy
  • Terms of Service

© 2026 la2base.com · All rights reserved

ruen
Forum/Форум для новичков[JAVA]/[help] Olympiad_data
Search

[help] Olympiad_data

2 replies64 viewsCurrently viewing: 1
V
v0vCh1k

User

Участник

Posts: 43

На форуме с: 07/29/2007

Репутация: +1

Рейтинг: 0

· 07/04/2009, 03:38 PM

Сборка: 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.

0
Александр
Александр

User

Ветеран

Posts: 1306

На форуме с: 05/25/2009

Репутация: +296

Рейтинг: 0

· 07/04/2009, 03:43 PM

Код
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`)
);

You can't feeling! No you can't feeling! And you can't feeling!

— People = Shit

0
Войдите или зарегистрируйтесь чтобы ответить