latest build zone starting problems

[thorndruid]

I usually don't like asking for hepl unless i can't find it in the forums. Thisproblem i cannot find i don't know if its a bug or database issue. It seems to me like a database issue. I downloaded tcsmyworld's npcmov_alpha_3.ace database and used that. I fixed the items problem with the latest cvs build and used the latest dumpeditems. Everything works on that front. When i use minilogin i get in and make a character. Starting it says zone unavailable and gives this error in my zone executable on the server.
Error1 in PopulateZoneLists query 'SELECT x,y,z,target_x,target_y,target_z,target_zone,headi ng,target_heading,number FROM zone_points WHERE zone='freportw' orde
r by number' #1054: Unknown column 'heading' in 'field list'
ERROR: Couldn't load zone lists.

Now i know very little about sql..i am usually a hardware guy, but i haven't gotten this far to be stumped. Any help would be apreciated.

[Trumpcard]

your database table is missing something... pull the latest db.sql down off SF, look at the zone_points table in it, and compare it against the one in your databse.


mysql eq;
describe zone_points;

the table def'n should match the db.sql exactly IF you're using the latest and greatest CVS code and db.sql off SF. If not, your database and/or codeversion is outta whack..

[thorndruid]

I tried deleting my databse and using the basic db.sql and i got in no problem..no npc or spawns though, but i am sure i can figure that out. Thanks for the help trumpcard.

Thorndruid.

[krich]

Thorn,

That Tcsmyworld database you were using is somewhat old. Look in the world building forum for a newer one.

regards,

krich