Install problems with the component

[ShaneR]

Hate to post this...seems I can't figure anything out myself these days and everything hates my touch...lol

Fresh install of Joomla 1.07, SMF RC2, both in same database...no previouse modulues/packages in SMF.

I can't even upload com_smf.  I get this:

SQL Error DB function failed with error number 1364
Field 'params' doesn't have a default value SQL=INSERT INTO jos_menu (`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`) VALUES ("mainmenu", "Forum", "index.php?option=com_smf", "components", 1, 0, 19, 0, 8, 0, "0000-00-00 00:00:00", 0, 0, 0, 3)
SQL =

INSERT INTO jos_menu
(`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`)
VALUES ("mainmenu", "Forum", "index.php?option=com_smf", "components", 1, 0, 19, 0, 8, 0, "0000-00-00 00:00:00", 0, 0, 0, 3)

Running PHP5, Mysql 5, Apache on local host.

Thanks ...

[Orstio]

This is a known issue with MySQL 5 strict.  From the experience of the last report, even if you were to delete that query from the smf.xml, it looks like Joomla's component installer is also not 100% compliant with MySQL 5 strict, so you won't be able to install components anyway.

[ShaneR]

Thanks Orstio.

This must be a  problem since joomla 1.04, then? Didn't have a problem with that version.

...i thought I was not running in strict mode...I'll need to look when I get back home.

[Orstio]

The latest version of MySQL 5 runs in strict mode as a default.

[ShaneR]

Thanks again, orstio.

I just commented out the strict mode in the ini file and all appears to be fine