1

Topic: Table iredadmin.settings doesn't exists

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.1
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version: Debian 9.12
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Mysql
- Web server (Apache or Nginx): apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi

I am experiencing an issue with iredadmin-pro.  When I go to System -> Settings to do some changes and save, I am unable to save it.  It says the table settings does not exists.  Can I have the table structure to create the table and its related relations.

The error message is as follows:
Jul 10 09:44:05 mail iredadmin: Traceback (most recent call last):#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 239, in process#012    return self.handle()#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 230, in handle#012    return self._delegate(fn, self.fvars, args)#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 462, in _delegate#012    return handle_class(cls)#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 438, in handle_class#012    return tocall(*args)#012  File "/usr/share/apache2/iRedAdmin-Pro-SQL-4.4/controllers/decorators.py", line 75, in proxyfunc#012    return func(self, *args, **kw)#012  File "/usr/share/apache2/iRedAdmin-Pro-SQL-4.4/controllers/decorators.py", line 125, in decorated#012    return f(*args, **kw)#012  File "/usr/share/apache2/iRedAdmin-Pro-SQL-4.4/controllers/panel/sys_settings.py", line 32, in POST#012    qr = iredutils.store_settings_in_db(kvs=form, flush=True)#012  File "/usr/share/apache2/iRedAdmin-Pro-SQL-4.4/libs/iredutils.py", line 1285, in store_settings_in_db#012    conn.delete("settings", vars={"account": account}, where="account=$account")#012  File "/usr/lib/python2.7/dist-packages/web/db.py", line 917, in delete#012    self._db_execute(db_cursor, q)#012  File "/usr/lib/python2.7/dist-packages/web/db.py", line 591, in _db_execute#012    out = cur.execute(query, params)#012  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, in execute#012    self.errorhandler(self, exc, value)#012  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler#012    raise errorvalue#012ProgrammingError: (1146, "Table 'iredadmin.settings' doesn't exist")
Jul 10 09:44:05 mail iredadmin:
Jul 10 09:44:05 mail iredadmin: [102.118.64.239] POST /iredadmin/system/settings

Thanks

Shafeek

----

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

2

Re: Table iredadmin.settings doesn't exists

Solved.  Got the table from SQL/iredmail.mysql

A+