POMOC - DB

[Jiris88 1]

Dobrý den mám problém nahrál sem new DB ale ukáže to toto a spadne Mangos...

 

Výpis z logu Server:

2010-03-08 16:46:37 MaNGOS/0.16.0-DEV (* * Revision 9499 - *) for Win32 (little-endian) [world-daemon]
2010-03-08 16:46:37 <Ctrl-C> to stop.


MM   MM         MM   MM  MMMMM   MMMM   MMMMM
MM   MM         MM   MM MMM MMM MM  MM MMM MMM
MMM MMM         MMM  MM MMM MMM MM  MM MMM
MM M MM         MMMM MM MMM     MM  MM  MMM
MM M MM  MMMMM  MM MMMM MMM     MM  MM   MMM
MM M MM M   MMM MM  MMM MMMMMMM MM  MM    MMM
MM   MM     MMM MM   MM MM  MMM MM  MM     MMM
MM   MM MMMMMMM MM   MM MMM MMM MM  MM MMM MMM
MM   MM MM  MMM MM   MM  MMMMMM  MMMM   MMMMM
       MM  MMM http://getmangos.com
       MMMMMM


2010-03-08 16:46:37 Using configuration file mangosd.conf.
2010-03-08 16:46:37 World Database: 127.0.0.1;3306;root;M0i6c8k6ey0686;mangos
2010-03-08 16:46:37 MySQL client library: 5.0.56
2010-03-08 16:46:37 MySQL server ver: 5.0.82-community-nt 
2010-03-08 16:46:37 ERROR:SQL: SELECT required_9482_01_mangos_spell_proc_event FROM db_version LIMIT 1
2010-03-08 16:46:37 ERROR:query ERROR: Unknown column 'required_9482_01_mangos_spell_proc_event' in 'field list'
2010-03-08 16:46:37 ERROR:Table `db_version` have field `required_8731_01_mangos_creature_template` but expected `required_9482_01_mangos_spell_proc_event`! Not all sql updates applied?

 

 

Výpis z logu DBErrors: 2

010-03-08 16:46:37 SQL: SELECT required_9482_01_mangos_spell_proc_event FROM db_version LIMIT 1
2010-03-08 16:46:37 query ERROR: Unknown column 'required_9482_01_mangos_spell_proc_event' in 'field list'
2010-03-08 16:46:37 Table `db_version` have field `required_8731_01_mangos_creature_template` but expected `required_9482_01_mangos_spell_proc_event`! Not all sql updates applied?

 

Prosím o help co s tim je....?

 

PS.: Zkoušel sem Updatovat DB ale nějak to nepomohlo....

[STONERSVK 899]

nahraj tam updaty

[Jiris88 1]

To tam mám nahrát vše z tohoto:

Ty stovky SQL?

I ztěch složek 0.5 , 0.6 atd???

Edited March 8, 2010 by Jiris88

[zynek 8]

hele problem je v tom ze to chce aby v Columns od tabulky 'db_version' bylo misto

required_8731_01_mangos_creature_template

todle

required_9482_01_mangos_spell_proc_event

najed na tabulku 'db_version' rozklikni ji a je tam takova slozka Columns tak na ni klikni pravym, dej Manage Colunns, tam prepis z

required_8731_01_mangos_creature_template

na

required_9482_01_mangos_spell_proc_event

a dej Alter.

 

a melo by to fakcit

[lenor 4]

ale ked to takto urobis tak nebudes mat pravdebodobne NPC a take veci lebo budu chybat updaty a este ano su to hentie subory kazdy ich musel tolko updatovat

[zynek 8]

ale ked to takto urobis tak nebudes mat pravdebodobne NPC a take veci lebo budu chybat updaty a este ano su to hentie subory kazdy ich musel tolko updatovat

 

vis ono je ten problem ze u mangose to dicky i kdys nahrajes updaty musis prepsat

[lenor 4]

vis ono je ten problem ze u mangose to dicky i kdys nahrajes updaty musis prepsat

Urcite nie vzdycki ja som nic neprepisoval a funguje mi to a po druhe on pisal ze to nerobil teda nieco v tom zmisle ako napisal toto??? na tie updaty cize z toho chapem ze ich tam nepridaval....

[zynek 8]

Urcite nie vzdycki ja som nic neprepisoval a funguje mi to a po druhe on pisal ze to nerobil teda nieco v tom zmisle ako napisal toto??? na tie updaty cize z toho chapem ze ich tam nepridaval....

 

ja ti nwm ale me se to stavalo vzdycky, vzdycky sem musel prepisovat tu ******** tabulku xD

[lenor 4]

nj mne ani raz

[brseker 131]

