trying server online

[Luxorshade]

i'm trying to get the server online, but i can't change the zone settings. i am using this command
UPDATE zone_settings SET zoneip = '81 .56.56.187'
before it tells me
"Your query contains UPDATE / DELETE without a WHERE clause. Confirm?
after that nothing is changing
try this
UPDATE zone_settings SET zoneip = '81 .56.56.187 'WHERE Id =' 3 ';
but recive this
SQL Error (1054): Unknown column 'Id' in 'where clause'

Someone can help me?

[Mortalelite]

If you are making your server available for public just make sure you have DB selected and run UPDATE zone_settings SET zoneip = 'IP Address'; and replace IP Address

https://github.com/LandSandBoat/server/wiki/Post-Install-Guide#changing-the-server-ip-address

With the message where says Your query contains UPDATE / DELETE without a WHERE clause just click yes. After that you should get message at bottom saying affected rows like around 298. You can also click on zone_settings to see the new IP

Also don't need to add the "WHERE Id =' 3"; remove that part and just use what above is posted

[Luxorshade]

i try used that, but nothing. more idea? ^^

[zach2good]

https://stackoverflow.com/questions/14546820/update-query-without-where-clause-doesnt-work

Turn off safe mode

[Mortalelite]

my router does not allow me to set ports higher than 32727. how can i change the access ports to the server?

What type of router do you have? Ports needed is
54230 TCP / 54230 UDP / 54231 TCP / 54001 TCP / 54002 TCP

[Luxorshade]

i have a iliadbox

[RAIST5150]

That is pretty strange indeed. By TCP/IP standards, should have 16 bits to work with (up to 65535).

Are you sure you aren't maybe typing an extra digit, making it too high?

[Luxorshade]

look on right screen xD

(yes, on left i rewatch saint seiya xD)

[Mortalelite]

Could be possible outdated modem/router firmware. Or ISP does not allow it maybe. I know you could look into a VPN that allows port forwarding to possible get around that. But I would advise trying to get with ISP to see what issue could be.