i updated to the 2806 rev of mangos and i get this when running...

i just updated to 2806 of mangos and i get this when i run mangosdb.exe i instaled the changesets 15 and 16.

Quote:

---

2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 218 not have stats data, using data for 217.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 219 not have stats data, using data for 218.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 220 not have stats data, using data for 219.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 221 not have stats data, using data for 220.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 222 not have stats data, using data for 221.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 223 not have stats data, using data for 222.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 224 not have stats data, using data for 223.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 225 not have stats data, using data for 224.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 226 not have stats data, using data for 225.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 227 not have stats data, using data for 226.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 228 not have stats data, using data for 227.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 229 not have stats data, using data for 228.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 230 not have stats data, using data for 229.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 231 not have stats data, using data for 230.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 232 not have stats data, using data for 231.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 233 not have stats data, using data for 232.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 234 not have stats data, using data for 233.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 235 not have stats data, using data for 234.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 236 not have stats data, using data for 235.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 237 not have stats data, using data for 236.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 238 not have stats data, using data for 237.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 239 not have stats data, using data for 238.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 240 not have stats data, using data for 239.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 241 not have stats data, using data for 240.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 242 not have stats data, using data for 241.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 243 not have stats data, using data for 242.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 244 not have stats data, using data for 243.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 245 not have stats data, using data for 244.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 246 not have stats data, using data for 245.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 247 not have stats data, using data for 246.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 248 not have stats data, using data for 247.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 249 not have stats data, using data for 248.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 250 not have stats data, using data for 249.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 251 not have stats data, using data for 250.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 252 not have stats data, using data for 251.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 253 not have stats data, using data for 252.
2006-12-13 15:23:54 ERROR:Race 8 Class 8 Level 254 not have stats data, using data for 253.
2006-12-13 15:23:54 Loading Quests...
2006-12-13 15:23:54 ERROR:Error opening quest_template table.

---

it's a database problem. The database you have isn't compatible with the rev you're using. My advice is to either:

1)re-download the SDB and ALL of the extra little patches
2)download a compilation, someone to just dumped the sql files for realm and world database, and has their wow rev stuff with it

what SDB should i get then the one for rev 2806 and changesets 10-16?

well dude the new infocreateplayer or stats doesnt work higher then 60 because it isnt set anymore ... check sdb forum for that i know someone posted something there about this


about a good update just take rev2806 use 0.51 full then update to 0.52 and latest 0.53 changeset 19
thats all and better start with a wipe if u have characters that still bugs u :)

IF ALL GOES JUST FINE START BACKUPING FOR FUTURE CRASHES OR DB LOOSES

Delete me !

is it ok to start w/rev 2806 and SDB 5.3 changeset 15 FULL then go from there?

the full sdb is 0.51full + 0.52full + 0.53 cs19 that is out use tortoise for simplify ur work just be sure u got those
wait i will link 0.51 full ... for u just in case u can't get the right one
i think 0.52 u have it :)

EDIT:

The download link is: SendSpace | The Best Free File Sharing Service SDB 0.51
The download link is: SendSpace | The Best Free File Sharing Service SDB 0.52
The download link is: SendSpace | The Best Free File Sharing Service SDB 0.53 Changeset 20

so i get rev2806 and then import the mangos.sql file in SDB .51 into the mangos db and then import mangos.sql from the SDB .52 into the mangos db then i get .53 changeset 19 and it'll work?

btw, where can i get .53 changeset 19 at

i got changeset 20 linked up

after i update with .53 cs 20 will the database be set until the next update. and i backed up the account, realmlistcharacters, realmlist, and news table from my old db will that still work on this one?

if the table structure are the same ofc if not ... u have to figure it out

are u useing TortoiseSVN ? it let u know when a new cs is out and the latest changes

usefull links

Script Dev:
https://opensvn.csie.org/traccgi/ScriptDev/timeline

Changelog:
http://svn.sourceforge.net/viewvc/ma...runk/?view=log
SQL:

SourceForge.net Repository - [mangos] Log of /trunk/sql
SRC:
http://svn.sourceforge.net/viewvc/ma.../src/?view=log

NEW SVN REPOSITORY!
Silver DataBase Communities SVN is located here:
Revision 20: /
https://opensvn.csie.org/traccgi/S_D_B

SDB:
https://opensvn.csie.org/SDB/patch/
Log In

Mangos Compiled bins win32:
(OFFLINE) Board Offline
Mangos-Files.de
Server up and running in development mode:
- if find bugs report them to Bug Tracker :

https://svn.mangosproject.org/trac/MaNGOS/newticket

ive tried setting up tortoisesvn before could never get it working XD...if you give me a link and guide ill use it XD

about my old accounts ill just wipe them cuz i only had 10 people that i know XD...

so do i need to download anything to use tortoisesvn?

Quote:

---

Originally Posted by zetsumei

ive tried setting up tortoisesvn before could never get it working XD...if you give me a link and guide ill use it XD

about my old accounts ill just wipe them cuz i only had 10 people that i know XD...

---

install it then create a folder named 0.53 right click on it use SVN Checkout then on URL of repository use this link:

