search

qrisat / inquisitor-mc

Automatically exported from code.google.com/p/inquisitor-mc
0 stars 0 forks source link

"statistics manager is not started" #21

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
First of all, firsttime-run didn't make the SQL table for joining.

But after first "block-break" i got a row in the table.

and one day later, i couldn't visit the web-server. so i tried: "inq webserver 
enable", and the log says:
[21:24:57 WARN]: [Inquisitor] web server cannot be started: statisticsManager 
is not started

so i checked "inq status", and it resulted like:

[21:21:08 INFO]: [Inquisitor] database is connected
[21:21:08 INFO]: [Inquisitor] statistics manager is not started
[21:21:08 INFO]: [Inquisitor] 1 groups registered
[21:21:08 INFO]: [Inquisitor]   group 'players' has 87 statistics, 5 instances 
cached
[21:21:08 INFO]: [Inquisitor]     'SystemAdm' has 0 dirty statistics (invalid)
[21:21:08 INFO]: [Inquisitor]     'xXlegendXx09' has 11 dirty statistics 
(invalid)
[21:21:08 INFO]: [Inquisitor]     'mmgid123' has 14 dirty statistics (invalid)
[21:21:08 INFO]: [Inquisitor]     'oddthing' has 1 dirty statistics (invalid)
[21:21:08 INFO]: [Inquisitor]     'rytter89' has 4 dirty statistics (invalid)
[21:21:08 INFO]: [Inquisitor] 0 pending updates
[21:21:08 INFO]: [Inquisitor] web server is not started

the missing field in the SQL table is an easy fix, but... how do i start the 
"statistics manager"?

Original issue reported on code.google.com by jov...@gmail.com on 7 May 2014 at 8:04

GoogleCodeExporter commented 8 years ago 
Are you running v2.27? If not, update and try again.

If so, can you send me the console log shortly after the server has started up?

Original comment by snarfatt...@gmail.com on 7 May 2014 at 11:09

GoogleCodeExporter commented 8 years ago 
[09:02:24 INFO]: |----Plugin information: Inquisitor----|
[09:02:24 INFO]: Status: Enabled
[09:02:24 INFO]: Description: Collects player statistics, stores them in a 
database, and optionally serves them through a built-in web server.
[09:02:24 INFO]: Version: 2.27
[09:02:24 INFO]: Main class: com.frdfsnlght.inquisitor.Inquisitor
[09:02:24 INFO]: Jar file: Inquisitor.2.27.jar
[09:02:24 INFO]: Authors: snarfattack, snarfattack, frdfsnlght
[09:02:24 INFO]: Website: http://code.google.com/p/inquisitor-mc/

[09:02:52 INFO]: This server is running CraftBukkit version git-Spigot-1432 
(MC: 1.7.8) (Implementing API version 1.7.8-R0.1-SNAPSHOT)

[08:58:43] [Server thread/INFO]: Starting minecraft server version 1.7.8
[08:58:43] [Server thread/INFO]: Loading properties
[08:58:43] [Server thread/INFO]: Default game type: SURVIVAL
[08:58:43] [Server thread/INFO]: This server is running CraftBukkit version 
git-Spigot-1432 (MC: 1.7.8) (Implementing API version 1.7.8-R0.1-SNAPSHOT)
[08:58:43] [Server thread/INFO]: Server Ping Player Sample Count: 12
[08:58:43] [Server thread/INFO]: Using 3 threads for Netty based IO
[08:58:43] [Server thread/INFO]: Generating keypair
[08:58:43] [Server thread/INFO]: Starting Minecraft server on *:25560
[08:58:44] [Server thread/INFO]: [Inquisitor] Loading Inquisitor v2.27
[08:58:45] [Server thread/INFO]: [Vault] Enabled Version 1.2.24-b304
[08:58:45] [Server thread/INFO]: [ProtocolLib] Enabling ProtocolLib 
v3.0.0-SNAPSHOT
[08:58:45] [Server thread/INFO]: [ProtocolLib] Started structure compiler 
thread.
[08:58:55] [Server thread/INFO]: [Inquisitor] Enabling Inquisitor v2.27
[08:58:55] [Server thread/INFO]: [Inquisitor] loaded configuration
[08:58:56] [Server thread/INFO]: [Inquisitor] connected to database
[08:58:56] [Server thread/INFO]: [Inquisitor] Applying v2.14 DB fix to existing 
players...
[08:58:56] [Server thread/WARN]: [Inquisitor] database connection cannot be 
completed: null
[08:58:56] [Server thread/INFO]: [Inquisitor] ready on server 'HeLP-online'

