1

Topic: Failed Iredadmin Pro upgrade

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

<class '_mysql_exceptions.OperationalError'> at /login

(1054, "Unknown column 'settings' in 'field list'")


Python
/usr/lib64/python2.7/site-packages/MySQLdb/connections.py in defaulterrorhandler, line 35

Web
POST https://50.196.193.137/iredadmin/login


Traceback (innermost first)
/usr/lib64/python2.7/site-packages/MySQLdb/connections.py in defaulterrorhandler
35.    raise errorclass, errorvalue ...

▶ Local vars

/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py in execute
173.            self.errorhandler(self, exc, value) ...

▶ Local vars

/usr/lib/python2.7/site-packages/web/db.py in _db_execute
586.            out = cur.execute(query, params) ...

▶ Local vars

/usr/lib/python2.7/site-packages/web/db.py in query
643.        self._db_execute(db_cursor, sql_query) ...

▶ Local vars

/usr/lib/python2.7/site-packages/web/db.py in select
681.        return self.query(qout, processed=True) ...

▶ Local vars

/var/www/iredadmin/libs/sqllib/auth.py in auth
27.                             limit=1) ...

▶ Local vars

/var/www/iredadmin/controllers/sql/basic.py in POST
62.                                account_type='admin') ...

▶ Local vars

/usr/lib/python2.7/site-packages/web/application.py in handle_class
395.            return tocall(*args) ...

▶ Local vars

/usr/lib/python2.7/site-packages/web/application.py in _delegate
419.            return handle_class(cls) ...

▶ Local vars

/usr/lib/python2.7/site-packages/web/application.py in handle
229.        return self._delegate(fn, self.fvars, args) ...

▶ Local vars

/usr/lib/python2.7/site-packages/web/application.py in process
238.                    return self.handle() ...

▶ Local vars

----

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

2

Re: Failed Iredadmin Pro upgrade

ty wrote:

(1054, "Unknown column 'settings' in 'field list'")

Your SQL table misses some new columns introduced in newer iRedMail release, please upgrade iRedMail to the latest stable release (0.9.4) first, then this iRedAdmin-Pro error will disappear automatically.

*) You can check iRedMail release version in file /etc/iredmail-release.
*) All iRedMail upgrade tutorials are available here: http://www.iredmail.org/docs/iredmail.releases.html
*) if you don't want to get your hands dirty, we offer paid remote upgrade support: http://www.iredmail.org/support.html

3

Re: Failed Iredadmin Pro upgrade

Would the issue be in the vmail database. I migrated the vmail database from a 0.8.5 server to a new server with the latest version installed. I did all the database field updates and everything is working fine there. The problem occurs when I then try upgrade iredadmin from 0.5 to 2.3.1

4

Re: Failed Iredadmin Pro upgrade

Yes, it's the vmail database. Please follow our tutorials (from 0.8.5 to 0.9.4, don't skip releases) and apply sql structure changes:
http://www.iredmail.org/docs/iredmail.releases.html