Quote Originally Posted by baal1980 View Post
First of all thanks for great work - in my opinion this is one of the best repacks available at the moment.

And my question: what exactly is truncation.sql file used for? I never use it when applying updates and txt file is not very clear...

Thanks.
Look on first page:



Note: I've added a second database which has no NPC's/Enemies in it so that you may, if you're like me, explore, take screenshots, etc. In order to use the second database, simply change this line in your mangosd.conf file

Code:
WorldDatabaseInfo=127.0.0.1;3306;root;mangos;mango  s;
to
Code:
WorldDatabaseInfo=127.0.0.1;3306;root;mangos;empty  ;
The Panoramas that you see in this post (click them to enlarge) were made using my empty exploration database.
...and now my question,

CU_0050 - db: characters_0001-0049_all.sql

Code:
(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:062
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:062
Warning Code : 1266
Using storage engine MyISAM for table 'auctionhousebot'

(3 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:016
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:016

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Query : ALTER TABLE character_db_version CHANGE COLUMN required_10332_02_characters_pet_aura required_10503_01_characters_creature_respa...
Error Code : 1054
Unknown column 'required_10332_02_characters_pet_aura' in 'character_db_version'
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:047
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:047
Warning Code : 1266
Using storage engine MyISAM for table 'creature_respawn'

Query : ALTER TABLE character_db_version CHANGE COLUMN required_10503_01_characters_creature_respawn required_10503_02_characters_gameob...
Error Code : 1054
Unknown column 'required_10503_01_characters_creature_respawn' in 'character_db_version'
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:046
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:046
Warning Code : 1266
Using storage engine MyISAM for table 'gameobject_respawn'
Is good or i do something wrong? Server work normal, without any errors...