Actualización Base de datos

Trinity Localized Languages
1

Muy buenas noches para todos, perdonen la molestia pero me he quedado sin ideas y necesito ayuda en la compilación de mi trinity. He logrado compilar todo sin problemas pero estoy atorado con la actualización de la bd, la versión que estaba usando es la TDB 335.11.47_2012_05_19, [SIZE=14px]ahora necesito actualizarla a la versión 335.52, pero no tengo idea como hacerlo, ya he probado de muchas maneras, pero hoy he descubierto que necesito actualizar desde 335.11, 335.12, 335.13 bueno al menos creo que eso es, si estoy equivocado, porfavor corrijanme y ayudenme a lograr mi actualización, llevo varias semanas en esto y estoy por volverme loco, ayuda porfavor[/SIZE]

[SIZE=14px]Saludos, y gracias por prestarme vuestros hombros para llorar, xd [/SIZE]

2

Buenas, yo me he iniciado hace poco en esto, una pregunta, has vuelto a compilar no? lo suyo es realizar como has descubierto o directamente metiendo la full, lo malo, mil errores probablemente.

Si no has compilado abra cosas que quizas no te funcionen o incluso que te de error el server.

Saludos,

3

Opte por la salida fácil una compilación totalmente nueva, quite el servidor anterior, a la larga creo que fue la mejor decisión.

4

Buenas noches, no logro actualizar mi BD he compilado la ultima version del core que aparece actualmente en el git, he importado la base de datos TDB_full_335.52_2013_07_17, pero cuando ejecuto el worldserver me saca el siguiente error:

Loading Item set names…

Loaded 2481 item set names in 6 ms
Loading Creature Model Based Info Data…
Loaded 24142 creature model based info in 51 ms
Loading Creature templates…
Creature (Entry: 31350) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 31350) has wrong value (0.000000) in speed_run, set to 1.14286.
Creature (Entry: 32795) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 32795) has wrong value (0.000000) in speed_run, set to 1.14286.
Creature (Entry: 2674) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 16236) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 16236) has wrong value (0.000000) in speed_run, set to 1.14286.
Creature (Entry: 20809) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 25855) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 26631) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 26631) has wrong value (0.000000) in speed_run, set to 1.14286.
Creature (Entry: 27894) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 27894) has wrong value (0.000000) in speed_run, set to 1.14286.
Creature (Entry: 28833) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 28833) has wrong value (0.000000) in speed_run, set to 1.14286.
Creature (Entry: 28887) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 29613) has wrong value (0.000000) in speed_walk, set to 1.
Creature (Entry: 29613) has wrong value (0.000000) in speed_run, set to 1.14286.
Creature (Entry: 30337) has wrong value (0.000000) in speed_walk, set to 1.
Loaded 29923 creature definitions in 760 ms
Loading Equipment templates…
[1054] Unknown column ‘id’ in ‘field list’
Your database structure is not up to date. Please make sure you’ve executed all queries in the sql/updates folders.
Aborted

Intento actualizar el sql/updates pero me genera un error al importar esta el error es el siguiente:

Query:
ALTER TABLE account ADD COLUMN token_key varchar(100) NOT NULL DEFAULT ‘’ AFTER s

Error occured at:2013-10-27 16:30:05
Line no.:1
Error Code: 1060 - Duplicate column name ‘token_key’
Query:
ALTER TABLE ‘account’ ADD COLUMN ‘token_key’ varchar(100) NOT NULL DEFAULT ‘’ AFTER ‘s’

Error occured at:2013-10-27 16:34:23
Line no.:1
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 ‘‘account’ ADD COLUMN ‘token_key’ varchar(100) NOT NULL DEFAULT ‘’ AFTER ‘s’’ at line 1
Query:
DELETE FROM ‘rbac_permissions’ WHERE ‘id’ BETWEEN 200 AND 216

Error occured at:2013-10-27 16:35:28
Line no.:2
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 ‘‘rbac_permissions’ WHERE ‘id’ BETWEEN 200 AND 216’ at line 1
Query:
ALTER TABLE account ADD COLUMN token_key varchar(100) NOT NULL DEFAULT ‘’ AFTER s

Error occured at:2013-10-27 16:36:04
Line no.:1
Error Code: 1060 - Duplicate column name ‘token_key’
Query:
ALTER TABLE ‘account’ ADD COLUMN ‘token_key’ varchar(100) NOT NULL DEFAULT ‘’ AFTER ‘s’

Error occured at:2013-10-27 16:39:25
Line no.:1
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 ‘‘account’ ADD COLUMN ‘token_key’ varchar(100) NOT NULL DEFAULT ‘’ AFTER ‘s’’ at line 1
Query:
INSERT INTO command (name, security, help) VALUES
(‘reload gameobject_questender’, 3, ‘Syntax: .reload gameobject_questendernReload gameobject_questender table.’)

Error occured at:2013-10-27 16:41:15
Line no.:2622
Error Code: 1054 - Unknown column ‘security’ in ‘field list’
Query:
ALTER TABLE logs ADD COLUMN level TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 AFTER type

Error occured at:2013-10-27 17:17:50
Line no.:2
Error Code: 1060 - Duplicate column name ‘level’
Query:
INSERT INTO creature_equip_template (entry, id, itemEntry1, itemEntry2, itemEntry3) VALUES
(31306, 1, 41371, 0, 0)

Error occured at:2013-10-27 17:45:59
Line no.:142
Error Code: 1054 - Unknown column ‘id’ in ‘field list’
Query:
INSERT INTO creature_equip_template (entry, id, itemEntry1, itemEntry2, itemEntry3) VALUES
(31306, 1, 41371, 0, 0)

Error occured at:2013-10-27 18:13:35
Line no.:142
Error Code: 1054 - Unknown column ‘id’ in ‘field list’
Query:
INSERT INTO command (name,security,help) VALUES
(‘reload creature_summon_groups’,3,‘Syntax: .reload creature_summon_groups
Reload creature_summon_groups table.’)

Error occured at:2013-10-27 18:16:44
Line no.:511
Error Code: 1054 - Unknown column ‘security’ in ‘field list’
Query:
UPDATE creature_template SET equipment_id = 0 WHERE name LIKE ‘%(1)’ OR name LIKE ‘%(2)’ OR name LIKE ‘%(3)’ OR name LIKE ‘%(4)’

Error occured at:2013-10-27 18:30:57
Line no.:102
Error Code: 1054 - Unknown column ‘equipment_id’ in ‘field list’

No logro saber a que se debe.

Muchas gracias.

Mi servidor esta montado en Ubuntu 12.04 64bits.

Saludos

5

Los nombres de las columnas han cambiando o ya no existen , vas a tener que modificar la consulta de forma manual.