Error after creating character

[Tauben]

Hi, after i create my character and it accepts his name (i am in minilogin) My comp makes 5 beepin noises and the game freezes. help!

[Shawn319]

Does the world.exe or zone.exe windows have any errors in them?

[Tauben]

No. Do I have to update the db.sql at all? I havent messed with it. should it be working?

[Tauben]

Please help, it's still doing it. I downloaded Ariak's DB, and it still happens.

[Shawn319]

Well if theres no errors in world or zone window theres not much i can do to find ou what the prob is.. paste your loginserver.ini and boot5zones.bat file here.

[Tauben]

boot5zones.bat:

@echo off
start zone9x . xx.xxx.xxx.x 7995 xx.xxx.xxx.x
start zone9x . xx.xxx.xxx.x 7996 xx.xxx.xxx.x
start zone9x . xx.xxx.xxx.x 7997 xx.xxx.xxx.x
start zone9x . xx.xxx.xxx.x 7998 xx.xxx.xxx.x
start zone9x . xx.xxx.xxx.x 7999 xx.xxx.xxx.x
exit
cls
--------
loginserver.ini:
[LoginServer]
loginserver=eqlogin.eqemu.net
worldname=taubenserver
locked=false
account=
password=
worldaddress=xx.xxx.xxx.x
loginport=5999
------
All the xx.xxx.xxx.x's are my IP.
Note: I login and everything perfectly, its just when im done creating my character (after you put in his name and the server accepts it) My computer makes beeping noises, and the character's name never shows up on the character select screen, BUT they DO show up in FQadmin when i edit my DB.

[Shawn319]

Try dropping the DB, re-sourcing it and not using FQadmin to do anything. I think theres something wrong with fqadmin not updating the DB correctly. i know the Player Profile part is missing about HALF the data it should (4000 something of 8108).

What OS are you on?

[Tauben]

I am on XP.
AHHAH! Upon further inspection of World.exe upon loading onto my server, there was a failure in loading the Createcharacter data. Here is the (lengthy) World.exe data.
--------

LoginServer.ini read.
Using database 'eq' at localhost
Loading items...done.
Loading guild ranks...done.
World server listening on: port 9000
Connected to LoginServer: eqlogin.eqemu.net:5999
New TCP connection: 24.129.101.2:3456
New zoneserver: #1 24.129.101.2:3456
Zoneserver SetConnectInfo: 24.129.101.2:3456: 24.129.101.2:7999
New TCP connection: 24.129.101.2:3457
New zoneserver: #2 24.129.101.2:3457
Zoneserver SetConnectInfo: 24.129.101.2:3457: 24.129.101.2:7995
New TCP connection: 24.129.101.2:3458
New zoneserver: #3 24.129.101.2:3458
Zoneserver SetConnectInfo: 24.129.101.2:3458: 24.129.101.2:7998
New TCP connection: 24.129.101.2:3459
New zoneserver: #4 24.129.101.2:3459
Zoneserver SetConnectInfo: 24.129.101.2:3459: 24.129.101.2:7997
New TCP connection: 24.129.101.2:3460
New zoneserver: #5 24.129.101.2:3460
Zoneserver SetConnectInfo: 24.129.101.2:3460: 24.129.101.2:7996
8757005 New client from ip: 24.129.101.2 port:3820
Logged in: LS#67: Tauben
Sending list of guilds
DB Query Error
Error #1054: Unknown column 'zonename' in 'field list'
Error in GetCharSelectInfo query 'SELECT name,profile,zonename FROM character_ W
HERE account_id=2 order by name' #1054: Unknown column 'zonename' in 'field list
'
Unknown opcode: 0x3521 size:2056
Unknown opcode: 0x3921 size:2056
Unknown opcode: 0x9221 size:4
0000: 09 E8 B5 0D | ....
Name approval request for:Zurumtik race:12 class:14
Loading starting items for: Race: 12 Class: 14 onto Zurumtik
9991999099979987998618700DB Query Error
Error #1054: Unknown column 'zonename' in 'field list'
Error in CreateCharacter query 'UPDATE character_ SET zonename='akanon', x = -10
08.000000, y = 1124.000000, z = 32.000000, profile='

[Shawn319]

Error #1054: Unknown column 'zonename' in 'field list'
Error in GetCharSelectInfo query 'SELECT name,profile,zonename FROM character_ W
HERE account_id=2 order by name' #1054: Unknown column 'zonename' in 'field list
'


theres your problem. must have a bad DB.

Open up mysql.exe and type "drop database eq;" without the quotes and hit enter.

then type "create database eq;" and hit enter

then type "source db.sql" and hit enter (with the db.sql file from 0.3.0 zip in the mysql/bin folder)

[Tauben]

Wahoo it works =)
Thanks a ton!!!

[Shawn319]

np

[Ach]

I got this same error when i tried using that Ariak database. Beeps after creation and all that error text.

Worked fine when I used the db that came with the emu, any way to fix it where the Ariak db will work?

[Hardarac]

Shawn

This sounds like people are using the old Ariak made DB ....

As I understand it there a few table changes to the new server ....

My guess is that when people upload the old DB ... it is getting its knickers in a twist.

Can we get Ariak to remove his old version that he made for 2.6 ?



Marv.