1 Topic by maxdonato

  • maxdonato
  • Member
  • Offline
  • Registered: 2015-08-11
  • Posts: 31

Topic: cron work: delete_mailboxes.py

Hi Everybody,
every day i get this mail from cron

Traceback (most recent call last):
  File "/var/www/iredadmin/tools/delete_mailboxes.py", line 158, in <module>
    qr = conn.select('deleted_mailboxes', where=sql_where)
  File "/usr/lib/python2.7/site-packages/web/db.py", line 682, in select
    return self.query(qout, processed=True)
  File "/usr/lib/python2.7/site-packages/web/db.py", line 644, in query
    self._db_execute(db_cursor, sql_query)
  File "/usr/lib/python2.7/site-packages/web/db.py", line 587, in _db_execute
    out = cur.execute(query, params)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'delete_date' in 'where clause'")
maybe a type somewhere, but i'm unable to find it, anyone outhere?

Kind Regards
Max

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: Centos 7.3.1611
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Web server (Apache or Nginx):apache
- Manage mail accounts with iRedAdmin-Pro? no
- Related log if you're reporting an issue:
====

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: cron work: delete_mailboxes.py

Your iRedMail is not upgraded to the latest release.

SQL table "vmail.deleted_mailboxes" was introduced in a newer iRedMail release than the one you're running. Please follow iRedMail upgrade tutorials to upgrade it:
http://www.iredmail.org/docs/iredmail.releases.html

3 Reply by Ange7 (edited by Ange7 2017-04-12 17:16:51)

  • Ange7
  • Member
  • Offline
  • Registered: 2015-05-26
  • Posts: 96

Re: cron work: delete_mailboxes.py

That's wrong, i have the same problem and i have the latest release

@maxdonato : http://www.iredmail.org/docs/upgrade.ir … _mailboxes

sql> ALTER TABLE deleted_mailboxes ADD COLUMN delete_date DATE DEFAULT NULL;
sql> CREATE INDEX idx_delete_date ON deleted_mailboxes (delete_date);

Thinks fix my problem, but i have this problem only since 2017 January...

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: cron work: delete_mailboxes.py

Are you both running PostgreSQL backend?

5 Reply by Ange7

  • Ange7
  • Member
  • Offline
  • Registered: 2015-05-26
  • Posts: 96

Re: cron work: delete_mailboxes.py

ZhangHuangbin wrote:

Are you both running PostgreSQL backend?

No, MySQL

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: cron work: delete_mailboxes.py

Hi @Ange7,

I need confirm: are you running iRedMail-0.9.6? was it upgraded from an old iRedMail release?

7 Reply by Ange7 (edited by Ange7 2017-04-12 23:12:52)

  • Ange7
  • Member
  • Offline
  • Registered: 2015-05-26
  • Posts: 96

Re: cron work: delete_mailboxes.py

ZhangHuangbin wrote:

Hi @Ange7,

I need confirm: are you running iRedMail-0.9.6? was it upgraded from an old iRedMail release?

root! josephine:/home/ange7# cat /etc/iredmail-release
> 0.9.6

Yes, i started with iRedMail 0.9.1 smile since i upgrad my iredmail server each time with new release

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: cron work: delete_mailboxes.py

Ange7 wrote:

Yes, i started with iRedMail 0.9.1 smile since i upgrad my iredmail server each time with new release

It sounds like you didn't fully apply the upgrade tutorial, and missed some steps.