New Server, Unable to create an account

[Viper20184]

Hello,

I just finished making a server and updating my client last night. Today I tried to log in, create an account and make sure everything is working correctly but ran into a wall.
I downloaded both Windower as well as Ashita... I set all my server info to 127.0.0.1 and pointed both of these apps to that. Both look to connect to the server and give me the option of logging in or creating a new account. When I try to create an account, it shoots back an error that the account already exists "Failed to create the new account.
Username already taken!"
Weird thing is, I have not created any usernames yet. The server window shows some weird SQL errors. I redid the issue using some random username and password so I could show here whats going on. Any advice on where I may have screwed up? If im reading the error, it seems its trying to insert the password into the wrong column but not sure why or how to fix it.

[kjLotus]

there were some very recent changes to account creation.. since it doesn't compile on linux atm, i'm looking into it anyways, so i'll be sure to make sure that it stops trying to insert the account name into a datetime column

and smack arcon for not testing, of course

[Viper20184]

Ahh.. so it wasnt something I did. Cool. Where should I look for updates for that when it does get fixed? github?

[kjLotus]

yep, if you do a git pull (plus merge depending on how you set up your local copy) it should work after you recompile (as i fixed it just now)

[Viper20184]

And yes it did. Thanks! I ran into another error but this one is covered by the FAQ so ill go on from here. Thanks again!

[Viper20184]

Hmm so I ran into a problem when I changed my server from a local one to one where I want to allow some friends online join. I made sure to do the following:

Open up ports 54230, 54231, 54001, 54002 (and UDP 54230). Now one thing is my router asks for a range and a host port... so I did the following:
TCP Range 54230 - 54230, Host Port 54230

I did the same for each of the ports... im not too familiar with port forwarding.

I also made sure to update the zoneip to my public IP address shown by whatsmyip.org.
I am using Windower4.. made sure to change the server it connects to use the public IP, also used --hairpin since I am running both the server and client on the same PC.
I put in both exceptions into the Windows Firewall and then I completely disabled it.

My friends are updating clients right now so I dont know if this is limited to just me or if other people are having the same issue yet.

So I start up the windower... it connects to the server and allows me to log in. The game starts up, lets me create (and select) a character. It goes through the normal connection stuff without issue. When it tried to load into the game, all I see is "Downloading Data".. it stays stuck there for a good 30 seconds or so then gives me a POL 3001 error.

The Connect server shows normal activity.. nothing out of the ordinary .. no errors or warning. The Game server shows no activity when it tries to pass on the info... so im thinking its something with my port forwarding. I saw a website in another post that checks your ports if they are open and all of them show to be open. Im thinking the host port may be where im running into a problem :/

[kjLotus]

if the game server shows no activity, it means your zoneip entries are wrong and the connect server sent you to the wrong place, or your ports are blocking it

[Viper20184]

So.. for the zoneip.. lets say my public IP us 74.14.74.54... thats what should be showing in there, correct or do I have to change it up somehow. I saw in an older post that it has to be calculated... like reversed then changed into something else. The post was like in 2012. Can I enter my actual IP address into the zoneip or does it have to be calculated.

If thats not the case, then I guess I have to keep messing with the port forwarding on my router because everything else looks correct to me.

[Viper20184]

Nevermind... operator error... I feel so dumb.. it was a port forwarding issue. Well I was able to connect.. now the next test is my friends. Thanks for all of you help kjLotus... hopefully my future requests are actual server things. Thanks again!!