1

Topic: Internal server error after upgrade

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 2.1.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: Ubuntu 14.04
- Related log if you're reporting an issue:
====

[Mon Jun 22 23:38:59.875821 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 239, in process
[Mon Jun 22 23:38:59.875834 2015] [:error] [pid 10513] [remote ]     return self.handle()
[Mon Jun 22 23:38:59.875845 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 230, in handle
[Mon Jun 22 23:38:59.875859 2015] [:error] [pid 10513] [remote ]     return self._delegate(fn, self.fvars, args)
[Mon Jun 22 23:38:59.875871 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 420, in _delegate
[Mon Jun 22 23:38:59.875882 2015] [:error] [pid 10513] [remote ]     return handle_class(cls)
[Mon Jun 22 23:38:59.875895 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/web/application.py", line 396, in handle_class
[Mon Jun 22 23:38:59.875907 2015] [:error] [pid 10513] [remote ]     return tocall(*args)
[Mon Jun 22 23:38:59.875917 2015] [:error] [pid 10513] [remote ]   File "/usr/share/apache2/iredadmin/controllers/sql/basic.py", line 60, in POST
[Mon Jun 22 23:38:59.875928 2015] [:error] [pid 10513] [remote ]     account_type='admin')
[Mon Jun 22 23:38:59.875938 2015] [:error] [pid 10513] [remote ]   File "/usr/share/apache2/iredadmin/libs/sqllib/auth.py", line 28, in auth
[Mon Jun 22 23:38:59.875991 2015] [:error] [pid 10513] [remote ]     limit=1)
[Mon Jun 22 23:38:59.876002 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 682, in select
[Mon Jun 22 23:38:59.876012 2015] [:error] [pid 10513] [remote ]     return self.query(qout, processed=True)
[Mon Jun 22 23:38:59.876023 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 644, in query
[Mon Jun 22 23:38:59.876034 2015] [:error] [pid 10513] [remote ]     self._db_execute(db_cursor, sql_query)
[Mon Jun 22 23:38:59.876044 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/web/db.py", line 587, in _db_execute
[Mon Jun 22 23:38:59.876054 2015] [:error] [pid 10513] [remote ]     out = cur.execute(query, params)
[Mon Jun 22 23:38:59.876064 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
[Mon Jun 22 23:38:59.876075 2015] [:error] [pid 10513] [remote ]     self.errorhandler(self, exc, value)
[Mon Jun 22 23:38:59.876085 2015] [:error] [pid 10513] [remote ]   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
[Mon Jun 22 23:38:59.876096 2015] [:error] [pid 10513] [remote ]     raise errorclass, errorvalue
[Mon Jun 22 23:38:59.876106 2015] [:error] [pid 10513] [remote ] OperationalError: (1054, "Unknown column 'settings' in 'field list'")

After the update I get the following error.
The previous version was 1.8.1

Thanks a lot!

----

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

2

Re: Internal server error after upgrade

You don't have SQL column 'settings' in some tables. Please upgrade iRedMail by following below steps strictly:
http://www.iredmail.org/docs/iredmail.releases.html

3

Re: Internal server error after upgrade

HI Zhang , I'm in the same situation , I have followed all these step in your link ,I'm quite sure that their is no setting column in any tables . I choose not to install Sogo , and don't create any table or column in vmail related to sogo , is that where the problem come from ?

4

Re: Internal server error after upgrade

The 'settings' column in multiple sql tables of "vmail" database was first introduced in iRedMail-0.8.7, and our upgrade tutorial clearly mentions the change:
http://www.iredmail.org/docs/upgrade.ir … l-database

5

Re: Internal server error after upgrade

Hi Zhang , sorry , my fault .