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.