Players table doesnt exist

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Player logs in, error shows up in console
2. Some data, like time played, isnt getting recorded correctly in Inquisitor
3.

What is the expected output? What do you see instead?
Play Time gets logged, no errors

What version of the product are you using? On what operating system?
2.2.7

Please provide any additional information below.
Inquisitor constantly complains that the players table is missing, but it isnt. 
It isnt accepting the table prefix that is configured in the config file. So 
yes the database.players table doesnt exist, but it is supposed to be using the 
table prefix from the config and looking for database.stats_players .... but it 
isnt. Not sure if this is a known issue or not, here is a copy of the error: 
http://pastebin.com/aBp4eq1g

Original issue reported on code.google.com by Chris.Gr...@gmail.com on 21 Aug 2014 at 8:43

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

No i do not have a . in there at all. My prefix is set as "stat_"

And the prefix is working on every table, except players.

Original comment by Chris.Gr...@gmail.com on 29 Aug 2014 at 2:06

[GoogleCodeExporter]

So you can see earlier in the log where it created the tables with the 
stats_players name?

Also, this is still a defect, make sure to stop the server, add that extra 
value in your config:
http://www.spigotmc.org/threads/inquisitor.12057/page-4#post-186521

Original comment by snarfatt...@gmail.com on 29 Aug 2014 at 2:07

[GoogleCodeExporter]

Its not looking for stat_players ... that is the problem

9:05:18 PM CONSOLE: ERROR]: [Inquisitor] OnPlayerJoin Exception message: Table 
'clientdb.players' doesn't exist

As you can see in the error. It is looking for clientdb.players and not 
clientdb.stat_players.

Ill have to wait for the owner to verify that stat_players exists, but 
inquisitor had worked before, so i cant imagine that the table doesnt exist. 
Also, I will try that config change and see if it makes a difference. 

Original comment by Chris.Gr...@gmail.com on 29 Aug 2014 at 2:11

[GoogleCodeExporter]

Actually, looks like it is already set

webServer: {port: 8081, enabled: true}
global: null
db: {v2-14-fix: true, password: '********', prefix: stat_, url: 
'jdbc:mysql://127.0.0.1:3306/clientdb',
    username: 'username'}

I modified the password, username, and database name in the above copy/paste 
just for security's sake :)

Original comment by Chris.Gr...@gmail.com on 29 Aug 2014 at 2:14

[GoogleCodeExporter]

Can you add quotes around the prefix? prefix: 'stat_',

Original comment by snarfatt...@gmail.com on 29 Aug 2014 at 2:23

[GoogleCodeExporter]

i think i tried that and it auto removed the quotes. but ill try it again. 

Original comment by Chris.Gr...@gmail.com on 29 Aug 2014 at 3:00

[GoogleCodeExporter]

I made the change and it did not get reverted. But when i rebooted the server, 
the issue persists. 

Original comment by Chris.Gr...@gmail.com on 29 Aug 2014 at 3:08

[GoogleCodeExporter]

The change to the file would need to be made with the server off. Or you can 
execute the following command with OP privilege: 

inq db set prefix stat_

Original comment by jverb...@gmail.com on 29 Aug 2014 at 3:19

[GoogleCodeExporter]

i ran the command, it said it completed successfully, but i still get the 
errors when a player logs in. 

Also, it is not recording player info. Notice on the page here for my 
character, it says the last time i joined was June 28. But it also says my last 
quit was today.
http://server.skgaming.net:8081/player/Sharrq27

Also, this player logged in after i made the change, yet it says he has never 
logged in, but has quit today
http://server.skgaming.net:8081/player/Duke1782

Original comment by Chris.Gr...@gmail.com on 29 Aug 2014 at 3:34

[GoogleCodeExporter]

OK, I'll load this up in my test server tomorrow and figure it out.

Original comment by snarfatt...@gmail.com on 29 Aug 2014 at 4:01

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

fixed

Original comment by snarfatt...@gmail.com on 30 Aug 2014 at 2:50

• Changed state: Fixed