CoronaCore / Issues

This repository is used as a centralized point for all issues regarding CoronaCore.
http://coronacore.org/
3 stars 4 forks source link

problem with create character #232

Closed unknownbboy closed 9 years ago

unknownbboy commented 9 years ago

One ,I share my problem in photo : http://i62.tinypic.com/2dv4k04.png Two : Please help me ,I use SQL on the corena source for database but I make character => my char is not created. Reason : DataBase error with mangosd.exe

http://i62.tinypic.com/2dv4k04.png

danielsreichenbach commented 9 years ago

Can you provide further details what kind of character you created?

unknownbboy commented 9 years ago

I need a fix data base for core! Finish! U can help me?

unknownbboy commented 9 years ago

i share photo for this Error ! i importing corenaCore Data base! but i have problem with create character ,i going to my account ,next i make a character ,but my character is not created and mangosd.exe has been crashed. http://oi62.tinypic.com/2dv4k04.jpg

2014-12-16 09:19:59 ERROR: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.equipmentCache 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 = '5' ORDER BY characters.guid
2014-12-16 09:19:59 ERROR:query ERROR: Unknown column 'characters.equipmentCache' in 'field list'
2014-12-16 09:22:40 ERROR:SQL: mysql_stmt_prepare() failed for 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, health, power1, power2, power3, power4, power5, exploredZones, equipmentCache, ammoId, knownTitles, actionBars) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '
2014-12-16 09:22:40 ERROR:SQL ERROR: Unknown column 'exploredZones' in 'field list'
danielsreichenbach commented 9 years ago

@unknownbboy it seems that in your original error report you missed posting the interesting part which is

2014-12-16 09:22:40 ERROR:SQL ERROR: Unknown column 'exploredZones' in 'field list'
Salja commented 9 years ago

looks like worng database or damage database use this character database https://github.com/CoronaCore/OneServer/tree/master/sql and try

Salja commented 9 years ago

well add me on skype salja09 and send me teamviewer datas i will look for you

Salja commented 9 years ago

Is fixed so close