just got a new MacOS X Server 10.3 (Panther) that came with MySQL 4.0.14. Previous system we had was MacOS X 1.2, the really old one. I old system I was running MySQL 3.23.39 (if I now remember it right).
I have good reason to believe that we made the change from old to new by the book. We took double backups from every table we had. Then we installed the new system and uploaded the databases. Everything was ok, mostly. For some strange reason, some of the tables just went berjerk. The main trouble is in the id field and it's auto_increment. Normally when I add a new line the new id is previous+1 (like 8993, 8994, 8995 ect.), but now the new id would be 0 and after that when I try to add a new line, I get the announcement: Duplicate entry '0' for key 1
The strange thing is that this does not happen in every table, just in some of them.
Does anyone have a clue what is happening?
TIA
Jude Vihervaara www.paikalliset.info
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
