Hello, When trying to optimize data held in mysql tables, I get the following error:
RROR 1175 (HY000) at line 5: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column I am using a sql query (purge-4.1.sql & optimize.sql) delivered with dspam. Have not changed anything in it. The optimization query works fine but purge does not work at all. I use mysql 5.1.11-beta on a FreeBSD 6.2 machine. Any idea where to look and what to change? -- Zbigniew Szalbot