Zkus do mangos DB aplikovat:

ALTER TABLE `db_version` CHANGE COLUMN `required_8731_01_mangos_creature_template` `required_9482_01_mangos_spell_proc_event` BIT;

Nevim jiste, ale melo by to fungovat

[Jiris88 1]

Zkus do mangos DB aplikovat:

ALTER TABLE `db_version` CHANGE COLUMN `required_8731_01_mangos_creature_template` `required_9482_01_mangos_spell_proc_event` BIT;

Nevim jiste, ale melo by to fungovat

 

Díky to funguje ale je tu nový problém...

 

Log Server:

2010-03-08 21:07:41 MaNGOS/0.16.0-DEV (* * Revision 9499 - *) for Win32 (little-endian) [world-daemon]
2010-03-08 21:07:41 <Ctrl-C> to stop.


MM   MM         MM   MM  MMMMM   MMMM   MMMMM
MM   MM         MM   MM MMM MMM MM  MM MMM MMM
MMM MMM         MMM  MM MMM MMM MM  MM MMM
MM M MM         MMMM MM MMM     MM  MM  MMM
MM M MM  MMMMM  MM MMMM MMM     MM  MM   MMM
MM M MM M   MMM MM  MMM MMMMMMM MM  MM    MMM
MM   MM     MMM MM   MM MM  MMM MM  MM     MMM
MM   MM MMMMMMM MM   MM MMM MMM MM  MM MMM MMM
MM   MM MM  MMM MM   MM  MMMMMM  MMMM   MMMMM
       MM  MMM http://getmangos.com
       MMMMMM


2010-03-08 21:07:41 Using configuration file mangosd.conf.
2010-03-08 21:07:41 World Database: 127.0.0.1;3306;root;M0i6c8k6ey0686;mangos
2010-03-08 21:07:41 MySQL client library: 5.0.56
2010-03-08 21:07:41 MySQL server ver: 5.0.82-community-nt 
2010-03-08 21:07:41 Character Database: 127.0.0.1;3306;root;M0i6c8k6ey0686;characters
2010-03-08 21:07:41 MySQL client library: 5.0.56
2010-03-08 21:07:41 MySQL server ver: 5.0.82-community-nt 
2010-03-08 21:07:41 Login Database: 127.0.0.1;3306;root;M0i6c8k6ey0686;realmd
2010-03-08 21:07:41 MySQL client library: 5.0.56
2010-03-08 21:07:41 MySQL server ver: 5.0.82-community-nt 
2010-03-08 21:07:41 Realm running as realm ID 1
2010-03-08 21:07:41 Using World DB: UDB 0.11.6 (384) for MaNGOS 8734 with SD2 SQL for rev. 1480
2010-03-08 21:07:41 Using creature EventAI: ACID 3.0.1 - Full Release for Mangos
2010-03-08 21:07:41 Using DataDir ./
2010-03-08 21:07:41 WORLD: VMap support included. LineOfSight:0, getHeight:0
2010-03-08 21:07:41 WORLD: VMap data directory is: ./vmaps
2010-03-08 21:07:41 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2010-03-08 21:07:43 
2010-03-08 21:07:43 Loading MaNGOS strings...
2010-03-08 21:07:43 
2010-03-08 21:07:43 >> Loaded 685 MaNGOS strings from table mangos_string
2010-03-08 21:07:43 Initialize data stores...
2010-03-08 21:07:47 
2010-03-08 21:07:47 >> Initialized 84 data stores
2010-03-08 21:07:47 Using enUS DBC Locale as default. All available DBC locales: enUS 
2010-03-08 21:07:47 
2010-03-08 21:07:47 Loading Script Names...
2010-03-08 21:07:52 
2010-03-08 21:07:52 >> Loaded 772 Script Names
2010-03-08 21:07:52 Loading InstanceTemplate...
2010-03-08 21:07:52 ERROR:Error in instance_template table, probably sql file format was updated (there should be 9 fields in sql).

 

Tomu už nerozumim vůbec (Myslim že tam má být jenom 9 sloupců ne)

 

/edit: tuším že to stačí updatovet ne?

/edit2: tak updatování nepomohlo

Edited March 8, 2010 by Jiris88

[zynek 8]

dam ti radu, nahraj jinou DB

[Jiris88 1]

dam ti radu, nahraj jinou DB

 

Já už sem nahrál třetí DB pls dejte sem nějakou funkční....

 

For 3.3.2

 

Nejlíp UDB

Edited March 9, 2010 by Jiris88

[Dendoo 222]

2010-03-08 21:07:52 ERROR:Error in instance_template table, probably sql file format was updated (there should be 9 fields in sql).

 

^^ nahraj updaty