Why does this say "NO such Column?"

King Nothing · Oct 25th 2016

SELECT * FROM XXXXX WHERE Player_user = GetPlayer

db.executeUpdate("INSERT INTO `XXXXX` (Player_user,PLayer_money) VALUES (GetPlayer, 2000);");

(GetPLayer is String GetPlayer = p.getName();)

Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: GetPlayer)
at org.sqlite.DB.newSQLException(DB.java:383)
at org.sqlite.DB.newSQLException(DB.java:387)
at org.sqlite.DB.throwex(DB.java:374)
at org.sqlite.NativeDB.prepare(Native Method)
at org.sqlite.DB.prepare(DB.java:123)
at org.sqlite.Stmt.executeQuery(Stmt.java:121)
at pluginapi.objects.SQLiteDatabaseAPI.executeQuery(SourceFile:57)
at EffNet.EffNet.onConnect(EffNet.java:68)
... 8 more

red51 · Oct 25th 2016

As it has been pointed out in your other topic, you have to put strings into single quotes (INSERT INTO `XXXXX` (Player_user, Player_money) VALUES ('GetPlayer', 2000);), or if "GetPlayer" is a variable, you have to use string concatenation (INSERT INTO `XXXXX` (Player_user, Player_money) VALUES ('" + GetPlayer + "', 2000);)

King Nothing · Oct 25th 2016

i used your example in the Javadoc,

i'm just Getting Fustrate and Cannot think straight.. this is really draining me

its still giving me the same EXACT error

red51 · Oct 25th 2016

But that's no reason to create multiple topics about the same issue. If you have created a topic, please stick to that topic when you want to post anything that's related to your topic.

In this case, please post your full code.

King Nothing · Oct 25th 2016

Java

// Decompiled by DJ v3.12.12.101 Copyright 2016 Atanas Neshkov  Date: 10/23/2016 9:06:16 AM
// Home Page:  http://www.neshkov.com/dj.html - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   EffNet.java


package EffNet;


import static java.awt.Event.INSERT;
import static java.lang.Character.getName;
import java.math.BigInteger;
import java.sql.ResultSet;
import java.sql.SQLException;
import net.risingworld.api.Plugin;
import net.risingworld.api.Server;
import net.risingworld.api.database.Database;
import net.risingworld.api.events.EventMethod;
import net.risingworld.api.events.Listener;
import net.risingworld.api.events.player.PlayerCommandEvent;
import net.risingworld.api.events.player.PlayerConnectEvent;
import net.risingworld.api.events.player.PlayerEvent;
import net.risingworld.api.events.player.PlayerSpawnEvent;
import net.risingworld.api.events.player.gui.PlayerGuiElementClickEvent;
import net.risingworld.api.gui.Font;
import net.risingworld.api.gui.GuiElement;
import net.risingworld.api.gui.GuiLabel;
import net.risingworld.api.gui.GuiPanel;
import net.risingworld.api.gui.GuiTextField;
import net.risingworld.api.gui.PivotPosition;
import net.risingworld.api.objects.Player;
import static sun.audio.AudioPlayer.player;


public class EffNet extends Plugin implements Listener
{


    GuiTextField label = new GuiTextField(0.5f, 0.25f, true, 1.0f, 1.0f,true);
    GuiPanel panel = new GuiPanel(0.5f, 0.25f, false, 400, 100, false);
    public int PMoney;
    protected Database db	= null;


	@Override
	public void onEnable()
	{
		db = getSQLiteConnection(getPath() + "/EffNet.db");
		db.execute("CREATE TABLE IF NOT EXISTS `EffNet` (`Player_user` VARCHAR(64), 'PLayer_money' INTEGER);");


               // db.executeUpdate("INSERT INTO `EffNet` (Player_user, PLayer_money) VALUES ('Bubba', '2000');");


//		db.close();
		registerEventListener(this);

	}


