[SOLVED]Error Installing

More
14 May 2013 16:50 - 14 May 2013 17:14 #945 by r3d4sh
I tried install Tractime Free an i see this error:

JInstaller: :Instalar: Error SQL DB función de error con el numero de error 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAUL 'C', `ex_id_calendars` int(11) DEFAULT NULL, `ex_version` varchar(' at line 8 SQL=CREATE TABLE IF NOT EXISTS `ltclg_tracktime_extensions` ( `id_extensions` int(11) NOT NULL AUTO_INCREMENT, `ex_title` varchar(50) NOT NULL, `ex_key` VARCHAR( 255 ) NULL DEFAULT NULL, `ex_commercial` tinyint(4) DEFAULT '0', `ex_valid_until` date DEFAULT NULL, `ex_id_ex_categories` int(11) DEFAULT NULL, `ex_type` ENUM( 'C', 'M', 'P', 'O' ) NOT NULL DEFAUL 'C', `ex_id_calendars` int(11) DEFAULT NULL, `ex_version` varchar(10) DEFAULT NULL, `ex_check` tinyint(4) DEFAULT NULL, `ex_update_url` varchar(255) DEFAULT NULL, `ex_enabled` tinyint(4) DEFAULT '0', `ex_j15` tinyint(4) DEFAULT NULL, `ex_j25` tinyint(4) DEFAULT NULL, `ex_j30` tinyint(4) DEFAULT NULL, `ex_note` text, PRIMARY KEY (`id_extensions`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
SQL =

CREATE TABLE IF NOT EXISTS `#__tracktime_extensions` (
`id_extensions` int(11) NOT NULL AUTO_INCREMENT,
`ex_title` varchar(50) NOT NULL,
`ex_key` VARCHAR( 255 ) NULL DEFAULT NULL,
`ex_commercial` tinyint(4) DEFAULT '0',
`ex_valid_until` date DEFAULT NULL,
`ex_id_ex_categories` int(11) DEFAULT NULL,
`ex_type` ENUM( 'C', 'M', 'P', 'O' ) NOT NULL DEFAUL 'C',
`ex_id_calendars` int(11) DEFAULT NULL,
`ex_version` varchar(10) DEFAULT NULL,
`ex_check` tinyint(4) DEFAULT NULL,
`ex_update_url` varchar(255) DEFAULT NULL,
`ex_enabled` tinyint(4) DEFAULT '0',
`ex_j15` tinyint(4) DEFAULT NULL,
`ex_j25` tinyint(4) DEFAULT NULL,
`ex_j30` tinyint(4) DEFAULT NULL,
`ex_note` text,
PRIMARY KEY (`id_extensions`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

My Versión of MySQL is 5.1.6 and php 5,3,24.

Thanks
Last edit: 14 May 2013 17:14 by admin.

Please Log in to join the conversation.

More
14 May 2013 16:53 #946 by admin
Replied by admin on topic [SOLVED]Error Installing
damn it, a typo in the install script

I'll create a new version ASAP

Please Log in to join the conversation.

More
14 May 2013 17:06 #947 by admin
Replied by admin on topic [SOLVED]Error Installing
please try again now

Please Log in to join the conversation.

More
14 May 2013 17:06 - 14 May 2013 17:08 #948 by r3d4sh
Replied by r3d4sh on topic [SOLVED]Error Installing
L'installazione è stata completata perfettamente.

grazie mille.

E. Fresno.
Last edit: 14 May 2013 17:08 by r3d4sh.

Please Log in to join the conversation.

Time to create page: 0.223 seconds