Hi, I'm trying to install Elgg, so i'm following the instruction on the wiki but at the end o have the following errors

There were a number of issues: 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 '\'+00:00\' */' at line 1

QUERY: /*!40103 SET TIME_ZONE=\'+00:00\' */; 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 '\'NO_AUTO_VALUE_ON_ZERO\' */' at line 1

QUERY: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=\'NO_AUTO_VALUE_ON_ZERO\' */; 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 '\'0\',
PRIMARY KEY (`id`),
KEY `owner_guid` (`owner_guid`),
KEY `site_guid' at line 5

QUERY: CREATE TABLE `elgg_access_collections` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`site_guid` bigint(20) unsigned NOT NULL DEFAULT \'0\',
PRIMARY KEY (`id`),
KEY `owner_guid` (`owner_guid`),
KEY `site_guid` (`site_guid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; 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 '\'integer\',\'text\') NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`' at line 6

QUERY: CREATE TABLE `elgg_annotations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_guid` bigint(20) unsigned NOT NULL,
`name_id` int(11) NOT NULL,
`value_id` int(11) NOT NULL,
`value_type` enum(\'integer\',\'text\') NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`access_id` int(11) NOT NULL,
`time_created` int(11) NOT NULL,
`enabled` enum(\'yes\',\'no\') NOT NULL DEFAULT \'yes\',
PRIMARY KEY (`id`),
KEY `entity_guid` (`entity_guid`),
KEY `name_id` (`name_id`),
KEY `value_id` (`value_id`),
KEY `owner_guid` (`owner_guid`),
KEY `access_id` (`access_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 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 '\'1\',
PRIMARY KEY (`id`),
UNIQUE KEY `api_key` (`api_key`)
) ENGINE=MyISAM ' at line 6

QUERY: CREATE TABLE `elgg_api_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_guid` bigint(20) unsigned DEFAULT NULL,
`api_key` varchar(40) DEFAULT NULL,
`secret` varchar(40) NOT NULL,
`active` int(1) DEFAULT \'1\',
PRIMARY KEY (`id`),
UNIQUE KEY `api_key` (`api_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 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 '\'object\',\'user\',\'group\',\'site\') NOT NULL,
`subtype` int(11) DEFAULT NU' at line 3

QUERY: CREATE TABLE `elgg_entities` (
`guid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` enum(\'object\',\'user\',\'group\',\'site\') NOT NULL,
`subtype` int(11) DEFAULT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`site_guid` bigint(20) unsigned NOT NULL,
`container_guid` bigint(20) unsigned NOT NULL,
`access_id` int(11) NOT NULL,
`time_created` int(11) NOT NULL,
`time_updated` int(11) NOT NULL,
`last_action` int(11) NOT NULL DEFAULT \'0\',
`enabled` enum(\'yes\',\'no\') NOT NULL DEFAULT \'yes\',
PRIMARY KEY (`guid`),
KEY `type` (`type`),
KEY `subtype` (`subtype`),
KEY `owner_guid` (`owner_guid`),
KEY `site_guid` (`site_guid`),
KEY `container_guid` (`container_guid`),
KEY `access_id` (`access_id`),
KEY `time_created` (`time_created`),
KEY `time_updated` (`time_updated`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 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 '\'object\',\'user\',\'group\',\'site\') NOT NULL,
`subtype` varchar(50) NOT NU' at line 3

QUERY: CREATE TABLE `elgg_entity_subtypes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` enum(\'object\',\'user\',\'group\',\'site\') NOT NULL,
`subtype` varchar(50) NOT NULL,
`class` varchar(50) NOT NULL DEFAULT \'\',
PRIMARY KEY (`id`),
UNIQUE KEY `type` (`type`,`subtype`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 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 '\'integer\',\'text\') NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`' at line 6

QUERY: CREATE TABLE `elgg_metadata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_guid` bigint(20) unsigned NOT NULL,
`name_id` int(11) NOT NULL,
`value_id` int(11) NOT NULL,
`value_type` enum(\'integer\',\'text\') NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`access_id` int(11) NOT NULL,
`time_created` int(11) NOT NULL,
`enabled` enum(\'yes\',\'no\') NOT NULL DEFAULT \'yes\',
PRIMARY KEY (`id`),
KEY `entity_guid` (`entity_guid`),
KEY `name_id` (`name_id`),
KEY `value_id` (`value_id`),
KEY `owner_guid` (`owner_guid`),
KEY `access_id` (`access_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 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 '\'yes\',\'no\') NOT NULL DEFAULT \'yes\',
`time_created` int(11) NOT NULL,
P' at line 11

QUERY: CREATE TABLE `elgg_system_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`object_id` int(11) NOT NULL,
`object_class` varchar(50) NOT NULL,
`object_type` varchar(50) NOT NULL,
`object_subtype` varchar(50) NOT NULL,
`event` varchar(50) NOT NULL,
`performed_by_guid` int(11) NOT NULL,
`owner_guid` int(11) NOT NULL,
`access_id` int(11) NOT NULL,
`enabled` enum(\'yes\',\'no\') NOT NULL DEFAULT \'yes\',
`time_created` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `object_id` (`object_id`),
KEY `object_class` (`object_class`),
KEY `object_type` (`object_type`),
KEY `object_subtype` (`object_subtype`),
KEY `event` (`event`),
KEY `performed_by_guid` (`performed_by_guid`),
KEY `access_id` (`access_id`),
KEY `time_created` (`time_created`),
KEY `river_key` (`object_type`,`object_subtype`,`event`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 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 '\'\',
`password` varchar(32) NOT NULL DEFAULT \'\',
`salt` varchar(8) NOT NU' at line 4

QUERY: CREATE TABLE `elgg_users_entity` (
`guid` bigint(20) unsigned NOT NULL,
`name` text NOT NULL,
`username` varchar(128) NOT NULL DEFAULT \'\',
`password` varchar(32) NOT NULL DEFAULT \'\',
`salt` varchar(8) NOT NULL DEFAULT \'\',
`email` text NOT NULL,
`language` varchar(6) NOT NULL DEFAULT \'\',
`code` varchar(32) NOT NULL DEFAULT \'\',
`banned` enum(\'yes\',\'no\') NOT NULL DEFAULT \'no\',
`admin` enum(\'yes\',\'no\') NOT NULL DEFAULT \'no\',
`last_action` int(11) NOT NULL DEFAULT \'0\',
`prev_last_action` int(11) NOT NULL DEFAULT \'0\',
`last_login` int(11) NOT NULL DEFAULT \'0\',
`prev_last_login` int(11) NOT NULL DEFAULT \'0\',
PRIMARY KEY (`guid`),
UNIQUE KEY `username` (`username`),
KEY `password` (`password`),
KEY `email` (`email`(50)),
KEY `code` (`code`),
KEY `last_action` (`last_action`),
KEY `last_login` (`last_login`),
KEY `admin` (`admin`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY `name_2` (`name`,`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 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 '\'0\',
`data` mediumblob,
PRIMARY KEY (`session`),
KEY `ts` (`ts`)
) ENGIN' at line 3

QUERY: CREATE TABLE `elgg_users_sessions` (
`session` varchar(255) NOT NULL,
`ts` int(11) unsigned NOT NULL DEFAULT \'0\',
`data` mediumblob,
PRIMARY KEY (`session`),
KEY `ts` (`ts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Variable 'sql_mode' can't be set to the value of 'NULL'

QUERY: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

Thanks for you help