McftProfiler

8 - MySQL checks

What steps will reproduce the problem?
1. Restart the server...
2.
3.

What is the expected output? What do you see instead?
Would not expect out put...

What version of the plugin are you using?
1.1.6

Do you have an error log of what happened?
2012-01-13 05:20:06 [INFO] [McftProfiler] Connection to the MySQL server successful.
2012-01-13 05:20:06 [INFO] [McftProfiler] Creating MySQL tables 'notes', 'profiles', and 'iplog'.
2012-01-13 05:20:06 [SEVERE] [McftProfiler] MySQL: Table 'mcftpro_notes' already exists
2012-01-13 05:20:06 [SEVERE] [McftProfiler] MySQL: Table 'mcftpro_profiles' already exists
2012-01-13 05:20:06 [SEVERE] [McftProfiler] MySQL: Table 'mcftpro_iplog' already exists
2012-01-13 05:20:06 [SEVERE] [McftProfiler] MySQL: Table 'mcftpro_votelog' already exists
2012-01-13 05:20:06 [INFO] [McftProfiler] Updating MySQL tables for version 1.1.2.
2012-01-13 05:20:06 [WARNING] [McftProfiler] MySQL: Error in SQL query: Duplicate column name 'laston'
2012-01-13 05:20:06 [INFO] [McftProfiler] Updated successfully.
2012-01-13 05:20:06 [INFO] [McftProfiler] Updating MySQL tables for version 1.1.3
2012-01-13 05:20:06 [WARNING] [McftProfiler] MySQL: Error in SQL query: Duplicate column name 'reputation'

Please provide any additional information below.

Can you add a function to first check to see if the tables exist before trying to recreate them every time the server restarts? Also, address the other warnings.

Otherwise, so far so good.

User When Change
laCourj Jan 15, 2012 at 01:57 UTC
laCourj Jan 13, 2012 at 13:27 UTC
crohakon Jan 13, 2012 at 10:24 UTC Create

You must login to post a comment. Don't have an account? Register to get one!

  • 2 comments
  • Avatar of laCourj laCourj Jan 13, 2012 at 13:27 UTC - 0 likes

    This will be fixed in the release of version 1.1.7. I'll try to push out that update later today.

  • Avatar of crohakon crohakon Jan 13, 2012 at 10:26 UTC - 0 likes

    version correction... 1.1.6b

  • 2 comments

Facts

Last updated
Jan 15, 2012
Reported
Jan 13, 2012
Status
Fixed - Developer made requested changes. QA should verify.
Type
Defect - A shortcoming, fault, or imperfection
Priority
Medium - Normal priority.
Votes
0

Reported by

Possible assignees