IMPORTANT Server Installation

Discussion in 'Installation' started by BigBen, Jul 3, 2017.

  1. BigBen

    BigBen Developer Staff Member

    Joined:
    Jul 2, 2016
    Messages:
    297
    Likes Received:
    441
  2. Syn

    Syn New Member

    Joined:
    Jul 3, 2017
    Messages:
    1
    Likes Received:
    0
  3. Marius1773

    Marius1773 New Member

    Joined:
    Jan 29, 2017
    Messages:
    1
    Likes Received:
    0
    Hi, in the Wiki it says "Insert UUID into the world table in your database"
    But which world table?in Navicat Lite it says its too long
     
  4. Lawson Zeugin

    Lawson Zeugin New Member

    Joined:
    Dec 22, 2016
    Messages:
    10
    Likes Received:
    8
    You need to run this code through your database after replacing the 0s following the "0x" with your generated UUID. And go ahead and replace "My Tanoa Server" (Give it a name) & "Tanoa" (map) with the information that corresponds with your server.

    Code:
    INSERT INTO `world`(`uuid`, `name`, `map`) VALUES (CAST(0x00000000000000000000000000000000 AS BINARY),'My Tanoa Server','Tanoa')
    
    ---
    What version is your MySQL? Syntax for MySQL changes over the year and for proper installation MySQL version 5.6 or newer is required.
     
  5. BetterDeadThanZed

    BetterDeadThanZed Member

    Joined:
    Apr 13, 2017
    Messages:
    44
    Likes Received:
    11
    I have the error as shown in the attachment when trying to run that code to insert the UUID.

    Database is "Server version: 10.1.13-MariaDB - mariadb.org binary distribution" according to the phpMyAdmin page.

    *EDIT* I updated to MariaDB 10.2.6 and I get the same error as seen in the attachment.
     

    Attached Files:

    Last edited: Jul 7, 2017
  6. clarkycal

    clarkycal Active Member

    Joined:
    Jul 3, 2017
    Messages:
    121
    Likes Received:
    29
    Hello BDTZ, nice to see you in another place, i used HeidiSQL to do all my database work, i do recommend you try the query with that program and see if it makes a difference.
     
  7. BetterDeadThanZed

    BetterDeadThanZed Member

    Joined:
    Apr 13, 2017
    Messages:
    44
    Likes Received:
    11
    Using HeidiSQL, I was able to execute the SQL code, but I'm still getting errors like this which I assume stems from a database issue:

    Code:
    10:24:30 "error while executing query: INSERT INTO `player_on_world_has_death_persistent_variables` (`player_uuid`, `world_uuid`, `death_persistent_variables_uuid`) VALUES (CAST(0x11E7631212660814A96BD05099096071 AS BINARY), CAST(0x11e75e625def9300a96ad05099096071 AS BINARY), CAST(0x11e7631ff970b3ffa96cd05099096071 AS BINARY)); ---- ERROR MESSAGE: Cannot add or update a child row: a foreign key constraint fails (`desolationredux`.`player_on_world_has_death_persistent_variables`, CONSTRAINT `fk_p_o_w_has_death_persistant_variables_worlds` FOREIGN KEY (`world_uuid`) REFERENCES `world` (`uuid`) ON DELETE)"
    10:24:30 Error in expression <VALUE: " + str(_x select 1));
    } forEach _nonpersvars;
    {
    _playerObj setVariable [>
    10:24:30   Error position: <_nonpersvars;
    {
    _playerObj setVariable [>
    10:24:30   Error Undefined variable in expression: _nonpersvars
    10:24:30 File DesoDB\Serialization\Players\fn_createPlayer.sqf, line 106
     
  8. BetterDeadThanZed

    BetterDeadThanZed Member

    Joined:
    Apr 13, 2017
    Messages:
    44
    Likes Received:
    11
    I got it worked out. I didn't realize that every time I ran the UUID tool it generated a new number so my UUID was off. :)
     
  9. karlsogm75

    karlsogm75 New Member

    Joined:
    Jul 9, 2017
    Messages:
    3
    Likes Received:
    0
    Improve skill is not working on my server?, i have 30 poits and i canĀ“not spend on it.
    any clue?
     
  10. Properpeanut

    Properpeanut New Member

    Joined:
    Dec 18, 2017
    Messages:
    1
    Likes Received:
    0
    Hi.

    I'm running my server with Desolation Redux, Cup Maps and Cup Terrains. whenever I try to join my server with Desolation_Chernarus mission, I get these errors:

    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:48 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc_e_config
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_cabuildings2_misc_cargo
    2017/12/17, 17:00:49 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:51 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:00:52 Warn: Shape '???' contains water texture however it does not carry a special class name. Consider craeting one to speed up the detection!
    2017/12/17, 17:01:04 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructures_mil
    2017/12/17, 17:01:04 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:01:04 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:01:05 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:01:05 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:05 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:13 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:14 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:17 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:17 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:17 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:18 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:18 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructureshouse_a_office01
    2017/12/17, 17:01:19 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_ind_workshop01
    2017/12/17, 17:01:19 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructures_mil
    2017/12/17, 17:01:20 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructureshouse_a_office02
    2017/12/17, 17:01:20 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructures_mil
    2017/12/17, 17:01:20 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructures_mil
    2017/12/17, 17:01:20 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:01:20 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructureshouse_a_hospital
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructureshouse_a_office02
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructureshouse_a_office02
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_buildings_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_castructures_mil
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:21 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_misc3_config
    2017/12/17, 17:01:22 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_cabuildings2_misc_cargo
    2017/12/17, 17:01:23 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_cabuildings2_misc_cargo
    2017/12/17, 17:01:23 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_cabuildings2_misc_cargo
    2017/12/17, 17:01:23 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_cabuildings2_misc_cargo
    2017/12/17, 17:01:23 Warning Message: You cannot play/edit this mission; it is dependent on downloadable content that has been deleted.
    cup_cabuildings2_misc_cargo

    Are there any other mods that I need to play that mission file?
     
  11. Legodev

    Legodev Developer Staff Member

    Joined:
    Jul 18, 2016
    Messages:
    384
    Likes Received:
    134
    seems like cup core is missing
     
    Properpeanut likes this.
  12. moosemilker

    moosemilker Member

    Joined:
    Mar 1, 2018
    Messages:
    38
    Likes Received:
    9
  13. Legodev

    Legodev Developer Staff Member

    Joined:
    Jul 18, 2016
    Messages:
    384
    Likes Received:
    134
  14. moosemilker

    moosemilker Member

    Joined:
    Mar 1, 2018
    Messages:
    38
    Likes Received:
    9
    Last edited: Mar 2, 2018
  15. Legodev

    Legodev Developer Staff Member

    Joined:
    Jul 18, 2016
    Messages:
    384
    Likes Received:
    134
    *cough cough* we always could use people who know how to script :D
     
    moosemilker likes this.
  16. jeansieb

    jeansieb New Member

    Joined:
    Jul 11, 2017
    Messages:
    10
    Likes Received:
    1
    Hi all
    Returning after some months and it seems that the generateuuid.bat file is not included in the new download? I also checked previous versions, and can't find it.
    Am I not seeing it? (Which is possible...)
     
    Last edited: Apr 18, 2018
  17. moosemilker

    moosemilker Member

    Joined:
    Mar 1, 2018
    Messages:
    38
    Likes Received:
    9
    It's not a requirement anymore.
     
    jeansieb likes this.

Share This Page