I think it is getting close now. I ran the queries above and added those fields back into the character_ table.
My friend just tried to logon while I watched the logs, this is the log entries from the eqemu_debug_world.log
Code:
29921 [05.18. - 16:54:12] [WORLD__CLIENT] Connection 67.82.63.141 PASSED banned IPs check. Processing connection.
29921 [05.18. - 16:54:12] [WORLD__CLIENT] Koloth: Logged in. Mode=(CharSel)
29921 [05.18. - 16:54:12] [WORLD__CLIENT] Koloth: LS Account #132210
29921 [05.18. - 16:54:21] [WORLD__CLIENT] NOCLE: Client disconnected (not active in process)
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Name approval request. Name=Sarus, race=Human, class=Monk
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Character creation request from Koloth LS#132210 (67.82.63.141:59639) :
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Name: Sarus
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Race: 1 Class: 7 Gender: 0 Deity: 210 Start zone: 4
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: STR STA AGI DEX WIS INT CHA Total
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: 85 85 90 90 75 75 75 575
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Face: 7 Eye colors: 3 3
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Hairstyle: 1 Haircolor: 17
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Beard: 255 Beardcolor: 255
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Validating char creation info...
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Found 0 errors in character creation request
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Current location: (null) -807.00, -239.00, -10.25
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Bind location: (null) -807.00, -239.00, -10.25
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Character creation successful: Sarus
29921 [05.18. - 16:55:25] [WORLD__CLIENT_ERR] Koloth: Zone not found in database zone_id=189, moveing char to arena character:Sarus
29921 [05.18. - 16:55:25] [WORLD__CLIENT] Koloth: Entering zone (null) (189)
It seems to be having trouble finding the zone still. At least it no longer had the 1054 error. But still cannot logon.