//config file:
db: {username: *hidden_username*, prefix: inc, password: *hidden_password*, 
url: 'jdbc:mysql://*hidden_hostname*/*hidden_database*'}
global: null
webServer: {port: 8181, enabled: true}

//dump from sql "incplayers"
-- phpMyAdmin SQL Dump
-- version 3.3.7deb7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 08, 2014 at 07:13 AM
-- Server version: 5.5.31
-- PHP Version: 5.4.27-1~dotdeb.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `minecraft`
--

-- --------------------------------------------------------

--
-- Table structure for table `incplayers`
--

CREATE TABLE IF NOT EXISTS `incplayers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `lastUpdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastJoin` timestamp NULL DEFAULT NULL,
  `mapped` longtext,
  `totalItemsPickedUp` int(11) DEFAULT '0',
  `totalDistanceTraveled` float DEFAULT '0',
  `lastKick` timestamp NULL DEFAULT NULL,
  `lavaBucketsEmptied` int(11) DEFAULT '0',
  `totalMobsKilled` int(11) DEFAULT '0',
  `lastKickMessage` varchar(255) DEFAULT NULL,
  `portalsCrossed` int(11) DEFAULT '0',
  `sessionTime` float DEFAULT '0',
  `level` int(11) DEFAULT '0',
  `mooshroomsMilked` int(11) DEFAULT '0',
  `potionEffects` longtext,
  `deaths` int(11) DEFAULT '0',
  `foodLevel` int(11) DEFAULT '0',
  `lastMobKill` timestamp NULL DEFAULT NULL,
  `groups` longtext,
  `chatMessages` int(11) DEFAULT '0',
  `joins` int(11) DEFAULT '0',
  `waterBucketsEmptied` int(11) DEFAULT '0',
  `totalBlocksPlaced` int(11) DEFAULT '0',
  `lastDeathMessage` varchar(255) DEFAULT NULL,
  `lastQuit` timestamp NULL DEFAULT NULL,
  `firstJoin` timestamp NULL DEFAULT NULL,
  `health` int(11) DEFAULT '0',
  `totalPlayersKilled` int(11) DEFAULT '0',
  `lastDeath` timestamp NULL DEFAULT NULL,
  `mooshroomsSheared` int(11) DEFAULT '0',
  `timesSlept` int(11) DEFAULT '0',
  `arrowsShot` int(11) DEFAULT '0',
  `exp` float DEFAULT '0',
  `itemsEnchanted` int(11) DEFAULT '0',
  `lifetimeExperience` int(11) DEFAULT '0',
  `uuid` varchar(36) DEFAULT NULL,
  `totalTime` float DEFAULT '0',
  `sheepDyed` int(11) DEFAULT '0',
  `totalExperience` int(11) DEFAULT '0',
  `remainingAir` int(11) DEFAULT '0',
  `exhaustion` float DEFAULT '0',
  `armor` longtext,
  `sheepSheared` int(11) DEFAULT '0',
  `online` tinyint(1) DEFAULT '0',
  `money` double DEFAULT '0',
  `lavaBucketsFilled` int(11) DEFAULT '0',
  `totalItemsCrafted` int(11) DEFAULT '0',
  `itemEnchantmentLevels` int(11) DEFAULT '0',
  `bedServer` varchar(50) DEFAULT NULL,
  `bedCoords` varchar(100) DEFAULT NULL,
  `quits` int(11) DEFAULT '0',
  `firesStarted` int(11) DEFAULT '0',
  `totalBlocksBroken` int(11) DEFAULT '0',
  `fishCaught` int(11) DEFAULT '0',
  `heldItemSlot` int(11) DEFAULT '0',
  `lastPlayerKilled` varchar(30) DEFAULT NULL,
  `fireTicks` int(11) DEFAULT '0',
  `lastPlayerKill` timestamp NULL DEFAULT NULL,
  `totalItemsDropped` int(11) DEFAULT '0',
  `gameMode` varchar(15) DEFAULT NULL,
  `cowsMilked` int(11) DEFAULT '0',
  `coords` varchar(100) DEFAULT NULL,
  `lastMobKilled` varchar(30) DEFAULT NULL,
  `saturation` float DEFAULT '0',
  `address` varchar(40) DEFAULT NULL,
  `inventory` longtext,
  `waterBucketsFilled` int(11) DEFAULT '0',
  `server` varchar(50) DEFAULT NULL,
  `displayName` varchar(255) DEFAULT NULL,
  `world` varchar(50) DEFAULT NULL,
  `ender` longtext,
  `bedWorld` varchar(50) DEFAULT NULL,
  `kicks` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `incplayers`
--

INSERT INTO `incplayers` (`id`, `name`, `lastUpdate`, `lastJoin`, `mapped`, 
`totalItemsPickedUp`, `totalDistanceTraveled`, `lastKick`, 
`lavaBucketsEmptied`, `totalMobsKilled`, `lastKickMessage`, `portalsCrossed`, 
`sessionTime`, `level`, `mooshroomsMilked`, `potionEffects`, `deaths`, 
`foodLevel`, `lastMobKill`, `groups`, `chatMessages`, `joins`, 
`waterBucketsEmptied`, `totalBlocksPlaced`, `lastDeathMessage`, `lastQuit`, 
`firstJoin`, `health`, `totalPlayersKilled`, `lastDeath`, `mooshroomsSheared`, 
`timesSlept`, `arrowsShot`, `exp`, `itemsEnchanted`, `lifetimeExperience`, 
`uuid`, `totalTime`, `sheepDyed`, `totalExperience`, `remainingAir`, 
`exhaustion`, `armor`, `sheepSheared`, `online`, `money`, `lavaBucketsFilled`, 
`totalItemsCrafted`, `itemEnchantmentLevels`, `bedServer`, `bedCoords`, 
`quits`, `firesStarted`, `totalBlocksBroken`, `fishCaught`, `heldItemSlot`, 
`lastPlayerKilled`, `fireTicks`, `lastPlayerKill`, `totalItemsDropped`, 
`gameMode`, `cowsMilked`, `coords`, `lastMobKilled`, `saturation`, `address`, 
`inventory`, `waterBucketsFilled`, `server`, `displayName`, `world`, `ender`, 
`bedWorld`, `kicks`) VALUES
(1, 'oddthing', '2014-05-07 14:27:19', NULL, 
'{"deathCauses":null,"animalsTamed":null,"mobsKilledByWeapon":null,"travelDistan
ces":null,"blocksPlaced":{"Wood":1},"travelTimes":null,"playersKilled":null,"foo
dEaten":null,"biomeDistances":null,"playersKilledByWeapon":null,"itemsCrafted":n
ull,"itemsPickedUp":{"Wood":1},"mobsKilled":null,"eggsThrown":null,"blocksBroken
":{"Wood":1},"biomeTimes":null,"itemsDropped":null}', 1, 0, '2014-05-07 
14:27:19', 0, 0, 'oddthing left the game.', 0, 0, 29, 0, '[]', 0, 18, NULL, 
'["VIP","default"]', 0, 0, 0, 1, NULL, '2014-05-07 09:53:26', NULL, 20, 0, 
NULL, 0, 0, 0, 0.338983, 0, 0, NULL, 0, 0, 786, 300, 0.514799, 
'[{"enchantments":{},"amount":1,"durability":24,"data":24,"type":309},{"enchantm
ents":{},"amount":1,"durability":24,"data":24,"type":308},{"enchantments":{},"am
ount":1,"durability":24,"data":24,"type":307},{"enchantments":{},"amount":1,"dur
ability":24,"data":24,"type":306}]', 0, 0, 0, 0, 0, 0, NULL, NULL, 1, 0, 1, 0, 
2, NULL, -20, NULL, 0, 'SURVIVAL', 0, '783.775,67,1469.968', NULL, 0, 
'127.0.0.1', 
'[{"enchantments":{},"amount":48,"durability":0,"data":0,"type":280},{"enchantme
nts":{},"amount":2,"durability":0,"data":0,"type":264},null,{"enchantments":{},"
amount":13,"durability":0,"data":0,"type":50},{"enchantments":{},"amount":11,"du
rability":0,"data":0,"type":297},{"enchantments":{},"amount":1,"durability":6,"d
ata":6,"type":257},{"enchantments":{},"amount":1,"durability":0,"data":0,"type":
257},{"enchantments":{},"amount":1,"durability":0,"data":0,"type":257},{"enchant
ments":{},"amount":1,"durability":120,"data":120,"type":267},null,null,{"enchant
ments":{},"amount":63,"durability":0,"data":0,"type":4},null,null,null,{"enchant
ments":{},"amount":10,"durability":0,"data":0,"type":4},null,{"enchantments":{},
"amount":1,"durability":0,"data":0,"type":85},{"enchantments":{},"amount":1,"dur
ability":52,"data":52,"type":275},null,null,null,null,null,{"enchantments":{},"a
mount":10,"durability":0,"data":0,"type":15},{"enchantments":{},"amount":63,"dur
ability":0,"data":0,"type":263},{"enchantments":{},"amount":64,"durability":0,"d
ata":0,"type":263},null,null,{"enchantments":{},"amount":2,"durability":0,"data"
:0,"type":14},null,null,null,null,{"enchantments":{},"amount":1,"durability":19,
"data":19,"type":268},{"enchantments":{},"amount":1,"durability":0,"data":0,"typ
e":257}]', 0, 'HeLP-online', 'oddthing', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 1),
(2, 'HaukFT81', '2014-05-07 14:27:19', NULL, 
'{"deathCauses":null,"animalsTamed":null,"mobsKilledByWeapon":null,"travelDistan
ces":{"Falling":9.034659},"blocksPlaced":{"Dirt":3,"Sapling":1,"Soul 
Sand":1},"travelTimes":null,"playersKilled":null,"foodEaten":{"Grilled 
Pork":1,"Cooked 
Beef":1},"biomeDistances":null,"playersKilledByWeapon":null,"itemsCrafted":null,
"itemsPickedUp":{"Dirt":6,"Cooked 
Beef":1,"Cobblestone":4,"Wood":1,"Sapling":1,"Soul 
Sand":1},"mobsKilled":null,"eggsThrown":null,"blocksBroken":{"Dirt":2,"Stone":2,
"Cobblestone":3,"Leaves":3,"Wood":1,"Grass":4},"biomeTimes":null,"itemsDropped":
{"Cooked Beef":2,"Nether Stalk":3,"Potion":1}}', 14, 0, '2014-05-07 14:27:19', 
0, 0, 'HaukFT81 left the game.', 0, 0, 16, 0, '[]', 0, 17, NULL, '["default"]', 
27, 0, 0, 5, NULL, '2014-05-07 14:19:44', NULL, 20, 0, NULL, 0, 1, 0, 
0.0500004, 0, 0, NULL, 0, 0, 324, 300, 0.104721, 
'[{"enchantments":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantmen
ts":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount
":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount":0,"durabilit
y":-1,"data":-1,"type":0}]', 0, 0, 0, 0, 0, 0, NULL, NULL, 2, 0, 15, 0, 4, 
NULL, -20, NULL, 6, 'SURVIVAL', 0, '302.206,77,291.644', NULL, 0, '127.0.0.1', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null]', 0, 'HeLP-online', 'HaukFT81', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 1),
(3, 'zhevs', '2014-05-07 13:43:03', NULL, NULL, 0, 0, NULL, 0, 0, NULL, 0, 0, 
0, 0, '[]', 0, 15, NULL, '["default"]', 0, 0, 0, 0, NULL, '2014-05-07 
13:43:03', NULL, 16, 0, NULL, 0, 0, 0, 0.192725, 0, 0, NULL, 0, 0, 1073, 300, 
1.10884, 
'[{"enchantments":{},"amount":1,"durability":3,"data":3,"type":309},{"enchantmen
ts":{"PROTECTION_ENVIRONMENTAL":1},"amount":1,"durability":3,"data":3,"type":308
},{"enchantments":{"DURABILITY":1},"amount":1,"durability":99,"data":99,"type":3
07},{"enchantments":{"PROTECTION_ENVIRONMENTAL":1},"amount":1,"durability":3,"da
ta":3,"type":306}]', 0, 0, 0, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 3, NULL, -20, 
NULL, 0, 'SURVIVAL', 0, '436.377,63,339.542', NULL, 0, '127.0.0.1', 
'[{"enchantments":{"DAMAGE_ALL":2,"DURABILITY":2,"KNOCKBACK":1},"amount":1,"dura
bility":354,"data":98,"type":276},{"enchantments":{"ARROW_DAMAGE":2,"DURABILITY"
:2},"amount":1,"durability":102,"data":102,"type":261},{"enchantments":{},"amoun
t":1,"durability":0,"data":0,"type":295},null,null,null,null,null,null,null,null
,null,null,null,null,null,null,{"enchantments":{},"amount":30,"durability":0,"da
ta":0,"type":262},null,null,null,null,null,null,null,null,null,null,null,null,nu
ll,null,null,null,null,null]', 0, 'HeLP-online', 'zhevs', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 0),
(4, 'KapteinNorge', '2014-05-07 14:27:19', NULL, '{"deathCauses":{"Entity 
Attack":1,"Fall":1,"Entity 
Explosion":1},"animalsTamed":null,"mobsKilledByWeapon":{"Iron Sword":4,"Iron 
Axe":1,"Iron 
Pickaxe":3},"travelDistances":{"Falling":69.263115},"blocksPlaced":{"Dirt":2,"Co
bblestone":3,"Torch":14,"Smooth Brick":39,"Furnace":1,"Wood":64,"Glass":2,"Bed 
Block":2,"Soul 
Sand":2},"travelTimes":null,"playersKilled":null,"foodEaten":{"Cooked 
Beef":4},"biomeDistances":null,"playersKilledByWeapon":null,"itemsCrafted":{"Iro
n Axe":1,"Torch":4,"Smooth 
Brick":12,"Furnace":1,"Wood":12,"Coal":9,"Chest":1,"Bed":1,"Iron 
Pickaxe":1,"Stick":8},"itemsPickedUp":{"Cooked 
Beef":1,"Gravel":1,"Leather":2,"Iron Axe":1,"Apple":1,"Cobblestone":167,"Rotten 
Flesh":1,"Wood":7,"Sapling":4,"Coal":17,"Chest":2,"Coal Block":42,"Raw 
Chicken":1,"Dirt":13,"Iron Ore":29,"Raw Beef":9,"String":2,"Torch":6,"Log 
2":108,"Soul Sand":1,"Bed":1,"Brown 
Mushroom":4,"Potion":1,"Stick":16},"mobsKilled":{"Spider":1,"Zombie":2,"Cow":5},
"eggsThrown":null,"blocksBroken":{"Gravel":1,"Leaves":22,"Stone":167,"Wood":7,"G
rass":1,"Huge Mushroom 1":8,"Glass":3,"Bed Block":1,"Iron Ore":29,"Coal 
Ore":17,"Torch":6,"Log 2":77,"Long Grass":2,"Soul Sand":1,"Leaves 
2":29},"biomeTimes":null,"itemsDropped":{"Soul Sand":1}}', 437, 0, '2014-05-07 
14:27:19', 0, 8, 'KapteinNorge left the game.', 0, 0, 0, 0, '[]', 3, 18, 
'2014-05-07 14:21:57', '["default"]', 97, 0, 0, 129, 'KapteinNorge was blown up 
by Creeper', NULL, NULL, 20, 0, '2014-05-07 14:21:59', 0, 0, 0, 0, 0, 56, NULL, 
0, 0, 0, 300, 0.549478, 
'[{"enchantments":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantmen
ts":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount
":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount":0,"durabilit
y":-1,"data":-1,"type":0}]', 0, 0, 0, 0, 50, 0, NULL, NULL, 0, 0, 371, 0, 0, 
NULL, -20, NULL, 1, 'SURVIVAL', 0, '-3059.68,64,-3527.372', 'Zombie', 0, 
'127.0.0.1', 
'[{"enchantments":{},"amount":1,"durability":140,"data":-116,"type":258},{"encha
ntments":{},"amount":1,"durability":0,"data":0,"type":50},{"enchantments":{},"am
ount":46,"durability":5,"data":5,"type":5},{"enchantments":{},"amount":2,"durabi
lity":0,"data":0,"type":54},{"enchantments":{},"amount":12,"durability":0,"data"
:0,"type":3},{"enchantments":{},"amount":1,"durability":0,"data":0,"type":365},{
"enchantments":{},"amount":9,"durability":1,"data":1,"type":162},{"enchantments"
:{},"amount":55,"durability":5,"data":5,"type":5},{"enchantments":{},"amount":32
,"durability":5,"data":5,"type":5},{"enchantments":{},"amount":4,"durability":0,
"data":0,"type":6},{"enchantments":{},"amount":1,"durability":0,"data":0,"type":
260},{"enchantments":{},"amount":1,"durability":5,"data":5,"type":5},null,null,n
ull,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,n
ull,null,null,null,null,{"enchantments":{},"amount":64,"durability":5,"data":5,"
type":5}]', 0, 'HeLP-online', 'KapteinNorge', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 1),
(5, 'Angeir', '2014-05-07 14:03:42', NULL, 
'{"deathCauses":null,"animalsTamed":null,"mobsKilledByWeapon":{"Diamond 
Sword":8},"travelDistances":null,"blocksPlaced":null,"travelTimes":null,"players
Killed":null,"foodEaten":null,"biomeDistances":null,"playersKilledByWeapon":null
,"itemsCrafted":null,"itemsPickedUp":{"Raw Chicken":1,"Raw 
Beef":5,"Leather":4,"Sulphur":3,"Feather":2,"Spider Eye":2,"Rotten 
Flesh":2},"mobsKilled":{"Creeper":1,"Spider":1,"Chicken":1,"Witch":1,"Zombie":1,
"Cow":3},"eggsThrown":null,"blocksBroken":{"Long 
Grass":1},"biomeTimes":null,"itemsDropped":{"Coal Block":42}}', 19, 0, NULL, 0, 
8, NULL, 0, 0, 15, 0, '[]', 0, 16, '2014-05-07 13:58:31', '["default"]', 22, 0, 
0, 0, NULL, '2014-05-07 14:03:42', NULL, 17, 0, NULL, 0, 0, 0, 0.136374, 0, 27, 
NULL, 0, 0, 2559, 300, 3.30302, 
'[{"enchantments":{"PROTECTION_ENVIRONMENTAL":4,"DURABILITY":3},"amount":1,"dura
bility":33,"data":33,"type":309},{"enchantments":{"PROTECTION_ENVIRONMENTAL":3,"
DURABILITY":3},"amount":1,"durability":8,"data":8,"type":308},{"enchantments":{"
PROTECTION_EXPLOSIONS":4},"amount":1,"durability":9,"data":9,"type":307},{"encha
ntments":{"PROTECTION_FIRE":1,"DURABILITY":1},"amount":1,"durability":15,"data":
15,"type":306}]', 0, 0, 0, 0, 0, 0, NULL, NULL, 1, 0, 1, 0, 1, NULL, -20, NULL, 
42, 'SURVIVAL', 0, '305.074,76,295.557', 'Chicken', 0, '127.0.0.1', 
'[{"enchantments":{"DIG_SPEED":3,"DURABILITY":3},"amount":1,"durability":740,"da
ta":-28,"type":278},{"enchantments":{"DAMAGE_ALL":4,"DURABILITY":3},"amount":1,"
durability":216,"data":-40,"type":276},{"enchantments":{"DURABILITY":1},"amount"
:1,"durability":265,"data":9,"type":279},{"enchantments":{},"amount":64,"durabil
ity":0,"data":0,"type":12},{"enchantments":{},"amount":1,"durability":0,"data":0
,"type":3},{"enchantments":{},"amount":3,"durability":0,"data":0,"type":265},{"e
nchantments":{},"amount":4,"durability":0,"data":0,"type":50},{"enchantments":{}
,"amount":6,"durability":0,"data":0,"type":364},{"enchantments":{},"amount":3,"d
urability":0,"data":0,"type":289},{"enchantments":{},"amount":64,"durability":0,
"data":0,"type":12},{"enchantments":{},"amount":2,"durability":0,"data":0,"type"
:262},{"enchantments":{},"amount":2,"durability":0,"data":0,"type":263},{"enchan
tments":{},"amount":9,"durability":0,"data":0,"type":363},{"enchantments":{},"am
ount":64,"durability":0,"data":0,"type":12},{"enchantments":{},"amount":56,"dura
bility":0,"data":0,"type":12},{"enchantments":{},"amount":37,"durability":0,"dat
a":0,"type":24},{"enchantments":{},"amount":2,"durability":0,"data":0,"type":4},
{"enchantments":{},"amount":6,"durability":0,"data":0,"type":15},{"enchantments"
:{},"amount":6,"durability":0,"data":0,"type":367},{"enchantments":{},"amount":2
,"durability":0,"data":0,"type":375},{"enchantments":{},"amount":4,"durability":
0,"data":0,"type":334},{"enchantments":{},"amount":2,"durability":0,"data":0,"ty
pe":288},{"enchantments":{},"amount":1,"durability":0,"data":0,"type":365},null,
null,null,null,null,null,null,null,null,null,null,null,null]', 0, 
'HeLP-online', 'Angeir', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 0),
(6, 'minern2000', '2014-05-07 14:16:31', NULL, 
'{"deathCauses":null,"animalsTamed":null,"mobsKilledByWeapon":null,"travelDistan
ces":null,"blocksPlaced":{"Dirt":7},"travelTimes":null,"playersKilled":null,"foo
dEaten":null,"biomeDistances":null,"playersKilledByWeapon":null,"itemsCrafted":n
ull,"itemsPickedUp":{"Dirt":2},"mobsKilled":null,"eggsThrown":null,"blocksBroken
":{"Grass":2},"biomeTimes":null,"itemsDropped":null}', 2, 0, NULL, 0, 0, NULL, 
0, 0, 0, 0, '[]', 0, 3, NULL, '["default"]', 11, 0, 0, 7, NULL, '2014-05-07 
14:16:31', NULL, 12, 0, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 300, 3.23081, 
'[{"enchantments":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantmen
ts":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount
":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount":0,"durabilit
y":-1,"data":-1,"type":0}]', 0, 0, 0, 0, 0, 0, NULL, NULL, 1, 0, 2, 0, 2, NULL, 
-20, NULL, 0, 'SURVIVAL', 0, '302.3,77,299.005', NULL, 0, '127.0.0.1', 
'[{"enchantments":{},"amount":1,"durability":0,"data":0,"type":295},{"enchantmen
ts":{},"amount":2,"durability":0,"data":0,"type":3},null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null,null]', 0, 
'HeLP-online', 'minern2000', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 0),
(7, 'JensLG123', '2014-05-07 14:27:19', NULL, 
'{"deathCauses":null,"animalsTamed":null,"mobsKilledByWeapon":null,"travelDistan
ces":{"Falling":76.735054},"blocksPlaced":{"Netherrack":32},"travelTimes":null,"
playersKilled":null,"foodEaten":{"Bread":6},"biomeDistances":null,"playersKilled
ByWeapon":null,"itemsCrafted":{"Iron 
Pickaxe":1},"itemsPickedUp":{"Quartz":132,"Netherrack":104,"Ink Sack":1,"Soul 
Sand":16},"mobsKilled":null,"eggsThrown":null,"blocksBroken":{"Quartz 
Ore":132,"Netherrack":107,"Soul 
Sand":16},"biomeTimes":null,"itemsDropped":{"Bread":4,"Diamond Pickaxe":1,"Ink 
Sack":1}}', 253, 0, '2014-05-07 14:27:19', 0, 0, 'JensLG123 left the game.', 1, 
0, 25, 0, '[]', 0, 20, NULL, '["default"]', 2, 0, 0, 32, NULL, '2014-05-07 
14:26:34', NULL, 20, 0, NULL, 0, 0, 0, 0.574468, 0, 457, NULL, 0, 0, 587, 300, 
0.395544, 
'[{"enchantments":{},"amount":1,"durability":36,"data":36,"type":309},{"enchantm
ents":{},"amount":1,"durability":11,"data":11,"type":308},{"enchantments":{},"am
ount":1,"durability":108,"data":108,"type":307},{"enchantments":{},"amount":1,"d
urability":36,"data":36,"type":306}]', 0, 0, 0, 0, 1, 0, NULL, NULL, 4, 0, 255, 
0, 6, NULL, -20, NULL, 6, 'SURVIVAL', 0, '375.232,69,118.34', NULL, 0, 
'127.0.0.1', 
'[{"enchantments":{},"amount":1,"durability":83,"data":83,"type":267},{"enchantm
ents":{},"amount":1,"durability":372,"data":116,"type":261},{"enchantments":{},"
amount":48,"durability":15,"data":15,"type":351},{"enchantments":{},"amount":11,
"durability":0,"data":0,"type":262},{"enchantments":{},"amount":20,"durability":
0,"data":0,"type":88},{"enchantments":{},"amount":64,"durability":0,"data":0,"ty
pe":406},{"enchantments":{},"amount":1,"durability":239,"data":-17,"type":257},{
"enchantments":{},"amount":1,"durability":0,"data":0,"type":297},{"enchantments"
:{},"amount":50,"durability":0,"data":0,"type":87},{"enchantments":{},"amount":6
4,"durability":0,"data":0,"type":406},{"enchantments":{},"amount":22,"durability
":0,"data":0,"type":87},{"enchantments":{},"amount":1,"durability":1,"data":1,"t
ype":259},{"enchantments":{},"amount":4,"durability":0,"data":0,"type":406},null
,{"enchantments":{},"amount":4,"durability":0,"data":0,"type":112},{"enchantment
s":{},"amount":2,"durability":0,"data":0,"type":20},null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null,null,null,null]', 0, 
'HeLP-online', 'JensLG123', 'world_nether', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 1),
(8, 'oss567', '2014-05-07 14:27:19', NULL, 
'{"deathCauses":null,"animalsTamed":null,"mobsKilledByWeapon":{"Iron 
Sword":3,"None":2},"travelDistances":{"Falling":13.643104},"blocksPlaced":{"Thin
 Glass":1,"Glowstone":1,"Torch":2,"Sugar Cane 
Block":2},"travelTimes":null,"playersKilled":null,"foodEaten":{"Bread":3,"Cooked

Chicken":1},"biomeDistances":null,"playersKilledByWeapon":null,"itemsCrafted":{"
Tnt":1},"itemsPickedUp":{"Bone":1,"Bread":4,"Diamond 
Pickaxe":1,"Sulphur":3,"Sand":4,"Nether 
Stalk":3,"String":4,"Arrow":2,"Torch":1,"Cobblestone":1,"Painting":7,"Sugar 
Cane":7},"mobsKilled":{"Creeper":2,"Spider":2,"Skeleton":1},"eggsThrown":null,"b
locksBroken":{"Sand":4,"Nether Brick":1,"Torch":1,"Cobblestone":1,"Sugar Cane 
Block":6},"biomeTimes":null,"itemsDropped":null}', 38, 0, '2014-05-07 
14:27:19', 0, 5, 'oss567 left the game.', 1, 0, 9, 0, '[]', 0, 13, '2014-05-07 
14:22:58', '["default"]', 16, 0, 0, 6, NULL, '2014-05-07 14:26:27', NULL, 3, 0, 
NULL, 0, 0, 0, 0.411765, 0, 26, NULL, 0, 0, 160, 291, 3.47124, 
'[{"enchantments":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantmen
ts":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount
":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount":0,"durabilit
y":-1,"data":-1,"type":0}]', 0, 0, 0, 0, 1, 0, NULL, NULL, 3, 0, 13, 0, 0, 
NULL, -20, NULL, 0, 'SURVIVAL', 0, '793.632,60.358,-101.731', 'Creeper', 6.2, 
'127.0.0.1', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null]', 0, 'HeLP-online', 'oss567', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 1),
(9, 'Main2909', '2014-05-07 14:27:19', NULL, 
'{"deathCauses":null,"animalsTamed":null,"mobsKilledByWeapon":null,"travelDistan
ces":{"Falling":19.691616},"blocksPlaced":null,"travelTimes":null,"playersKilled
":null,"foodEaten":null,"biomeDistances":null,"playersKilledByWeapon":null,"item
sCrafted":null,"itemsPickedUp":null,"mobsKilled":null,"eggsThrown":null,"blocksB
roken":null,"biomeTimes":null,"itemsDropped":null}', 0, 0, '2014-05-07 
14:27:19', 0, 0, 'Main2909 left the game.', 0, 0, 0, 0, '[]', 0, 6, NULL, 
'["default"]', 4, 0, 0, 0, NULL, NULL, NULL, 10, 0, NULL, 0, 0, 0, 0, 0, 0, 
NULL, 0, 0, 0, 300, 2.31334, 
'[{"enchantments":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantmen
ts":{},"amount":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount
":0,"durability":-1,"data":-1,"type":0},{"enchantments":{},"amount":0,"durabilit
y":-1,"data":-1,"type":0}]', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, NULL, 
-20, NULL, 0, 'SURVIVAL', 0, '14.614,62.463,234.673', NULL, 0, '127.0.0.1', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null]', 0, 'HeLP-online', 'Main2909', 'world', 
'[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,nul
l,null,null,null,null,null,null,null,null,null,null,null]', NULL, 1);

//error in log when joining
[09:11:35] [User Authenticator #1/INFO]: UUID of player oddthing is 
b7cc18e8-4239-3df1-a776-97950f4710a8
[09:11:35] [Server thread/ERROR]: [Inquisitor] OnPlayerJoin Exception message: 
Unknown column 'name' in 'where clause'
[09:11:35] [Server thread/ERROR]: [Inquisitor] Stack Trace: 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
'name' in 'where clause'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
        at com.frdfsnlght.inquisitor.PlayerStats.onPlayerJoin(PlayerStats.java:335)
        at com.frdfsnlght.inquisitor.PlayerListenerImpl.onPlayerJoin(PlayerListenerImpl.java:65)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
        at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30)
        at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487)
        at net.minecraft.server.v1_7_R3.PlayerList.c(PlayerList.java:251)
        at net.minecraft.server.v1_7_R3.PlayerList.a(PlayerList.java:138)
        at net.minecraft.server.v1_7_R3.LoginListener.c(LoginListener.java:105)
        at net.minecraft.server.v1_7_R3.LoginListener.a(LoginListener.java:43)
        at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:170)
        at net.minecraft.server.v1_7_R3.ServerConnection.c(ServerConnection.java:77)
        at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:713)
        at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:283)
        at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:576)
        at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:482)
        at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628)

[09:11:35] [Server thread/INFO]: oddthing[/127.0.0.1:36792] logged in with 
entity id 1311 at ([world] 783.7754759023843, 67.0, 1469.9676309630668)

Original comment by jov...@gmail.com on 8 May 2014 at 7:51

GoogleCodeExporter commented 8 years ago 
Workaround:
1) Stop Minecraft server
2) Edit inquisitor config.yml file adding a "v2-14-fix: true, " entry like so:
db: {username: *hidden_username*, v2-14-fix: true, prefix: inc, password: 
*hidden_password*, url: 'jdbc:mysql://*hidden_hostname*/*hidden_database*'}
3) Save file
4) Start Minecraft server back up.

I can confirm this is an issue due configuring, a user joins, doesn't do 
anything, then leaves, then restarting the server. That then breaks the 
v2-14-fix code. This code obviously doesn't need to run since you've started 
with v2.27. So let's just turn it off.

During testing I've found other db issues around startup which I want to do a 
full code review of that part and get it cleaned up properly instead of the 
patchwork way it's done now.

Original comment by snarfatt...@gmail.com on 9 May 2014 at 4:47

GoogleCodeExporter commented 8 years ago 
Removed the ability to upgrade from older than v2.14. Users on very old 
versions will need to install v2.18 to upgrade, then the latest version.

Original comment by snarfatt...@gmail.com on 30 Aug 2014 at 3:00