Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'

2002-01-21 Thread Johan Hallenberg - LUB NetLab
Hello again, "ERROR 1169: Can't write, because of unique constraint, to table" is a bug that have been fixed in release 3.23.44, look at the page http://www.mysql.com/doc/N/e/News-3.23.44.html . /Johan - Before posting, plea

Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'

2002-01-21 Thread Johan Hallenberg - LUB NetLab
Hello, I'm experience the same problem. I use a query like this: SELECT publ,fak,id,COUNT(*) FROM ftxt_stat WHERE year LIKE '2001' AND month LIKE 'Oct' GROUP BY publ,fak,id; If I remove COUNT(*) I don't get the error. The table I use look like this: CREATE TABLE ftxt_stat ( year VARCHA