Avatar billede jjbirk Nybegynder
29. januar 2014 - 17:57 Der er 10 kommentarer og
1 løsning

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');
Avatar billede arne_v Ekspert
29. januar 2014 - 18:15 #1
14:01:05, 28 jan 2014 12:00:00

er vel forkert format

maaske:

2014-01-28 14:01:05
Avatar billede jjbirk Nybegynder
29. januar 2014 - 18:20 #2
Hej Arne.

Måske men hvor skal det ændres ??
Jeg er langt fra god til dette så håber du vil sætte det ind, så det bliver rigtigt.
Avatar billede jjbirk Nybegynder
29. januar 2014 - 18:26 #3
Fejlen kan også ses på billedet jeg har lagt her
http://gupl.dk/706839/
Håber det evt. hjælper med at kunne finde fejlen.
Avatar billede arne_v Ekspert
29. januar 2014 - 18:29 #4
Jeg gaetter paa at problemer er her:

INSERT INTO `{dbprefix}user_roles` (`userID`, `roleID`, `addDate`) VALUES (1, 1, '{datenow} 12:00:00');

Det som erstatter {datenow} med faktisk dato indsaetter et forkert format.
Avatar billede jjbirk Nybegynder
29. januar 2014 - 18:38 #5
Hmmm jeg er slet ikke med. Gider du indsætte det i filen og evt sende det til mig, på johnsen28@gmail.com

Jeg kan slet ikke se der er lavet nogle ændringer.
Avatar billede arne_v Ekspert
29. januar 2014 - 18:48 #6
Jeg kan ikke gaette mig til hvilken kode som processer {datenow}.

Hvis der kun er den ene linie og du kun skal koere det en enkelt gang saa kan du aendre linien til:

INSERT INTO `{dbprefix}user_roles` (`userID`, `roleID`, `addDate`) VALUES (1, 1, '2014-01-28 12:00:00');
Avatar billede jjbirk Nybegynder
29. januar 2014 - 19:16 #7
Ja så kom jeg da lidt længere :-)
men da jeg skulle til at oprette admin konto kom fejlen som vist
på billedet her
http://gupl.dk/706842/
Avatar billede jjbirk Nybegynder
29. januar 2014 - 22:00 #8
Hele programmet kan hentes her
http://projectpress.org/
hvis nogen ville hjælpe med at få det til at køre.
Avatar billede jjbirk Nybegynder
30. januar 2014 - 11:57 #9
Nå så gik det spørgsmål i stå :-(
Arne skriv et svar så jeg kan få lukket det.
Avatar billede jjbirk Nybegynder
31. januar 2014 - 22:08 #10
Hvad så Arne, smider du ikke et svar ??
Du fik mig jo lidt længere, godt nok ikke i mål.
Avatar billede jjbirk Nybegynder
01. februar 2014 - 12:40 #11
nå ingen svar, jamen så lukker jeg selv
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester