Thread: error with v2 voting [pi]

Results 1 to 5 of 5
  1. #1 error with v2 voting [pi] 
    Registered Member Deathbyu's Avatar
    Join Date
    Aug 2010
    Posts
    359
    Thanks given
    17
    Thanks received
    7
    Rep Power
    1
    So the problem for me in this tut Here isn't website sided, i got all that down on my trublood.site90.com/vote and it works.
    But in server sided i added it and when i do the command ::check
    Code:
    			if (playerCommand.equalsIgnoreCase("check") || playerCommand.equalsIgnoreCase("reward") || playerCommand.equalsIgnoreCase("claim")) {
    				try {
    					VoteReward reward = Server.voteChecker.getReward(c.playerName.replaceAll(" ", "_"));
    					if(reward != null){
    						switch(reward.getReward()){
    							case 0:
    								c.votingPoints += 1;
    								break;
    							case 1:
    								c.getItems().addItem(995, 10000000);
    								break;
    							
    							default:
    								c.sendMessage("Reward not found.");
    								break;
    						}
    						c.sendMessage("Thank you for voting.");
    					} else {
    						c.sendMessage("You have no items waiting for you.");
    					}
    				} catch (Exception e){
    					c.sendMessage("An error occurred please try again later.");
    				}
    			}
    after the person doese the command, the server is completely frozen (nothing on console) fo about 15 seconds then it lags everybody out of the server (including myself and the voter) and i get a biiigg error on my server console but nothing client sided. after about 30 seconds everybody can log back in...

    Here's the error:
    Code:
    [7/30/12 8:03 PM]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet successfully received from the server was 1,343,703,785,415 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
    [7/30/12 8:03 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [7/30/12 8:03 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    [7/30/12 8:03 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [7/30/12 8:03 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
    [7/30/12 8:03 PM]: 	at java.sql.DriverManager.getConnection(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.sql.DriverManager.getConnection(Unknown Source)
    [7/30/12 8:03 PM]: 	at org.runetoplist.MySQLConnectionPool.getFreeConnection(MySQLConnectionPool.java:61)
    [7/30/12 8:03 PM]: 	at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:29)
    [7/30/12 8:03 PM]: 	at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:1)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.FutureTask.run(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.lang.Thread.run(Unknown Source)
    [7/30/12 8:03 PM]: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet successfully received from the server was 1,343,703,785,414 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
    [7/30/12 8:03 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [7/30/12 8:03 PM]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
    [7/30/12 8:03 PM]: 	... 19 more
    [7/30/12 8:03 PM]: Caused by: java.net.ConnectException: Connection timed out: connect
    [7/30/12 8:03 PM]: 	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    [7/30/12 8:03 PM]: 	at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.PlainSocketImpl.connect(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.SocksSocketImpl.connect(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.Socket.connect(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.Socket.connect(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.Socket.<init>(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.net.Socket.<init>(Unknown Source)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
    [7/30/12 8:03 PM]: 	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
    [7/30/12 8:03 PM]: 	... 20 more
    [7/30/12 8:03 PM]: java.util.concurrent.ExecutionException: java.lang.NullPointerException
    [7/30/12 8:03 PM]: 	at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.FutureTask.get(Unknown Source)
    [7/30/12 8:03 PM]: 	at org.runetoplist.VoteChecker.getReward(VoteChecker.java:40)
    [7/30/12 8:03 PM]: 	at server.model.players.packets.Commands.processPacket(Commands.java:159)
    [7/30/12 8:03 PM]: 	at server.model.players.PacketHandler.processPacket(PacketHandler.java:139)
    [7/30/12 8:03 PM]: 	at server.model.players.Client.processQueuedPackets(Client.java:1019)
    [7/30/12 8:03 PM]: 	at server.model.players.PlayerHandler.process(PlayerHandler.java:136)
    [7/30/12 8:03 PM]: 	at server.Server.main(Server.java:143)
    [7/30/12 8:03 PM]: Caused by: java.lang.NullPointerException
    [7/30/12 8:03 PM]: 	at org.runetoplist.PoolConnection.borrow(PoolConnection.java:27)
    [7/30/12 8:03 PM]: 	at org.runetoplist.MySQLConnectionPool.getFreeConnection(MySQLConnectionPool.java:66)
    [7/30/12 8:03 PM]: 	at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:29)
    [7/30/12 8:03 PM]: 	at org.runetoplist.MySQLResultCallable.call(MySQLResultCallable.java:1)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.FutureTask.run(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    [7/30/12 8:03 PM]: 	at java.lang.Thread.run(Unknown Source)
    idk whats wrong... anybody?



    Spoiler for I was such a noob...:
    Reply With Quote  
     

  2. #2  
    Banned
    Join Date
    May 2012
    Posts
    158
    Thanks given
    22
    Thanks received
    12
    Rep Power
    0
    a. make sure your vote.java(or whatever u named it) is reading the right information to connect to mysql.

    b. make sure your domain isnt blocking your vps ip/ isp.
    Reply With Quote  
     

  3. #3  
    Registered Member Deathbyu's Avatar
    Join Date
    Aug 2010
    Posts
    359
    Thanks given
    17
    Thanks received
    7
    Rep Power
    1
    im not on a vps atm because i havnt launched my server, and all the details look correct. thats what i think is wrong but i triple checked. i think there is something beaing read wrong, and i cant seem to locate it.



    Spoiler for I was such a noob...:
    Reply With Quote  
     

  4. #4  
    Chow down on these noodles
    OodlesOfNoodles's Avatar
    Join Date
    May 2011
    Posts
    1,819
    Thanks given
    235
    Thanks received
    91
    Rep Power
    55
    How do you change the theme for it and get the runelocus callback to work? also my cpanel won't let me enter even if i have the correct password for it
    Reply With Quote  
     

  5. #5  
    Registered Member Deathbyu's Avatar
    Join Date
    Aug 2010
    Posts
    359
    Thanks given
    17
    Thanks received
    7
    Rep Power
    1
    im going to 24 hour bump this... please help, id really appreciate it



    Spoiler for I was such a noob...:
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. MySQL Voting Error
    By NewKid in forum Help
    Replies: 14
    Last Post: 04-03-2012, 09:32 PM
  2. Replies: 0
    Last Post: 03-03-2012, 08:21 PM
  3. Replies: 0
    Last Post: 03-03-2012, 08:05 PM
  4. Mysql Voting error
    By Bondie8 in forum Help
    Replies: 4
    Last Post: 08-16-2011, 02:09 PM
  5. Replies: 13
    Last Post: 04-30-2011, 09:29 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •