GmW-Reacher Posted October 6, 2014 Report Share Posted October 6, 2014 Hello everyone, i downloaded the Coin script as shown on http://devzupa.be/#/dayz/sc999 but evertime when i try to join the server crashes/restarts because of the following message in my Hive.log: 2014-10-05 19:26:19 HiveExt: [Information] Method: 999 Params: SELECT `PlayerMorality` FROM `player_data` WHERE `PlayerUID` = '76561198068341710':[0]: 2014-10-05 19:26:19 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.player_data' doesn't exist) in MySQLQuery SQL: 'SELECT `PlayerMorality` FROM `player_data` WHERE `PlayerUID` = '76561198068341710'' so i tried to rename my Player_DATA to player_data. Now i get the you must be close to a rock to mine ore message with the following Hive.log message: 2014-10-07 15:55:37 HiveExt: [Information] Method: 101 Params: 76561198068341710:11:Reacher: 2014-10-07 15:55:37 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT `CharacterID`, `Worldspace`, `Inventory`, `Backpack`, TIMESTAMPDIFF(MINUTE,`Datestamp`,`LastLogin`) as `SurvivalTime`, TIMESTAMPDIFF(MINUTE,`LastAte`,NOW()) as `MinsLastAte`, TIMESTAMPDIFF(MINUTE,`LastDrank`,NOW()) as `MinsLastDrank`, `Model` FROM `Character_DATA` WHERE `PlayerUID` = '76561198068341710' AND `Alive` = 1 ORDER BY `CharacterID` DESC LIMIT 1' 2014-10-07 15:55:37 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT `Generation`, `Humanity`, `Model`, `Infected` FROM `Character_DATA` WHERE `PlayerUID` = '76561198068341710' AND `Alive` = 0 ORDER BY `CharacterID` DESC LIMIT 1' 2014-10-07 15:55:37 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO `Character_DATA` (`PlayerUID`, `InstanceID`, `Worldspace`, `Inventory`, `Backpack`, `Medical`, `Generation`, `Datestamp`, `LastLogin`, `LastAte`, `LastDrank`, `Humanity`) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)' 2014-10-07 15:55:37 HiveExt: [Error] Error creating character for playerId 76561198068341710 2014-10-07 15:55:37 HiveExt: [Information] Result: ["ERROR"] is anybody able to help me out? SOLVED THANKS TO avidieking!! Link to comment Share on other sites More sharing options...
avdieking Posted October 6, 2014 Report Share Posted October 6, 2014 you can look into the hive log to and look what happens Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 6, 2014 Author Report Share Posted October 6, 2014 ok first of all thanks for your answer/help :) i checked thee hive.log and he says the following: 2014-10-06 16:54:01 HiveExt: [Information] Method: 999 Params: SELECT `PlayerMorality` FROM `player_data` WHERE `PlayerUID` = 'xxxxxxxxxxx':[0]: 2014-10-06 16:54:01 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.player_data' doesn't exist) in MySQLQuery SQL: 'SELECT `PlayerMorality` FROM `player_data` WHERE `PlayerUID` = 'xxxxxxxxxxx'' any suggestions how to solve this? Because Player_DATA defenetly exists in my DB. Or maybe i do have to rename my player data because on my DB it says: Player_DATA and not player_data? Link to comment Share on other sites More sharing options...
avdieking Posted October 6, 2014 Report Share Posted October 6, 2014 this could be just try it out nothing can happen to the database Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 6, 2014 Author Report Share Posted October 6, 2014 yes i will do this tomorrow, and thanks for the help more, tomorrow :) Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 7, 2014 Author Report Share Posted October 7, 2014 updated my main text.... Link to comment Share on other sites More sharing options...
avdieking Posted October 7, 2014 Report Share Posted October 7, 2014 try to rename your character_data to Character_DATA Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 7, 2014 Author Report Share Posted October 7, 2014 already tried that, then i get the "you must be close to a rock to mine ore" message and the Hive.log says: 2014-10-07 15:55:37 HiveExt: [Information] Method: 101 Params: 76561198068341710:11:Reacher: 2014-10-07 15:55:37 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT `CharacterID`, `Worldspace`, `Inventory`, `Backpack`, TIMESTAMPDIFF(MINUTE,`Datestamp`,`LastLogin`) as `SurvivalTime`, TIMESTAMPDIFF(MINUTE,`LastAte`,NOW()) as `MinsLastAte`, TIMESTAMPDIFF(MINUTE,`LastDrank`,NOW()) as `MinsLastDrank`, `Model` FROM `Character_DATA` WHERE `PlayerUID` = '76561198068341710' AND `Alive` = 1 ORDER BY `CharacterID` DESC LIMIT 1' 2014-10-07 15:55:37 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT `Generation`, `Humanity`, `Model`, `Infected` FROM `Character_DATA` WHERE `PlayerUID` = '76561198068341710' AND `Alive` = 0 ORDER BY `CharacterID` DESC LIMIT 1' 2014-10-07 15:55:37 Database: [Error] Error 1146 (Table 'ni367620_3_epoch.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO `Character_DATA` (`PlayerUID`, `InstanceID`, `Worldspace`, `Inventory`, `Backpack`, `Medical`, `Generation`, `Datestamp`, `LastLogin`, `LastAte`, `LastDrank`, `Humanity`) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)' 2014-10-07 15:55:37 HiveExt: [Error] Error creating character for playerId 76561198068341710 2014-10-07 15:55:37 HiveExt: [Information] Result: ["ERROR"] and by the way it is called Character_DATA Link to comment Share on other sites More sharing options...
avdieking Posted October 7, 2014 Report Share Posted October 7, 2014 you replaced the hive.dll or? Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 7, 2014 Author Report Share Posted October 7, 2014 yep i did... Link to comment Share on other sites More sharing options...
avdieking Posted October 7, 2014 Report Share Posted October 7, 2014 can i get access on your server add me on skype when i can skype: avdiek Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 7, 2014 Author Report Share Posted October 7, 2014 i added you Link to comment Share on other sites More sharing options...
avdieking Posted October 7, 2014 Report Share Posted October 7, 2014 whats your skype name i didn't get the request Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 7, 2014 Author Report Share Posted October 7, 2014 i have no idea something like Niklas? Link to comment Share on other sites More sharing options...
avdieking Posted October 7, 2014 Report Share Posted October 7, 2014 not avdieking avdiek ? Link to comment Share on other sites More sharing options...
GmW-Reacher Posted October 7, 2014 Author Report Share Posted October 7, 2014 yep avdiek might take a little while? Link to comment Share on other sites More sharing options...
