Jump to content

Problem with installing [Resolved]

- - - - -
Started by DavidBoggitt, Jul 13 2009 12:34 AM

This topic has been archived. This means that you cannot reply to this topic.
10 replies to this topic

#1
DavidBoggitt
Posted 13 July 2009 - 12:34 AM

DavidBoggitt

    Newbie

  • Members
  • PipPip
  • 26 posts
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;

#2
DavidBoggitt
Posted 13 July 2009 - 08:51 AM

DavidBoggitt

    Newbie

  • Members
  • PipPip
  • 26 posts
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.

#3
Guest_Jordan_*
Posted 13 July 2009 - 01:45 PM

Guest_Jordan_*
  • Guests
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).

#4
DavidBoggitt
Posted 13 July 2009 - 02:13 PM

DavidBoggitt

    Newbie

  • Members
  • PipPip
  • 26 posts
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.

#5
Guest_Jordan_*
Posted 13 July 2009 - 02:27 PM

Guest_Jordan_*
  • Guests
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.

#6
DavidBoggitt
Posted 13 July 2009 - 02:36 PM

DavidBoggitt

    Newbie

  • Members
  • PipPip
  • 26 posts
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? :)

#7
Guest_Jordan_*
Posted 13 July 2009 - 02:42 PM

Guest_Jordan_*
  • Guests
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.

#8
DavidBoggitt
Posted 13 July 2009 - 02:47 PM

DavidBoggitt

    Newbie

  • Members
  • PipPip
  • 26 posts
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!

#9
DavidBoggitt
Posted 13 July 2009 - 02:55 PM

DavidBoggitt

    Newbie

  • Members
  • PipPip
  • 26 posts
Confirm: installation fine now! Thanks again,

Dave.

#10
Guest_Jordan_*
Posted 13 July 2009 - 04:36 PM

Guest_Jordan_*
  • Guests
Excellent! I'll add that fix to the final release. :)

#11
Guest_Jordan_*
Posted 05 August 2009 - 07:05 AM

Guest_Jordan_*
  • Guests
Fixed in Public Beta 3. Closed.
Back to ionFiles




  1. CODECALL Programming Forum
  2. → General Discussion
  3. → Community Projects
  4. → ionFiles
IPB skins by Skinbox