X-Forums

Computer, Games, and Technology

Character Creation Error

15 posts

  1. kromar

    Member
    Joined: Sep '08
    Posts: 8

    Whenever I create a character, nothing shows up. It creates them but they aren't there... My server log gives me this, can someone help me figure out what the problem is? I tried a fresh install, update, and oatmans fix but nothing works...

    2008-09-06 17:45:54 WORLD: World initialized
    2008-09-06 17:45:54 mangosd process priority class set to HIGH
    2008-09-06 17:45:54
    2008-09-06 17:45:54
    2008-09-06 17:46:19 ERROR:SQL: INSERT INTO characters (guid,account,name,race,class,map, dungeon_difficulty, position_x, position_y, position_z, orientation, data, 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, gmstate, stable_slots, at_login, zone, death_expire_time, taxi_path) VALUES (2, 5, 'Aina', 3, 1, 0, 0, -6240.32, 331.033, 382.758, 0, '2 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90 0 0 0 100 0 90 0 1000 0 100 0 1 3 16843011 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1161117696 1157234688 1157234688 1053240066 1069547520 54 54 0 1085725550 1087822702 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 0 25 16 25 19 19 0 0 0 0 0 0 0 0 0 0 32 0 0 0 0 0 0 0 0 0 0 1092616192 0 0 0 0 0 0 0 0 0 0 20 10240 33 0 0 7 0 0 1073741824 1077936128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33883399 33554437 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12282 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1073741824 0 0 0 0 5 1073741824 7 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 1073741824 13 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 26 65537 0 95 327681 0 44 327681 0 172 327681 0 54 327681 0 162 327681 0 98 19661100 0 111 19661100 0 413 65537 0 414 65537 0 415 65537 0 433 65537 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1083892040 0 1084227584 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', '32 0 0 8 0 0 0 0 ', 0, 0, 0, 0, 0, 1220748379, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '' )
    2008-09-06 17:46:19 ERROR:SQL ERROR: Unknown column 'dungeon_difficulty' in 'field list'
    2008-09-06 17:46:28 Halting process...

    Posted 1 year ago » Permalink

  2. Grim

    Member
    Joined: May '08
    Posts: 7

    Have you started Realmd.exe?

    Modified mangosd.conf and realmd.conf?

    Posted 1 year ago » Permalink

  3. Grim

    Member
    Joined: May '08
    Posts: 7

    Have you started Realmd.exe?

    Modified mangosd.conf and realmd.conf?

    Posted 1 year ago » Permalink

  4. kromar

    Member
    Joined: Sep '08
    Posts: 8

    I did that

    Posted 1 year ago » Permalink

  5. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    1. open notepad
    2. type:
    ALTER TABLE characters DELETE COLUMN dungeon_difficulty;
    3. safe as fix.sql
    4. open commandprompt (start -> run -> cmd)
    5. type in cmd:
    mysql -uroot -p%your_mysql_password% -D Characters < "C:\foldersX\fix.sql"

    replace %your_mysql_password% with you mysql password; replace FolderX with whereever you saved your fix.sql

    Posted 1 year ago » Permalink

  6. kromar

    Member
    Joined: Sep '08
    Posts: 8

    Works, thanks :]

    Posted 1 year ago » Permalink

  7. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    Your welcome. Do bear in mind this is a (very) quick and dirty fix.

    Posted 1 year ago » Permalink

  8. silentgamer89

    Member
    Joined: Sep '08
    Posts: 11

    ive been having the same problem i tried this to fix the problem and yet it says ive got a syntax error:

    ERROR 1064 (42000| at line 1: 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 'DELETE COLUMN dungeon_difficulty' at line 1

    what do i do to resolve this? please help

    ps im using MySQL Server 5.0 if this helps anyone

    Posted 1 year ago » Permalink

  9. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    I got 5.0 as well. Did you type the ; at the end of the line? + check for other typos

    Posted 1 year ago » Permalink

  10. silentgamer89

    Member
    Joined: Sep '08
    Posts: 11

    i copied it 100% from what you put up there and it just says the error when ever i try this

    Posted 1 year ago » Permalink

  11. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    Thats really odd. Could you post the line in your fix.sql file?

    Posted 1 year ago » Permalink

  12. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    Wrong thread, please delete

    Posted 1 year ago » Permalink

  13. silentgamer89

    Member
    Joined: Sep '08
    Posts: 11

    all fixed any way, i changed it to add in a line or two and it worked

    Posted 1 year ago » Permalink

  14. Remar

    Veteran
    Joined: Feb '08
    Posts: 347

    off topic @ Pitje, way cool help there. You know your way around SQL pretty well :-)

    Posted 1 year ago » Permalink

  15. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    heh, no i dont. Trial and Error. If something causes a bug, delete it. (A)

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.

Topic Info

General

Discuss about anything else

1,256 Topics – 6,633 Posts