[sorry if this is duplicated, having some problems switching email client]
Re: [gentoo-server] mysql-4.1 (Francesco R., Thu Oct 20 12:39:07 2005) Alle 06:42, giovedì 20 ottobre 2005, Ben Munat ha scritto: > I see that MySQL-4.1 has been marked stable... anyone have any > warnings I should heed before undertaking the upgrade (from Yes, I've spent some time with a user that had problem upgrading a phpBB site. first: a duplicate primary key, reproduce case below ========= failed insert =========== DROP TABLE IF EXISTS `t1`; CREATE TABLE `t1` ( `f1` varchar(50) binary NOT NULL default '', primary KEY (`f1`) ) ENGINE=MyISAM; /*!40000 ALTER TABLE `t1` DISABLE KEYS */; LOCK TABLES `t1` WRITE; INSERT INTO `t1` VALUES ( 0x686D6D),( 0x686D6DB2); /*!40000 ALTER TABLE `t1` ENABLE KEYS */; --ERROR 1062 (23000) at line 10: Duplicate entry 'hmm' for key 1 ========= failed insert =========== the duplicate key is "hmm" with "hmm²" Another problem was MySQL importing truncated fields, the fields where truncated at charachter with dieresis. The solution here was to pipe the dump through iconv: # iconv -f ISO-8859-15 -t UTF-8 dump.sql | mysql The other problem was with php-4 and the well known connection charset problem. To be sincere we 've not solved the last one in a satisfing way, but this is my fault, it's way too much time I've setted up my boxes to work with php-5 and mysql-4.1. > 4.0.25-r2)? Francesco, you still lurking? > > b when having time ;-) -- [email protected] mailing list
