change the date

More
11 years 6 months ago - 11 years 6 months ago #1164 by Dirk
Replied by Dirk on topic Re: change the date
If the date is on the first of the month the month will also be changed. I am really sure it is the timezone. Don't forget that every user can have his own timezone in joomla.

Please send a sql-dump with the structure of your table and 2 or 3 examples to This email address is being protected from spambots. You need JavaScript enabled to view it.
DROP TABLE IF EXISTS `krcw_joodb_sample`;
CREATE TABLE IF NOT EXISTS `krcw_joodb_sample` (
  `myid` int(1) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
...
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `image` longblob,
  PRIMARY KEY (`myid`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

INSERT INTO `krcw_joodb_sample` (`myid`, `title`, `value`, `usefull`, `picture`, `short_description`, `description`, `wikipedia`, `category`, `date`, `state`, `image`) VALUES
(3, 'Basketball', '9,45', 'Yes', 'basketball.jpg', 'A Baskeball sport utility.', 'Basketball is a team sport ...', 'http://en.wikipedia.org/wiki/Basketball', 'Sport', '2009-10-27 15:36:39', 1, NULL),
(12, 'Paprika', '1,9', 'Yes', 'paprica.jpg', 'I wonder why people .....', 'http://en.wikipedia.org/wiki/Paprika', 'Food', '2009-10-15 16:15:46', 1, NULL),
(13, 'Football', '14', 'Yes', 'football.jpg', 'In America ....', 'Football is the name ....', 'http://en.wikipedia.org/wiki/Football', 'Sport', '2009-10-27 17:27:31', 1, NULL);
Last edit: 11 years 6 months ago by Dirk.

Please Log in to join the conversation.

More
11 years 6 months ago #1170 by Dirk
Replied by Dirk on topic Re: change the date
Just to close the thread.

It was in fact the timzone

So if you have a similar problem check
"global configuration -> server -> location settings"
in Joomla 2.5

The "Server Time Zone" must be "UTC".

Only if you have a unusal configuration. (E.g. A local Windows XAMPP installation) it might be your local Timezone.

Please Log in to join the conversation.

Moderators: Dirkjoest