SQL error during installation - please advise ASAP!

this is what I'm getting during the installation:

  • 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'' */' 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 `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,
    `ac' at line 6

    QUERY: CREATE TABLE `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 DE' at line 6

    QUERY: CREATE TABLE `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 NULL' at line 3

    QUERY: CREATE TABLE `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 NULL' at line 3

    QUERY: CREATE TABLE `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,
    `ac' at line 6

    QUERY: CREATE TABLE `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,
    PRI' at line 11

    QUERY: CREATE TABLE `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 'yes'',''no'') NOT NULL DEFAULT ''no'',
    `admin` enum(''yes'',''no'') NOT NULL D' at line 10

    QUERY: CREATE TABLE `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`)
    ) ENGINE=' at line 3

    QUERY: CREATE TABLE `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 */;