Hi Janos,
Am 25.08.2013 um 22:37 schrieb Janos SUTO <[email protected]>: > > Hello Christian, > > On 2013-08-25 21:50, Christian Vielhauer wrote: >> okay, i have tried with an mail from 22.8.2013. >> in webui table, it shows date "2013.08.24" >> in webui mailview, it shows "Date: Thu, 22 Aug 2013 11:31:57 +0200" > > > >> pilertest 4000....eml gives the following information: >> ..... >> sent: 1377163917, delivered-date: 0 >> hdr len: 1611 >> body digest: d39d18af8e5b6b0f1cae7f0c3edc8e6d842389a84074c69f8e2923aa9e38504a >> rules check: (null) >> retention period: 1598380156 >> attachments: >> direction: 3 >> spam: 0 >> _________________________________ >> Timestamp 1377163917 == 22/08/2013 == Date of Header > > so far so good > >>> Also connect to the piler database, and run the following: >>> select id, sent, archived from metadata limit 10; >> I think you mean column arrived, not archived, because archived is not >> available > > yes, you are right > > >> mysql> select id, sent, archived from metadata limit 10; >> ERROR 1054 (42S22): Unknown column 'archived' in 'field list' >> mysql> select id, sent, arrived from metadata limit 10; >> +----+------------+------------+ >> | id | sent | arrived | >> +----+------------+------------+ >> | 1 | 1322122415 | 1377158448 | >> | 2 | 1323787445 | 1377158448 | >> | 3 | 1296133257 | 1377158448 | >> | 4 | 1361173764 | 1377158448 | >> | 5 | 1325859359 | 1377158450 | >> | 6 | 1305890031 | 1377158450 | >> | 7 | 1352987456 | 1377158450 | >> | 8 | 1248235864 | 1377158450 | >> | 9 | 1370009806 | 1377158450 | >> | 10 | 1355389487 | 1377158450 | >> +----+------------+------------+ >> 10 rows in set (0.00 sec) >> Timestamp 1377158448 == 22/08/2013 !!!!! >> Timestamp 1322122415 == 24/11/2011 !!!!! > > > that's correct > > >> OR from same id as the .eml file: >> mysql> select id, sent, arrived from metadata where >> piler_id='40000000521906a80dbfb10400abf0ee5405'; >> +--------+------------+------------+ >> | id | sent | arrived | >> +--------+------------+------------+ >> | 276928 | 1377371806 | 1377371806 | >> +--------+------------+------------+ >> 1 row in set (0.00 sec) >> Timestamp 1377371806 == 24/08/2013 !!!!! but 22/08/2013 is read by pilertest > > > wait a second. When got an email by smtp, then sent = arrived = <current > timestamp> > However when import manually by pilerimport, then sent is usually differ from > arrived. > Arrived means when the email arrived the archive. > > I also took a spam from back 2006, and imported manually, and the gui shows > the date > properly: 2006.09.01. or similar. Also the shown date is computed from the > "sent" column > which is fine for you. > > Please check model/search/search.php, locate the get_meta_data function, and > verify that > it has the following line: > $m['date'] = date(DATE_TEMPLATE, $m['sent']); > $m['date'] = date(DATE_TEMPLATE, $m['sent']); > > then check DATE_TEMPLATE in config*php, and finally check the clock and > timezone of the virtual > machine. > $config['DATE_TEMPLATE'] = 'Y.m.d'; Europe/Budapest but it's same as Berlin ... Sun Aug 25 22:43:58 CEST 2013 > Janos > > > Everything looks right ... you have got the attached png from previous mail ? Chris
