Hjælp hvorfor denne fejl.
Hej.Har hentet et program som jeg vil installere på min server.
men jeg får en fejl når den opretter tabellerne i sql.
Den skriver Mysql: Forkert datetime værdi: `14: 01:05, 28
jan 2014 12:00:00 `for kolonne`addDate ì række 1
Her er listen den opretter tabellerne efter, er det i den fejlen
ligger eller hvor ???
CREATE TABLE `{dbprefix}app` (
`ID` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
`restore` datetime NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}chat` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`from` varchar(255) NOT NULL DEFAULT '',
`to` varchar(255) NOT NULL DEFAULT '',
`message` text NOT NULL,
`sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`recd` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}event` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`EventInput` varchar(255) CHARACTER SET latin1 NOT NULL,
`datepicker` int(11) NOT NULL,
`where_text` varchar(255) CHARACTER SET latin1 NOT NULL,
`WhoInvited` varchar(255) CHARACTER SET latin1 NOT NULL,
`e_user` varchar(200) CHARACTER SET latin1 NOT NULL,
`date_created` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}forum_posts` (
`p_id` int(11) NOT NULL AUTO_INCREMENT,
`topic_id` int(11) NOT NULL,
`p_user` varchar(80) NOT NULL,
`p_reply` longtext NOT NULL,
`p_datetime` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}forum_topics` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`topic` varchar(255) NOT NULL DEFAULT '',
`detail` longtext NOT NULL,
`t_user` varchar(80) NOT NULL,
`datetime` varchar(25) NOT NULL DEFAULT '',
`views` int(4) NOT NULL DEFAULT '0',
`replies` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}members` (
`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`md5_id` varchar(255) NOT NULL,
`username` varchar(80) NOT NULL,
`first_name` varchar(20) NOT NULL,
`last_name` varchar(40) NOT NULL,
`email` varchar(80) NOT NULL,
`aim` varchar(80) NOT NULL,
`msn` varchar(80) NOT NULL,
`gtalk` varchar(80) NOT NULL,
`ichat` varchar(80) NOT NULL,
`twitter` varchar(80) NOT NULL,
`facebook` varchar(80) NOT NULL,
`users_ip` varchar(200) NOT NULL,
`dob` date NOT NULL DEFAULT '1900-01-01',
`bio` mediumtext NOT NULL,
`privacy` tinyint(1) NOT NULL,
`signature` tinytext NOT NULL,
`password` varchar(255) NOT NULL,
`activation_code` int(10) NOT NULL DEFAULT '0',
`auth_token` varchar(255) DEFAULT NULL,
`active` tinyint(1) DEFAULT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{dbprefix}membermeta` (
`umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`meta` varchar(155) DEFAULT NULL,
`value` longtext,
PRIMARY KEY (`umeta_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}news` (
`newsid` int(11) NOT NULL AUTO_INCREMENT,
`dtime` datetime DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`text` text,
PRIMARY KEY (`newsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}notes` (
`n_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`note` tinytext NOT NULL,
`n_user` varchar(255) NOT NULL DEFAULT '',
`author` varchar(255) NOT NULL DEFAULT '',
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`date_created` int(11) NOT NULL,
PRIMARY KEY (`n_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}online` (
`o_user` text CHARACTER SET latin1 NOT NULL,
`timeout` text CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}options` (
`option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`option_name` varchar(64) NOT NULL DEFAULT '',
`option_value` longtext NOT NULL,
PRIMARY KEY (`option_id`),
UNIQUE KEY `option_name` (`option_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}plugins` (
`plugin_id` int(11) NOT NULL AUTO_INCREMENT,
`plugin_loc` text NOT NULL,
PRIMARY KEY (`plugin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{dbprefix}plugin_updates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`plugin_slug` varchar(255) NOT NULL,
`version` varchar(255) NOT NULL,
`update_url` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `plugin_slug` (`plugin_slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}private_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`message` text CHARACTER SET latin1 NOT NULL,
`from` int(11) NOT NULL,
`to` int(11) NOT NULL,
`from_viewed` tinyint(1) NOT NULL DEFAULT '0',
`to_viewed` tinyint(1) NOT NULL DEFAULT '0',
`from_deleted` tinyint(1) NOT NULL DEFAULT '0',
`to_deleted` tinyint(1) NOT NULL DEFAULT '0',
`from_vdate` datetime DEFAULT NULL,
`to_vdate` datetime DEFAULT NULL,
`from_ddate` datetime DEFAULT NULL,
`to_ddate` datetime DEFAULT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}projects` (
`p_id` int(11) NOT NULL AUTO_INCREMENT,
`ptype_id` int(11) NOT NULL,
`project_name` varchar(255) NOT NULL,
`project_description` text NOT NULL,
`creator` varchar(255) NOT NULL,
`contact_email` varchar(80) NOT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}project_forum_posts` (
`p_id` int(11) NOT NULL AUTO_INCREMENT,
`topic_id` int(11) NOT NULL,
`pp_id` int(11) NOT NULL,
`pfp_user` varchar(80) NOT NULL,
`pfp_post` longtext NOT NULL,
`pfp_datetime` datetime NOT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}project_forum_topics` (
`pft_id` int(11) NOT NULL AUTO_INCREMENT,
`pt_id` int(11) NOT NULL,
`pft_topic` varchar(255) NOT NULL DEFAULT '',
`pft_detail` longtext NOT NULL,
`pft_user` varchar(80) NOT NULL,
`pft_datetime` datetime NOT NULL,
`pft_view` int(11) NOT NULL DEFAULT '0',
`pft_reply` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`pft_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}project_leaders` (
`pl_id` int(11) NOT NULL AUTO_INCREMENT,
`p_id` int(11) NOT NULL,
`pl_user` varchar(255) NOT NULL,
PRIMARY KEY (`pl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}project_members` (
`pm_id` int(11) NOT NULL AUTO_INCREMENT,
`pp_id` int(11) NOT NULL,
`pm_user` varchar(255) NOT NULL,
PRIMARY KEY (`pm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}project_types` (
`pt_id` int(11) NOT NULL AUTO_INCREMENT,
`project_type` varchar(255) NOT NULL,
`dt_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`pt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}saved_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`report_title` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
`report_vars` longtext CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (`id`),
KEY `report_title` (`report_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{dbprefix}todo` (
`taskID` int(11) NOT NULL AUTO_INCREMENT,
`pID` int(11) NOT NULL,
`shortdesc` varchar(155) NOT NULL DEFAULT '',
`longdesc` text NOT NULL,
`priority` varchar(255) NOT NULL,
`status` int(11) NOT NULL DEFAULT '0',
`expdate` date NOT NULL,
KEY `taskID` (`taskID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}user_types` (
`usrt_id` int(11) NOT NULL AUTO_INCREMENT,
`user_type` varchar(255) NOT NULL,
`dt_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`usrt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}user_user_types` (
`uut_id` int(11) NOT NULL AUTO_INCREMENT,
`ut_id` int(11) NOT NULL,
`uut_user` varchar(255) NOT NULL,
PRIMARY KEY (`uut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}wall_likes_username` (
`l_user` varchar(100) NOT NULL,
`post_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}wall_posts` (
`p_id` int(11) NOT NULL AUTO_INCREMENT,
`post` varchar(255) NOT NULL,
`date_created` int(11) NOT NULL,
`p_user` varchar(200) NOT NULL,
`email` varchar(80) NOT NULL,
`likes` int(11) NOT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `{dbprefix}wall_posts_comments` (
`c_id` int(11) NOT NULL AUTO_INCREMENT,
`c_user` varchar(200) NOT NULL,
`comments` text NOT NULL,
`date_created` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`email` varchar(80) NOT NULL,
PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{dbprefix}user_perms` (
`ID` bigint(20) unsigned zerofill NOT NULL AUTO_INCREMENT,
`userID` bigint(20) NOT NULL,
`permID` bigint(20) NOT NULL,
`value` tinyint(1) NOT NULL DEFAULT '0',
`addDate` datetime NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `userID` (`userID`,`permID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE IF NOT EXISTS `{dbprefix}permissions` (
`ID` bigint(20) unsigned zerofill NOT NULL AUTO_INCREMENT,
`permKey` varchar(30) NOT NULL,
`permName` varchar(30) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `permKey` (`permKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000001, 'access_admin', 'Access Admin');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000002, 'add_news', 'Add News');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000003, 'edit_news', 'Edit News');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000004, 'delete_news', 'Delete News');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000005, 'generate_reports', 'Generate Reports');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000006, 'access_site', 'Access Site');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000007, 'add_projects', 'Add Projects');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000008, 'edit_projects', 'Edit Projects');
INSERT INTO `{dbprefix}permissions` (`ID`, `permKey`, `permName`) VALUES(00000000000000000009, 'delete_projects', 'Delete Projects');
CREATE TABLE IF NOT EXISTS `{dbprefix}roles` (
`ID` bigint(20) unsigned zerofill NOT NULL AUTO_INCREMENT,
`roleName` varchar(20) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `roleName` (`roleName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `{dbprefix}roles` (`ID`, `roleName`) VALUES(00000000000000000001, 'Administrator');
INSERT INTO `{dbprefix}roles` (`ID`, `roleName`) VALUES(00000000000000000002, 'Member');
CREATE TABLE IF NOT EXISTS `{dbprefix}role_perms` (
`ID` bigint(20) unsigned zerofill NOT NULL AUTO_INCREMENT,
`roleID` bigint(20) NOT NULL,
`permID` bigint(20) NOT NULL,
`value` tinyint(1) NOT NULL DEFAULT '0',
`addDate` datetime NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `roleID_2` (`roleID`,`permID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000007, 0, 1, 0, '2012-03-17 12:20:57');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000008, 0, 2, 0, '2012-03-17 12:20:57');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000009, 0, 4, 0, '2012-03-17 12:20:57');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000010, 0, 3, 0, '2012-03-17 12:20:57');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000022, 2, 6, 1, '2012-03-17 18:45:01');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000023, 1, 1, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000024, 1, 6, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000025, 1, 2, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000026, 1, 7, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000027, 1, 4, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000028, 1, 9, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000029, 1, 3, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000030, 1, 8, 1, '2012-03-24 01:31:27');
INSERT INTO `{dbprefix}role_perms` (`ID`, `roleID`, `permID`, `value`, `addDate`) VALUES(00000000000000000031, 1, 5, 1, '2012-03-24 01:31:27');
CREATE TABLE IF NOT EXISTS `{dbprefix}user_roles` (
`userID` bigint(20) NOT NULL,
`roleID` bigint(20) NOT NULL,
`addDate` datetime NOT NULL,
UNIQUE KEY `userID` (`userID`,`roleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `{dbprefix}user_roles` (`userID`, `roleID`, `addDate`) VALUES (1, 1, '{datenow} 12:00:00');