Script neukládá do DB

  $nadpis = $_GET['nadpis'];
  $text = $_GET['text'];
  $zverejnit = $_GET['zverejnit'];
  $id = $_GET['id'];
  
$prikaz = mysql_query("INSERT INTO denicky_zaznamy (denicek_nadpis,denicek_text, user_id) VALUES ($nadpis,$text,$id)");
echo "Váš vzkaz byl uložen!<a href='javascript:history.back();'>Zpět</a>, nebo na <a href='./index.php'> index</a>";

CREATE TABLE users (
  user_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  uzivatel TEXT NULL,
  heslo TEXT NULL,
  PRIMARY KEY(user_id)
)
TYPE=InnoDB;

CREATE TABLE denicky (
  denicky_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  user_id INTEGER UNSIGNED NOT NULL,
  denicek_nazev TEXT NULL,
  PRIMARY KEY(denicky_id, user_id),
  FOREIGN KEY(user_id)
    REFERENCES users(user_id)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=InnoDB;

CREATE TABLE denicky_zaznamy (
  iddenicky_zaznamy INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  denicky_id INTEGER UNSIGNED NOT NULL,
  user_id INTEGER UNSIGNED NOT NULL,
  denicek_nadpis TEXT NULL,
  denicek_text TEXT NULL,
  datum DATE NULL,
  PRIMARY KEY(iddenicky_zaznamy, denicky_id, user_id),
  INDEX denicky_zaznamy_FKIndex2(denicky_id, user_id),
  FOREIGN KEY(user_id)
    REFERENCES users(user_id)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(denicky_id, user_id)
    REFERENCES denicky(denicky_id, user_id)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=InnoDB;

průůůšvih You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Cannot add or update a child row: a foreign key constraint fails (`newdatabase/denicky_zaznamy`, CONSTRAINT `denicky_zaznamy_ibfk_2` FOREIGN KEY (`denicky_id`, `user_id`) REFERENCES `denicky` (`denicky_id`, `user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION)

  $nadpis = $_GET['nadpis'];
  $text = $_GET['text'];
  $zverejnit = $_GET['zverejnit'];
  $id = $_GET['id'];

  
$prikaz = mysql_query("INSERT INTO denicky_zaznamy (denicek_id,user_id,denicek_nadpis,denicek_text) VALUES ('$id','$user_id','$nadpis','$text')");
if (mysql_error()) {
  echo "průůůšvih  " . mysql_error();
} else {
  echo "Uloženo";
}