Vehicles not spawning

Discussion in 'Support' started by AshPlatoon86, Jun 17, 2016.

Tags:
  1. AshPlatoon86

    AshPlatoon86 New Member

    Joined:
    Jun 17, 2016
    Messages:
    6
    Likes Received:
    0
    Hi Everyone,

    I am using the Pwnoz0r private hive dayz mod server files, which are excellent.
    We have been having a great time on the server and the files make most things easy to do thanks to the guide.
    However i have come across a problem and wondered whether you could help, basically the server is not spawning any vehicles at all, they appear in the phpmyadmin tables as having world locations, but they dont actually appear in game at all.

    I have googled this issue else where but cant find any solution, people talk about the vehicles script but i cant find such a script.

    Running 1.8.7 Dayz Private hive vanilla Chernarus.

    Any and all help is greatly appreciated.
     
  2. Pwnoz0r

    Pwnoz0r Administrator Staff Member

    Joined:
    Oct 18, 2012
    Messages:
    255
    Likes Received:
    110
    The SQL file was updated about 11 days ago at this point. Make sure to grab the latest version of the SQL file here.

    Commit changes
     
  3. AshPlatoon86

    AshPlatoon86 New Member

    Joined:
    Jun 17, 2016
    Messages:
    6
    Likes Received:
    0
    Ah ok thank you, do i need to go on my server and delete the previous sql and just swap out the file ? (sorry i am not very i.t literate and its my first time doing things of this nature).
     
  4. AshPlatoon86

    AshPlatoon86 New Member

    Joined:
    Jun 17, 2016
    Messages:
    6
    Likes Received:
    0
    Ok so i have removed the old database and remade it using the new sql file you kindly provided me, but the same problem still persists, also tents do not save after server restart i have just found out.

    Update : The tents and vehicles appear to be writing to the db, i.e the vehicles have world locations and the tents show as being written on the db, but the vehicles dont show at all and if you stop and start the server the tents are no longer there (even though they still show on the db) they dont appear in game after restart, so it seems to be writing the data correctly but not reading the data correctly ?
     
    Last edited: Jun 18, 2016
  5. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    Pwnozor,
    First ace job on DayZ mod dude. Still way better than SA.

    Ash and I have been getting nowhere all day with this.

    We have completely rebuilt both the DB and server a few times and followed your guide to the letter.

    We are stumped!

    Please help. We are losing all our hair!
     
  6. AshPlatoon86

    AshPlatoon86 New Member

    Joined:
    Jun 17, 2016
    Messages:
    6
    Likes Received:
    0
    So we managed to get the tents to stay after restart, i changed the instance name from 1337 to the server name (thinking it was the water mark section....yes im stupid), however the vehicles are still not spawning even after running the new sql file.
     
  7. Pwnoz0r

    Pwnoz0r Administrator Staff Member

    Joined:
    Oct 18, 2012
    Messages:
    255
    Likes Received:
    110
    Execute
    Code:
    CALL `pMain`('i');
    and
    Code:
    CALL `pSpawnVehicles`('i');
    on your MySQL database (where i = instance). This should spawn vehicles for your instance. If your server is running when this executes, a restart will be required for the changes to take place.
     
  8. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    Thanks for getting back to us dude.
    I'm afraid we are way down the level of knowledge!☹️
    Where are those to be executed and how do we execute them.

    I notice in the 187.sql that pMain has an instance of (1337) as per the allocated instance.

    Sorry for being noobz
     
  9. AshPlatoon86

    AshPlatoon86 New Member

    Joined:
    Jun 17, 2016
    Messages:
    6
    Likes Received:
    0
    Excellent thank you very much for the help, but yeah what PCSheepy said :)
     
  10. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    Ok so I think! I know what you mean! :-/

    In the init file our server instance is set as 1337.

    I can see pMain ('I') and pSpawnVehicles ('I') in the 187.sql file.

    Am I right that I need to change the ('i') in both those to ('1337') then execute the 187.sql file again.

    Sorry for being such a douche!
     
  11. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    So we tried changing the ('i') in both and then re executed the 187.sql but yet vehicles still don't seem to appear in game.

    -- Dumping structure for procedure hivemind.pMain
    DELIMITER //
    CREATE DEFINER=`dayzhivemind`@`%` PROCEDURE `pMain`(IN `1337` INT)
    MODIFIES SQL DATA
    BEGIN
    # Server instance ID.
    #-----------------------------------------------
    DECLARE sInstance VARCHAR(8) DEFAULT i;
    #-----------------------------------------------
    #Last Ran
    update event_scheduler set LastRun = NOW() where System = "pMain";
    #Starts Cleanup
    CALL pCleanupBase(); #comment out to disable base decay
    CALL pCleanup();

    CALL pSpawnVehicles(sInstance);
    END//
    DELIMITER ;

    -- Dumping structure for procedure hivemind.pSpawnVehicles
    DELIMITER //
    CREATE DEFINER=`dayzhivemind`@`%` PROCEDURE `pSpawnVehicles`(IN `1337` int)
     
  12. Pwnoz0r

    Pwnoz0r Administrator Staff Member

    Joined:
    Oct 18, 2012
    Messages:
    255
    Likes Received:
    110
    Since the default instance is 1337, execute
    Code:
    CALL `pMain`('1337');
    on to your MySQL database.
    [​IMG]
    You don't need to worry about what is in the 187.sql file as that is that does nothing after it is executed on the database.
     
  13. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    really appreciate your help dude. Will try that now
     
  14. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    when I'm running it I get error user dayzhivemind@% does not exist but it does:(
     
  15. Pwnoz0r

    Pwnoz0r Administrator Staff Member

    Joined:
    Oct 18, 2012
    Messages:
    255
    Likes Received:
    110
    What MySQL user is your server instance running off of?
     
  16. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    dayzhivemind

    I'm on TS if that's easier ts.iruclan.com
     
  17. Pwnoz0r

    Pwnoz0r Administrator Staff Member

    Joined:
    Oct 18, 2012
    Messages:
    255
    Likes Received:
    110
    Delete your database and execute the 187.sql file I just updated. Then run the following on your server:
    Code:
    CREATE USER 'dayzhivemind'@'%' IDENTIFIED BY 'password';
    GRANT ALL PRIVILEGES ON hivemind.* TO 'dayzhivemind'@'%' WITH GRANT OPTION;
    FLUSH PRIVILEGES;
    
    Make sure to change password to a strong password.

    After this you should be able to run the pMain function.
     
  18. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    woohoo! what a legend. We now have vehicles. only 50 but better than none. Thanks very much
     
  19. AshPlatoon86

    AshPlatoon86 New Member

    Joined:
    Jun 17, 2016
    Messages:
    6
    Likes Received:
    0
    My forum post was hijacked by PCSheepy but yes as he says it is working now, thanks for all the help Pwnoz0r mcuh appreciated.
     
  20. PCSheepy

    PCSheepy New Member

    Joined:
    Jun 18, 2016
    Messages:
    10
    Likes Received:
    0
    Oi wind your neck in. You neeeeed me!
     

Share This Page