Thread: Auto donate" Andy's" mysql error

Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1 Auto donate" Andy's" mysql error 
    Banned

    Join Date
    Oct 2012
    Posts
    4,716
    Thanks given
    1,682
    Thanks received
    1,105
    Rep Power
    0
    R-S Mod Response  Streetwave
    Edited out the database info, don't forget to remove it next time.


    Code:
    [5/4/14 11:52 PM]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Ta
    ble 'luzoxpkn_donations.itemstore' doesn't exist
    [5/4/14 11:52 PM]:      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    [5/4/14 11:52 PM]:      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (NativeConstructorAccessorImpl.java:62)
    [5/4/14 11:52 PM]:      at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [5/4/14 11:52 PM]:      at java.lang.reflect.Constructor.newInstance(Constructor
    .java:408)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.Util.getInstance(Util.java:381)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1030)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:956)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3536)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3468)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
    
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    07)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2642)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2571)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
    pl.java:1451)
    [5/4/14 11:52 PM]:      at net.utility.MysqlConnector.claimPayment(MysqlConnecto
    r.java:65)
    [5/4/14 11:52 PM]:      at net.packets.impl.Commands.processPacket(Commands.java
    :825)
    [5/4/14 11:52 PM]:      at net.packets.PacketHandler.processPacket(PacketHandler
    .java:180)
    [5/4/14 11:52 PM]:      at org.luzox.game.players.Client.processQueuedPackets(Cl
    ient.java:1583)
    [5/4/14 11:52 PM]:      at org.luzox.game.players.PlayerHandler.process(PlayerHa
    ndler.java:199)
    [5/4/14 11:52 PM]:      at org.luzox.game.Server$1.execute(Server.java:146)
    [5/4/14 11:52 PM]:      at org.luzox.event.Task.tick(Task.java:118)
    [5/4/14 11:52 PM]:      at org.luzox.event.TaskScheduler.run(TaskScheduler.java:
    104)
    [5/4/14 11:52 PM]:      at java.util.concurrent.Executors$RunnableAdapter.call(E
    xecutors.java:511)
    [5/4/14 11:52 PM]:      at java.util.concurrent.FutureTask.runAndReset(FutureTas
    k.java:308)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
    duledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
    duledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ThreadPoolExecutor.runWorker(Thr
    eadPoolExecutor.java:1142)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Th
    readPoolExecutor.java:617)
    [5/4/14 11:52 PM]:      at java.lang.Thread.run(Thread.java:744)
    [5/4/14 11:52 PM]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Ta
    ble 'luzoxpkn_donations.itemstore' doesn't exist
    [5/4/14 11:52 PM]:      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    [5/4/14 11:52 PM]:      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (NativeConstructorAccessorImpl.java:62)
    [5/4/14 11:52 PM]:      at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(DelegatingConstructorAccessorImpl.java:45)
    [5/4/14 11:52 PM]:      at java.lang.reflect.Constructor.newInstance(Constructor
    .java:408)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.Util.getInstance(Util.java:381)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1030)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:956)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3536)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3468)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
    
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    07)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2642)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2571)
    [5/4/14 11:52 PM]:      at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
    pl.java:1451)
    [5/4/14 11:52 PM]:      at net.utility.MysqlConnector.claimPayment(MysqlConnecto
    r.java:65)
    [5/4/14 11:52 PM]:      at net.packets.impl.Commands.processPacket(Commands.java
    :825)
    [5/4/14 11:52 PM]:      at net.packets.PacketHandler.processPacket(PacketHandler
    .java:180)
    [5/4/14 11:52 PM]:      at org.luzox.game.players.Client.processQueuedPackets(Cl
    ient.java:1583)
    [5/4/14 11:52 PM]:      at org.luzox.game.players.PlayerHandler.process(PlayerHa
    ndler.java:199)
    [5/4/14 11:52 PM]:      at org.luzox.game.Server$1.execute(Server.java:146)
    [5/4/14 11:52 PM]:      at org.luzox.event.Task.tick(Task.java:118)
    [5/4/14 11:52 PM]:      at org.luzox.event.TaskScheduler.run(TaskScheduler.java:
    104)
    [5/4/14 11:52 PM]:      at java.util.concurrent.Executors$RunnableAdapter.call(E
    xecutors.java:511)
    [5/4/14 11:52 PM]:      at java.util.concurrent.FutureTask.runAndReset(FutureTas
    k.java:308)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
    duledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
    duledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ThreadPoolExecutor.runWorker(Thr
    eadPoolExecutor.java:1142)
    [5/4/14 11:52 PM]:      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Th
    readPoolExecutor.java:617)
    [5/4/14 11:52 PM]:      at java.lang.Thread.run(Thread.java:744)
    Could anyone help me idk what i did wrong either its website or server

    This is the website db

    Code:
    <?php
    // MYSQL Connecter - Created By Andrew Sampson: [email protected] ; codeusa.net
    $conn = mysql_connect("localhost", "Edited out", "Edited out");
    mysql_select_db('luzoxpkn_donations', $conn);
    ?>
    Server sided connection

    Code:
    	public static void createConnection() {
    		try {
    			Class.forName("com.mysql.jdbc.Driver").newInstance();
    
    			connection = DriverManager.getConnection("jdbc:mysql://Edited out", "Edited out ","Edited out");
    		} catch (Exception e) {
    			e.printStackTrace();
    		}
    
    	}
    The database also its 0,00mb



    my skype vanelderen.patrick
    Last edited by Streetwave; 05-05-2014 at 04:47 PM.
    Reply With Quote  
     

  2. #2  
    Registered Member EqualsTheD's Avatar
    Join Date
    Aug 2011
    Posts
    100
    Thanks given
    60
    Thanks received
    12
    Rep Power
    13
    Why is ur database info in the help thread........
    Reply With Quote  
     

  3. #3  
    Banned

    Join Date
    Oct 2012
    Posts
    4,716
    Thanks given
    1,682
    Thanks received
    1,105
    Rep Power
    0
    Quote Originally Posted by EqualsTheD View Post
    Why is ur database info in the help thread........
    Oh shit i forgot Thanks Streetwave
    Reply With Quote  
     

  4. #4  
    Respected Member

    Join Date
    Jan 2009
    Posts
    5,682
    Thanks given
    1,093
    Thanks received
    3,494
    Discord
    View profile
    Rep Power
    5000
    the table does not exist
    Reply With Quote  
     

  5. #5  
    Registered Member EqualsTheD's Avatar
    Join Date
    Aug 2011
    Posts
    100
    Thanks given
    60
    Thanks received
    12
    Rep Power
    13
    Quote Originally Posted by ipkmills View Post
    Just to show extra information i could always change them
    It's not needed information, and frankly the details you provided would allow anyone to login to your admincp and do anything with your website they liked.. which from what i gather hapened last night
    Reply With Quote  
     

  6. #6  
    Banned

    Join Date
    Oct 2012
    Posts
    4,716
    Thanks given
    1,682
    Thanks received
    1,105
    Rep Power
    0
    Quote Originally Posted by EqualsTheD View Post
    It's not needed information, and frankly the details you provided would allow anyone to login to your admincp and do anything with your website they liked.. which from what i gather hapened last night
    Changed its details thank you i forgot my bad

    Edit?: do you know how i can fix this
    Reply With Quote  
     

  7. #7  
    Banned

    Join Date
    Oct 2012
    Posts
    4,716
    Thanks given
    1,682
    Thanks received
    1,105
    Rep Power
    0
    Quote Originally Posted by Stuart View Post
    the table does not exist
    I don't uderstand i havent done any database stuff in my life
    Reply With Quote  
     

  8. #8  
    Middle Finger is Here


    Join Date
    Feb 2012
    Age
    28
    Posts
    2,555
    Thanks given
    377
    Thanks received
    502
    Rep Power
    162
    add remote access to your database [ your vps ip ].
    Hi
    Reply With Quote  
     

  9. #9  
    Banned

    Join Date
    Oct 2012
    Posts
    4,716
    Thanks given
    1,682
    Thanks received
    1,105
    Rep Power
    0
    Quote Originally Posted by Braveyy View Post
    add remote access to your database [ your vps ip ].
    Done that already
    Reply With Quote  
     

  10. #10  
    Banned

    Join Date
    Oct 2012
    Posts
    4,716
    Thanks given
    1,682
    Thanks received
    1,105
    Rep Power
    0
    Payng 4,53$ andy asks 7$ but im 3$ short due my other acc being paypal locked no idea how to fix that
    Reply With Quote  
     

Page 1 of 2 12 LastLast

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. [PI] Automatic Donation MYSQL error!
    By NewRune in forum Help
    Replies: 7
    Last Post: 11-01-2011, 10:48 PM
  2. Replies: 3
    Last Post: 10-18-2011, 08:02 PM
  3. auto donation system error
    By eragol in forum Help
    Replies: 6
    Last Post: 09-05-2011, 02:51 AM
  4. Weird Auto Donation Error
    By TrainWrecked in forum Help
    Replies: 4
    Last Post: 08-01-2011, 06:35 PM
  5. [PI] donating Mysql error
    By Syndicate in forum Help
    Replies: 7
    Last Post: 02-12-2011, 01:19 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
  •