Crea tu Servidor WoW
"Aquí NO se hospeda ningún tipo de servidor privado. Esto es un foro para aprender a crearlos!. Asi que no pidan el realmlist!.
La pagina en si esta abandonada por todo el staff, y ahora solo cuenta con miembros activos."

Registrate para poder ver al completo el foro.

¿Quieres crearte un servidor privado de famoso juego World of Warcraft? ¡Pues este es tu sitio!


No estás conectado. Conéctate o registrate

Migración Personajes Trinity Core 3.1.3 a 3.3.2a

Ir abajo  Mensaje [Página 1 de 1.]

Buenas tardes,

Soy relativamente nuevo en esto y tengo un pequeño problema... a ver si alguien que me lea, me puede ayudar...

Tal y como he puesto en el asunto, no se como migrar los personajes de la versión 3.1.3 a 3.3.2a de Trinity Core...

Lo he intentado importando charecters y realmd con SQLyog de la version 3.1.3 a .sql e importandola a la nueva db de la versión 3.3.2a... la importación se realiza con éxito... entro perfectamente con mi user y pass pero después no veo mis personajes... Os adjunto el log que me saca el server por si sabe alguien que puede estar pasando... o si hay otro sistema... porque hay poca información sobre el tema googleando... y llevo así ya 1 mes para hacerlo...

Muchas gracias de antemano amigos

Mario

____________________________________________________________

2010-03-09 14:37:01 query ERROR: Unknown column 'instance_reset.difficulty' in 'on clause'
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('249','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('309','0','1268366400')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('409','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('469','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('509','0','1268366400')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('531','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('532','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('533','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('534','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('544','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('548','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('550','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('564','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('565','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('568','0','1268366400')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('580','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('603','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('615','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('616','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('624','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('249','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('269','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('533','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('540','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('542','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('543','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('545','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('546','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('547','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('552','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('553','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('554','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('555','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('556','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('557','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('558','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('560','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('574','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('575','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('576','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('578','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('585','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('595','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('598','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('599','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('600','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('601','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('602','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('603','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('604','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('608','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('615','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('616','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('619','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('624','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('632','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('650','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('658','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('668','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','2','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','2','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','3','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','3','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:53 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, raiddifficulty, leaderGuid FROM groups
2010-03-09 14:37:53 query ERROR: Unknown column 'raiddifficulty' in 'field list'
2010-03-09 14:38:33 SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.data FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '7' ORDER BY characters.guid
2010-03-09 14:38:33 query ERROR: Unknown column 'characters.gender' in 'field list'
2010-03-09 14:38:36 SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.data FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '7' ORDER BY characters.guid
2010-03-09 14:38:36 query ERROR: Unknown column 'characters.gender' in 'field list'
2010-03-09 14:43:22 SQL: UPDATE realmlist SET color = 2 WHERE id = '1'
2010-03-09 14:43:22 SQL ERROR: Can't connect to MySQL server on '127.0.0.1' (10061)
2010-03-09 14:52:28 SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.data FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '7' ORDER BY characters.guid
2010-03-09 14:52:28 query ERROR: Unknown column 'characters.gender' in 'field list'
2010-03-09 15:07:28 SQL: UPDATE account SET online = 0 WHERE id = 7;
2010-03-09 15:07:28 SQL: UPDATE characters SET online = 0 WHERE account = 7;
2010-03-09 15:07:28 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:28 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 SQL: UPDATE uptime SET uptime = 1200, maxplayers = 1 WHERE realmid = 1 AND starttime = 1268142452
2010-03-09 15:07:32 SQL: SELECT guid,position_x,position_y,map,player FROM corpse WHERE UNIX_TIMESTAMP()-time > '1200' AND corpse_type = '0'
2010-03-09 15:07:32 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 query ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 SQL: DELETE FROM logs WHERE (time + 1209600) < 1268143652;
2010-03-09 15:07:32 SQL: SELECT guid,position_x,position_y,map,player FROM corpse WHERE UNIX_TIMESTAMP()-time > '259200' AND corpse_type <> '0'
2010-03-09 15:07:32 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 query ERROR: Access denied for user 'root'@'localhost' (using password: YES)

Ver perfil de usuario

fran

avatar
Administrador
Administrador
Pff esk nos e como esk necesitas migrar yo nunca lo necesito cuando actualizo un server nunca vamos
En todo caso lo podrias hacer por un sistema nuevo que se ha puesto en marcha en arcemu y mangos pero yo aun estoy viendolo


_________________


Ver perfil de usuario
Actualizando... tengo algunas lagunas mentales sobre las actualizaciones... no se muy bien como hacerlas... ¿hay algún manual que me explique paso a paso la mecánica a seguir...? Porque actualizar ya lo intenté pero tuve problemas también con las importaciones de los archivos que me bajaba con Tortoise... las actualizaciones que me bajaba al importarlas con SQLyog me daban error... Sad

Me podrías decir como actualizo desde 0 mi querido Trinity Core 3.1.3 please!??

Ver perfil de usuario

fran

avatar
Administrador
Administrador
pfff la cosa seria sustituir archivos hay un post que pusieron


_________________


Ver perfil de usuario
Ansss... no lo encuentro... y no es por se vago ni mucho menos... me he estoy mirando por todas las entradas de los Foros y no encuentro nada que solucione mi duda existencial que me esta quitando horas de sueño... ya no se ni que poner en google... he buscado hasta en francés...

Echame una manita please Fran...

De todas formas te agradezco las contestaciones tan rápidas de antes... muchas veces las preguntas se quedan en el aire en los foros como me ha pasado en casi todos...

Ver perfil de usuario

fran

avatar
Administrador
Administrador
Umm mira te explico yo mismo lo que tienes que hacer es sustituir archivos que esten pasados de versiones como el arcemu o mangos s egun utilizes la base de datos y los maps y vmaps si tienes claro ya cone sto haces todo lo demas que es ponero on , extraer cosas etc...y listo


_________________


Ver perfil de usuario
Gracias... pero me he quedado igual... Sad se que tengo que hacer todo eso pero no se como...

Ver perfil de usuario

fran

avatar
Administrador
Administrador
xDD pues que yo sepa se hace asi not e puedo ayudar mas , la cosa es facil soloe s sustituir archivos es lo mas facil que existe


_________________


Ver perfil de usuario
Buenas,

Pues lo que he hecho ha sido sustituir los archivos realmd y characters que había en la carpeta mysql data... pero... lamentablemente sigo entrando en la cuenta pero no puedo ver los personajes creados... tengo que hacer algo más?? Algún tipo de compilación con la bd??? Razz

Ver perfil de usuario

fran

avatar
Administrador
Administrador
peor los sustiuistes de otras versiones ?


_________________


Ver perfil de usuario

Contenido patrocinado


Volver arriba  Mensaje [Página 1 de 1.]

Permisos de este foro:
No puedes responder a temas en este foro.