[WEB] Webchat v2.0 - Chat with the game on the web [1317]

Discussion in 'Inactive/Unsupported Plugins' started by Q.from.the.continuum, Aug 5, 2011.

  1. Webchat - Chat with the game on the website.

    Version: v2.0

    On this page you will see action this plugin: http://q-minecraft.pl

    [​IMG]


    Installation
    1. Extract the archive.
    2. Move chat2 to the directory web page. In the place where you want to have a chat add
      Code:
      <?php include 'chat2/index.php'; ?>
    3. You need to edit settings.php.
    4. Move WebChat.jar to the plugin folder in your bukkit serwer.
    5. Reload server, You'll see the errors is normal. Stop the server and edit a configuration file.
    6. You need to create a database in mysql: chatMC or change database in settings.
    7. Run server.
    I moved this topic here: http://dev.bukkit.org/server-mods/webchat/
    Please do not post in this topic, I will not update it or answer the questions in it.



    Download: http://q-serw.pl/storage/chat2.0.rar
    Version 2.0 may have some errors. I will try to fix them in version 2.1

    Changelog:

    Version 2.0
    • Plugin is written in Java.
    • Added sql file.
    • Added a basic css file.
    • Added ability to write from the website.
    • Fixed display of duplicate messages.
    • Improved code readability.
    Version 1.1
    • Fixed bugs related with mysql
    Version 1.0
    • First release.
    Features:

    • Adding possibilities of writing a chat with the website.
    • Writing the code more accessible
    • Adding a sample template css.
     
  2. Offline

    DemonCraft

    I would like you to post a link of your website using this or something, I'm not going to use it unless I know what it looks like and such.
     
  3. @DemonCraft
    http://q-minecraft.pl/

    @GeekPlaya
    I can not write in Java. It was only going to learn.
    Webchat will be for sure my first plugin in Java.

    If anyone uses this plugin on your site is very please link.
     
  4. Offline

    Iso

    Could you please add a register system?
    That you type ingame /chatregister <password> and online you logg in with your ingame-name and you <password>
     
  5. @up
    I'm going to introduce support for registering on the website. For example, you log on the Site as a User, and what you write on the part of the game will be seen as: [WEB] <user> content.
    But that's just when to write a plugin in Java.
     
  6. Offline

    MJRamon

    Python, Prototype? Ahh... Too bad.
    I wish it didn't use Python and used jQuery
     
  7. @MJRamon
    Wait 1-2 weeks. Already written in Java plugin.
    And beyond the technical limitations like the idea?
     
  8. Offline

    ONeill

    This is one of the best and most useful plugins for any website with a server =) Thank you for that!
    I would also love to see this working without any requirements, just java / php / javascrit / jquery or things like that :D
    I will try this later on my page and hope you get an update in the near future :D
    +1 for you =)
     
  9. Offline

    Iso

  10. @lso
    No plans to develop plug-in that direction. This is a simple plugin to be so simple to be easy to modify and change.
    I'm going to add the possibility of writing by registered players on the website.

    Just that the webmaster, assign to variable variable from the loginchat.
    Code:
    $_SESSION["loginChat"]=$_SESSION["login"]
     
  11. Offline

    Moovlin

    Ive been following this thread since relase and I cant wait to see it in Java! best of luck!
     
  12. Offline

    BlancoLanda

    I get this error:

    Code:
    22:44:59 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab
    le 'craftes_phpbb.chat2' doesn't exist
    22:44:59 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    22:44:59 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (NativeConstructorAccessorImpl.java:57)
    22:44:59 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(DelegatingConstructorAccessorImpl.java:45)
    22:44:59 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Constructor
    .java:525)
    22:44:59 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    22:44:59 [SEVERE]       at com.mysql.jdbc.Util.getInstance(Util.java:382)
    22:44:59 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1052)
    22:44:59 [SEVERE]       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3593)
    22:44:59 [SEVERE]       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3525)
    22:44:59 [SEVERE]       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    
    22:44:59 [SEVERE]       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    40)
    22:44:59 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2620)
    22:44:59 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2570)
    22:44:59 [SEVERE]       at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
    pl.java:1474)
    22:44:59 [SEVERE]       at WebChat.WebChat.readingFromTheWebsite(WebChat.java:12
    4)
    22:44:59 [SEVERE]       at WebChat.WebChat$watki.run(WebChat.java:182)
    22:44:59 [SEVERE]       at java.lang.Thread.run(Thread.java:722)
    I already configured MySQL settings, at server and at .php file. What's the problem?
     
  13. @BlancoLanda
    Probably not have created a table in the database.
    Plugin does not work well with some plugins to colorize chat.
    Working on this
     
  14. Offline

    gartral

    Where does the contents of chat2.sql go?

    [Edit] also, i set up a database chat, but i get a BUNCH of errors from it in the sever..

    Code:
    2011-10-11 23:16:41 [INFO] Starting minecraft server version Beta 1.8.1
    2011-10-11 23:16:41 [INFO] Loading properties
    2011-10-11 23:16:42 [INFO] Starting Minecraft server on *:25565
    2011-10-11 23:16:42 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1112-g54a13b2-b1240jnks (MC: 1.8.1)
    2011-10-11 23:16:43 [INFO] [LogBlock] Version check: Your version is up to date
    2011-10-11 23:16:43 [INFO] [LogBlock] Connecting to root@jdbc:mysql://localhost:3306/minecraftnew...
    2011-10-11 23:16:44 [INFO] Spout 1.0.6.403 has been initialized
    2011-10-11 23:16:44 [INFO] Preparing level "world"
    2011-10-11 23:16:44 [INFO] Default game type: 0
    2011-10-11 23:16:44 [INFO] Preparing start region for level 0 (Seed: 2622290174383282006)
    2011-10-11 23:16:45 [INFO] Preparing spawn area: 44%
    2011-10-11 23:16:46 [INFO] Preparing start region for level 1 (Seed: 2622290174383282006)
    2011-10-11 23:16:46 [INFO] Preparing spawn area: 0%
    2011-10-11 23:16:47 [INFO] Preparing spawn area: 65%
    2011-10-11 23:16:48 [INFO] CommandBook 1.6 enabled.
    2011-10-11 23:16:48 [WARNING] CommandBook: 0 Warps(s) loaded
    2011-10-11 23:16:48 [WARNING] CommandBook: 0 Homes(s) loaded
    2011-10-11 23:16:48 [INFO] CommandBook: Maximum wrapper compatibility is enabled. Some features have been disabled to be compatible with poorly written server wrappers.
    2011-10-11 23:16:48 [INFO] CommandBook: 0 banned name(s) loaded.
    2011-10-11 23:16:48 [INFO] CommandBook: 1 kit(s) loaded.
    2011-10-11 23:16:48 [INFO] CommandBook: Using the Bukkit Permissions API.
    2011-10-11 23:16:48 [INFO] CraftBukkitUpToDate version 2.6.7 is enabled!
    2011-10-11 23:16:48 [INFO] CButD: Permission system not detected, defaulting to OP
    2011-10-11 23:16:48 [INFO] [CustomDifficulty] Loading Plugin: Multiverse-Core
    2011-10-11 23:16:48 [INFO] [Multiverse-Core] - Version 2.0-b279 Enabled - By Rigby and fernferret
    2011-10-11 23:16:48 [INFO] [AllPay] - Version 3.0 - using only an item based economy for Multiverse-Core v2.0-b279
    2011-10-11 23:16:48 [INFO] [Multiverse-Core] - Multiverse Config -- Loaded
    2011-10-11 23:16:48 [INFO] [Multiverse-Core] - World Config -- Loaded
    2011-10-11 23:16:48 [INFO] Preparing start region for level 2 (Seed: 1741803213)
    2011-10-11 23:16:48 [INFO] CButD: CraftBukkit is Outdate, try to download new version
    2011-10-11 23:16:49 [INFO] Preparing spawn area for Game, 65%
    2011-10-11 23:16:50 [INFO] [Multiverse-Core] Loading World & Settings - 'Game' - NORMAL
    2011-10-11 23:16:50 [INFO] [Multiverse-Core] Loading World & Settings - 'world' - NORMAL
    2011-10-11 23:16:50 [INFO] Preparing start region for level 3 (Seed: -8906921669300942338)
    2011-10-11 23:16:51 [INFO] Preparing spawn area for ruby, 77%
    2011-10-11 23:16:51 [INFO] [Multiverse-Core] Loading World & Settings - 'ruby' - NORMAL
    2011-10-11 23:16:51 [INFO] Preparing start region for level 4 (Seed: -6547077679567448445)
    2011-10-11 23:16:52 [INFO] Preparing spawn area for skyrealm, 89%
    2011-10-11 23:16:53 [INFO] [Multiverse-Core] Loading World & Settings - 'skyrealm' - SKYLANDS
    2011-10-11 23:16:53 [INFO] Preparing start region for level 5 (Seed: 1920585402)
    2011-10-11 23:16:54 [INFO] Preparing spawn area for RFTW, 48%
    2011-10-11 23:16:54 [INFO] [Multiverse-Core] Loading World & Settings - 'RFTW' - NORMAL
    2011-10-11 23:16:54 [INFO] Preparing start region for level 6 (Seed: 3433174)
    2011-10-11 23:16:55 [INFO] Preparing spawn area for test, 89%
    2011-10-11 23:16:56 [INFO] [Multiverse-Core] Loading World & Settings - 'test' - NORMAL with seed: 3433174
    2011-10-11 23:16:56 [INFO] Preparing start region for level 7 (Seed: 1920585402)
    2011-10-11 23:16:57 [INFO] Preparing spawn area for RFTW2, 20%
    2011-10-11 23:16:58 [INFO] [Multiverse-Core] Loading World & Settings - 'RFTW2' - NORMAL
    2011-10-11 23:16:58 [INFO] [Multiverse-Core] 7 - World(s) loaded.
    2011-10-11 23:16:58 [INFO] WorldGuard: Using the Bukkit Permissions API.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world) Lava fire is blocked.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world) All fire spread is disabled.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'world"
    2011-10-11 23:16:58 [INFO] WorldGuard: (world_nether) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world_nether) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world_nether) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] The automatic update-Check only work every 6 hours, the last check was 10 minutes ago.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world_nether) Lava fire is blocked.
    2011-10-11 23:16:58 [INFO] WorldGuard: (world_nether) All fire spread is disabled.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'world_nether"
    2011-10-11 23:16:58 [INFO] WorldGuard: (Game) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (Game) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (Game) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (Game) Lava fire is blocked.
    2011-10-11 23:16:58 [INFO] WorldGuard: (Game) All fire spread is disabled.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'Game"
    2011-10-11 23:16:58 [INFO] WorldGuard: (ruby) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (ruby) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (ruby) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (ruby) Lava fire is blocked.
    2011-10-11 23:16:58 [INFO] WorldGuard: (ruby) All fire spread is disabled.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'ruby"
    2011-10-11 23:16:58 [INFO] WorldGuard: (skyrealm) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (skyrealm) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (skyrealm) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (skyrealm) Lava fire is blocked.
    2011-10-11 23:16:58 [INFO] WorldGuard: (skyrealm) All fire spread is disabled.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'skyrealm"
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW) Lava fire is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW) Fire spread is UNRESTRICTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'RFTW"
    2011-10-11 23:16:58 [INFO] WorldGuard: (test) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (test) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (test) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (test) Lava fire is blocked.
    2011-10-11 23:16:58 [INFO] WorldGuard: (test) All fire spread is disabled.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'test"
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW2) Single session is enforced.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW2) TNT ignition is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW2) Lighters are PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW2) Lava fire is PERMITTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: (RFTW2) Fire spread is UNRESTRICTED.
    2011-10-11 23:16:58 [INFO] WorldGuard: Loaded configuration for world 'RFTW2"
    2011-10-11 23:16:58 [INFO] WorldGuard: 1 regions loaded for 'world'
    2011-10-11 23:16:58 [WARNING] WorldGuard: Region file for world "world_nether" missing or inaccessible.
    2011-10-11 23:16:58 [INFO] WorldGuard: 1 regions loaded for 'Game'
    2011-10-11 23:16:58 [WARNING] WorldGuard: Region file for world "ruby" missing or inaccessible.
    2011-10-11 23:16:58 [WARNING] WorldGuard: Region file for world "skyrealm" missing or inaccessible.
    2011-10-11 23:16:58 [WARNING] WorldGuard: Region file for world "RFTW" missing or inaccessible.
    2011-10-11 23:16:58 [WARNING] WorldGuard: Region file for world "test" missing or inaccessible.
    2011-10-11 23:16:58 [WARNING] WorldGuard: Region file for world "RFTW2" missing or inaccessible.
    2011-10-11 23:16:58 [INFO] WorldGuard 5.3 enabled.
    2011-10-11 23:16:58 [INFO] [CustomDifficulty] Hooked into WorldGuard v5.3.
    2011-10-11 23:16:58 [INFO] [CustomDifficulty] Found the following 1 difficulties:
    default.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Couldn't hook into Permissions!
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Couldn't hook into Register!
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world world. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world world_nether. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world Game. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world ruby. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world skyrealm. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world RFTW. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world test. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [WARNING] [CustomDifficulty] Spawning will not be activated for world RFTW2. World's difficulty is invalid and ignoring is disabled.
    2011-10-11 23:16:58 [INFO] [CustomDifficulty] MobListCleanup activated.
    2011-10-11 23:16:58 [INFO] [CustomDifficulty] Mob counter started.
    2011-10-11 23:16:58 [INFO] [CustomDifficulty] version 4.5.0 (for CB: 1240) has been enabled. (10529.52ms)
    2011-10-11 23:16:58 [INFO] Lockette version 1.4.4 is being enabled!  Yay!  (Core version 1.2.3)
    2011-10-11 23:16:58 [INFO] Lockette: Detected craftbukkit build [1240] ok.
    2011-10-11 23:16:58 [INFO] Lockette: Using ops file for admin permissions.
    2011-10-11 23:16:58 [INFO] Lockette: Ready to protect your containers.
    2011-10-11 23:16:58 [INFO] [MobDisguise] by desmin88 version 1.63 enabled.
    2011-10-11 23:16:58 [INFO] [MultiInv] version 2.3.2 is enabled!
    2011-10-11 23:16:58 [INFO] [MultiInv] Permission system not enabled. Using ops.txt
    2011-10-11 23:16:59 [INFO] [MultiVerse-NetherPortals] - Version 2.0-b225 Enabled - By Rigby and fernferret
    2011-10-11 23:16:59 [INFO] [MultiVerse-Portals] - Version 2.0-b254 Enabled - By Rigby and fernferret
    2011-10-11 23:16:59 [INFO] [MultiVerse-Portals]  16 - Portals(s) loaded
    2011-10-11 23:16:59 [INFO] [WebChat] Version 2.0 is enabled.
    2011-10-11 23:17:00 [INFO] WorldEdit 4.7 enabled.
    2011-10-11 23:17:00 [INFO] WorldEdit: Using the Bukkit Permissions API.
    2011-10-11 23:17:00 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    2011-10-11 23:17:00 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-10-11 23:17:00 [INFO] [MultiVerse-Portals]  Found WorldEdit. Using it for selections.
    2011-10-11 23:17:00 [INFO] [WorldRestore] version 0.2 is loading...
    2011-10-11 23:17:00 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:00 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:00 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-10-11 23:17:00 [INFO] [WorldRestore] Plugin start time: -165539685
    2011-10-11 23:17:00 [INFO] [WorldRestore] Worlds loaded: RFTW,RFTW2
    2011-10-11 23:17:00 [INFO] [WorldRestore] version 0.2 is enabled without permissions!
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-10-11 23:17:00 [INFO] [LogBlock] Permissions plugin not found. Using Bukkit Permissions.
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-10-11 23:17:00 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-10-11 23:17:00 [SEVERE]     at WebChat.WebChat.readingFromTheWebsite(WebChat.java:124)
    2011-10-11 23:17:00 [SEVERE]     at WebChat.WebChat$watki.run(WebChat.java:182)
    2011-10-11 23:17:00 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    2011-10-11 23:17:00 [INFO] [LogBlock] Scheduled consumer with bukkit scheduler.
    2011-10-11 23:17:00 [INFO] LogBlock v1.32 by DiddiZ enabled.
    2011-10-11 23:17:00 [INFO] Server permissions file permissions.yml is empty, ignoring it
    2011-10-11 23:17:00 [INFO] Done (1.600s)! For help, type "help" or "?"
    2011-10-11 23:17:03 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    2011-10-11 23:17:03 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-10-11 23:17:03 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:03 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:03 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-10-11 23:17:03 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-10-11 23:17:03 [SEVERE]     at WebChat.WebChat.readingFromTheWebsite(WebChat.java:124)
    2011-10-11 23:17:03 [SEVERE]     at WebChat.WebChat$watki.run(WebChat.java:182)
    2011-10-11 23:17:03 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    2011-10-11 23:17:06 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    2011-10-11 23:17:06 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-10-11 23:17:06 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:06 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:06 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-10-11 23:17:06 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-10-11 23:17:06 [SEVERE]     at WebChat.WebChat.readingFromTheWebsite(WebChat.java:124)
    2011-10-11 23:17:06 [SEVERE]     at WebChat.WebChat$watki.run(WebChat.java:182)
    2011-10-11 23:17:06 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    2011-10-11 23:17:09 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    2011-10-11 23:17:09 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-10-11 23:17:09 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:09 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:09 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-10-11 23:17:09 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-10-11 23:17:09 [SEVERE]     at WebChat.WebChat.readingFromTheWebsite(WebChat.java:124)
    2011-10-11 23:17:09 [SEVERE]     at WebChat.WebChat$watki.run(WebChat.java:182)
    2011-10-11 23:17:09 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    2011-10-11 23:17:12 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    2011-10-11 23:17:12 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-10-11 23:17:12 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:12 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:12 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-10-11 23:17:12 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-10-11 23:17:12 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-10-11 23:17:12 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-10-11 23:17:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-10-11 23:17:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-10-11 23:17:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-10-11 23:17:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-10-11 23:17:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-10-11 23:17:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-10-11 23:17:13 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-10-11 23:17:13 [SEVERE]     at WebChat.WebChat.readingFromTheWebsite(WebChat.java:124)
    2011-10-11 23:17:13 [SEVERE]     at WebChat.WebChat$watki.run(WebChat.java:182)
    2011-10-11 23:17:13 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    2011-10-11 23:17:16 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    2011-10-11 23:17:16 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-10-11 23:17:16 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:16 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:16 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-10-11 23:17:16 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-10-11 23:17:16 [SEVERE]     at WebChat.WebChat.readingFromTheWebsite(WebChat.java:124)
    2011-10-11 23:17:16 [SEVERE]     at WebChat.WebChat$watki.run(WebChat.java:182)
    2011-10-11 23:17:16 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    2011-10-11 23:17:17 [INFO] CONSOLE: Stopping the server..
    2011-10-11 23:17:17 [INFO] Stopping server
    2011-10-11 23:17:17 [INFO] [CustomDifficulty] Mob counter stopped.
    2011-10-11 23:17:17 [INFO] [CustomDifficulty] has been disabled.
    2011-10-11 23:17:17 [INFO] Lockette: Closing all automatic doors.
    2011-10-11 23:17:17 [INFO] [MobDisguise] by desmin88 version 1.63 disabled.
    2011-10-11 23:17:17 [INFO] [MultiInv] Plugin disabled.
    2011-10-11 23:17:17 [INFO] [Multiverse-Core] - Disabled
    2011-10-11 23:17:17 [INFO] [MultiVerse-NetherPortals] - Disabled
    2011-10-11 23:17:17 [INFO] [WebChat] is DISABLED!
    2011-10-11 23:17:17 [INFO] WorldGuard 5.3 disabled.
    2011-10-11 23:17:17 [INFO] [WorldRestore] version 0.2 is disabled!
    2011-10-11 23:17:17 [INFO] [LogBlock] Waiting for consumer ...
    2011-10-11 23:17:17 [INFO] [LogBlock] Remaining queue size: 1
    2011-10-11 23:17:17 [INFO] LogBlock disabled.
    2011-10-11 23:17:17 [INFO] Saving chunks
    2011-10-11 23:17:19 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    2011-10-11 23:17:19 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-10-11 23:17:19 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:19 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-10-11 23:17:19 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-10-11 23:17:19 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-10-11 23:17:19 [SEVERE]     at WebChat.WebChat.readingFromTheWebsite(WebChat.java:124)
    2011-10-11 23:17:19 [SEVERE]     at WebChat.WebChat$watki.run(WebChat.java:182)
    2011-10-11 23:17:19 [SEVERE]     at java.lang.Thread.run(Unknown Source)
     
  15. @gartral
    Code:
    2011-10-11 23:17:00 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'chatmc.chat2' doesn't exist
    The problem is obvious, the plugin does not see the table in the database.
    If you have created a database, do not use file, sql, php file he creates these tables.
     
  16. Offline

    gartral

    I have created the database, and keep having the same error, I haven't even gotten too getting my website set up with the php/css frontend for all this yet. the user i'm using using for WebChat is webchat, the database is called webchat.chat2. I have set up the config file in the /plugins/WebChat folder.. file follows:
    Code:
    #Minecraft Properties File
    #Tue Oct 11 23:06:27 EDT 2011
    port=3306
    user=webchat
    password=*************
    database=chatmc.chat2
    server=localhost
    please tell me what else I might be doing wrong
     
  17. @gartral
    If you have the same problem as predecessors, it means that you have something wrong with the table, most likely, has not been created.
    Php file responsible for the chat on the page itself should generate tables, if not please use the sql file, I added it as an alternative.
    Best to install a chat on the website, if it works it also bukkit plugin should work.
     

Share This Page