1

Topic: problem with mysql?

==== Required information ====
- iRedMail version: 1.8.1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: openSUSE 12.1 (x86_64)
- Related log if you're reporting an issue:
====
Hello,
my symptom is here:
1. When I erased a domain, doman was erased but the error message was displayed:
       (1054, "Unknown column 'domain' in 'where clause'")
2. Deleting of domain was not logged
3. If I want to create a new domain, this error message is displayed and new domain was not created:
       (1054, "Unknown column 'defaultlanguage' in 'field list'")

Thank you for your help
Jan

2

Re: problem with mysql?

You didn't upgrade iRedMail to the latest stable release, so you missed steps required to add addition SQL columns.

*) What's the iRedMail version on your server? You can check file /etc/iredmail-release.
*) Upgrade tutorials for iRedMail are available here:
http://www.iredmail.org/doc.html#upgrade_tutorial

3

Re: problem with mysql?

OK, you're right. Thanks for the tip.