how is it possible that i get no erros after executing INSERT query but still nothing is inserted?
btw it works if I connect to another server

following simple code

Qt Code: 
  1. query.prepare("INSERT INTO Ruchy (z,do,twr_id,ilosc,opis,czas,dozor_prc_id) VALUES ('"+ui->LE_ruchy_z_id->text()+"','"+ui->LE_ruchy_do_id->text()+"','"+ui->LE_ruchy_twr_id->text()+"','"+QString::number(ui->SB_ruchy_ilosc->value())+"','"+ui->PTE_ruchy_opis->toPlainText()+"',now(),'"+QString::number(::prc_id)+"')");
  2.     query.exec();
  3.     qDebug()<<"ruchy querry : "<<query.lastQuery();
  4.     qDebug()<<"Ruchy insert  : "<<query.lastError();
  5.     qDebug()<<"ruchy last id: "<<query.lastInsertId().toString();
To copy to clipboard, switch view to plain text mode 

gives following debug

Qt Code: 
  1. ruchy querry :  "INSERT INTO Ruchy (z,do,twr_id,ilosc,opis,czas,dozor_prc_id) VALUES ('-2','1','210','1','test2',now(),'1')" 
  2. Ruchy insert  :  QSqlError(-1, "", "") 
  3. ruchy last id:  ""
To copy to clipboard, switch view to plain text mode