- Timo Sirainen, 2008-08-31 07:40
[...] How were you able to create a "when" column? I only get syntax error if I try to do that. [...]
Wow, Timo, you're the man - great catch! 8-) I created the table using phpMyAdmin, which didn't seem to mind that column name. Now I changed it to "timestamp", and lo and behold:
[root@airframe]:~# mysql -p dovecot Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2813 Server version: 5.0.51 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from expire; +----------+-------------------+------------+ | username | path | timestamp | +----------+-------------------+------------+ | | zlatko-mail/Trash | 1222753691 | +----------+-------------------+------------+ 1 row in set (0,00 sec)
mysql>
Thanks a lot, I was just starting to sprinkle the expire plugin source with debugging statements all over the place to see what's going on. :-)
Thanks again, Thomas