	@Override
	public void onDisable()
	{
		if (db != null)
			db.close();
	}
        @EventMethod


public void onConnect(PlayerConnectEvent event) throws SQLException{
    Player p = event.getPlayer();

 


  String GetPlayer = p.getName();
 String query = "SELECT * FROM EffNet WHERE Player_user = GetPlayer";

		try (ResultSet result = db.executeQuery(query))
		{
			//String fromwhom = result.getString("player_name");
			if(result.next())
			{

                                int PMoney = result.getInt("PLayer_money"); 


                        			}


                        if (event.isNewPlayer()){
                            db.executeUpdate ("INSERT INTO EffNet ('Player_user','PLayer_money') VALUES ('"+GetPlayer+"',2000);");
                                                }


                        else {
                          db.executeUpdate ("INSERT INTO EffNet ('Player_user','PLayer_money') VALUES ('"+GetPlayer+"',2000);");


                            }
                    } catch (SQLException e)
		{
			e.printStackTrace();
                }



	


   




	
}    @EventMethod
    public void onSpawn(PlayerSpawnEvent event){

        String query = "SELECT * FROM `EffNet` WHERE `Player_user` = 'Bubba'";

		try (ResultSet result = db.executeQuery(query))
		{
			//String fromwhom = result.getString("player_name");
			if(result.next())
			{

                                int PMoney = result.getInt("PLayer_money"); 

                               label.setText("$EB:" + PMoney);
                        			}

                                            // String GetPlayer = player.getName();  
                       // p.setAttribute("whosthePlayer",GetPlayer);



		} catch (SQLException e)
		{
			e.printStackTrace();


   
}
      Player p = event.getPlayer();
        //GuiPanel panel = new GuiPanel(0.5f, 0.25f, true, 400, 50, false);
   // GuiTextField label = new GuiTextField(0.5f, 0.25f, true, 0.5f, 0.5f,true);

  //  label.setText("$EB:" + PMoney);
    p.addGuiElement(panel);
    panel.addChild(label);
 p.addGuiElement(label);
}
public static void main(String[] args) {


	// create 3 BigInteger objects
	BigInteger bi1, bi2, bi3;


	bi1 = new BigInteger("123");
	bi2 = new BigInteger("-123");


	// assign difference of bi1 and bi2 to bi3
	bi3 = bi1.subtract(bi2);


	String str = "Subtraction result: " +bi1+ " - " +bi2+ " = " +bi3;


	// print bi3 value
	System.out.println( str );
   }


@EventMethod
 public void onCommand(PlayerCommandEvent event){
     BigInteger bi1, bi2, bi3;


        bi1 = new BigInteger("2000");
	bi2 = new BigInteger("50");    //this method will be called when the "PlayerCommandEvent" 
            //triggers, i.e. when a player enters a command into chat.

    Player p = event.getPlayer();
        String WDP = (String) p.getAttribute("whosthePlayer"); 

        String playerName = p.getName();
        String command = event.getCommand();
        Server server = getServer();
        String cmd[] = command.split(" ");

        if(cmd[0].equals("/help")){

            String helpme = command.substring(6);
            p.sendTextMessage(helpme);
            if(cmd.length > 1)
            {
                if(helpme.equals("mail"))
                {
                    p.sendTextMessage(helpme);
                    p.sendTextMessage("/mail (To player) - will allow you to Write a Message to a player");
                    p.sendTextMessage("/read Reads your messages)");
                } else
                if(helpme.equals("Effnet"))
                {
                    p.sendTextMessage("/en Drink Will Quench Your Thirst for 50 EffBucks");
                    p.sendTextMessage("/en FeedMe will Fill your Hunger for 50 EffBucks");
                    p.sendTextMessage("@user will send a Private Message to a user)");
                    p.sendTextMessage("/transfer xx to player will Transfer xx Amt of Effbucks to that Plsyer.");
                }
            }
        }
            else if(cmd[0].equals("/en"))
                {
                    String ECmd = command.substring(4);
                    p.sendTextMessage(ECmd);

                    if(cmd.length > 1)
                        if(ECmd.equals("Drink"))
                        {
                            p.sendTextMessage("I bet that Hit the spot!");
                            server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Drinks up!");
                            bi3 = bi1.subtract(bi2);
                           String str = "Subtraction result: " +bi1+ " - " +bi2+ " = " +bi3;
                             p.sendTextMessage(str);
                            p.setThirst(100);

                        } else
                        if(ECmd.equals("FeedMe"))
                       {
                            p.sendTextMessage("Yummy!g!");
                            server.broadcastTextMessage("[#58ca32]" + playerName + "[#6878f5] Odered a Pizza From Mario's Perfect Pizza!");
                            p.setHunger(100);
     }
                   }

 }
}


        //Create a panel
 
       // GuiPanel panel = new GuiPanel(0.5f, 0.25f, true, 400, 100, false);

Display More

and I did reply to my old topic and no one answered

zfoxfire · Oct 25th 2016

Seriously Captain? If nobody responds to your other post then wait longer or bump the topic. This is basic forum etiquette. Creating multiple identical topics is spamming. Nobody should have to explain this to you.

And welcome to the world of programming. We all get frustrated when things dont work out as we hope. Solutions are not always straightforward. I am glad to see you trying but whining and pouting when something doesn't work only reveals your attitude towards learning. We've had lengthy arguments on this topic several months ago in another thread where you ended the discussion by adding "i already know basic java" to your signature. You aren't fooling anyone. Again, I am glad to see you trying but please try to control your frustration. Patience and perseverence are necessary attributes to be a programmer.

red51 · Oct 25th 2016

Quote from Captian_Cornball

68. String query = "SELECT * FROM EffNet WHERE Player_user = GetPlayer";

As mentioned, you have to use single quotes, and if it's a variable, you have to use string concatenation: String query = "SELECT * FROM EffNet WHERE Player_user = '" + GetPlayer + "';

Quote from Captian_Cornball

and I did reply to my old topic and no one answered

Your latest post was >>the above code SHOULD work and update the record<<, how is this a question? Apparently you edited your initial post (you removed your original text and replaced it by a new question), you should never do that, since that makes all replies in your topic pointless (and, in addition, no one will see your question) If you have a new question (which is related to the topic), post it in a new response.

King Nothing · Oct 25th 2016

Thank you, and Sorry for double Posting... I honestly forgot i posted the same Thing, all I wanted was to get this stupid database working. I was on the verge of shooting my Computer. thats how fustrated was

Participate now!