Basically, it says : "find all the surveys the user has the permission to access, joined with its default languages "in your case, this request fails.. On duplicate key update statements performing multiple-row insert in the table that had unique and fulltext indexes. ( bug #6784 ) [22 may 2005 16:02] cheng tan. The above test case work fine if we split the multi-values insert sentence to single-value sentence as following: insert into t1(f1) values(1),(2); to: insert into t1(f1) values(1); insert into t1(f1) values(2); because we can write a separate "set insert_id=n" sentence for every insert row sentence to binlog..
Perhaps you can check out this question and answer: mysql replication: 'duplicated entry for primary key' 1 : skip all the duplicate key errors simply add this to my.cnf on the slave [mysqld] slave-skip-errors=1062 skip-slave-start and restart mysql.. The on duplicate key update clause can contain multiple column assignments, separated by commas. in assignment value expressions in the on duplicate key update clause, you can use the values(col_name) function to refer to column values from the insert portion of the insert on duplicate key update statement.. It turns out that magento uses a primary key with value “0” in some cases (which is bad practice). mysql’s default behaviour when inserting data in auto incremental fields with value “0” is to set it to the next possible auto increment value..
