Jump to content

error while importing updatepacks

Guest DARKMOON

By Guest DARKMOON
in OldGeneral discussion

 Share

Recommended Posts

DARKMOON Newbie

DARKMOON

Posted
Posted

sorry all i saw it's posted on this site it was ment for udb :) and it's solved so mods can you delete this topic

EDIT: I see that i opened the topic in the wrong section ,sorry i had more tabs open and did a mistake hope mods can move it to the right section :) and i can only import : "388_updatepack_mangos" and "389_updatepack_mangos"

hi sorry if i posted in the wrong section or it's been posted already i didn't find any topic.

now i imported the udb and the SD2 mangos_full.sql and when i try to update i get almost the same error with all the packs (i removed a part cuz otherwise he didn't accept :(:

Query:
/*  */
/* AREATRIGGER */
DELETE FROM areatrigger_scripts WHERE entry=4591

Error occured at:2010-06-04 00:52:45
Line no.:4
Error Code: 1146 - Table 'wow.areatrigger_scripts' doesn't exist

Query:
/*  */
/* AREATRIGGER */
DELETE FROM areatrigger_scripts WHERE entry=4591

Error occured at:2010-06-04 00:53:35
Line no.:4
Error Code: 1146 - Table 'wow.areatrigger_scripts' doesn't exist

Query:
UPDATE creature_template SET speed_walk=1.0 WHERE entry=121

Error occured at:2010-06-04 01:23:49
Line no.:36799
Error Code: 1054 - Unknown column 'speed_walk' in 'field list'

Query:
UPDATE creature_template SET faction_A=1733, faction_H=1733, npcflag=npcflag|1, unit_flags=768, baseattacktime=2000, rangeattacktime=0, dynamicflags=0, scale=1.000000, unit_class=1, speed_walk=1.000000, speed_run=1.428571 WHERE entry=39371

Error occured at:2010-06-04 01:29:28
Line no.:274
Error Code: 1054 - Unknown column 'speed_walk' in 'field list'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9630_01_characters_characters required_9632_01_characters_characters bit

Error occured at:2010-06-04 01:29:51
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
DELETE FROM sd2_db_version

Error occured at:2010-06-04 01:30:41
Line no.:5
Error Code: 1146 - Table 'wow.sd2_db_version' doesn't exist

Query:
UPDATE creature_template SET faction_A=1733, faction_H=1733, npcflag=npcflag|1, unit_flags=768, baseattacktime=2000, rangeattacktime=0, dynamicflags=0, scale=1.000000, unit_class=1, speed_walk=1.000000, speed_run=1.428571 WHERE entry=39371

Error occured at:2010-06-04 01:31:12
Line no.:274
Error Code: 1054 - Unknown column 'speed_walk' in 'field list'

Query:
INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
(-1000580,'Sleep now, young one ...',0,0,0,0,'Raelorasz SAY_SLEEP'),
(-1000581,'A wonderful specimen.',0,0,0,0,'Raeloarsz SAY_SPECIMEN')

Error occured at:2010-06-04 01:31:55
Line no.:4
Error Code: 1062 - Duplicate entry '-1000580' for key 'PRIMARY'

Query:
GRANT ALL PRIVILEGES ON `scriptdev2` . * TO 'mangos'@'localhost' WITH GRANT OPTION

Error occured at:2010-06-04 01:34:17
Line no.:3
Error Code: 1133 - Can't find any matching row in the user table

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2010-06-04 01:39:04
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-06-04 01:41:45
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-06-04 01:42:01
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-06-04 01:42:06
Line no.:2
Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-06-04 01:45:50
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9375_01_characters_character_glyphs required_9611_01_characters bit

Error occured at:2010-06-04 01:45:56
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9630_01_characters_characters required_9632_01_characters_characters bit

Error occured at:2010-06-04 01:49:03
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

xxxxx to much text didn't accept:(

Error occured at:2010-06-04 01:51:24
Line no.:23965
Error Code: 1054 - Unknown column 'poiId' in 'field list'

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9630_01_characters_characters required_9632_01_characters_characters bit

Error occured at:2010-06-04 01:52:08
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
ALTER TABLE realmd_db_version CHANGE COLUMN required_9010_01_realmd_realmlist required_9746_01_realmd_realmlist bit

Error occured at:2010-06-04 01:52:33
Line no.:2
Error Code: 1146 - Table 'wow.realmd_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9751_01_characters required_9767_03_characters_characters bit

Error occured at:2010-06-04 01:53:34
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9751_01_characters required_9767_03_characters_characters bit

Error occured at:2010-06-04 01:54:50
Line no.:2
Error Code: 1146 - Table 'wow.character_db_version' doesn't exist

Query:
/*  */
/* AREATRIGGER */
DELETE FROM areatrigger_scripts WHERE entry=4591

Error occured at:2010-06-04 02:02:14
Line no.:4
Error Code: 1146 - Table 'scriptdev2.areatrigger_scripts' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-06-04 02:08:11
Line no.:2
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:
ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-06-04 02:09:08
Line no.:2
Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Hope u can help :)

(there's changes alot comparing when i quited wow (own fun sdb & udb) , acid etc maybe i do something wrong )

 Share
Go to topic listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use