Piler Export

[Former user]

Hi!

I'm getting this error log in pilerexport, it doesn't export the messages.

Apr  5 15:53:43 mailpiler pilerexport[8471]: 40000000570409c114163c1c00b7c43ecea1: mysql_stmt_prepare() error: Unknown column 'deleted' in 'where clause' => sql: SELECT DISTINCT `id`, `piler_id`, `digest`, `bodydigest` FROM v_messages WHERE deleted=0  AND  `sent` >= 1326247200 AND  `sent` <= 1326333599 ORDER BY id ASC
Apr  5 15:53:58 mailpiler pilerexport[8523]: unknown key: "session_timeout"
Apr  5 15:53:58 mailpiler pilerexport[8523]: 40000000570409d0219920ac002b7e1ffc41: mysql_stmt_prepare() error: Unknown column 'deleted' in 'where clause' => sql: SELECT DISTINCT `id`, `piler_id`, `digest`, `bodydigest` FROM v_messages WHERE deleted=0  AND  `sent` >= 1326247200 AND  `sent` <= 1326333599 ORDER BY id ASC
Apr  5 15:54:04 mailpiler pilerexport[8536]: unknown key: "session_timeout"
Apr  5 15:54:04 mailpiler pilerexport[8536]: 40000000570409d60b5b3bf40064882f5ffd: mysql_stmt_prepare() error: Unknown column 'deleted' in 'where clause' => sql: SELECT DISTINCT `id`, `piler_id`, `digest`, `bodydigest` FROM v_messages WHERE deleted=0  AND  `sent` >= 1326247200 AND  `sent` <= 1329011999 ORDER BY id ASC

[Former user]

I changed v_message view to add metadata.deleted and the issue is fixed.

I think it should be added to a .sql in the util folder, like db-upgrade-to-master.sql.

[Janos SUTO]

What version do you have? Was it an upgrade? If so, then from which version?

[Former user]

Git master.... I was on 1.2.0

[Janos SUTO]

I see it now. I've just added the fix to the master branch. Thanks for noticing the glitch.