Sometimes an easy to fix bug viewed by thousands of eyes survives for ages. Today I sent this trivial patch to Joomla forge which fixes a bug in modules/mod_archive.php.
If for some reason (sad or stupid reasons, you have a choice as usual) you need to restore a MySQL dump of a Joomla DB and you have experienced the same problem described here, well, you could find it useful to run this pre import script I wrote.
Update (2006-12-07): this might be needed if you [...]
If for some reason (sad or stupid reasons, you have a choice) you need to import into MySQL 3.x a dump made with phpMyAdmin of a MySQL 5.x DB of Joomla 1.0.x, don’t forget to change the closing sequence of the tables as:
+) ENGINE=MyISAM AUTO_INCREMENT={n} DEFAULT CHARSET={c} AUTO_INCREMENT=2 ;
-) TYPE=MyISAM AUTO_INCREMENT={n};
where {c} and {n} [...]
My posts, unless otherwise expressly stated, are licensed under a Creative Commons Attribution-Share Alike 2.5 Italy License.