New hive has been released

Discussion in 'Announcements' started by thevisad, Feb 9, 2013.

  1. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    A new hive has been released that will bring us closer to the official 1.7.5.1 Hive. While we maintain the original database schemas in this release, we are adding some additional columns in our tables that will allow us to damage tents and other deployables. This also assists in resolving the tents not loading properly into the game on reboot and other issues with the tents saving properly.

    You MUST upgrade your database schema for this. Your server has the potential for crashing and the data will not be written to the database unless you do.

    Grab this from the GitHub Repository.
     
  2. TheLaughingMan

    TheLaughingMan Well-Known Member

    Joined:
    Nov 8, 2012
    Messages:
    137
    Likes Received:
    13
    Is there a real reason needed for 'fuel' in deployables?
     
  3. Gunhaver

    Gunhaver Member

    Joined:
    Jan 27, 2013
    Messages:
    40
    Likes Received:
    3
    just for clarification. if updating from a previous version of reality, we replace the hive files with the new ones and run db_migrate.pl?
     
  4. wriley

    wriley Member

    Joined:
    Jan 15, 2013
    Messages:
    92
    Likes Received:
    7
    That seemed to do the trick for me, though I haven't tested everything yet.
     
  5. .=QUACK=.Major.Pain

    .=QUACK=.Major.Pain Valued Member!

    Joined:
    Oct 27, 2012
    Messages:
    542
    Likes Received:
    28
    We run all of our servers and maps through one database.
    So if I update the database, it would not work for other maps? Am I correct?

    Thinking I would have to copy the database and apply the update for Cherno only and leave other maps on the old database. Make sense?
     
  6. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    Databases should still work, it is just additional columns, no changes in the way they work.
     
  7. .=QUACK=.Major.Pain

    .=QUACK=.Major.Pain Valued Member!

    Joined:
    Oct 27, 2012
    Messages:
    542
    Likes Received:
    28
    ok - I think I am going to separate the databases into 1 db per map.
    Going to start the db over for Chernarus.
     
  8. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    Yes, in official all of the items are stored in a single database vehicles/deployables share the same db. In Reality, the items are stored in two databases based on the fact that Bliss split them off originally. In order to get them working properly, they need the same columns in both so that the query can handle the fields correctly.
     
  9. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    I have mine both ways, some servers run under a single db others run over individual.
     
  10. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    Correct, you need to be on version 0.37 in order for the hive to work properly.
     
  11. TheLaughingMan

    TheLaughingMan Well-Known Member

    Joined:
    Nov 8, 2012
    Messages:
    137
    Likes Received:
    13
    In your current DB structure they share the same db.... they have different tables....
     
  12. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    Yes, you knew what I meant :)
     
  13. Gunhaver

    Gunhaver Member

    Joined:
    Jan 27, 2013
    Messages:
    40
    Likes Received:
    3
    I have copied the new hive files over to my server and attempted to run perl db_migrate.pl and it fails attempting to migrate to 0.37. Tents aren't writing to the db. Should I just start with a clean install of the server and use my existing DB?

    This is the error that shows up in my server log
    21:49:13 HiveExt(0): [Error] Error executing |CHILD:308:1:TentStorage:0:31:[111,[6567.39,9208.56,0.0112305]]:[]:[]:0:65674920860111:|
     
  14. Gunhaver

    Gunhaver Member

    Joined:
    Jan 27, 2013
    Messages:
    40
    Likes Received:
    3
    I think i fixed it. Just went into the new schema folder > reality > 0.36-0.37 and ran the 2 included SQL queries manually. I get sleep options on tents now and they seem to be writing to the DB just fine.
     
  15. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    Ok awesome, need to figure out what the issue is with the inablity to go to a new version, I know its due to a problem with vehicles already being in the tables.
     
  16. Gunhaver

    Gunhaver Member

    Joined:
    Jan 27, 2013
    Messages:
    40
    Likes Received:
    3
    For those having the issue, running the commands manually seems to be a quick easy fix for the time being. Also, noticed something in the new restater config. It has @bliss listed in the mod parameters, and it also looks for config_deadbeef for the server cfg file. Just changed a couple names and was g2g.
     
  17. TheLaughingMan

    TheLaughingMan Well-Known Member

    Joined:
    Nov 8, 2012
    Messages:
    137
    Likes Received:
    13
    It is most likely from people adding in their own vehicles. Some updates ayan would hardcode the ids, other's he would let the db create them.
     
  18. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    I have removed all of the ID's from the newer codebase and let the mysql server handle that, I will do the same for the older files as well.
     
  19. daysgreywolf

    daysgreywolf Member

    Joined:
    Jan 30, 2013
    Messages:
    80
    Likes Received:
    1
    Are players able to spawn as females yet? Or is this still a feature only available to public hives?
     
  20. thevisad

    thevisad Moderator Staff Member

    Joined:
    Dec 18, 2012
    Messages:
    627
    Likes Received:
    160
    This will be fixed in the next update (tomorrow sometime), I just hashed out all the fixes to the tents/vehicles as well so I want to test all of this functionality properly.
     

Share This Page