Database wieredness when adding grid waypoints
 

I have attempted to create a grid to move some npcs.
Afterwards I checked the database to see what the table now looked like and found a patten of 2 waypoints there then a 3rd blank which repeats leaving every 3rd waypoint set to 0.

I dont know if this is a known problem or not,

Grid Table sample below
http://www.tpcnet.co.uk/logs/gridtable.htm

I know theres loads of errors there already but hopefully its of some use :roll:
Zone Server Log below

-----------
Zone server 'gfaydark' listening on port:7996
-----------
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [12:51 pm]
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [12:51 pm]
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [12:52 pm]
7448377 New client from ip: 192.168.0.26 port: 1742
Login packet 1 (OP_SetDataRate = 5)
Unexpected packet during CLIENT_CONNECTING2: OpCode: 0xe841, size: 4
0: 00 00 A0 40 | ...@
Login packet 2
Loaded playerprofile for Moonphoenix - size: 8460/8460
Loaded alt_adv_table for Moonphoenix - size: 258/258
Login packet 3
Unexpected packet during CLIENT_CONNECTING4: OpCode: 0xf540, size: 8
0: 00 00 05 00 0C 00 00 00 | ........
Unexpected packet during CLIENT_CONNECTING4: OpCode: 0xf540, size: 8
0: 00 00 05 00 0C 00 00 00 | ........
Login Packet 4
Sending doorspawns...MakeDoorSpawnPacket Error: door_id is too high!
MakeDoorSpawnPacket Error: door_id is too high!
done
Sending objects...done
Sending zonepoints...done
Enterzone complete (Login 5)
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Unknown opcode: 0x2880 size:0
Unknown opcode: 0xfffc size:0
Unknown opcode: 0xffc0 size:0
Unknown opcode: 0xffc0 size:0
Message:<SYSTEM_MSG>:Zone REPOP IMMINENT
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Unknown opcode: 0x0008 size:0
Unknown opcode: 0xfffc size:0
Unknown opcode: 0xffff size:0
Unknown opcode: 0xfffc size:0
Message:<SYSTEM_MSG>:Zone REPOP IMMINENT
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Unknown opcode: 0xfe41 size:2
Message:<SYSTEM_MSG>:Zone REPOP IMMINENT
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Unknown opcode: 0x6040 size:0
Unknown opcode: 0xffc0 size:0
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Message:wp add 1001 30 6
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Message:<SYSTEM_MSG>:Zone REPOP IMMINENT
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

Client disconnected: Moonphoenix
Dropping client: Process=false, ip=192.168.0.26, port=1742
Automatic shutdown
Message:----SERVER SHUTDOWN----

Of course I could b a total idiot and it could be entirely my fault, but you never know :confused:

Hmm.. For one, you downloaded from CVS obviously, but didnt update your databsae to include the new column in variables (ts)

Dont know about the gridpoints issue.

I know about the ts column, Im not worried about that. And have sorted it anyway

Some of the unexpected packet errors are also identical to the ones i got before i used the handy new patcher.