Problem with installing [Resolved]

[DavidBoggitt]

Hi,

I've used ionFiles on another site, so I know it works! But I thought I'd try the most recent version (4.5.0 PB2) on a new site I'm doing. However, upon installation, I got this error message. If it helps, I tried installing version 4.4.5 on the same site and it installed perfectly.

Thanks,

Dave.

* JInstaller::install: SQL Error. DB function failed with error number 1074
Column length too big for column 'active_template' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS `jos_ionfile_conf` ( `id` tinyint(11) NOT NULL default '0', `hdr_text` LONGTEXT NOT NULL, `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 '0', `allow_category` int(11) NOT NULL default '1', `show_search` int(11) NOT NULL default '1', `search_pos` int(11) NOT NULL default '0', `disable_search` int(11) NOT NULL default '0', `enable_logging` int(11) NOT NULL default '0', `log_views` int(11) NOT NULL default '0', `total_views` int(11) NOT NULL default '0', `only_uniquedls` int(11) NOT NULL default '0', `active_template` varchar(500) 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` LONGTEXT NOT NULL,
`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 '0',
`allow_category` int(11) NOT NULL default '1',
`show_search` int(11) NOT NULL default '1',
`search_pos` int(11) NOT NULL default '0',
`disable_search` int(11) NOT NULL default '0',
`enable_logging` int(11) NOT NULL default '0',
`log_views` int(11) NOT NULL default '0',
`total_views` int(11) NOT NULL default '0',
`only_uniquedls` int(11) NOT NULL default '0',
`active_template` varchar(500) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

* Component Install: SQL Error. DB function failed with error number 1074
Column length too big for column 'active_template' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS `jos_ionfile_conf` ( `id` tinyint(11) NOT NULL default '0', `hdr_text` LONGTEXT NOT NULL, `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 '0', `allow_category` int(11) NOT NULL default '1', `show_search` int(11) NOT NULL default '1', `search_pos` int(11) NOT NULL default '0', `disable_search` int(11) NOT NULL default '0', `enable_logging` int(11) NOT NULL default '0', `log_views` int(11) NOT NULL default '0', `total_views` int(11) NOT NULL default '0', `only_uniquedls` int(11) NOT NULL default '0', `active_template` varchar(500) 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` LONGTEXT NOT NULL,
`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 '0',
`allow_category` int(11) NOT NULL default '1',
`show_search` int(11) NOT NULL default '1',
`search_pos` int(11) NOT NULL default '0',
`disable_search` int(11) NOT NULL default '0',
`enable_logging` int(11) NOT NULL default '0',
`log_views` int(11) NOT NULL default '0',
`total_views` int(11) NOT NULL default '0',
`only_uniquedls` int(11) NOT NULL default '0',
`active_template` varchar(500) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

[DavidBoggitt]

OK - I've just tried installing 4.5.0 PB2 on a local WAMP and a vanilla 1.5.12 and all was fine - I noticed I get the message that the directory iFDownloads was created so could this be the problem - that it couldn't be created on the live server?

If so, could I create this directory myself and then try reinstalling?

Cheers,

Dave.

[Jordan]

Interesting, on the site that caused the error it is complaining about the size of the varchar. What database and version are you using? If you need a quick fix you can edit the installation XML file (the only xml file in the zip) and change that varchar(500) to varchar(255).

[DavidBoggitt]

Hi Jordan and thanks for getting back to me.

It's a MySQL utf8_general_ci database... set up from cpanel on my UK2 hosting account. It's J! 1.5.11 at the moment... it's a site very early in development and hadn't got round to updating to 1.5.12 yet... but could that be the problem...?! I think that it's the most recent version of ionFiles too (4.5.0 PB2).

Ok... just tried to install on another site on the same hosting account that is J! 1.5.12 and got the same error message... so that can't be it!

Another other thoughts, rather than your fix, in case other users run into the same problem?

Thanks again for taking the time to look at this.

Dave.

[Jordan]

I believe you might be using version 4 of MySQL while I developed and tested with version 5. I will fix it in the next release though. For now, however, the fix will have to suffice. Thanks for reporting the bug and if you find any other please let me know.

[DavidBoggitt]

Ah - yes, I'm positive that's right. Do you think that most hosts are using MySQL version 5 now and is mine lagging behind a little?

Thanks also explains why it worked perfectly on my local WAMP .

Dave.

P.S. Any timescale for 4.5.0 stable?

[Jordan]

I'm not sure. I've yet (well, until this installer for ionFiles) to run into a problem where something didn't work in MySQL 4 that did in MySQL 5. I'm not sure if hosts update or not, to be honest.

I'd love to get the stable version out by the end of next week but it doesn't seem like many people are willing to test the beta version.

[DavidBoggitt]

I'll give your fix a try and test it, but I was only going to use it for a fairly simple download listing. Still, it might turn up some bugs!

[DavidBoggitt]

Confirm: installation fine now! Thanks again,

Dave.

[Jordan]

Excellent! I'll add that fix to the final release.