Need Some help with 1017 on minilogin

[tazzz1137]

Hi I am a TRUR NEWB and have read and installed form Jezebells guide GREAT guide BTW
but when i log in server selcet get 1017
LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999
127.0.0.1:1370: TCPConnection::RecvData(): Connection timeout
is my minilogin
world
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5
[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..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Liberating a country that despises us...
TCP listening on: 66.82.916:9000
World server listening on: 66.82.916:9000
Connected to LoginServer: localhost:5999
and bat5
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[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: 5023
[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: 127.0.0.1:9000
127.0.0.1:9000: TCPConnection::RecvData(): Connection timeout
Connected to worldserver: 127.0.0.1:9000
have redone grant all commad and also have done search and done all that i found in it that could possible hel anyhel p much appreciated
Tazzz1137
PS working on minilogin on on sys not internet

[Monrezz]

You need to download and run the doors update sql file.

On a side note, this is my 666th post. Mwuhahaha! :twisted:

Don't let Jarin read this thread :?

[tazzz1137]

OK I have used link in Jazz guide went to doorupdate-03-15-04.sql
and clicked and saved fileas Doorupdate-03-05-04.sql ran mysql bat code
source doorupdate-03-15-04.sql
File unable to open
and update is in Bin?? so am i doing it wrong or what ?
Tazzzz

C:\Documents and Settings\Betty\Desktop>cd\mysql\bin

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 218 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> source doorupdate-03-15-04.sql
ERROR:
Failed to open file 'doorupdate-03-15-04.sql', error: 2
mysql>

C:\Documents and Settings\Betty\Desktop>cd\mysql\bin

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 219 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> source doorupdate-03-15-04.sql
ERROR:
Failed to open file 'doorupdate-03-15-04.sql', error: 2
mysql>
STUCK :(
Tazzz

[Monrezz]

Rename it source.sql, then you'll mke sure you didn't make any mistakes in the filename. Also, don't use mysql -u root mysql, because then you'll source the door update into your mysql database not your everquest one.

[tazzz1137]

OK gusse i am comp stupid or confused lol
Ok i rename file source.sql then what I DOnot use mysql.bat to source if not how do i source doorupdate?? and I want it in eq DB from sql or in my EQ dic?? I am sorry for all the questions just getting brain fried on this damm doorupdat :evil:
TY much for all your help :D

[bluejam]

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 219 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> source doorupdate-03-15-04.sql
ERROR:
Failed to open file 'doorupdate-03-15-04.sql', error: 2
mysql>

I believe Monrezz meant this. There's a "use eq;" command missing, but my guess is that you haven't copied the file to your mysql/bin folder?

[tazzz1137]

I have tried it both ways and Yes I ahve copied it to mysql bin folder many differnt times to make sure it is there also have renamed it doeerupdate-03-05-04.sql made sure it is a sql file also and still error and yes used use eq; also in last post listed results error 2

[Monrezz]

Open a command prompt and do a tree output of the directory, and paste it here.