JInstaller::install: Error SQL (error in RC5 installation)

Hi,

First Thank you for this component.

I have been searching the forum to solve my install error, but I have been unable to find an answer.

I am running joomla 1.5.10 and I am trying to install the chronoform RC5 component, I have tried to do a manual installation but I can't do it, I unpack the zip and point the istallation to "http://mydomain.com/test/chronoinstall" (I am not in the root folder, I am developing the site in the "test" folder), and it says "installation package not found"

When I try to install through the manager it pops this warning:

JInstaller::install: Error SQL. DB function failed with error number 1064
Algo est� equivocado en su sintax cerca 'CHARACTER SET `utf8`' en la linea 29 SQL=CREATE TABLE IF NOT EXISTS `jos_chrono_contact` ( `id` INT NOT NULL AUTO_INCREMENT, `name` TEXT NOT NULL, `html` LONGTEXT NOT NULL, `scriptcode` LONGTEXT NOT NULL, `redirecturl` TEXT NOT NULL, `emailresults` TINYINT(1) NOT NULL, `fieldsnames` TEXT NOT NULL, `fieldstypes` TEXT NOT NULL, `onsubmitcode` LONGTEXT NOT NULL, `onsubmitcodeb4` LONGTEXT NOT NULL, `server_validation` LONGTEXT NOT NULL, `attformtag` LONGTEXT NOT NULL, `submiturl` TEXT NOT NULL, `emailtemplate` LONGTEXT NOT NULL, `useremailtemplate` LONGTEXT NOT NULL, `paramsall` LONGTEXT NOT NULL, `titlesall` LONGTEXT NOT NULL, `dbclasses` LONGTEXT NOT NULL, `autogenerated` LONGTEXT NOT NULL, `chronocode` LONGTEXT NOT NULL, `theme` TEXT NOT NULL, `published` TINYINT(1) NOT NULL, `extra1` LONGTEXT NOT NULL, `extra2` LONGTEXT NOT NULL, `extra3` LONGTEXT NOT NULL, `extra4` LONGTEXT NOT NULL, `extra5` LONGTEXT NOT NULL, PRIMARY KEY (`id`) ) CHARACTER SET `utf8`
SQL =

CREATE TABLE IF NOT EXISTS `jos_chrono_contact` (
           `id` INT NOT NULL AUTO_INCREMENT,
           `name` TEXT NOT NULL,
		   `html` LONGTEXT NOT NULL,
		   `scriptcode` LONGTEXT NOT NULL,
		   `redirecturl` TEXT NOT NULL,
		   `emailresults` TINYINT(1) NOT NULL,
		   `fieldsnames` TEXT NOT NULL,
		   `fieldstypes` TEXT NOT NULL,
		   `onsubmitcode` LONGTEXT NOT NULL,
		   `onsubmitcodeb4` LONGTEXT NOT NULL,
		   `server_validation` LONGTEXT NOT NULL,
		   `attformtag` LONGTEXT NOT NULL,
		   `submiturl` TEXT NOT NULL,	 
		   `emailtemplate` LONGTEXT NOT NULL,	
		   `useremailtemplate` LONGTEXT NOT NULL,  
		   `paramsall` LONGTEXT NOT NULL,
		   `titlesall` LONGTEXT NOT NULL,
		   `dbclasses` LONGTEXT NOT NULL,
		   `autogenerated` LONGTEXT NOT NULL,
		   `chronocode` LONGTEXT NOT NULL,
		   `theme` TEXT NOT NULL,
           `published` TINYINT(1) NOT NULL,
		   `extra1` LONGTEXT NOT NULL,
		   `extra2` LONGTEXT NOT NULL,
		   `extra3` LONGTEXT NOT NULL,
		   `extra4` LONGTEXT NOT NULL,
		   `extra5` LONGTEXT NOT NULL,
            PRIMARY KEY (`id`) ) CHARACTER SET `utf8`

Please could you help me?

Hi tama,

the zip files are unpacked directly under this path ?

some fix which "may" work for you and was reported by another user:

By the way a good fix to address the installation problems on hosting companies is to create a PHP.ini file and add the text (which depends on host) max_execution_time = 300 (1and1 allows me to process uploads to MYSQL for 300 seconds).

Cheers
Max

Thank you for the response.

I can't see where php.ini is. I think it's hidden

My ISP have told me that the final sentence "CHARACTER SET `utf8`" is incompatible with his version of MySQL (???). Can I avoid it (or change it)?
Thanks

Well I have edited "chronocontact.xml" removing the string "CHARACTER SET `utf8`", packing it again and it works!
Is there any issue doing this?

Thanks

Hi Tama,

The only downside is that you might have some odd problems saving special characters but if your site is mostly in English it shouldn't be any problem.

Bob

My site is is Spanish, so characters like "ñ" and tildes may be a problem...
I must talk with my ISP to found a solution. Perhaps with another codification?
any hint? (it's very strange to me the incompatibility thing...)