change the date
- Dirk
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
12 years 7 months ago - 12 years 7 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.
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: 12 years 7 months ago by Dirk.
Please Log in to join the conversation.
- Dirk
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
12 years 7 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.
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: Dirk, joest