Hi,
I did an install for XOOPS 2.2.3a on WinXP, Apache 2.0.55, PHP 4.4.1 and MySQL 5.018 and I get 3 insert errors:
1 entries inserted to table xoops_bannerclient.
1 entries inserted to table xoops_imgset.
1 entries inserted to table xoops_imgset_tplset_link.
7 entries inserted to table xoops_ranks.
17 entries inserted to table xoops_smiles.
3 entries inserted to table xoops_groups.
2 entries inserted to table xoops_groups_users_link.
19 entries inserted to table xoops_group_permission.
1 entries inserted to table xoops_tplset.

Failed inserting 3 entries to table xoops_banner.

I had to add for some reason: htmlbanner, htmlcode default values. Maybe it is a bug in MySQL 5?
INSERT INTO xoops_banner ( bid, cid, imptotal, impmade, clicks, imageurl, clickurl, date, htmlbanner, htmlcode ) VALUES ( '1', '1', '0', '1', '0', '".XOOPS_URL."/images/banners/xoops_banner.gif', 'https://xoops.org/', '1008813250', 0, '');
INSERT INTO xoops_banner ( bid, cid, imptotal, impmade, clicks, imageurl, clickurl, date, htmlbanner, htmlcode ) VALUES ( '2', '1', '0', '1', '0', '".XOOPS_URL."/images/banners/xoops_banner_2.gif', 'https://xoops.org/', '1008813250', 0, '');
INSERT INTO xoops_banner ( bid, cid, imptotal, impmade, clicks, imageurl, clickurl, date, htmlbanner, htmlcode ) VALUES ( '3', '1', '0', '1', '0', '".XOOPS_URL."/images/banners/banner.swf', 'https://xoops.org/', '1008813250', 0, '');

Nicolas