If you have a error in istalation
Quote:
"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 'DEFAULT CHARSET=utf8' at line 15"
see:
solutionyou can edit the .sql files to remove the expression DEFAULT CHARSET-latin1
the good code is this :
code .sql
-- table `xg_class`
CREATE TABLE `xg_class` (
`class_id` mediumint(8) NOT NULL auto_increment,
`class_name` varchar(60) NOT NULL default '',
`class_short_name` char(3) NOT NULL default '',
`module_id` mediumint(8) NOT NULL default '0',
`primary_field_name` varchar(60) NOT NULL default '',
`is_for_admin` tinyint(1) NOT NULL default '0',
`is_for_creator` tinyint(1) NOT NULL default '0',
`in_block` tinyint(1) NOT NULL default '1',
`is_wrf_valid` tinyint(1) NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
`date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
`date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`class_id`)
) ENGINE=MyISAM ;
-- table `xg_module`
CREATE TABLE `xg_module` (
`module_id` mediumint(8) NOT NULL auto_increment,
`module_name` varchar(30) NOT NULL default '0',
`short_name` char(2) NOT NULL default '',
`version` varchar(10) NOT NULL default '',
`master_class_name` varchar(60) NOT NULL default '0',
`date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
`date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`module_id`)
) ENGINE=MyISAM ;
-- table `xg_field_def`
CREATE TABLE `xg_field_def` (
`field_id` mediumint(8) NOT NULL auto_increment,
`key_id` mediumint(8) NOT NULL default '0',
`class_id` mediumint(8) NOT NULL default '0',
`field_name` varchar(60) NOT NULL default '',
`field_type` varchar(60) NOT NULL default '',
`html_type` varchar(60) NOT NULL default '',
`size` mediumint(8) NOT NULL default '0',
`html_extra` varchar(100) NOT NULL default '',
`source_join_key` varchar(60) NOT NULL default '',
`foreign_class` varchar(60) NOT NULL default '',
`weight` smallint(3) NOT NULL default '0',
`tray` varchar(20) NOT NULL default '',
`default_value` varchar(80) NOT NULL default '',
`is_needed` tinyint(1) NOT NULL default '0',
`is_in_create_form` tinyint(1) NOT NULL default '0',
`is_in_modif_form` tinyint(1) NOT NULL default '0',
`is_search` tinyint(1) NOT NULL default '0',
`is_list_show` tinyint(1) NOT NULL default '0',
`is_partof_desc` tinyint(1) NOT NULL default '0',
`is_partof_key_unicity` tinyint(1) NOT NULL default '0',
`with_help` tinyint(1) NOT NULL default '0',
`uid` mediumint(8) NOT NULL default '0',
`date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
`date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`field_id`)
) ENGINE=MyISAM ;
-- table `xg_statut`
CREATE TABLE `xg_statut` (
`statut_id` mediumint(8) NOT NULL auto_increment,
`class_id` mediumint(8) NOT NULL default '0',
`statut_number` tinyint(2) NOT NULL default '0',
`with_historique` tinyint(1) NOT NULL default '0',
`template_visu` mediumint(8) NOT NULL default '0',
`statut_name` varchar(30) NOT NULL default '0',
`date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
`date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`statut_id`)
) ENGINE=MyISAM ;
-- table `xg_statut_criteria`
CREATE TABLE `xg_statut_criteria` (
`criteria_id` mediumint(8) NOT NULL auto_increment,
`statut_id` mediumint(8) NOT NULL default '0',
`php_variable_name` varchar(60) NOT NULL default '',
`class_id` mediumint(8) NOT NULL default '0',
`field_name` varchar(60) NOT NULL default '0',
`value` varchar(30) NOT NULL default '0',
`operator` varchar(10) NOT NULL default '0',
`transition` varchar(20) NOT NULL default '',
`uid` mediumint(8) NOT NULL default '0',
`date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
`date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`criteria_id`)
) ENGINE=MyISAM ;
-- table `xg_statut_field`
CREATE TABLE `xg_statut_field` (
`statut_field_id` mediumint(8) NOT NULL auto_increment,
`field_id` mediumint(8) NOT NULL default '0',
`statut_id` mediumint(8) NOT NULL default '0',
`rang` smallint(2) NOT NULL default '0',
`date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
`date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`statut_field_id`),
UNIQUE KEY `statut_field_id` (`statut_field_id`)
) ENGINE=MyISAM ;
-- table `xg_action`
CREATE TABLE `xg_action` (
`action_id` mediumint(8) NOT NULL auto_increment,
`action_name` varchar(60) NOT NULL default '',
`weight` mediumint(3) NOT NULL default '0',
`with_confirm` tinyint(1) NOT NULL default '0',
`statut_id` mediumint(8) NOT NULL default '0',
`class_id` mediumint(8) NOT NULL default '0',
`date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
`date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`action_id`)
) ENGINE=MyISAM ;
The instalacion is a correct in this moment
best regarts
aixos
