[SOLVED] Can't get it running....

[GmW-Reacher]

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!!

[avdieking]

you can look into the hive log to and look what happens

[GmW-Reacher]

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?

[avdieking]

this could be just try it out nothing can happen to the database

[GmW-Reacher]

yes i will do this tomorrow, and thanks for the help 

 

more, tomorrow :)

[GmW-Reacher]

updated my main text....

[avdieking]

try to rename your character_data to Character_DATA

[GmW-Reacher]

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

[avdieking]

you replaced the hive.dll or?

[GmW-Reacher]

yep i did...

[avdieking]

can i get access on your server add me on skype when i can skype: avdiek

[GmW-Reacher]

i added you

[avdieking]

whats your skype name i didn't get the request

[GmW-Reacher]

i have no idea something like Niklas?

[avdieking]

not avdieking avdiek ?

[GmW-Reacher]

yep avdiek might take a little while?