Thread: Shard/No-Dose Help

Results 1 to 4 of 4
  1. #1 Shard/No-Dose Help 
    Registered Member
    Join Date
    May 2011
    Posts
    312
    Thanks given
    14
    Thanks received
    17
    Rep Power
    0
    Code:
    java.sql.SQLException: Field 'pet' doesn't have a default value
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
            at com.rs2.net.RegisterListener$Register.run(RegisterListener.java:99)

    This is what happens when I try to register a new account using the client provided, I port forwarded, set up my SQL, and changed the password in the server.

    Base: http://www.rune-server.org/runescape...ml#post2724179




    EDIT: By editing out Pet, and Running I got the account to register however now when I log in it says..


    Code:
    [00:00:01]: Injected FlagMap with 105531 objects covering 208255 tiles in 330ms.
    
    [00:00:01]: listening for connections on port 43594.
    [00:00:32]: java.sql.SQLException: Column 'running' not found.
    [00:00:32]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055
    )
    [00:00:32]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    
    [00:00:32]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    
    [00:00:32]:     at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:11
    36)
    [00:00:32]:     at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2777)
    [00:00:32]:     at com.rs2.net.Login.process(Login.java:210)
    [00:00:32]:     at com.rs2.net.Login.read(Login.java:363)
    [00:00:32]:     at com.rs2.net.ConnectionListener.read(ConnectionListener.java:1
    23)
    [00:00:32]:     at com.rs2.net.ConnectionListener.run(ConnectionListener.java:77
    )
    [00:00:32]:     at java.lang.Thread.run(Thread.java:662)
    [00:00:32]: Zoft logged in [idx=1, online=1]
    [00:00:33]: java.sql.SQLException: Column 'running' not found.
    [00:00:33]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055
    )
    [00:00:33]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    
    [00:00:33]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    
    [00:00:33]:     at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:11
    36)
    [00:00:33]:     at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2777)
    [00:00:33]:     at com.rs2.net.Login.process(Login.java:210)
    [00:00:33]:     at com.rs2.net.Login.read(Login.java:363)
    [00:00:33]:     at com.rs2.net.ConnectionListener.read(ConnectionListener.java:1
    23)
    [00:00:33]:     at com.rs2.net.ConnectionListener.run(ConnectionListener.java:77
    )
    [00:00:33]:     at java.lang.Thread.run(Thread.java:662)
    [00:00:33]: Zoft logged in [idx=1, online=1]
    [00:00:34]: java.sql.SQLException: Column 'running' not found.
    [00:00:34]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055
    )
    [00:00:34]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    
    [00:00:34]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    
    [00:00:34]:     at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:11
    36)
    [00:00:34]:     at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2777)
    [00:00:34]:     at com.rs2.net.Login.process(Login.java:210)
    [00:00:34]:     at com.rs2.net.Login.read(Login.java:363)
    [00:00:34]:     at com.rs2.net.ConnectionListener.read(ConnectionListener.java:1
    23)
    [00:00:34]:     at com.rs2.net.ConnectionListener.run(ConnectionListener.java:77
    )
    [00:00:34]:     at java.lang.Thread.run(Thread.java:662)
    [00:00:34]: Zoft logged in [idx=1, online=1]
    Reply With Quote  
     

  2. #2  
    arrowzftw
    Guest
    Set your pet table settings to a default value of -1
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    May 2011
    Posts
    312
    Thanks given
    14
    Thanks received
    17
    Rep Power
    0
    Yeah, I found out what is causing the errors, I removed pet from runescape.sql but then guess what..


    Code:
    Registration Server is Online on port 43595.
    java.sql.SQLException: Field 'running' doesn't have a default value
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
            at com.rs2.net.RegisterListener$Register.run(RegisterListener.java:99)
    Reply With Quote  
     

  4. #4  
    Registered Member Beershake's Avatar
    Join Date
    Mar 2011
    Age
    28
    Posts
    287
    Thanks given
    49
    Thanks received
    25
    Rep Power
    2
    not removing... You must modify your database and edit as other ints.. There will be another one poisonDemage but there isnt so you will need to add it to your database.
    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. what dose this mean :S
    By zhstyle1990 in forum Help
    Replies: 11
    Last Post: 08-13-2011, 07:29 PM
  2. shard- no dose sql error
    By Romania Clan in forum Help
    Replies: 0
    Last Post: 04-18-2011, 03:36 PM
  3. Dose anyone how anything about a vb forums?
    By R4nger 0wnz in forum Chat
    Replies: 1
    Last Post: 02-08-2010, 04:23 PM
  4. where dose this go?
    By Ninja assassin in forum Help
    Replies: 3
    Last Post: 01-04-2010, 05:20 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
  •