1 Topic by bsd3000

  • bsd3000
  • Member
  • Offline
  • Registered: 2019-01-07
  • Posts: 6

Topic: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version 0.9.9
- Deployed with downloadable installer?
- Linux/BSD distribution name and version:  Linux CentOS 7
- Store mail accounts in which backend  MYSQL
- Web server NGINX
- Manage mail accounts with iRedAdmin-Pro? YES
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

After upgrade to iRedAdmin-PRO 3.1 (mysql)
when I add new domain I see:

Error: OperationalError(1054, "Unknown column 'disabled_mail_services' in 'field list'")

I think some sql missing in upgrade process sad

but which ones?

kind regards

----

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: 31,088

Re: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

- Which iRedMail release did you install at the beginning?
- Try to compare your sql tables with this one (0.9.9), especially table "domain":
https://bitbucket.org/zhb/iredmail/src/ … mail.mysql

3 Reply by bsd3000

  • bsd3000
  • Member
  • Offline
  • Registered: 2019-01-07
  • Posts: 6

Re: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

HI
ZhangHuangbin, thanks for your answers

but

in https://bitbucket.org/zhb/iredmail/src/ … ew-default
I don't find disabled_mail_services field

my domain table is equal of your schema  sad

(I user iredmail 0.9.9)

4 Reply by bsd3000

  • bsd3000
  • Member
  • Offline
  • Registered: 2019-01-07
  • Posts: 6

Re: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

Hi

I upgraded iredmail from 0.9.5-1 (but I walk trought all middle step.. 0.9.6.. 0.9.7.. etc etc)

I upgraded iRedMail-Pro-SQL from iRedAdmin-Pro-SQL-2.4.1 to iRedAdmin-Pro-SQL-3.1

the db schema of vmail tables is correct (like https://bitbucket.org/zhb/iredmail/src/ … w-default)


it seem  fields setting of domain tables do not have correct value when I try to add new domain

How can I do to debug/search the issue?

kind regards

5 Reply by bsd3000

  • bsd3000
  • Member
  • Offline
  • Registered: 2019-01-07
  • Posts: 6

Re: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

from mysql query log (when I add a new "test.it" domain)
I see:

           73 Query    SELECT domain FROM domain WHERE domain='test.it' LIMIT 1
           73 Query    SELECT alias_domain FROM alias_domain WHERE alias_domain='test.it' LIMIT 1
           73 Query    INSERT INTO domain (domain, disabled_mail_services, description, created, maxquota, settings, mailboxes, active, aliases) VALUES ('test.it', ('throttle'), '', '2019-01-09 12:05:32', 0, 'default_user_quota:1024;default_language:it_IT;', 0, 1, 0)

but it returns

#1054 - Unknown column 'disabled_mail_services' in 'field list'

but disabled_mail_services is missing from this 0.9.9 sql
https://bitbucket.org/zhb/iredmail/src/ … ew-default

is it an issue?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

Did you modify iRedAdmin-Pro source code?

7 Reply by bsd3000

  • bsd3000
  • Member
  • Offline
  • Registered: 2019-01-07
  • Posts: 6

Re: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

Hi

I downloaded your code from iredmail.org, no modification

now, to solve this issue I added a disabled_mail_services fileds after domain fields in domain table.
In this case when I add new domain, it works and disabled_mail_services filled with "(trhottle)" value

M

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Error: OperationalError(1054, "Unknown column 'disabled_mail_services

bsd3000 wrote:

now, to solve this issue I added a disabled_mail_services fileds after domain fields in domain table.
In this case when I add new domain, it works and disabled_mail_services filled with "(trhottle)" value

This is not right.

- I can not reproduce this issue locally. And there's no sql column "disabled_mail_services" at all.
- Could you try to add a new domain name? any domain name is ok. let's see whether you can reproduce this issue steadily: each time you add new domain, it raises this error.
- Is it possible to give me direct ssh access with root privilege? I'd like to debug it directly. If it's a bug of iRedAdmin-Pro, it will be free, but if it's not, i will charge one support ticket ($99) for this, ok for you?