Reason: Server error MySQL Error - 1048: Column 'item' cannot be null

[davey Stokhof]

Hi Guys,

I am working with Flex builder, and am making a mobile application with PHP and an sql database.

I have an error showing up when I try to test the following code:

public function add_basket_item() {
include '../vo/basketVO.php';
$stmt = mysqli_prepare($this->connection, "INSERT INTO basket (item, amount) VALUES (?, ?)");
$this->throwExceptionOnError();

mysqli_stmt_bind_param($stmt, 'ss',$item->item, $item->amount);
$this->throwExceptionOnError();

mysqli_stmt_execute($stmt);
$this->throwExceptionOnError();

$autoid = mysqli_stmt_insert_id($stmt);

mysqli_stmt_free_result($stmt);
mysqli_close($this->connection);

return $autoid;
}



error:
InvocationTargetException:There was an error while invoking the operation. Check your server settings and try invoking the operation again.

Reason: Server error MySQL Error - 1048: Column 'item' cannot be null /Applications/MAMP/htdocs/MenuPlannerApp/services/DBBase.php on line 26


Any help would be much appreciated