Revision 20: /patch/0.5.3
then if u want to check out just right click on the folder and SVN Update

i checked the server log and this is what errors i get

Quote:

---

2006-12-13 16:41:04 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `creature_loot_template`
2006-12-13 16:41:04 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-13 16:41:04
2006-12-13 16:41:04 ERROR:>> Loaded 0 loot definitions. DB table `creature_loot_template` is empty.
2006-12-13 16:41:04 fishing_loot_template :
2006-12-13 16:41:04 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `fishing_loot_template`
2006-12-13 16:41:04 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-13 16:41:04
2006-12-13 16:41:04 ERROR:>> Loaded 0 loot definitions. DB table `fishing_loot_template` is empty.
2006-12-13 16:41:04 gameobject_loot_template :
2006-12-13 16:41:04 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `gameobject_loot_template`
2006-12-13 16:41:04 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-13 16:41:04
2006-12-13 16:41:04 ERROR:>> Loaded 0 loot definitions. DB table `gameobject_loot_template` is empty.
2006-12-13 16:41:04 item_loot_template :
2006-12-13 16:41:04 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `item_loot_template`
2006-12-13 16:41:04 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-13 16:41:04
2006-12-13 16:41:04 ERROR:>> Loaded 0 loot definitions. DB table `item_loot_template` is empty.
2006-12-13 16:41:04 pickpocketing_loot_template :
2006-12-13 16:41:04 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `pickpocketing_loot_template`
2006-12-13 16:41:04 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-13 16:41:04
2006-12-13 16:41:04 ERROR:>> Loaded 0 loot definitions. DB table `pickpocketing_loot_template` is empty.
2006-12-13 16:41:04 skinning_loot_template :
2006-12-13 16:41:04 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `skinning_loot_template`
2006-12-13 16:41:04 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-13 16:41:04
2006-12-13 16:41:04 ERROR:>> Loaded 0 loot definitions. DB table `skinning_loot_template` is empty.
2006-12-13 16:41:04 Initializing Scripts...
2006-12-13 16:41:04 WORLD: Starting BattleGround System
2006-12-13 16:41:05 WORLD: SetInitialWorldSettings done
2006-12-13 16:41:05 Loading Transports...
2006-12-13 16:41:05 ERROR:SQL: SELECT `entry`, `name`, `period` FROM transports
2006-12-13 16:41:05 ERROR:query ERROR: Table 'mangos.transports' doesn't exist
2006-12-13 16:41:05
2006-12-13 16:41:05 >> Loaded 0 transports
2006-12-13 16:41:05 WORLD: Starting Event System
2006-12-13 16:41:05 WORLD: Starting Corpse Handler
2006-12-13 16:41:05
2006-12-13 16:41:05 mangosd process priority class set to HIGH
2006-12-13 16:41:05
2006-12-13 16:41:49 Account: 'BRYCE' Login.
2006-12-13 16:42:03 Account: 'BRYCE' Login.
2006-12-13 16:42:22 ERROR:SQL: INSERT INTO `character` (`guid`,`realm`,`account`,`name`,`race`,`class`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`data`,`taximask`,`online`,`highest_rank`,`standing`,`rating`,`cinematic`,`totaltime`,`leveltime`,`rest_bonus`,`logout_time`,`is_logout_resting`,`resettalents_cost`,`resettalents_time`,`trans_x`, `trans_y`, `trans_z`, `trans_o`, `transguid`) VALUES (2, 1, 5, 'Bryce', 1, 1, 0, -8949.95, -132.493, 83.5312, 0, '2 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 0 0 1114636288 0 1148846080 0 0 0 1 1 16777473 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1157234688 1157234688 1157234688 1053240066 1069547520 49 49 0 1082864435 1082864438 1082430026 1082430026 285273600 0 0 0 0 16 0 0 0 0 0 0 1102577664 1101004800 1102053376 1101004800 1101529088 1109393408 0 0 0 0 0 0 0 0 4008635904 29 0 0 21 0 0 1077936128 1077936128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34146562 33615363 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39 0 0 0 0 0 0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0 0 0 0 0 2362 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1073741936 0 0 0 0 3 1073741936 4 1073741936 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 1073741936 6 1073741936 0 0 0 0 0 0 0 0 0 0 0 0 7 1073741936 8 1073741936 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 98 19661100 0 162 327681 0 754 65537 0 415 65537 0 414 65537 0 413 65537 0 433 65537 0 95 327681 0 26 65537 0 256 65537 0 257 65537 0 44 327681 0 54 327681 0 43 327681 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1083892040 1065353216 1084227584 1084227584 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 0 0 0 4007657472 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', '2 0 0 0 0 0 0 0 ', 0, 0, 0, 0, 0, 0, 0, 0, 1166046142, 0, 0, 0, 0, 0, 0, 0, 0 )
2006-12-13 16:42:22 ERROR:SQL ERROR: Unknown column 'trans_x' in 'field list'
2006-12-13 16:42:22 ERROR:SQL: DELETE FROM `character_spell_cooldown` WHERE `guid` = '2'
2006-12-13 16:42:22 ERROR:SQL ERROR: Table 'mangos.character_spell_cooldown' doesn't exist

---