ChestShop (iConomyChestShop)

30 - sql errors when using chestshop with updated iconomy and chestshop (previously iconomychestshop, right?)

What steps will reproduce the problem?
1. trying to write to sql when it did not previously
2. updated from the last version 1.8.1 to the new one and it's now throwing up errors saying it can't write to sql
3. it never threw up that message before, but i'd rather install the sql if i could figure it out.

What is the expected output? What do you see instead?
no error when using chest shops

What version of the plugin are you using? (/csversion)
3.29

What version of the CraftBukkit are you using? (/version)
1.0.1 (1597)

What economy plugin are you using? (iConomy, BOSEconomy, etc?)
iConomy

Do you have an error log of what happened?
Database Error: java.sql.SQLException No suitable driver found for jdbc:mysql:\\localhost:3306\iConomy

Please provide any additional information below.
My config is below
# iConomy 5.0
# %author     Nijikokun <nijikokun@gmail.com>
# %license    GPLv2
# %copyright  Copyright AniGaiku LLC (C) 2010-2011
##
# Setup Notes
#   - Default
#     This node consists of all the 'default' data.
#   - Formatting
#     Allows you to control the output of how you will
#     see the currency in-game with the major/minor features.
#   - Banking
#     Allows users to store money in a seperate location as
#     well as transfer from bank to bank between users
#     - Multiple
#       Allows users to create multiple accounts with banks
#     - Q & A
#       Q: Why?
#       A: Money on hand can be lost, money in banks should not
#           be altered upon plugin specifictions in iConomy 5.0
#   - Interest amount is done in seconds.
#     - Online
#       If only true, only one bank / account will recieve money for that player.
#       If only false, it will go through each bank / account and deposit money.
#     - Announce
#       Sends message each time a player recieves money.
#     - Amount
#       - On
#         Each time interest runs you can either deposit the money into a bank (Interest)
#         or directly into a players holdings (Wage).
#     - Interval
#       - Seconds
#         Basic Table:
#           1 minute = 60 seconds
#           1 hour = 1 minute * 60 = 3600 seconds
#           1 day = 1 hour * 24 = 86400 seconds
#           1 week = 1 day * 7 = 604800 seconds
#   - Database
#     - Type
#       Can only be h2 or MySQL, no longer supports SQLite.
#     - Settings
#       If you choose h2, only the first two are needed, do not alter MySQL.
#       - MySQL
#         Do not use remote databases from free sites, please use either a
#          remote database from a personal hosted VPS or DEDI or a local
#          database. This will prevent any 'timeout' or 'invalid settings'
#          or 'cannot connect to database' issues. Thank you :)!
##

System:
    Default:
        Currency:
            Major: [ 'Gold', 'Gold' ]                # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
            Minor: [ 'Silver', 'Silver' ]                    # Minor (Major.[Minor]) 0.23 Coins  (With Seperate 0 Dollars, 23 Coins)
        Account:
            Holdings: 100.0                            # Default holdings on hand upon join / creation.
        Bank:
            Name: Rothschild                             # Default Bank Name
            Currency:
                Major: [ 'Gold', 'Gold' ]
                Minor: [ 'Silver', 'Silver' ]
            Account:
                Fee: 0.0                             # Default cost to register an account
                Holdings: 100.0                        # Default initial account holdings
    Formatting:
        Minor: false                                  # Example (true) 0.23 Coins and 1.23 Dollars (false) 0.23 Dollars and 1.23 Dollars
        Seperate: false                               # Example (true) 1 Dollar, 23 Coins (false) 1.23 Dollars (Only if Minor is true)
    Logging:
        Enabled: false                                # Logs transactions done inside iConomy only, other plugins must utilize the api. (Logs to SQL)
    Banking:
        Enabled: false
        Accounts:
            Multiple: true
    Interest:
        Enabled: false
        Online: true                                  # Only give to players who are online?
        Announce:
            Enabled: false
        Interval:
            Seconds: 60
        Amount:
            Cutoff: 0.0                               # Amount limit to be met until we stop giving interest. (0.0 for no limit)
            On: 'Players'                             # Banks or Players
            Percent: 0.0                              # Percent of holdings to give / take (Negative to take) (Overrides Min/Max)
            Maximum: 1                                # (Range) Maximum amount for random in between. (Make Max/Min equal for a flat-rate amount ie: 5/5)
            Minimum: 2                                # (Range) Minimum amount for random in between.
    Database:
        Type: 'H2SQL'                                 # H2 or MySQL
        Settings:
          Name: 'minecraft'
          Table: 'iConomy'
          MySQL:
              Username: 'root'
              Password: 'pass'
              Hostname: 'localhost'
              Port: 3306

User When Change
spydercanopus Dec 13, 2011 at 10:59 UTC
spydercanopus Dec 13, 2011 at 09:52 UTC Create

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

  • 1 comment
  • Avatar of spydercanopus spydercanopus Dec 13, 2011 at 10:59 UTC - 0 likes

    I deleted the old folder in plugins and it works again. Thanks for a cool plugin.

    Close ticket

  • 1 comment

Facts

Last updated
Dec 13, 2011
Reported
Dec 13, 2011
Status
Invalid - This was not a valid report.
Type
Defect - A shortcoming, fault, or imperfection
Priority
Medium - Normal priority.
Votes
0

Reported by

Possible assignees