Last updated date
Hi all
I am using spip 1.8.2 d .
Few of my rubriques is showing the last updated date as the current
date.
How to correct this problem?
I have enclosed the table structure and two records .
The first rubrique, "Practical Information" (first sql statement below)
is showing the correct updated date, whereas "L'Institut" (the second sql statement
below) is showing the last updated date as the current date.
Thanks.
-------------------------------------------------------------------
INSERT INTO
`spip_rubriques`
(`id_rubrique`, `id_parent`, `titre`, `descriptif`, `texte`,
`id_secteur`, `maj`, `export`, `id_import`, `statut`, `date`, `lang`,
`langue_choisie`, `idx`, `extra`, `url_propre`, `statut_tmp`,
`date_tmp`) VALUES (7, 1, '5. Practical Information', '<abbr
title="Institut Français de Pondichéry"
lang="fr">IFP</abbr>',
0x7b7b7b5265616368696e6720746865204946507c616262727d7d7d0d0a0d0a3c70207374796c653d226865696768743a3230307078223e0d0a3c61626c653e,
1, '2008-02-04 17:12:16', 'oui', 0, 'prive', '0000-00-00 00:00:00',
'en', 'non', '', '', 'Practical-Information', 'prive', '0000-00-00
00:00:00');
INSERT INTO `spip_rubriques` (`id_rubrique`, `id_parent`, `titre`,
`descriptif`, `texte`, `id_secteur`, `maj`, `export`, `id_import`,
`statut`, `date`, `lang`, `langue_choisie`, `idx`, `extra`,
`url_propre`, `statut_tmp`, `date_tmp`) VALUES (8, 2, '1. L''Institut',
'Présentation',
0x7b7b7b446972656374696f6e7d7d7d0d0a446972656374657572203a204a65616e2d506965727265204d756c6c657220283c6120687265663d222e22028646f6e7420332076c3a9686963756c657320e2809c746f75732d7465727261696e73e2809d292e0d0a,
2, '2008-03-17 09:50:19', 'oui', 0, 'publie', '2006-12-21 00:00:00',
'fr', 'non', 'oui', '', 'L-Institut', 'publie', '2006-12-21 00:00:00');
CREATE TABLE `spip_rubriques` (
`id_rubrique` bigint(21) NOT NULL auto_increment,
`id_parent` bigint(21) NOT NULL default '0',
`titre` text NOT NULL,
`descriptif` text NOT NULL,
`texte` longblob NOT NULL,
`id_secteur` bigint(21) NOT NULL default '0',
`maj` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`export` varchar(10) default 'oui',
`id_import` bigint(20) default '0',
`statut` varchar(10) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`lang` varchar(10) NOT NULL default '',
`langue_choisie` char(3) default 'non',
`idx` enum('','1','non','oui','idx') NOT NULL default '',
`extra` longblob,
`url_propre` varchar(255) NOT NULL default '',
`statut_tmp` varchar(10) NOT NULL default '',
`date_tmp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id_rubrique`),
KEY `lang` (`lang`),
KEY `idx` (`idx`),
KEY `id_parent` (`id_parent`),
KEY `url_propre` (`url_propre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;
-------------------------------------------------------------------