Rough Start. Every time.

[inu]

So, I can't be sure if I did something wrong, or this is actually supposed to happen.
I'm running a fully updated FFXI, launched by the latest version of Ashita using the --harpin moded POL.exe.
How to easily spot the problem:

- Create Character
- Chose Town to start (any)
- Get stuck at "Acquiring PlayOnline character list." (bar stuck at around 85%), until finally after around a minute it times out with an "Error Code: POL-0260".

- Join the server again
- Select the character already created previously and Log in with it
- But then it gets stuck on "Downloading data..."

DSGame seems to be having a lot of fun when this part happens:

Code: Select all

(...)
[20:46:12][Info] mapsession:192.168.1.100:54090 is coming to world...
[20:46:12][Info] parse: 00A | 0001 0000 2E from user: Character
[20:46:12][Debug] CZone:: Bastok_Mines IncreaseZoneCounter <1> Character
[20:46:14][Info] parse: 00A | 0002 0000 2E from user: Character
[20:46:14][Warning] Client cannot receive packet or key is invalid: Character
[20:46:16][Info] parse: 00A | 0003 0000 2E from user: Character
[20:46:16][Warning] Client cannot receive packet or key is invalid: Character
[20:46:18][Info] parse: 00A | 0004 0000 2E from user: Character
[20:46:18][Warning] Client cannot receive packet or key is invalid: Character
[20:46:20][Info] parse: 00A | 0005 0000 2E from user: Character
[20:46:20][Warning] Client cannot receive packet or key is invalid: Character
[20:46:22][Info] parse: 00A | 0006 0000 2E from user: Character
[20:46:22][Warning] Client cannot receive packet or key is invalid: Character
[20:46:24][Info] parse: 00A | 0007 0000 2E from user: Character
[20:46:24][Warning] Client cannot receive packet or key is invalid: Character
[20:46:26][Info] parse: 00A | 0008 0000 2E from user: Character
[20:46:26][Warning] Client cannot receive packet or key is invalid: Character
[20:46:28][Info] parse: 00A | 0009 0000 2E from user: Character
[20:46:28][Warning] Client cannot receive packet or key is invalid: Character
[20:46:30][Info] parse: 00A | 000A 0000 2E from user: Character
[20:46:30][Warning] Client cannot receive packet or key is invalid: Character
[20:46:32][Info] parse: 00A | 000B 0000 2E from user: Character
[20:46:32][Warning] Client cannot receive packet or key is invalid: Character
[20:46:34][Info] parse: 00A | 000C 0000 2E from user: Character
[20:46:34][Warning] Client cannot receive packet or key is invalid: Character
[20:46:36][Info] parse: 00A | 000D 0000 2E from user: Character
[20:46:36][Warning] Client cannot receive packet or key is invalid: Character
[20:46:38][Info] parse: 00A | 000E 0000 2E from user: Character
[20:46:38][Warning] Client cannot receive packet or key is invalid: Character
[20:46:40][Info] parse: 00A | 000F 0000 2E from user: Character
[20:46:40][Warning] Client cannot receive packet or key is invalid: Character
[20:46:42][Info] parse: 00A | 0010 0000 2E from user: Character
[20:46:42][Warning] Client cannot receive packet or key is invalid: Character
[20:46:44][Info] parse: 00A | 0011 0000 2E from user: Character
[20:46:44][Warning] Client cannot receive packet or key is invalid: Character
[20:46:46][Info] parse: 00A | 0012 0000 2E from user: Character
[20:46:48][Warning] Client cannot receive packet or key is invalid: Character
[20:46:48][Debug] UpdateWeather Finished
[20:46:48][Info] parse: 00A | 0013 0000 2E from user: Character
[20:46:49][Warning] Client cannot receive packet or key is invalid: Character
[20:46:50][Debug] UpdateWeather Finished
[20:46:50][Info] parse: 00A | 0014 0000 2E from user: Character
[20:46:50][Warning] Client cannot receive packet or key is invalid: Character
[20:46:52][Info] parse: 00A | 0015 0000 2E from user: Character
[20:46:52][Warning] Client cannot receive packet or key is invalid: Character
[20:46:54][Info] parse: 00A | 0016 0000 2E from user: Character
[20:46:54][Warning] Client cannot receive packet or key is invalid: Character
[20:46:56][Info] parse: 00A | 0017 0000 2E from user: Character
[20:46:56][Warning] Client cannot receive packet or key is invalid: Character
[20:46:58][Info] parse: 00A | 0018 0000 2E from user: Character
[20:46:58][Warning] Client cannot receive packet or key is invalid: Character
[20:47:00][Info] parse: 00A | 0019 0000 2E from user: Character
[20:47:00][Warning] Client cannot receive packet or key is invalid: Character
[20:47:02][Info] parse: 00A | 001A 0000 2E from user: Character
[20:47:02][Warning] Client cannot receive packet or key is invalid: Character
[20:47:04][Info] parse: 00A | 001B 0000 2E from user: Character
[20:47:04][Warning] Client cannot receive packet or key is invalid: Character
[20:47:06][Info] parse: 00A | 001C 0000 2E from user: Character
[20:47:06][Warning] Client cannot receive packet or key is invalid: Character
[20:47:08][Info] parse: 00A | 001D 0000 2E from user: Character
[20:47:08][Warning] Client cannot receive packet or key is invalid: Character
[20:47:10][Info] parse: 00A | 001E 0000 2E from user: Character
[20:47:10][Warning] Client cannot receive packet or key is invalid: Character
[20:47:12][Info] parse: 00A | 001F 0000 2E from user: Character
[20:47:12][Warning] Client cannot receive packet or key is invalid: Character
[20:47:14][Info] parse: 00A | 0020 0000 2E from user: Character
[20:47:14][Warning] Client cannot receive packet or key is invalid: Character
[20:47:16][Info] parse: 00A | 0021 0000 2E from user: Character
[20:47:16][Warning] Client cannot receive packet or key is invalid: Character
[20:47:18][Info] parse: 00A | 0022 0000 2E from user: Character
[20:47:18][Warning] Client cannot receive packet or key is invalid: Character
[20:47:20][Info] parse: 00A | 0023 0000 2E from user: Character
[20:47:20][Warning] Client cannot receive packet or key is invalid: Character
[20:47:22][Info] parse: 00A | 0024 0000 2E from user: Character
[20:47:23][Warning] Client cannot receive packet or key is invalid: Character
[20:47:24][Info] parse: 00A | 0025 0000 2E from user: Character
[20:47:24][Warning] Client cannot receive packet or key is invalid: Character
[20:47:26][Info] parse: 00A | 0026 0000 2E from user: Character
[20:47:26][Warning] Client cannot receive packet or key is invalid: Character
[20:47:29][Info] parse: 00A | 0027 0000 2E from user: Character
[20:47:29][Warning] Client cannot receive packet or key is invalid: Character
[20:47:31][Info] parse: 00A | 0028 0000 2E from user: Character
[20:47:31][Warning] Client cannot receive packet or key is invalid: Character
[20:47:33][Info] parse: 00A | 0029 0000 2E from user: Character
[20:47:33][Warning] Client cannot receive packet or key is invalid: Character
[20:47:35][Info] parse: 00A | 002A 0000 2E from user: Character
[20:47:35][Warning] Client cannot receive packet or key is invalid: Character
[20:47:37][Info] parse: 00A | 002B 0000 2E from user: Character
[20:47:37][Warning] Client cannot receive packet or key is invalid: Character
[20:47:39][Info] parse: 00A | 002C 0000 2E from user: Character
[20:47:39][Warning] Client cannot receive packet or key is invalid: Character
[20:47:41][Info] parse: 00A | 002D 0000 2E from user: Character
[20:47:41][Warning] Client cannot receive packet or key is invalid: Character
[20:47:43][Info] parse: 00A | 002E 0000 2E from user: Character
[20:47:43][Warning] Client cannot receive packet or key is invalid: Character
[20:47:45][Info] parse: 00A | 002F 0000 2E from user: Character
[20:47:45][Warning] Client cannot receive packet or key is invalid: Character
[20:47:47][Info] parse: 00A | 0030 0000 2E from user: Character
[20:47:47][Warning] Client cannot receive packet or key is invalid: Character
[20:47:49][Info] parse: 00A | 0031 0000 2E from user: Character
[20:47:49][Warning] Client cannot receive packet or key is invalid: Character
[20:47:51][Info] parse: 00A | 0032 0000 2E from user: Character
[20:47:51][Warning] Client cannot receive packet or key is invalid: Character
[20:47:53][Info] parse: 00A | 0033 0000 2E from user: Character
[20:47:53][Warning] Client cannot receive packet or key is invalid: Character
[20:47:55][Info] parse: 00A | 0034 0000 2E from user: Character
[20:47:55][Warning] Client cannot receive packet or key is invalid: Character
[20:47:57][Info] parse: 00A | 0035 0000 2E from user: Character
[20:47:57][Warning] Client cannot receive packet or key is invalid: Character
[20:47:59][Info] parse: 00A | 0036 0000 2E from user: Character
[20:47:59][Warning] Client cannot receive packet or key is invalid: Character
[20:48:01][Info] parse: 00A | 0037 0000 2E from user: Character
[20:48:01][Warning] Client cannot receive packet or key is invalid: Character
[20:48:03][Info] parse: 00A | 0038 0000 2E from user: Character
[20:48:07][Warning] Client cannot receive packet or key is invalid: Character
[20:48:07][Info] parse: 00A | 0039 0000 2E from user: Character
[20:48:07][Warning] Client cannot receive packet or key is invalid: Character
[20:48:07][Info] parse: 00A | 003A 0000 2E from user: Character
[20:48:07][Warning] Client cannot receive packet or key is invalid: Character
[20:48:09][Info] parse: 00A | 003B 0000 2E from user: Character
[20:48:09][Warning] Client cannot receive packet or key is invalid: Character
[20:48:11][Info] parse: 00A | 003C 0000 2E from user: Character
[20:48:11][Warning] Client cannot receive packet or key is invalid: Character
[20:48:13][Info] parse: 00A | 003D 0000 2E from user: Character
[20:48:13][Warning] Client cannot receive packet or key is invalid: Character

