1017, I have tried everything

[Archades]

Hey, I am getting the 1017 error while trying to run a minilog server. I have searched and tried all the guides and what-not.

I am using Win. XP. I have a D-Link router. I do not have a firewall. I have followed this guide (http://www.eqemulator.net/forums/viewtopic.php?t=13403) to the very end.

I can see my server and its not locked or anything but when I go to connect I get the 1017 error.

Login Server file

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport2=5997
loginport3=5997
worldname=Vengeance X Archades
worldaddress=c-24-20-xx-xxx.client.comcast.net
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
ChatChannelServer=192.168.x.xxx

db file

# READ README.TXT!
[Database]
host=localhost
user=xxxxxxxx
password=xxxxxxx
database=eq
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

Boot5Zone.exe file

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone.exe . c-24-20-xx-xxx.client.comcast.net 7995 localhost
start zone.exe . c-24-20-xx-xxx.client.comcast.net 7996 localhost
start zone.exe . c-24-20-xx-xxx.client.comcast.net 7997 localhost
start zone.exe . c-24-20-xx-xxx.client.comcast.net 7998 localhost
start zone.exe . c-24-20-xx-xxx.client.comcast.net 7999 localhost
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

MiniLoginAccounts.ini file

localhost xxxxxxxx xxxxxxx

World.exe output

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: c-24-20-xx-xxx.client.comcast.net:9000
World server listening on: c-24-20-xx-xxx.client.comcast.net:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997
142875 New TCP connection: 127.0.0.1:4081
New zoneserver: #1 127.0.0.1:4081
Zoneserver SetConnectInfo: 127.0.0.1:4081: c-24-20-xx-xxx.client.comcast.net:799
5

Boot5Zone.exe output

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.6
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
Error in DBLoadDoors query 'SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading
,opentype,guild,lockpick,keyitem,triggerdoor,trigg ertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,liftheight,invert_state,incli ne from doors' #1054: Unknown
column 'invert_state' in 'field list'
Error: EMuShareMem: DLLLoadDoors: !cbDBLoadDoors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5061
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 160 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000

EQHost file

[Registration Servers]
{
"register.eqemulator.net:5999"
}
[Login Servers]
{
"eqlogin1.eqemulator.net:5997"
"eqlogin2.eqemulator.net:5997"
"eqlogin3.eqemulator.net:5997"
}

MiniLogin output

LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999

[Baelin]

Since your using MiniLogin you don't want to connect to the eqemu login server. If localhost doesn't work replace it with your local ip address.

eqhost.txt - You have have to fiddle with the port numbers

[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}

LoginServer.ini

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=localhost
loginport=5999
worldname=Personal Testing
worldaddress=localhost
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=


-B

[Archades]

Ok I changed my EQHost.txt and now there are no servers on the server select screen when I run EQEmu.

[NarutoLegacy]

The guide you used was not intended for mini logins. You need to follow a mini login guide, it should answer that question.

[Shawn319]

Unknown
column 'invert_state' in 'field list'


wrong db.. re-srouce DB.sql and start over.

[NarutoLegacy]

Sorry I skimmed through the first post quickly. To fix this problem there is no need to resource, just save this file to your bin folder and source this: doorupdate-03-15-04.sql (http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemu/eqemu/eqemu/EQEMu%20Release/doorupdate-03-15-04.sql?content-type=text%2Fplain&rev=1.1.1.1)

By sourceing that you are adding two newly added door columns from March 15th, 2003. The new database by TC'sMyWorld should include that when it comes out, so this wont be needed much longer. Also if you followed that guide you mentioned it does mention that file.

[Archades]

What do you mean by sourcing, I do have the doorupdate-03-15-04.sql script in my bin folder.

ALTER TABLE doors ADD COLUMN invert_state int DEFAULT 0;
ALTER TABLE doors ADD COLUMN incline int DEFAULT 0;
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='107';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='107';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='106';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='106';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='105';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='105';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='104';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='104';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='103';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='103';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='102';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='102';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='101';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='101';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='100';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='100';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='99';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='99';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='98';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='98';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='97';
UPDATE doors SET incline='127' WHERE zone='gfaydark' AND doorid='97';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='96';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='96';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='95';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='95';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='94';
UPDATE doors SET incline='5' WHERE zone='gfaydark' AND doorid='94';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='93';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='93';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='92';
UPDATE doors SET incline='139' WHERE zone='gfaydark' AND doorid='92';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='91';
UPDATE doors SET incline='147' WHERE zone='gfaydark' AND doorid='91';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='90';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='90';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='89';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='89';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='88';
UPDATE doors SET incline='131' WHERE zone='gfaydark' AND doorid='88';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='87';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='87';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='86';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='86';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='85';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='85';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='82';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='82';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='82';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='81';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='81';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='81';
UPDATE doors SET liftheight='69' WHERE zone='gfaydark' AND doorid='80';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='80';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='80';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='79';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='79';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='79';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='78';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='78';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='78';
UPDATE doors SET liftheight='98' WHERE zone='gfaydark' AND doorid='77';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='77';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='77';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='75';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='75';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='74';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='74';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='74';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='73';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='73';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='73';
UPDATE doors SET liftheight='68' WHERE zone='gfaydark' AND doorid='69';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='69';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='69';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='68';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='68';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='67';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='67';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='66';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='66';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='65';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='65';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='64';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='64';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='63';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='63';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='62';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='62';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='61';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='61';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='60';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='60';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='59';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='59';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='58';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='58';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='57';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='57';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='56';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='56';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='55';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='55';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='54';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='54';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='53';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='53';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='52';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='52';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='51';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='51';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='50';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='50';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='49';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='49';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='48';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='48';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='47';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='47';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='46';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='46';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='45';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='45';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='44';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='44';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='43';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='43';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='42';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='42';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='41';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='41';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='40';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='40';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='39';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='39';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='38';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='38';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='37';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='37';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='36';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='36';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='35';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='35';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='34';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='34';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='33';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='33';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='32';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='32';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='31';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='31';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='30';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='30';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='29';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='29';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='28';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='28';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='27';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='27';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='26';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='26';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='25';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='25';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='24';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='24';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='23';
UPDATE doors SET incline='1' WHERE zone='gfaydark' AND doorid='23';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='22';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='22';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='21';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='21';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='20';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='20';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='18';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='18';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='17';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='17';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='16';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='16';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='15';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='15';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='14';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='14';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='13';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='13';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='12';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='12';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='11';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='11';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='10';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='10';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='9';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='9';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='8';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='8';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='7';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='7';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='6';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='6';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='5';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='5';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='3';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='3';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='2';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='2';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='1';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='1';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='0';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='0';
UPDATE doors SET liftheight='177' WHERE zone='gfaydark' AND doorid='177';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='177';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='177';

When I try to run it though I can't get it to work, is it needed for the server to work?