row could not be located for updating
The exception 'row could not be located for updating' appears almost every
time I try to update some record in my program.
Table:
CREATE TABLE POTREBITELI (
ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
PSEVDONIM CHAR(12) NOT NULL,
IME CHAR(30) NOT NULL,
PRIVILEGII INTEGER UNSIGNED NOT NULL,
DOBAVEN_OT BIGINT UNSIGNED NULL,
DOBAVEN_DATA DATETIME NOT NULL,
AKTIVEN BIT NOT NULL,
DE_TIMESTAMP TIMESTAMP NULL,
DE_OPERATOR BIGINT UNSIGNED NOT NULL,
DE_VERSIJA DECIMAL(5,3) NOT NULL,
DE_HASH CHAR(25) NULL,
PRIMARY KEY(ID)
);
Server log:
070216 1:47:49 4 Query UPDATE `vive`.`potrebiteli` SET `IME`='asssaassj4hhjjj ',`PRIVILEGII`=1,`DE_OPERATOR`=0,`DE_VERSIJA`=.100 WHERE `ID`=1 AND `IME`='asssaassj4hhjjj' AND `PRIVILEGII`=2 AND `DE_OPERATOR`=0 AND `DE_VERSIJA`=.100
4 Query SELECT `ID`,`PSEVDONIM`,`IME`,`PRIVILEGII`,`DOBAVEN_OT`,`DOBAVEN_DATA`,`AKTIVEN`,`DE_TIMESTAMP`,`DE_OPERATOR`,`DE_VERSIJA`,`DE_HASH` FROM `vive`.`potrebiteli` WHERE `ID`=1
(Please, notice the strange spaces in the value for IME field on row 2)
ConnectionString:
Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data Source=myodbc.vive;Extended Properties="DATABASE=vive;DSN=myodbc.vive;OPTION=0;PORT=0;SERVER=localhost;UID=root"
What did I do wrong?