[HELP]Running a server

[Toitsss]

hi, got a prob. I can connect to my server good, it shows online on the url, but my mate cant get pass the character list. gives errors after that.

 

[flaxe]

seems like the same problem I had before... try this query in your database:

UPDATE `accounts` SET `name` = `id`

credits to belthazor for that query

 

[Toitsss]

and what do i do with the line, explain please, rookie here~

 

[flaxe]

go to your database, enter: localhost/phpmyadmin in your browser, then enter your database, and press the "SQL" button at the top above the tablets, then write that query I posted before.

 

[Toitsss]

Viga (error)

SQL-päring:

UPDATE `accounts` SET `name` = `id`

MySQL said:
#1054 - Unknown column 'name' in 'field list'

that happened if i clicked the left sql in the left corner and on the middle one also.

 

[flaxe]

Hm.. If I understand that MySQL said: correct, then the 'name' column aint existing, and if it doesn't then it's wierd... sorry but I can't help you any further now probably someone else comes that knows how to fix it.

 

[Toitsss]

post the thread where u got the line from please.

 

[flaxe]

http://otland.net/f16/cant-connect-server-main-acc-38033/

there u got it

 

[Toitsss]

doenst really help me, meh anyone else willing to try?

 

[Cykotitan]

Did you portforward..?
Open ports 80, 7171 and 7172 ...

 

[Toitsss]

forwarded 80, 443, 7171, 7172, 3306

 

[Toitsss]

fixed, can close <3