Malformed Query? #30


  • Defect
  • Replied
Open
Assigned to _ForgeUser2779866
  • _ForgeUser2694929 created this issue Jan 18, 2012

    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 Connection
    2012-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.

  • _ForgeUser2694929 added the tags New Defect Jan 18, 2012
  • _ForgeUser7441580 posted a comment Jan 25, 2012

    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.


    Edited Jan 25, 2012
  • _ForgeUser2694929 posted a comment Feb 5, 2012

    can you fix this?

  • _ForgeUser6944000 posted a comment Feb 21, 2012

    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.

  • _ForgeUser2779866 posted a comment Feb 27, 2012

    Please try v2.0.7.

  • _ForgeUser2779866 removed a tag New Feb 27, 2012
  • _ForgeUser2779866 added a tag Waiting Feb 27, 2012
  • _ForgeUser7536780 posted a comment Mar 20, 2012

    Get his also. i guess its becuase my db name is 'muezli-server.com'

    Please fix.

  • _ForgeUser7536780 removed a tag Waiting Mar 20, 2012
  • _ForgeUser7536780 added a tag Replied Mar 20, 2012

To post a comment, please login or register a new account.