X-Forums

Computer, Games, and Technology

I cant create char :(

14 posts

  1. oria

    New Member
    Joined: Aug '08
    Posts: 3

    Hi I finaly finish to install the mangos Repack Arcane-Fire and I used the fix.
    After that I`m loging into my user and i try to create a acount and nothing happends :| i try this few times and i cant create acount :(
    pls help me guys. thx!!

    this is the eror:

    2008-08-26 05:33:29 SQL: UPDATE characters SET online = 0
    2008-08-26 05:33:29 SQL ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:33:29 SQL: SELECT MAX(guid) FROM characters
    2008-08-26 05:33:29 query ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:33:29 SQL: SELECT MAX(id) FROM character_pet
    2008-08-26 05:33:29 query ERROR: Table 'characters.character_pet' doesn't exist
    2008-08-26 05:33:29 SQL: SELECT MAX(guid) FROM item_instance
    2008-08-26 05:33:29 query ERROR: Table 'characters.item_instance' doesn't exist
    2008-08-26 05:33:29 SQL: SELECT MAX(id) FROM auctionhouse
    2008-08-26 05:33:29 query ERROR: Table 'characters.auctionhouse' doesn't exist
    2008-08-26 05:33:29 SQL: SELECT MAX(id) FROM mail
    2008-08-26 05:33:29 query ERROR: Table 'characters.mail' doesn't exist
    2008-08-26 05:33:29 SQL: SELECT MAX(id) FROM item_text
    2008-08-26 05:33:29 query ERROR: Table 'characters.item_text' doesn't exist
    2008-08-26 05:33:29 SQL: SELECT MAX(guid) FROM corpse
    2008-08-26 05:33:29 query ERROR: Table 'characters.corpse' doesn't exist
    2008-08-26 05:33:29 SQL: DELETE FROM character_inventory WHERE item >= '1'
    2008-08-26 05:33:29 SQL ERROR: Table 'characters.character_inventory' doesn't exist
    2008-08-26 05:33:29 SQL: DELETE FROM mail_items WHERE item_guid >= '1'
    2008-08-26 05:33:29 SQL ERROR: Table 'characters.mail_items' doesn't exist
    2008-08-26 05:33:29 SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
    2008-08-26 05:33:29 SQL ERROR: Table 'characters.auctionhouse' doesn't exist
    2008-08-26 05:33:29 SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
    2008-08-26 05:33:29 SQL ERROR: Table 'characters.guild_bank_item' doesn't exist
    2008-08-26 05:33:29 SQL: DELETE FROM corpse WHERE corpse_type = '0'
    2008-08-26 05:33:29 SQL ERROR: Table 'characters.corpse' doesn't exist
    2008-08-26 05:33:30 SQL: SELECT id, map, resettime FROM instance WHERE resettime > 0
    2008-08-26 05:33:30 query ERROR: Table 'characters.instance' doesn't exist
    2008-08-26 05:33:30 SQL: SELECT mapid, resettime FROM instance_reset
    2008-08-26 05:33:30 query ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime < '1219721610' AND instance.resettime > '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1219721610')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance' doesn't exist
    2008-08-26 05:33:30 SQL: DELETE FROM character_instance USING character_instance LEFT JOIN characters ON character_instance.guid = characters.guid WHERE characters.guid IS NULL
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.character_instance' doesn't exist
    2008-08-26 05:33:30 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-08-26 05:33:30 SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance' doesn't exist
    2008-08-26 05:33:30 SQL: SELECT id FROM instance
    2008-08-26 05:33:30 query ERROR: Table 'characters.instance' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('249','1220155200')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: SELECT id FROM instance
    2008-08-26 05:33:30 query ERROR: Table 'characters.instance' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('269','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('309','1219982400')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('409','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('469','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('509','1219982400')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('531','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('532','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('533','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('534','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('540','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('542','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('543','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('544','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('545','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('546','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('547','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('548','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('550','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('552','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('553','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('554','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('555','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('556','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('557','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('558','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('560','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('564','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('565','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('568','1219982400')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('580','1220328000')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: INSERT INTO instance_reset VALUES ('585','1219809600')
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-08-26 05:33:30 SQL: DELETE FROM character_instance USING character_instance LEFT JOIN instance ON character_instance.instance = instance.id WHERE instance.id IS NULL
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.character_instance' doesn't exist
    2008-08-26 05:33:30 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
    2008-08-26 05:33:30 SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-08-26 05:33:33 Item (Entry: 849 8) not correct 20655 display id, must be 44666 (using it).
    2008-08-26 05:33:33 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
    2008-08-26 05:33:33 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
    2008-08-26 05:33:33 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
    2008-08-26 05:33:33 Item (Entry: 3380 8) not correct 47014 display id, must be 51920 (using it).
    2008-08-26 05:33:33 Item (Entry: 3386 8) not correct 47131 display id, must be 51758 (using it).
    2008-08-26 05:33:33 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
    2008-08-26 05:33:33 SQL: SELECT id, text FROM item_text
    2008-08-26 05:33:33 query ERROR: Table 'characters.item_text' doesn't exist
    2008-08-26 05:33:42 Spell (id: 5179 8) have SPELL_EFFECT_QUEST_COMPLETE for quest 11122 , but quest not have flag QUEST_MANGOS_FLAGS_EXPLORATION_OR_EVENT. Quest flags must be fixed, quest modified to enable objective.
    2008-08-26 05:33:44 SQL: SELECT MAX(id) FROM character_pet
    2008-08-26 05:33:44 query ERROR: Table 'characters.character_pet' doesn't exist
    2008-08-26 05:33:44 SQL: SELECT position_x, position_y, position_z, orientation, map, data, time, corpse_type, instance, guid FROM corpse WHERE corpse_type <> 0
    2008-08-26 05:33:44 query ERROR: Table 'characters.corpse' doesn't exist
    2008-08-26 05:33:48 SQL: SELECT itemguid,item_template FROM auctionhouse
    2008-08-26 05:33:48 query ERROR: Table 'characters.auctionhouse' doesn't exist
    2008-08-26 05:33:48 SQL: SELECT COUNT(*) FROM auctionhouse
    2008-08-26 05:33:48 query ERROR: Table 'characters.auctionhouse' doesn't exist
    2008-08-26 05:33:48 SQL: SELECT guildid FROM guild
    2008-08-26 05:33:48 query ERROR: Table 'characters.guild' doesn't exist
    2008-08-26 05:33:48 SQL: SELECT arenateamid FROM arena_team
    2008-08-26 05:33:48 query ERROR: Table 'characters.arena_team' doesn't exist
    2008-08-26 05:33:48 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, leaderGuid FROM groups
    2008-08-26 05:33:48 query ERROR: Table 'characters.groups' doesn't exist
    2008-08-26 05:33:48 SQL: SELECT id,messageType,sender,receiver,itemTextId,has_items,expire_time,cod,checked,mailTemplateId FROM mail WHERE expire_time < '1219721628'
    2008-08-26 05:33:48 query ERROR: Table 'characters.mail' doesn't exist
    2008-08-26 05:33:48 SQL: DELETE FROM mail WHERE expire_time < '1219721628' AND has_items = '0' AND itemTextId = 0
    2008-08-26 05:33:48 SQL ERROR: Table 'characters.mail' doesn't exist
    2008-08-26 05:33:48 SQL: SELECT MAX(id) FROM instance
    2008-08-26 05:33:48 query ERROR: Table 'characters.instance' doesn't exist
    2008-08-26 05:33:49 SQL: SELECT MAX(time) FROM character_queststatus_daily
    2008-08-26 05:33:49 query ERROR: Table 'characters.character_queststatus_daily' doesn't exist
    2008-08-26 05:33:52 SQL: SELECT characters.data, characters.name, characters.position_x, characters.position_y, characters.position_z, characters.map, characters.totaltime, characters.leveltime, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' WHERE characters.account = '5' ORDER BY characters.guid
    2008-08-26 05:33:52 query ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:33:55 SQL: SELECT characters.data, characters.name, characters.position_x, characters.position_y, characters.position_z, characters.map, characters.totaltime, characters.leveltime, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' WHERE characters.account = '5' ORDER BY characters.guid
    2008-08-26 05:33:55 query ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:33:55 SQL: SELECT characters.data, characters.name, characters.position_x, characters.position_y, characters.position_z, characters.map, characters.totaltime, characters.leveltime, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' WHERE characters.account = '5' ORDER BY characters.guid
    2008-08-26 05:33:55 query ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:34:02 SQL: SELECT guid FROM characters WHERE name = 'Oria'
    2008-08-26 05:34:02 query ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:34:02 SQL: SELECT COUNT(guid) FROM characters WHERE account = '5'
    2008-08-26 05:34:02 query ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:34:02 SQL: DELETE FROM characters WHERE guid = '2'
    2008-08-26 05:34:02 SQL ERROR: Table 'characters.characters' doesn't exist
    2008-08-26 05:34:02 SQL: SELECT characters.data, characters.name, characters.position_x, characters.position_y, characters.position_z, characters.map, characters.totaltime, characters.leveltime, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' WHERE characters.account = '5' ORDER BY characters.guid
    2008-08-26 05:34:02 query ERROR: Table 'characters.characters' doesn't exist

    Posted 1 year ago » Permalink

  2. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    I think something went wrong when installing. In your fresh installation folder is a file called characters.sql . First, empty the characters databse if it exists, and then fill it again with the characters.sql (using a tool like navicat makes this kind of things easy. GL

    Posted 1 year ago » Permalink

  3. oria

    New Member
    Joined: Aug '08
    Posts: 3

    "First, empty the characters databse if it exists"
    how to do that?
    I`v download nacivat mysql and I dont know what to do

    Posted 1 year ago » Permalink

  4. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    right, open navicat and set up a new connection (r-click -> new connection). give it a name your like; Hostname/IPaddress: "localhost" Port: 3306; user name: "root" password: "your mysql password". Hit ok, and open the connection.
    You should then see a bunch of databases (mangos, characters, realmd, scriptdev2, information_schema and some more). Double click characters; all tables appear on the right. Select them, hit delete and confirm. Now your characters databse is empty. Next, double click characters again, right click characters and hit execute batch file. Browse to your AF fresh install folder and select characters.sql; repeat for 358_corepatch_characters_6241_to_6346.sql and ArcaneCharactersFix.sql (which is in the AF fix)

    GL

    Posted 1 year ago » Permalink

  5. oria

    New Member
    Joined: Aug '08
    Posts: 3

    finally!
    dude thx!!
    you realy help me!! I`v allmust get crazy from this!
    realy thx man =)

    Posted 1 year ago » Permalink

  6. udja

    Member
    Joined: Aug '08
    Posts: 7

    I am having this same problem, except when I try to execute the characters batch file, or any of the .sql files, I get error messages and it will not complete the table. any suggestions?

    Posted 1 year ago » Permalink

  7. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    simply run the reaperx fresh install :p does effectively the same, but a bit less subtle.

    @oria: you're welcome :) happy to help whereever i can

    Posted 1 year ago » Permalink

  8. udja

    Member
    Joined: Aug '08
    Posts: 7

    Ran the fresh install several times; still nothing. any other solutions to not being able to see characters?

    Posted 1 year ago » Permalink

  9. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    Did you apply the AF fix?

    Posted 1 year ago » Permalink

  10. udja

    Member
    Joined: Aug '08
    Posts: 7

    yea the first patch to fix the creature database is applied.

    Posted 1 year ago » Permalink

  11. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    Alright then, what is the exact error message?

    Posted 1 year ago » Permalink

  12. Debbie

    Member
    Joined: Nov '08
    Posts: 6

    Hi, i have the same problem. When i create a char nothing apears. And i've tried to reextracte them scuessfully but without luck. How can i fix this?

    Posted 1 year ago » Permalink

  13. daggo

    Regular
    Joined: May '08
    Posts: 157

    How does your mangod.conf look concerning your 'characters' DB?
    make sure it is pointed to the correct DB, ip address, and port.

    Also, make sure you are using the newer Arcane fire repack, as the older is very buggy.

    Are you updating from an older repack? Do you have characters you need to save? A fresh install would be the best solution but if you need to save some characters, then back them up first and then run the upgrade.

    What are you using to extract your characters from the DB? I use SqlYog so I really cant help you with navigating through Navicat. Another approach to this would be to first backup your characters to an .sql file, then do a fresh install, restore your characters DB, then manually update the characters DB. Its a much more complex way of fixing things but works.

    Posted 1 year ago » Permalink

  14. Debbie

    Member
    Joined: Nov '08
    Posts: 6

    Hey Daggo! Thanks for the help. But i figured it out. I simply Started fresh by installing Mangos 6245 and then upgrading from 6245 to the Reaper-x Arcane-fire, that solved my problems and all works just fine now thanks!

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.

Topic Info

Tags

Forums

General

Discuss about anything else

1,273 Topics – 6,706 Posts

Copyright © 2008 X-Forums All Rights Reserved

Design by 1234.info | Ported by Aditya | Reaper-X Blog | Reaper-X Forums | Store | 0.042 - 9 queries