- Until it finally times out with:

Error code: FFXI-3001
No response from the FINAL FANTASY XI server.
Connection timed out.
Press OK to shut down.

- Finally by the 3rd try, the game finally allows us to go into the world.
However... there is no intro cut-scene. (Ok, I'm not sure if this one was implemented yet)

It's not exactly game breaking, but it looks pretty rough from the start.
Is this supposed to be like this, or did I fail to setup something properly?

Also, it seems like it's impossible to (properly) delete characters right now.

Code: Select all

[02/Mar 21:01][Info] lobbyview_parse:attempt to delete char:<21833> from ip:<192
.168.1.100>
[02/Mar 21:01][SQL] DB error - Table 'dspdb.char_titles' doesn't exist

[PrBlahBlahtson]

http://kile.dyndns.info:8765/index.php? ... Works#Misc

Why is your database missing the char_titles table?

[inu]

http://kile.dyndns.info:8765/index.php? ... Works#Misc

Why is your database missing the char_titles table?

Oh, was unaware of the FFXI-Boot issue. Thank you for the information.

Regarding the char_titles table, was it supposed to be created by importing which file? I would assume by a "char_titles.sql" (for consistency), but that one's not in the trunk atm.
The database was setup automatically by DSPServerUpdater to save me the trouble of doing it manually.

[whasf]

I think the updater doesn't update the char_* tables since that could cause a loss of character data.

[inu]

I think the updater doesn't update the char_* tables since that could cause a loss of character data.

That makes perfect sense.
However, shouldn't it be available here? http://code.google.com/p/onetimexi/sour ... runk%2Fsql

[whasf]

What revision is your server? I think that got moved into char_stats as a column.

[inu]

It's currently on r2829, and I've got those errors on r2827.
The server was created like 2 or 3 days ago.

[whasf]

I just updated to 2829 and I'm not seeing the sql error. I think your .exe needs to be rebuilt.

[inu]

I've rebuilt the applications, however that last failure to delete screwed up my database a bit, gonna take a while to find and repair at this rate.
I'll edit the post when It's all done

EDIT1:
Funny, Navicat 8 is not able to delete the character(s) either (from the chars table), I'm starting to think it might be my MySQL (5.5.28) version maybe.

EDIT2:
Yeah, recompiling didn't really fix anything.

EDIT3:
mXI still gets stuck at the "Downloading data..." part, except it doesn't generate all those errors and times out faster.

EDIT4:
Thank you very much for your support, r2839 seems to have fixed the character deletion issues with newer MySQL versions.

EDIT5:
Even tho there were not more errors, it seems like the character wasn't really removed from all the places it should have been removed from. Will inspect this later, when I have the time. It could have been just some left overs from the previous problem.