This site works best with JavaScript enabled. Please enable JavaScript to get the best experience from this site.
What steps will reproduce the problem?1. Install Statistician latest version
What is the expected output? What do you see instead?I get:2012-01-18 20:09:54 [INFO] [Statistician] CALL minecraft-stats.newPlayer('3af66681-f84d-4f52-b38f-c5d26fb0aa44','lallypally1'); :: Stored Procedure Failed, Checking Connection2012-01-18 20:09:54 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
What version of the product are you using?
Do you have an error log of what happened?
Please provide any additional information below.
After hitting the wall with this myself and looking at a few different things I will explain my cause and what I think is the solution.
I was using a database called some-database-name. Now while the plugin would create the tables correctly it would not perform any of the stored procedures. I checked the structure against the SQL on github and all was correct.
I then noticed that the CALL database-name.proc() queries appeared to be missing back-quotes around the database name. I proved this by copying and manually executing the command from the plugin without back-quotes around the database name, and it failed, I then added the back-quotes and it executed without error...
So in short you should be executing CALL `database-name`.proc()
As a work around remove any -'s or any other non alphanumeric chars from the database name.
can you fix this?
To fix this after I changed machines I had to setup a new database and let it create the tables. Once that was done I imported the information that I wanted via CLI mysql. Seemed to work fine from there.
Please try v2.0.7.
Get his also. i guess its becuase my db name is 'muezli-server.com'
Please fix.
To post a comment, please login or register a new account.