Jump to content
  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
srosiskas

error v nahravaní db

Recommended Posts

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:26:03

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:26:23

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:26:29

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:28:08

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:29:00

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:31:42

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:34:10

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:35:36

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:41:24

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:43:05

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:47:20

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:52:59

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

DROP TABLE IF EXISTS `account_data`

 

Error occured at:2011-03-30 18:53:13

Line no.:42

Error Code: 6 - Error on delete of '.\characters\account_data.MYI' (Errcode: 2)

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_11217_01_mangos_creature_addon required_11234_01_mangos_command bit

 

Error occured at:2011-03-30 20:17:56

Line no.:1

Error Code: 1054 - Unknown column 'required_11217_01_mangos_creature_addon' in 'db_version'

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_11217_01_mangos_creature_addon required_11234_01_mangos_command bit

 

Error occured at:2011-03-30 20:19:05

Line no.:1

Error Code: 1054 - Unknown column 'required_11217_01_mangos_creature_addon' in 'db_version'

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_11217_01_mangos_creature_addon required_11234_01_mangos_command bit

 

Error occured at:2011-03-30 20:20:08

Line no.:1

Error Code: 1054 - Unknown column 'required_11217_01_mangos_creature_addon' in 'db_version'

 

Query:

CREATE TABLE `areatrigger_involvedrelation` (

`id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',

`quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

 

Error occured at:2011-03-30 20:25:03

Line no.:18

Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

 

Query:

CREATE TABLE `areatrigger_involvedrelation` (

`id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',

`quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

 

Error occured at:2011-03-30 20:25:06

Line no.:18

Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

 

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit

 

Error occured at:2011-03-30 20:27:56

Line no.:2

Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

 

Query:

UPDATE gossip_menu_option SET action_menu_id=-1 WHERE menu_id=576 AND id=0

 

Error occured at:2011-03-30 20:28:09

Line no.:4282

Error Code: 1264 - Out of range value adjusted for column 'action_menu_id' at row 1

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_11117_01_mangos_world_template required_11169_01_mangos_mangos_string bit

 

Error occured at:2011-03-30 20:28:35

Line no.:2

Error Code: 1054 - Unknown column 'required_11117_01_mangos_world_template' in 'db_version'

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_11117_01_mangos_world_template required_11169_01_mangos_mangos_string bit

 

Error occured at:2011-03-30 20:28:49

Line no.:2

Error Code: 1054 - Unknown column 'required_11117_01_mangos_world_template' in 'db_version'

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_11117_01_mangos_world_template required_11169_01_mangos_mangos_string bit

 

Error occured at:2011-03-30 20:28:52

Line no.:2

Error Code: 1054 - Unknown column 'required_11117_01_mangos_world_template' in 'db_version'

 

Query:

INSERT IGNORE INTO creature_template_addon VALUES (34049,0,0,1,0,0,0,NULL)

 

Error occured at:2011-03-30 20:29:17

Line no.:2075

Error Code: 1136 - Column count doesn't match value count at row 1

 

Query:

CREATE TABLE `areatrigger_involvedrelation` (

`id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',

`quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

 

Error occured at:2011-03-30 20:31:39

Line no.:18

Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

 

Query:

UPDATE quest_template SET RequiredClasses=32 WHERE RewRepFaction1=1098 AND ZoneOrSort=-241

 

Error occured at:2011-03-30 20:33:47

Line no.:19162

Error Code: 1054 - Unknown column 'RequiredClasses' in 'field list'

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_10257_01_mangos_command required_10263_01_mangos_pool_creature bit

 

Error occured at:2011-03-30 20:44:00

Line no.:2

Error Code: 1054 - Unknown column 'required_10257_01_mangos_command' in 'db_version'

 

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit

 

Error occured at:2011-03-30 20:44:05

Line no.:2

Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_10257_01_mangos_command required_10263_01_mangos_pool_creature bit

 

Error occured at:2011-03-30 20:46:03

Line no.:2

Error Code: 1054 - Unknown column 'required_10257_01_mangos_command' in 'db_version'

 

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit

 

Error occured at:2011-03-30 20:46:09

Line no.:2

Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_10427_01_mangos_spell_proc_event required_10430_01_mangos_spell_chain bit

 

Error occured at:2011-03-30 20:46:57

Line no.:1

Error Code: 1054 - Unknown column 'required_10427_01_mangos_spell_proc_event' in 'db_version'

 

Query:

ALTER TABLE db_version CHANGE COLUMN required_10457_01_mangos_spell_proc_event required_10500_01_mangos_scripts bit

 

Error occured at:2011-03-30 20:47:26

Line no.:1

Error Code: 1054 - Unknown column 'required_10457_01_mangos_spell_proc_event' in 'db_version'

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-17 10:06:49

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-17 10:07:46

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-17 10:07:51

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-17 10:10:31

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-17 10:10:34

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-17 10:10:45

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill, unk2)

VALUES (1236549, 2, 7, -1, "illidanka maind hand", "illidanka maind hand", "illidanka maind hand", "illidanka maind hand", 45479, 0, 0, 10000, 10000, 13, 9, -1, 200, 200, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 5000, 7, 2000, 38, 4000, 28, 450, 36, 450, 19, 5000, 22, 5000, 4, 2000, 3, 600, 13, 500, 32000, 64000, 0, 4000, 5000, 0, 50000, 96, 96, 87, 96, 96, 96, 1400, 0, 0, 18060, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 0, "illidanka", 0, 0, 0, 0, 0, 1, 3, 0, 0, 500, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 8, 0, 3303, 0, 0, 0)

 

Error occured at:2011-04-29 09:39:46

Line no.:2

Error Code: 1062 - Duplicate entry '1236549' for key 1

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 15:33:22

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 15:33:53

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 15:36:50

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 15:37:20

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 19:06:01

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 19:09:34

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 19:30:23

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

GRANT USAGE ON * . * TO 'oregon'@'localhost' IDENTIFIED BY 'oregon' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0

 

Error occured at:2011-04-29 19:30:32

Line no.:1

Error Code: 1146 - Table 'mysql.user' doesn't exist

 

Query:

REVOKE ALL PRIVILEGES ON * . * FROM 'oregon'@'localhost'

 

Error occured at:2011-04-29 19:30:39

Line no.:1

Error Code: 1146 - Table 'mysql.user' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 20:53:49

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 20:53:52

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 20:54:31

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

/*!40103 SET TIME_ZONE='+00:00' */

 

Error occured at:2011-04-29 20:59:20

Line no.:12

Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

 

Query:

DROP TABLE IF EXISTS `areatrigger_involvedrelation`

 

Error occured at:2011-06-17 15:09:15

Line no.:22

Error Code: 1046 - No database selected

 

Query:

DROP TABLE IF EXISTS `areatrigger_involvedrelation`

 

Error occured at:2011-06-17 15:09:17

Line no.:22

Error Code: 1046 - No database selected

 

Query:

DROP TABLE IF EXISTS `areatrigger_involvedrelation`

 

Error occured at:2011-06-17 15:09:35

Line no.:22

Error Code: 1046 - No database selected

 

Query:

DROP TABLE IF EXISTS `areatrigger_involvedrelation`

 

Error occured at:2011-06-17 15:09:46

Line no.:22

Error Code: 1046 - No database selected

 

Query:

DROP TABLE IF EXISTS `db_version`

 

Error occured at:2011-06-17 15:09:54

Line no.:22

Error Code: 1046 - No database selected

 

Query:

/*!40100 SET CHARACTER SET cp1250;*/

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "world" /*!40100 DEFAULT CHARACTER SET latin1 */

 

Error occured at:2011-06-22 11:11:00

Line no.:21

Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';*/

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/

/*!40014 SET @OLD_' at line 1

 

Query:

/*!40100 SET CHARACTER SET cp1250;*/

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "world" /*!40100 DEFAULT CHARACTER SET latin1 */

 

Error occured at:2011-06-22 11:11:48

Line no.:21

Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';*/

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/

/*!40014 SET @OLD_' at line 1

 

Query:

/*!40100 SET CHARACTER SET cp1250;*/

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "world" /*!40100 DEFAULT CHARACTER SET latin1 */

 

Error occured at:2011-06-22 11:12:53

Line no.:21

Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';*/

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/

/*!40014 SET @OLD_' at line 1

 

Edited by srosiskas
  • Downvote 7

Share this post


Link to post
Share on other sites

Spoužívej spoiler! :angry:

Další věc - koho zajímá co jsi měl za chybu 30. března 2011? Maž logy! <_<

A proč k tomu nenapíšeš například o co ses snažil? Tohle je pravá nefalšovaná plichta.

Edited by Wolf Officious

Share this post


Link to post
Share on other sites

eror mam ze dneška .. a instaloval jsem si oregon core db

pře sqlyog a revize 1408

tak a je to jasne ty zijes na jiny planete, jiny caso prostor :D

 

Error occured at:2011-03-30 18:26:03

 

eror ze dneska mas na konci logu a ty sem hodis log co mnel error jeste hitler za valky

 

 

pouzivej tag

/spoiler] jen pred lomitko zavorku

 

 

 

mas proste dojebabranou DB zmazni to a nahrej to znovu prez navicat treba :teehee:

Edited by STONERSVK

Share this post


Link to post
Share on other sites

1/2 část opravena

ale došlo k další

world nahraji ale DB nejde 0.7 ale 0.6 jde a potřebuji právě tu 0.7

 

chyba při nahrávání 0.7

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM `creature_model_info` WHERE (`modelid`=7113)' at line 32

[Err] -- ODB0.0.7 Alpha database updatepack

-- In dev., so please use at own risk (you will not get help for issues regarding this updatepack untill release day)

-- Database for Oregoncore 2.4.3 core rev 1391+

 

-- Update the version table in database

UPDATE `version` SET `db_version`='ODB 0.0.7 DEV for OregonCore rev.1391'

 

--

-- World Zones redone (Thx to Darkgroom for supplying the data, Dave for redoing the zones)

--

--

-- Sunstrider Isle

--

 

--

-- Eversong woods

--

 

--

-- Ghostlands

--

 

 

--

-- Instances

--

--

-- The deadmines

--

 

-- Set correct model for Captain Greenskin

DELETE FROM `creature_model_info` WHERE (`modelid`=7113);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

Edited by srosiskas

Share this post


Link to post
Share on other sites

+ při spouštění serveru

hesla jsem si vymyslel

 

server.log

 

2011-06-22 12:31:32 Using configuration file oregoncore.conf.

2011-06-22 12:31:32 OregonCore Rev: 1408 Hash: 95d75fb6c0c3 (Win32,little-endian) (core-daemon)

2011-06-22 12:31:32 <Ctrl-C> to stop.

 

2011-06-22 12:31:32 _____

2011-06-22 12:31:32 /\ __`\

2011-06-22 12:31:32 \ \ \/\ \ _ __ __ __ ___ ___

2011-06-22 12:31:32 \ \ \ \ \/\`'__\'__`\ /'_ `\ / __`\/' _ `\

2011-06-22 12:31:32 \ \ \_\ \ \ \/\ __//\ \L\ \/\ \L\ \\ \/\ \

2011-06-22 12:31:32 \ \_____\ \_\ \____\ \____ \ \____/ \_\ \_\

2011-06-22 12:31:32 \/_____/\/_/\/____/\/___L\ \/___/ \/_/\/_/

2011-06-22 12:31:32 /\____/

2011-06-22 12:31:32 \_/__/

2011-06-22 12:31:32 http://www.oregoncore.com

 

2011-06-22 12:31:32 MySQL client library: 5.1.50

2011-06-22 12:31:32 MySQL server ver: 5.0.45-community-nt

2011-06-22 12:31:32 MySQL client library: 5.1.50

2011-06-22 12:31:32 MySQL server ver: 5.0.45-community-nt

2011-06-22 12:31:32 MySQL client library: 5.1.50

2011-06-22 12:31:32 MySQL server ver: 5.0.45-community-nt

2011-06-22 12:31:32 Realm running as realm ID 1

2011-06-22 12:31:32 Using World DB: ODB 0.0.4 UP1 for OregonCore rev.822

2011-06-22 12:31:32 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.

2011-06-22 12:31:32 Using DataDir ./

2011-06-22 12:31:32 ERROR: VMap height checking disabled! Creatures movements and other various things WILL be broken! Expect no support.

2011-06-22 12:31:32 WORLD: VMap support included. LineOfSight:0, getHeight:0, indoorCheck:0, PetLOS:0

2011-06-22 12:31:32 WORLD: VMap data directory is: ./vmaps

2011-06-22 12:31:32

2011-06-22 12:31:32 Loading Oregon strings...

2011-06-22 12:31:32

2011-06-22 12:31:32 >> Loaded 751 Oregon strings from table oregon_string

2011-06-22 12:31:32 Initialize data stores...

2011-06-22 12:31:33

2011-06-22 12:31:33 >> Initialized 60 data stores

2011-06-22 12:31:33 Using enUS DBC Locale as default. All available DBC locales: enUS

2011-06-22 12:31:33

2011-06-22 12:31:33 Loading Script Names...

2011-06-22 12:31:37 Loading Instance Template...

2011-06-22 12:31:37 >> Loaded 58 Instance Template definitions

2011-06-22 12:31:37

2011-06-22 12:31:37 Loading SkillLineAbilityMultiMap Data...

2011-06-22 12:31:37

2011-06-22 12:31:37 >> Loaded 7025 SkillLineAbility MultiMap

2011-06-22 12:31:37 Cleaning up instances...

2011-06-22 12:31:37

2011-06-22 12:31:37 >> Initialized 0 instances

2011-06-22 12:31:37 Packing instances...

2011-06-22 12:31:37

2011-06-22 12:31:37 >> Instance numbers remapped, next instance id is 1

2011-06-22 12:31:37 Loading Localization strings...

2011-06-22 12:31:38

2011-06-22 12:31:38 >> Loaded 0 creature locale strings. DB table locales_creature is empty.

2011-06-22 12:31:38

2011-06-22 12:31:38 >> Loaded 0 gameobject locale strings. DB table locales_gameobject is empty.

2011-06-22 12:31:38

2011-06-22 12:31:38 >> Loaded 0 Item locale strings. DB table locales_item is empty.

2011-06-22 12:31:38

2011-06-22 12:31:38 >> Loaded 0 Quest locale strings. DB table locales_quest is empty.

2011-06-22 12:31:38

2011-06-22 12:31:38 >> Loaded 0 Quest locale strings. DB table locales_npc_text is empty.

2011-06-22 12:31:38

2011-06-22 12:31:38 >> Loaded 0 PageText locale strings. DB table locales_page_text is empty.

2011-06-22 12:31:38

2011-06-22 12:31:38 >> Loaded 0 gossip_menu_option locale strings. DB table `locales_gossip_menu_option` is empty.

2011-06-22 12:31:38 >>> Localization strings loaded

2011-06-22 12:31:38

2011-06-22 12:31:38 Loading Page Texts...

2011-06-22 12:31:38 >> Loaded 1431 page texts

2011-06-22 12:31:38

2011-06-22 12:31:38 Loading Game Object Templates...

2011-06-22 12:31:39 >> Loaded 13674 game object templates

2011-06-22 12:31:39

2011-06-22 12:31:39 Loading Spell Chain Data...

2011-06-22 12:31:39

2011-06-22 12:31:39 >> Loaded 867 spell chains

2011-06-22 12:31:39 Loading Spell Required Data...

2011-06-22 12:31:39

2011-06-22 12:31:39 >> Loaded 37 spell required records

2011-06-22 12:31:39 Loading Spell Elixir types...

2011-06-22 12:31:40

2011-06-22 12:31:40 >> Loaded 99 spell elixir definitions

2011-06-22 12:31:40 Loading Spell Learn Skills...

2011-06-22 12:31:40

2011-06-22 12:31:40 >> Loaded 78 Spell Learn Skills from DBC

2011-06-22 12:31:40 Loading Spell Learn Spells...

2011-06-22 12:31:40

2011-06-22 12:31:40 >> Loaded 14 spell learn spells + 500 found in DBC

2011-06-22 12:31:40 Loading Spell Proc Event conditions...

2011-06-22 12:31:41

2011-06-22 12:31:41 >> Loaded 579 custom spell proc event conditions +11 custom

2011-06-22 12:31:41 Loading Aggro Spells Definitions...

2011-06-22 12:31:41 >> Loaded 90 aggro generating spells

2011-06-22 12:31:41

2011-06-22 12:31:41 Loading NPC Texts...

2011-06-22 12:31:42

2011-06-22 12:31:42 >> Loaded 4461 npc texts

2011-06-22 12:31:42 Loading Enchant Spells Proc datas...

2011-06-22 12:31:42 >> Loaded 6 enchant proc data definitions

2011-06-22 12:31:42 Loading Item Random Enchantments Table...

2011-06-22 12:31:42

2011-06-22 12:31:42 >> Loaded 28408 Item Enchantment definitions

2011-06-22 12:31:42 Loading Items...

2011-06-22 12:31:44 >> Loaded 23880 item prototypes

2011-06-22 12:31:44

2011-06-22 12:31:44 Loading Item Texts...

2011-06-22 12:31:44

2011-06-22 12:31:44 >> Loaded 0 item pages

2011-06-22 12:31:44 Loading Creature Model Based Info Data...

2011-06-22 12:31:44 >> Loaded 17001 creature model based info

2011-06-22 12:31:44

2011-06-22 12:31:44 Loading Equipment templates...

2011-06-22 12:31:45 >> Loaded 1930 equipment template

2011-06-22 12:31:45

2011-06-22 12:31:45 Loading Creature templates...

2011-06-22 12:31:45 ERROR: Error in creature_template table, probably sql file format was updated (there should be 68 fields in sql).

 

 

 

Edited by srosiskas

Share this post


Link to post
Share on other sites

Srosiska já proti tobě nic nemám, ale překvapuje mě, jak tu píšeš do přihlášky, že umíš SQL a podobné kraviny a přitom neumíš nahrát a opravit pitomé SQLko.. Nic proti tobě nemám, ale nepiš bláboly, že něco umíš a pak se ptáš na tohle..

  • Upvote 1

Share this post


Link to post
Share on other sites

Základní věcí je rozumět chybám a znát SQL (SQL není jen INSERT, DELETE a WHERE, to je třeba si uvědomit!).

Když znáš chybu, máš v ruce SQL batch a rozumíš tomu, tak nemusíš zakládat tyhle stupidní témata.

Vylez zpět na strom a uč se.

  • Upvote 3

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×