SQL insert help

[Ohk4y]

Hello, I came across an error while trying to insert a row into a sqlite database, which the database is named 'loot'. I get an error outputted by sql in rc:

PHP Code:

SQL Error: constraint failed 


Here's the sql part of the script:

PHP Code:

function AddToLoot() {
  temp.mineral = "SELECT content FROM inventories WHERE rowid="@this.itemm;
  temp.account = player.account;
  temp.classn = "mineral";
  temp.name_en = temp.mineral;
  temp.loc = this.level;
  temp.x = this.x;
  temp.y = this.y;
  temp.query = "INSERT INTO loot (account, class, name_en, loc, x, y) VALUES ('"@temp.account@"', '"@temp.classn@"', '"@temp.name_en@"', '"@temp.loc@"', '"@temp.x@"', '"@temp.y@"')";
  temp.requestObject = requestsql(temp.query, true);
    
  this.waitfor(temp.requestObject, "onReceiveData", 30);
  
  if (temp.requestObject.error) {
    echo("SQL Error: " @ temp.requestObject.error);
    return;
  }  
  this.chat = temp.requestObject.lastinsertid;
} 


Anybody know what I did wrong?

[cbk1994]

Not possible to tell without seeing the table structure but I'd guess you're trying to insert a duplicate value into a column with a UNIQUE constraint/index.

[Ohk4y]

That first row, I just typed in the information manually to see what it would look like.


Don't know if this helps:

PHP Code:

CREATE TABLE 'loot' (account TEXT DEFAULT '' PRIMARY KEY, class TEXT DEFAULT '', name_en TEXT DEFAULT '', loc TEXT DEFAULT '', x INTEGER DEFAULT 0, y INTEGER DEFAULT 0) 


[fowlplay4]

It's because you have account as your primary key, which automatically makes it unique.