После Рестарта Сервера Перестали Работать Кланы

[77888768 2]

Было куча кланов, сделал рестар кланы остались в бд, ошибок не было при запуске, но в игре почему-то кланов нет, кто знает что делать?

[77888768 2]

Стукните плиз в скайп MrCTAJIuH или в асю 564-892-891

[Freeman 0]

Перезалей таблицу в БД forums

[77888768 2]

Вот такая вот ошибка: Could not restore clan sub-units: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'leader_name' in 'field list'

Помогите, как создать 'leader_name' в бд

[iceman 42]

ALTER TABLE `название таблици` ADD `leader_name` TINYINT(1) NOT NULL DEFAULT '0' AFTER `тут имя столбика после которого будет идти 'leader_name`;

[77888768 2]

Вроде с кланами разобрался, но вот проблема опять меня не пускает в игру, т.к. я вхожу в логин сервер, выбираю серв, выбираю чара и нажимаю "играть" и меня не пускает в игру и ничего не пишет, пытаюсь создать чара, но пишет "Невозможно создать чара" По моему чего-то в бд не хватает, подскажите как исправить.

Вот лог запуска сервера:

===================================================================-[ Configs ]
Loading Game Server config
Loading: ./Config/hexid.txt.
Loading: ./Config/Network/GameServer.ini.
Loading: ./Config/Server/Protected/MMO-Core.ini.
Loading: ./Config/idfactory.ini.
Loading: ./Config/Server/Options.ini.
Loading: ./Config/Server/Other.ini.
Loading: ./Config/Server/Rates.ini.
Loading: ./Config/Server/AltSettings.ini.
Loading: ./Config/Server/ClanHall.ini.
Loading: ./Config/Server/Olympiad.ini.
Loading: ./Config/Server/Enchant.ini.
Loading: ./Config/Server/Boss.ini.
Loading: ./Config/Bonus/L2jFulLTeaM.ini.
Loading: ./Config/Bonus/Physics.ini.
Loading: ./Config/Bonus/Admin.ini.
Loading: ./Config/Bonus/PvP.ini.
Loading: ./Config/Bonus/Crafting.ini.
Loading: ./Config/Bonus/Developer.ini.
Loading: ./Config/Bonus/ElitClanHall.ini.
Loading: ./Config/Server/SevenSigns.ini.
Loading: ./Config/Bonus/AwaySystem.ini.
Loading: ./Config/Bonus/BankSystem.ini.
Loading: ./Config/Bonus/Offline.ini.
Loading: ./Config/Bonus/Voiced.ini.
Loading: ./Config/Bonus/Clan.ini.
Loading: ./Config/Bonus/Characters.ini.
Loading: ./Config/Bonus/Announce.ini.
Loading: ./Config/Bonus/Donator.ini.
Loading: ./Config/Bonus/ClassMaster.ini.
Loading: ./Config/Bonus/Skills.ini.
Loading: ./Config/Bonus/PremiumAccount.ini.
Loading: ./Config/Bonus/PowerPack/PowerPack.ini.
Loading: ./Config/Server/Protected/FloodProtected.ini.
Loading: ./Config/Server/Protected/Packets.ini.
Loading: ./Config/Server/Protected/Other.ini.
Loading: ./Config/Server/GeoData.ini.
Loading: ./Config/Event/RaidEvent.ini.
Loading: ./Config/Event/Champion.ini.
Loading: ./Config/Event/Wedding.ini.
Loading: ./Config/Event/Rebirth.ini.
Loading: ./Config/Event/DM.ini.
Loading: ./Config/Event/TownWar.ini.
Loading: ./Config/Event/PcBang.ini.
Loading: ./Config/Event/TvT.ini.
Loading: ./Config/extender.ini.
Loading: ./Config/chatfilter.txt.
Loaded 228 Filter Words.
==================================================================-[ Database ]
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnClose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kfsx8k1johtycy1dxfv|30d082, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx8k1johtycy1dxfv|30d082, idleConnectionTestPeriod -> 3600, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost/la2?useUnicode=true&characterEncoding=UTF-8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 2000, maxStatements -> 0, maxStatementsPerConnection -> 150, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
==========================================================-[ L2jFulLTeaM Info ]
===================================================================-[ Threads ]
Cache[HTML]: Running lazy cache
Cache[Crest]: 0.006MB on 26 files loaded. (Forget Time: 300s , Capacity: 50)
Initializing Script Engine Manager
Script Engine: java 1.6 - Language: java - Language Version: 1.6
Script Engine: jython 2.2.1 - Language: python - Language Version: 2.2.1
Script Engine: BeanShell Engine 1.1 - Language: BeanShell - Language Version: 2.0b5
Script Engine: Mozilla Rhino 1.6 release 2 - Language: ECMAScript - Language Version: 1.6
==============================================================-[ Guard System ]
Guard System: Disabled
=====================================================================-[ World ]
L2World: Setting up World Regions
L2World: (87 by 128) World Region Grid set up.
Announcements: Loaded 3 Announcements.
GameServer: Loaded 0 Auto Announcements.
Updated characters online status.
IDFactory: 102912 id's available.
StaticObject: Loaded 30 StaticObject Templates.
TeleportLocationTable: Loaded 840 Teleport Location Templates.
TeleportLocationTable: Loaded 174 Custom Teleport Location Templates.
====================================================================-[ Skills ]
SkillTreeTable: Loaded 0 skills.
FishingSkillTreeTable: Loaded 109 general skills.
FishingSkillTreeTable: Loaded 8 dwarven skills.
EnchantSkillTreeTable: Loaded 14310 enchant skills.
PledgeSkillTreeTable: Loaded 64 pledge skills
SkillsEngine: Loaded 30385 Skill templates from XML files.
SkillSpellbookTable: Loaded 334 Spellbooks.
=====================================================================-[ Items ]
ItemTable: Loaded 1014 Armors.
ItemTable: Loaded 6887 Items.
ItemTable: Loaded 1313 Weapons.
ArmorSetsTable: Loaded 51 armor sets.
ArmorSetsTable: Loaded custom armor sets.
Extractable items data: Loaded 333 extractable items!
Summon items data: Loaded 12 summon items.
=======================================================================-[ Npc ]
Initializing Walkers Routes Table.
WalkerRoutesTable: Loaded 167 Npc Walker Routes.
NpcTable: Loaded 7099 Npc Templates.
NpcTable: Loaded 7106 Npc Templates.
CustomDropList : Added 0 custom droplist
NPCTable: No npc correlating with id : 20688
NpcTable: Loaded 439 Minions.
================================================================-[ Characters ]
Restored 1 clans from the database.
CharTemplateTable: Loaded 0 Character Templates.
LevelUpData: Loaded 89 Character Level Up Templates.
HennaTable: Loaded 180 Templates.
HennaTreeTable: Loaded 0 Henna Tree Templates.
Helper Buff Table: Loaded 14 Templates.
===================================================================-[ Geodata ]
Geo Engine: - Loading Geodata...
Geo Engine: - Loading: 22_24.l2j -> region offset: 728X: 22 Y: 24
Geo Engine: - Max Layers: 4 Size: 3962974 Loaded: 3962974
Geo Engine: - Loading: 20_13.l2j -> region offset: 653X: 20 Y: 13
Geo Engine: - Max Layers: 6 Size: 4267314 Loaded: 4267314
Geo Engine: - Loading: 25_16.l2j -> region offset: 816X: 25 Y: 16
Geo Engine: - Max Layers: 6 Size: 6498272 Loaded: 6498272
Geo Engine: - Loading: 26_14.l2j -> region offset: 846X: 26 Y: 14
Geo Engine: - Max Layers: 5 Size: 2747550 Loaded: 2747550
Geo Engine: - Loading: 22_15.l2j -> region offset: 719X: 22 Y: 15
Geo Engine: - Max Layers: 5 Size: 7774266 Loaded: 7774266
Geo Engine: - Loading: 20_17.l2j -> region offset: 657X: 20 Y: 17
Geo Engine: - Max Layers: 6 Size: 5709916 Loaded: 5709916
Geo Engine: - Loading: 24_14.l2j -> region offset: 782X: 24 Y: 14
Geo Engine: - Max Layers: 4 Size: 6156546 Loaded: 6156546
Geo Engine: - Loading: 24_15.l2j -> region offset: 783X: 24 Y: 15
Geo Engine: - Max Layers: 5 Size: 5781964 Loaded: 5781964
Geo Engine: - Loading: 23_21.l2j -> region offset: 757X: 23 Y: 21
Geo Engine: - Max Layers: 6 Size: 5915114 Loaded: 5915114
Geo Engine: - Loading: 23_15.l2j -> region offset: 751X: 23 Y: 15
Geo Engine: - Max Layers: 6 Size: 10894422 Loaded: 10894422
Geo Engine: - Loading: 23_20.l2j -> region offset: 756X: 23 Y: 20
Geo Engine: - Max Layers: 6 Size: 7313318 Loaded: 7313318
Geo Engine: - Loading: 24_17.l2j -> region offset: 785X: 24 Y: 17
Geo Engine: - Max Layers: 5 Size: 5651342 Loaded: 5651342
Geo Engine: - Loading: 25_21.l2j -> region offset: 821X: 25 Y: 21
Geo Engine: - Max Layers: 2 Size: 1351742 Loaded: 1351742
Geo Engine: - Loading: 24_18.l2j -> region offset: 786X: 24 Y: 18
Geo Engine: - Max Layers: 6 Size: 4063182 Loaded: 4063182
Geo Engine: - Loading: 21_22.l2j -> region offset: 694X: 21 Y: 22
Geo Engine: - Max Layers: 5 Size: 5973246 Loaded: 5973246
Geo Engine: - Loading: 20_22.l2j -> region offset: 662X: 20 Y: 22
Geo Engine: - Max Layers: 5 Size: 4832388 Loaded: 4832388
Geo Engine: - Loading: 21_18.l2j -> region offset: 690X: 21 Y: 18
Geo Engine: - Max Layers: 6 Size: 6043604 Loaded: 6043604
Geo Engine: - Loading: 25_17.l2j -> region offset: 817X: 25 Y: 17
Geo Engine: - Max Layers: 5 Size: 8580214 Loaded: 8580214
Geo Engine: - Loading: 21_16.l2j -> region offset: 688X: 21 Y: 16
Geo Engine: - Max Layers: 10 Size: 7195714 Loaded: 7195714
Geo Engine: - Loading: 21_24.l2j -> region offset: 696X: 21 Y: 24
Geo Engine: - Max Layers: 7 Size: 6416940 Loaded: 6416940
Geo Engine: - Loading: 25_15.l2j -> region offset: 815X: 25 Y: 15
Geo Engine: - Max Layers: 6 Size: 12010470 Loaded: 12010470
Geo Engine: - Loading: 20_16.l2j -> region offset: 656X: 20 Y: 16
Geo Engine: - Max Layers: 6 Size: 3553506 Loaded: 3553506
Geo Engine: - Loading: 19_23.l2j -> region offset: 631X: 19 Y: 23
Geo Engine: - Max Layers: 5 Size: 5129654 Loaded: 5129654
Geo Engine: - Loading: 22_21.l2j -> region offset: 725X: 22 Y: 21
Geo Engine: - Max Layers: 4 Size: 4599770 Loaded: 4599770
Geo Engine: - Loading: 23_16.l2j -> region offset: 752X: 23 Y: 16
Geo Engine: - Max Layers: 5 Size: 6424884 Loaded: 6424884
Geo Engine: - Loading: 20_21.l2j -> region offset: 661X: 20 Y: 21
Geo Engine: - Max Layers: 9 Size: 9887908 Loaded: 9887908
Geo Engine: - Loading: 24_19.l2j -> region offset: 787X: 24 Y: 19
Geo Engine: - Max Layers: 5 Size: 3335538 Loaded: 3335538
Geo Engine: - Loading: 19_17.l2j -> region offset: 625X: 19 Y: 17
Geo Engine: - Max Layers: 4 Size: 1269380 Loaded: 1269380
Geo Engine: - Loading: 24_21.l2j -> region offset: 789X: 24 Y: 21
Geo Engine: - Max Layers: 4 Size: 4126332 Loaded: 4126332
Geo Engine: - Loading: 23_18.l2j -> region offset: 754X: 23 Y: 18
Geo Engine: - Max Layers: 21 Size: 8017312 Loaded: 8017312
Geo Engine: - Loading: 19_18.l2j -> region offset: 626X: 19 Y: 18
Geo Engine: - Max Layers: 4 Size: 4882918 Loaded: 4882918
Geo Engine: - Loading: 22_19.l2j -> region offset: 723X: 22 Y: 19
Geo Engine: - Max Layers: 5 Size: 4035796 Loaded: 4035796
===================================================================-[ Economy ]
TradeController: Loaded 493 Buylists.
TradeController: Loaded 129 Limited Buylists.
TradeController: Loaded 0 Custom Buylists.
================================================================-[ Clan Halls ]
Initializing ClanHallManager
Loaded: 0 clan halls
Loaded: 44 free clan halls
Fortress of Resistanse: 264479 sec. to capture
Devastated Castle: 512880 sec. until siege begin
SiegeManager of Bandits Stronghold
Initializing AuctionManager
Loaded: 38 auction(s)
======================================================================-[ Zone ]
Loading zones...
Initializing ArenaManager
Initializing TownManager
Initializing OlympiadStadiaManager
Initializing CastleManager
Loaded: 9 castles
Initializing GrandBossManager
GrandBossManager: Loaded 10 Instances
Initializing FishingZoneManager
Initializing FortManager
Loaded: 21 fortress
GrandBossManager: Initialized 18 Grand Boss Zones
Done: loaded 516 zones.
=================================================================-[ Spawnlist ]
Siege of Oren: Sun Jan 15 16:00:00 EET 2012
Siege of Giran: Sun Jan 15 16:00:00 EET 2012
Siege of Gludio: Sat Jan 21 20:00:00 EET 2012
Siege of Dion: Sat Jan 21 20:00:00 EET 2012
Siege of Innadril: Sun Jan 15 16:00:00 EET 2012
Siege of Aden: Sat Jan 21 20:00:00 EET 2012
Siege of Goddard: Sun Jan 15 16:00:00 EET 2012
DayNightSpawnManager: Day/Night handler initialised
Siege of Rune: Sat Jan 21 20:00:00 EET 2012
Siege of Schuttgart: Sat Jan 21 20:00:00 EET 2012
SpawnTable: Loaded 37638 Npc Spawn Locations.
CustomSpawnTable: Loaded 0 Npc Spawn Locations.
RaidBossSpawnManager: Loaded 170 Instances
RaidBossSpawnManager: Scheduled 11 Instances
DayNightSpawnManager: Deleted 0 night creatures
DayNightSpawnManager: Spawning 232 day creatures
==========================================================-[ Dimensional Rift ]
DimensionalRiftManager: Loaded 7 room types with 56 rooms.
DimensionalRiftManager: Loaded 462 dimensional rift spawns, 0 errors.
======================================================================-[ Misc ]
RecipeController: Loaded 871 Recipes.
Initializing AugmentationData.
AugmentationData: Loaded: 52 augmentation stats.
Initializing Flood Protector
Initializing MercTicketManager
Loaded: 0 Mercenary Tickets
Initializing PetitionManager
Initializing CursedWeaponsManager
Initializing ItemsAutoDestroy.
==========================================================-[ L2jFulLTeaM Mods ]
Initializing CoupleManager
Loaded: 1 couples(s)
Error while loading buff templates Column 'char_class' not found.
=====================================================================-[ Manor ]
ManorManager: Loaded 256 seeds
Initializing CastleManorManager
===================================================================-[ Castles ]
Initializing SiegeManager
Initializing FortSiegeManager
CrownManager: initialized
======================================================================-[ Boat ]
Initializing BoatManager
=====================================================================-[ Doors ]
Searching clan halls doors:
DoorTable: Loaded 548 Door Templates.
===========================================================-[ Foure sepulches ]
GrandBossManager: Loaded 10 Instances
FourSepulchersManager: Beginning in Attack time
===============================================================-[ Seven Signs ]
SevenSigns: Currently in the Seal Validation period!
SevenSigns: The Lords of Dawn have won the Seal of Avarice.
SevenSigns: The Seal of Gnosis remains unclaimed.
SevenSigns: The Seal of Strife remains unclaimed.
SevenSigns: The Lords of Dawn were victorious last week.
SevenSigns: Next period begins in 5 days, 22 hours and 24 mins.
SevenSignsFestival: Initialization bypassed due to Seal Validation in effect.
===============================================================-[ Hero System ]
Olympiad System: Loading Olympiad System....
Olympiad System: Currently in Olympiad Period
Olympiad System: Period Ends....
Olympiad System: In 21 days, 16 hours and 24 mins.
Olympiad System: Next Weekly Change is in....
Olympiad System: 5 days, 18 hours and 52 mins.
Olympiad System: Loaded 2 Nobles
Olympiad System: Competition Period Starts in 0 days, 0 hours and 0 mins.
Olympiad System: Event starts/started : Tue Jan 10 18:00:14 EET 2012
Hero System: Loaded 0 Heroes.
Hero System: Loaded 0 all time Heroes.
=============================================================-[ Access Levels ]
AccessLevels: Loaded 6 Access Levels from database.
Admin Access Rights: Loaded 595 Access Rigths from database.
GmListTable: initalized.
==================================================================-[ Handlers ]
Olympiad System: Olympiad Game Started
ItemHandler: Loaded 2039 handlers.
SkillHandler: Loaded 76 handlers.
AdminCommandHandler: Loaded 348 handlers.
UserCommandHandler: Loaded 14 handlers.
VoicedCommandHandler: Loaded 6 handlers.
AutoChatHandler : Loaded 32 handlers in total.
AutoSpawnHandler : Loaded 129 handlers in total.
Loading custom messages...====================================================================-[ Quests ]
Initializing QuestManager
========================================================================-[ AI ]
AI load:
- Antharas
- Baium
- Core
- Queen Ant
- Van Halter
- Gordon
- Monastery
- Transform
- Fairy Trees
- Summon Minions
- Zombie Gatekeepers
- Ice Fairy Sirra
- Golkonda
- Hallate
- Kernon
- Varka/Ketra Ally
- Barakiel
===================================================================-[ Scripts ]
start loading Individual AI
Orfen: live
Valakas:  dead
Zaken: live
start loading Group template AI
Replaced: SagasSuperclass with a new version
importing custom: 912_buffer	 OK
Compiled Scripts Cache is disabled.
Loaded: 457 quests
=================================================================-[ TvT Event ]
TvT Event: disable load.
===================================================================-[ Daemons ]
PcBang point daemon: launched.
Olympiad save daemon: launched.
Raid points reset daemon: launched.
Recommendation daemon: launched.
Seven signs update daemon: launched.
=================================================================-[ PowerPack ]
Engrave system:
...spawned engraver
...Loaded 0 engraved items
...Enabled
L2TopDeamon: Initializing.					   
-------------------------------------------------------------------------------
Operating System: Linux 2.6.32-5-686 i386
-------------------------------------------------------------------------------
Available CPUs: 4
===============================================================-[ GaMe SerVeR ]
Connecting to login on 127.0.0.1:9014
Registered on login as Server 1 : L2jFT
Selector Started