1.0.6.1 DB did not save chars

[Anhor]

As I have mentioned several times, my server does not ensure any character. In order to exclude all errors I have made a complete reinstallation of 1.0.6.1

I have NOT changed anything to the server- and clientfiles!

I've run on the database first 106update and then 1061update!

infiSTAR is NOT installed!

Logged in, run around, things looted, changed clothes, logged out ---> logged in ---> newbie *sig*

[salival]

Are there any errors in your HiveExt.log in config\yourServerName? Same folder you have HiveExt.ini

[Anhor]

Yes, but I have no idea what it means. I´m no DB specialist :(

 

2017-03-13 18:21:18 HiveExt: [Information] Method: 101 Params: 76561198127974288:1:Anhor:
2017-03-13 18:21:18 Database: [Error] Error 1054 (Unknown column 'playerGroup' in 'field list') in MySQLQuery SQL: 'SELECT `PlayerName`, `PlayerSex`, `playerGroup`, `PlayerCoins`, `BankCoins` FROM `Player_DATA` WHERE `PlayerUID`='76561198127974288''
2017-03-13 18:21:18 HiveExt: [Information] Created a new player 76561198127974288 named 'Anhor'
2017-03-13 18:21:18 Database: [Error] Error 1054 (Unknown column 'Coins' in 'field list') 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`, `Coins` FROM `Character_DATA` WHERE `PlayerUID` = '76561198127974288' AND `Alive` = 1 ORDER BY `CharacterID` DESC LIMIT 1'
2017-03-13 18:21:18 HiveExt: [Information] Created a new character 3 for player 'Anhor' (76561198127974288)
2017-03-13 18:21:18 HiveExt: [Information] Result: ["PASS",true,"3",0,"",[],0,0,0.97]
2017-03-13 18:21:18 HiveExt: [Information] Method: 203 Params: 3:[[],[]]:[,[],[]]:
2017-03-13 18:21:18 HiveExt: [Information] Result: ["PASS"]
2017-03-13 18:21:18 HiveExt: [Information] Method: 103 Params: 76561198127974288:3:2:
2017-03-13 18:21:18 HiveExt: [Information] Result: ["PASS"]
2017-03-13 18:21:18 Database: [Error] Error 1054 (Unknown column 'playerGroup' in 'field list') in MySQLStmtPrepare SQL: 'INSERT INTO `Player_DATA` (`PlayerUID`, `PlayerName`, playerGroup) VALUES (?, ?, ?)'
2017-03-13 18:21:21 HiveExt: [Information] Method: 102 Params: 3:
2017-03-13 18:21:21 Database: [Error] Error 1054 (Unknown column 'Coins' in 'field list') in MySQLQuery SQL: 'SELECT `Worldspace`, `Medical`, `Generation`, `KillsZ`, `HeadshotsZ`, `KillsH`, `KillsB`, `CurrentState`, `Humanity`, `InstanceID`,  `Coins`  FROM `Character_DATA` WHERE `CharacterID`=3'
2017-03-13 18:21:21 HiveExt: [Information] Result: ["ERROR"]
2017-03-13 18:21:21 HiveExt: [Information] Method: 102 Params: 3:
2017-03-13 18:21:21 Database: [Error] Error 1054 (Unknown column 'Coins' in 'field list') in MySQLQuery SQL: 'SELECT `Worldspace`, `Medical`, `Generation`, `KillsZ`, `HeadshotsZ`, `KillsH`, `KillsB`, `CurrentState`, `Humanity`, `InstanceID`,  `Coins`  FROM `Character_DATA` WHERE `CharacterID`=3'
2017-03-13 18:21:21 HiveExt: [Information] Result: ["ERROR"]
2017-03-13 18:21:21 HiveExt: [Information] Method: 102 Params: 3:
2017-03-13 18:21:21 Database: [Error] Error 1054 (Unknown column 'Coins' in 'field list') in MySQLQuery SQL: 'SELECT `Worldspace`, `Medical`, `Generation`, `KillsZ`, `HeadshotsZ`, `KillsH`, `KillsB`, `CurrentState`, `Humanity`, `InstanceID`,  `Coins`  FROM `Character_DATA` WHERE `CharacterID`=3'
2017-03-13 18:21:21 HiveExt: [Information] Result: ["ERROR"]
2017-03-13 18:21:21 HiveExt: [Information] Method: 102 Params: 3:
2017-03-13 18:21:21 Database: [Error] Error 1054 (Unknown column 'Coins' in 'field list') in MySQLQuery SQL: 'SELECT `Worldspace`, `Medical`, `Generation`, `KillsZ`, `HeadshotsZ`, `KillsH`, `KillsB`, `CurrentState`, `Humanity`, `InstanceID`,  `Coins`  FROM `Character_DATA` WHERE `CharacterID`=3'
2017-03-13 18:21:21 HiveExt: [Information] Result: ["ERROR"]
2017-03-13 18:21:21 HiveExt: [Information] Method: 102 Params: 3:
2017-03-13 18:21:21 Database: [Error] Error 1054 (Unknown column 'Coins' in 'field list') in MySQLQuery SQL: 'SELECT `Worldspace`, `Medical`, `Generation`, `KillsZ`, `HeadshotsZ`, `KillsH`, `KillsB`, `CurrentState`, `Humanity`, `InstanceID`,  `Coins`  FROM `Character_DATA` WHERE `CharacterID`=3'
2017-03-13 18:21:21 HiveExt: [Information] Result: ["ERROR"]

 

[salival]

It looks like you are not running the correct database, since coins are not in that database.

 

If you are starting from scratch use epoch.sql

If you are updating from 1.0.5.1 then you need to run the update scripts (don't upgrade imo)

 

[Anhor]

KK, give it a try.

 

[Anhor]

Not real a difference .........

2017-03-13 18:58:50 HiveExt: [Information] HiveExt 
2017-03-13 18:58:50 Database: [Information] Connected to MySQL database xxx.xx.xxx.xx:xxxx/XxxxxxXx client ver: 5.5.28 server ver: 5.5.47-0+deb7u1
2017-03-13 18:58:50 Database: [Information] Connected to MySQL database xxx.xx.xxx.xx:xxxx/XxxxxxXx client ver: 5.5.28 server ver: 5.5.47-0+deb7u1
2017-03-13 18:58:50 HiveExt: [Information] Method: 307 Params: 
2017-03-13 18:58:50 HiveExt: [Information] Result: ["PASS",[2017,3,13,18,58]]
2017-03-13 18:58:50 HiveExt: [Information] Method: 302 Params: 1:false:
2017-03-13 18:58:50 Database: [Error] Error 1054 (Unknown column 'StorageCoins' in 'field list') in MySQLQuery SQL: 'SELECT `ObjectID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage`, `StorageCoins` FROM `Object_DATA` WHERE `Instance`=1 AND `Classname` IS NOT NULL AND `Damage` < 1'
2017-03-13 18:58:50 HiveExt: [Error] Failed to fetch objects from database
2017-03-13 18:58:50 HiveExt: [Information] Result: ["ObjectStreamStart",0,"135547ab677753714f36a1c9c771746b"]
2017-03-13 18:58:51 HiveExt: [Information] Method: 307 Params: 
2017-03-13 18:58:51 HiveExt: [Information] Result: ["PASS",[2017,3,13,18,58]]
2017-03-13 18:58:54 HiveExt: [Information] Method: 307 Params: 
2017-03-13 18:58:54 HiveExt: [Information] Result: ["PASS",[2017,3,13,18,58]]

 

[Anhor]

Dont ask me why ........ but now it works!

Thx salival!