Plugin attempts to create tables that already exist #109


  • New
  • Defect
Open
Assigned to _ForgeUser2623578
  • _ForgeUser8957619 created this issue Jul 29, 2013

    === What steps will reproduce the problem? Consider taking pictures or videos if your problem is hard to explain  ===

    After converting the plugin to use MySQL, and letting it run the first time, I, of course, went back and removed a lot of the database permissions that the CRCR user had (as any responsible DBA should do). Once all the tables have been created, there shouldn't be any need for anything other than SELECT/INSERT/UPDATE/DELETE needed on those tables.

    However... Even after all the tables have been created, the plugin still attempts to create them when initializing.... The plugin should recognize that all schema is already in place and not attempt to recreate the tables each time it initializes.

    === What is the expected output? What do you see instead? ===
    Expected output:  No errors
    What I see:
    ...
    2013-07-29 04:00:22 [INFO] [CreativeControl] Enabling CreativeControl v6.4
    2013-07-29 04:00:22 [INFO] [CreativeControl]: Initializing configurations...
    2013-07-29 04:00:22 [INFO] [CreativeControl]: Loading Modules...
    2013-07-29 04:00:22 [INFO] [CreativeControl]: Connecting to the MySQL database...
    2013-07-29 04:00:22 [INFO] [CreativeControl]: MySQL database connected Successfuly!
    2013-07-29 04:00:22 [INFO] CREATE command denied to user 'CrcrUser'@'sql_server' for table 'crcr_internal'
    2013-07-29 04:00:22 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-22-444.txt
    2013-07-29 04:00:22 [INFO] Failed to create `crcr_groups` table
    2013-07-29 04:00:22 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-22-512.txt
    2013-07-29 04:00:22 [INFO] Failed to create `crcr_players` table
    2013-07-29 04:00:22 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-22-575.txt
    2013-07-29 04:00:22 [INFO] Failed to create `crcr_players_adventurer` table
    2013-07-29 04:00:22 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-22-673.txt
    2013-07-29 04:00:22 [INFO] Failed to create `crcr_players_survival` table
    2013-07-29 04:00:22 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-22-734.txt
    2013-07-29 04:00:22 [INFO] Failed to create `crcr_players_creative` table
    2013-07-29 04:00:23 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-22-796.txt
    2013-07-29 04:00:23 [INFO] Failed to create `crcr_blocks_world` table
    2013-07-29 04:00:23 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-23-613.txt
    2013-07-29 04:00:23 [INFO] Failed to create `crcr_blocks_world_nether` table
    2013-07-29 04:00:24 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-23-990.txt
    2013-07-29 04:00:24 [INFO] Failed to create `crcr_blocks_world_the_end` table
    2013-07-29 04:00:24 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-24-106.txt
    2013-07-29 04:00:24 [INFO] Failed to create `crcr_regions` table
    2013-07-29 04:00:24 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-24-222.txt
    2013-07-29 04:00:24 [INFO] [CreativeControl]: Failed to create `crcr_friends` table
    2013-07-29 04:00:24 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-24-282.txt
    2013-07-29 04:00:24 [INFO] [CreativeControl]: Failed to create `crcr_internal` table
    2013-07-29 04:00:24 [INFO] [CreativeControl]: This error is avaliable at: plugins/CreativeControl/error/error-29-07-2013-04-00-24-342.txt
    2013-07-29 04:00:24 [INFO] [CreativeControl]: Registring Events...
    2013-07-29 04:00:24 [INFO] [CreativeControl]: Vault hooked as permissions plugin
    2013-07-29 04:00:24 [INFO] [CreativeControl]: CreativeControl v6.4 loaded in 2,338 ms!

    === What version of the product are you using? [Latest is not a version] ===
    CreativeControl v6.4

    === Do you have an error log? This plugin also generates logs, they can be found at /plugins/CreativeControl/errors/ ===
    I have them all.  However, I'm not going to post them all here.  The root of the problem is that after the initial setup, the "CREATE" permission was removed from the user.

    === Please provide any additional information below. ===

    Please update the plugin to check for the existence of the tables, before trying to create them.  No DBA would give the database user CREATE permissions permanently.

  • _ForgeUser8957619 added the tags New Defect Jul 29, 2013

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