quest_template problem

[Madghost]

After beeing looking in search for several hours i ddint find the soluiton to this problem that is why i make this post.

I hope someone ca help solving ti.

current rev: 2636


2006-11-11 12:27:03 World Database: 127.0.0.1;3306;root;root;mangos
2006-11-11 12:27:03 Connected to MySQL database at 127.0.0.1
2006-11-11 12:27:03 Login Database: 127.0.0.1;3306;root;root;realmd
2006-11-11 12:27:03 Connected to MySQL database at 127.0.0.1
2006-11-11 12:27:03 Realm running as realm ID 1
2006-11-11 12:27:03 Using DataDir ./ ...
2006-11-11 12:27:03 Check existing of map file './maps/0004331.map': exist.
2006-11-11 12:27:03 Check existing of map file './maps/0004832.map': exist.
2006-11-11 12:27:03 Check existing of map file './maps/0004832.map': exist.
2006-11-11 12:27:03 Check existing of map file './maps/0013339.map': exist.
2006-11-11 12:27:03 Check existing of map file './maps/0002828.map': exist.
2006-11-11 12:27:03 Check existing of map file './maps/0011230.map': exist.
2006-11-11 12:27:03 Check existing of map file './maps/0013732.map': exist.
2006-11-11 12:27:03 Initialize data stores...
2006-11-11 12:27:03
2006-11-11 12:27:03 >> Loaded 22 data stores
2006-11-11 12:27:03
2006-11-11 12:27:03 Loading Game Object Templates...
2006-11-11 12:27:03 >> Loaded 4033 game object templates
2006-11-11 12:27:03 Loading levelup stat gains...
2006-11-11 12:27:03
2006-11-11 12:27:03 >> Loaded 2360 levelup definitions
2006-11-11 12:27:03 Loading Quests...
2006-11-11 12:27:03 ERROR:Error in `quest_template` table, probably sql file format was updated (there should be 92 fields in sql).

[MentaL]

[anatem]

revert your quest_template.sql to an older version or reinstall database that fixes it most times

[Madghost]

This problem is solved.

Just made the batch from updated mangos.sql file and server running ok.

Now there is another problem i have found but i have also seen unswer somewhere in this forum.

SQL: SELECT `id`,`gmlevel`,`sessionkey`,`last_ip`,`locked`, `password`, `v`, `s`
, `banned` FROM `account` WHERE `username` = 'ADMINISTRATOR'
query ERROR: Unknown column 'v' in 'field list'
SOCKET: Sent Auth Response (unknown account).

I will look better to see if i find it.

[Madghost]

Problem solved instal lates revision.

Revision 1123 and any revision after 1123, e.g. 1124 or 1137,
already includes this update in the default database
file mangos.sql.