[Fixed] Error during install

[polyvios_s]

Trying to do a fresh install of 4.3 with J1.5.3 and getting this error (messy hope I could make it look ok):



* JInstaller::install: SQL Error. DB function failed with error number 1067
Invalid default value for 'show_archive' SQL=CREATE TABLE IF NOT EXISTS `jos_ionfile_conf` ( `id` tinyint(11) NOT NULL default '0', `hdr_text` varchar(250) NOT NULL default 'Downloads', `show_size` int(11) NOT NULL default '1', `show_ver` int(11) NOT NULL default '0', `show_lic` int(11) NOT NULL default '0', `show_icon` int(11) NOT NULL default '0', `show_dl` int(11) NOT NULL default '1', `show_desc` int(11) NOT NULL default '0', `show_hdr` int(11) NOT NULL default '1', `show_totals` int(11) NOT NULL default '0', `show_hdr_desc` int(11) NOT NULL default '1', `hdr_desc_text` LONGTEXT NOT NULL, `show_date` int(11) NOT NULL default '0', `allow_direct` int(11) NOT NULL default '0', `extra_fields` varchar(255) NOT NULL default '', `show_archive` int(11) NOT NULL default '', `allow_category` int(11) NOT NULL default '', `show_search` int(11) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_ionfile_conf` (
`id` tinyint(11) NOT NULL default '0',
`hdr_text` varchar(250) NOT NULL default 'Downloads',
`show_size` int(11) NOT NULL default '1',
`show_ver` int(11) NOT NULL default '0',
`show_lic` int(11) NOT NULL default '0',
`show_icon` int(11) NOT NULL default '0',
`show_dl` int(11) NOT NULL default '1',
`show_desc` int(11) NOT NULL default '0',
`show_hdr` int(11) NOT NULL default '1',
`show_totals` int(11) NOT NULL default '0',
`show_hdr_desc` int(11) NOT NULL default '1',
`hdr_desc_text` LONGTEXT NOT NULL,
`show_date` int(11) NOT NULL default '0',
`allow_direct` int(11) NOT NULL default '0',
`extra_fields` varchar(255) NOT NULL default '',
`show_archive` int(11) NOT NULL default '',
`allow_category` int(11) NOT NULL default '',
`show_search` int(11) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

* Component Install: SQL Error. DB function failed with error number 1067
Invalid default value for 'show_archive' SQL=CREATE TABLE IF NOT EXISTS `jos_ionfile_conf` ( `id` tinyint(11) NOT NULL default '0', `hdr_text` varchar(250) NOT NULL default 'Downloads', `show_size` int(11) NOT NULL default '1', `show_ver` int(11) NOT NULL default '0', `show_lic` int(11) NOT NULL default '0', `show_icon` int(11) NOT NULL default '0', `show_dl` int(11) NOT NULL default '1', `show_desc` int(11) NOT NULL default '0', `show_hdr` int(11) NOT NULL default '1', `show_totals` int(11) NOT NULL default '0', `show_hdr_desc` int(11) NOT NULL default '1', `hdr_desc_text` LONGTEXT NOT NULL, `show_date` int(11) NOT NULL default '0', `allow_direct` int(11) NOT NULL default '0', `extra_fields` varchar(255) NOT NULL default '', `show_archive` int(11) NOT NULL default '', `allow_category` int(11) NOT NULL default '', `show_search` int(11) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_ionfile_conf` (
`id` tinyint(11) NOT NULL default '0',
`hdr_text` varchar(250) NOT NULL default 'Downloads',
`show_size` int(11) NOT NULL default '1',
`show_ver` int(11) NOT NULL default '0',
`show_lic` int(11) NOT NULL default '0',
`show_icon` int(11) NOT NULL default '0',
`show_dl` int(11) NOT NULL default '1',
`show_desc` int(11) NOT NULL default '0',
`show_hdr` int(11) NOT NULL default '1',
`show_totals` int(11) NOT NULL default '0',
`show_hdr_desc` int(11) NOT NULL default '1',
`hdr_desc_text` LONGTEXT NOT NULL,
`show_date` int(11) NOT NULL default '0',
`allow_direct` int(11) NOT NULL default '0',
`extra_fields` varchar(255) NOT NULL default '',
`show_archive` int(11) NOT NULL default '',
`allow_category` int(11) NOT NULL default '',
`show_search` int(11) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

any advice?

[Jordan]

Hey Polyvios_s, I've released a new version (4.3.1) which fixes this error. It was a typo in my installation scripts (I was trying to pass a string instead of an integer). If you find any more bugs please let me know.

[Xav]

It's amazing how many things can go wrong in stuff like this! I'm actually surprised when one of my programs does work - there's an endless supply of mistakes that can be made. But then again, the fun of it is trying to work out where you went wrong.

[Jordan]

Yup, and it works on one machine then another user downloads it and it doesn't work. The wide variety of users computers/servers make it very hard to debug before release (unless you have a lot of money or pay a company to run tests). This bug, though, I could of caught had I been more thorough in my tests.

[polyvios_s]

works like a charm with the new release thanks