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

Results 1 to 14 of 14
  1. #1
    Infraction Banned zetsumei is offline
    Member +Rank
    Dec 2006 Join Date
    255Posts

    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.

    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.
    Last edited by zetsumei; 13-12-06 at 09:36 PM.


  2. #2
    Newbie Shozokui is offline
    MemberRank
    Oct 2006 Join Date
    18Posts
    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

  3. #3
    Infraction Banned zetsumei is offline
    Member +Rank
    Dec 2006 Join Date
    255Posts
    what SDB should i get then the one for rev 2806 and changesets 10-16?

  4. #4
    Grand Master kennythekid is offline
    Grand MasterRank
    Aug 2005 Join Date
    RomaniaLocation
    636Posts
    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
    Last edited by kennythekid; 13-12-06 at 10:10 PM.

  5. #5
    Grand Master kennythekid is offline
    Grand MasterRank
    Aug 2005 Join Date
    RomaniaLocation
    636Posts
    Delete me !
    Last edited by kennythekid; 13-12-06 at 10:09 PM.

  6. #6
    Infraction Banned zetsumei is offline
    Member +Rank
    Dec 2006 Join Date
    255Posts
    is it ok to start w/rev 2806 and SDB 5.3 changeset 15 FULL then go from there?

  7. #7
    Grand Master kennythekid is offline
    Grand MasterRank
    Aug 2005 Join Date
    RomaniaLocation
    636Posts
    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
    Last edited by kennythekid; 13-12-06 at 10:07 PM.

  8. #8
    Infraction Banned zetsumei is offline
    Member +Rank
    Dec 2006 Join Date
    255Posts
    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

  9. #9
    Grand Master kennythekid is offline
    Grand MasterRank
    Aug 2005 Join Date
    RomaniaLocation
    636Posts
    i got changeset 20 linked up

  10. #10
    Infraction Banned zetsumei is offline
    Member +Rank
    Dec 2006 Join Date
    255Posts
    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?

  11. #11
    Grand Master kennythekid is offline
    Grand MasterRank
    Aug 2005 Join Date
    RomaniaLocation
    636Posts
    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
    Last edited by kennythekid; 13-12-06 at 10:20 PM.

  12. #12
    Infraction Banned zetsumei is offline
    Member +Rank
    Dec 2006 Join Date
    255Posts
    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?
    Last edited by zetsumei; 13-12-06 at 10:22 PM.

  13. #13
    Grand Master kennythekid is offline
    Grand MasterRank
    Aug 2005 Join Date
    RomaniaLocation
    636Posts
    Quote Originally Posted by zetsumei View Post
    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

  14. #14
    Infraction Banned zetsumei is offline
    Member +Rank
    Dec 2006 Join Date
    255Posts
    i checked the server log and this is what errors i get

    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
    Last edited by zetsumei; 13-12-06 at 10:45 PM.



Advertisement