1 Topic by imre.kovacs

  • imre.kovacs
  • Member
  • Offline
  • Registered: 2021-07-29
  • Posts: 2

Topic: Can't create new user after upgrade!

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

Just upgraded to the most recent version by following your tutorial. All seems to work fine, except I can't see my domain on the admin page, but when I go to Add a user menu, it shows all the users and the domain. This is not a big issue, but when I was trying to add a new user, I got this error:
Error: InternalError(1054, "Unknown column 'mailboxfolder' in 'field list'")

Could you please help me with this?

Regards,
Imre

----

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: 30,789

Re: Can't create new user after upgrade!

imre.kovacs wrote:

Error: InternalError(1054, "Unknown column 'mailboxfolder' in 'field list'")

SQL column "mailboxfolder" was introduced in iRedMail-0.9.9, please double check your upgrade procedure and make sure no steps were missed.
https://docs.iredmail.org/upgrade.iredm … db-special

3 Reply by imre.kovacs (edited by imre.kovacs 2021-07-30 14:59:43)

  • imre.kovacs
  • Member
  • Offline
  • Registered: 2021-07-29
  • Posts: 2

Re: Can't create new user after upgrade!

ZhangHuangbin wrote:
imre.kovacs wrote:

Error: InternalError(1054, "Unknown column 'mailboxfolder' in 'field list'")

SQL column "mailboxfolder" was introduced in iRedMail-0.9.9, please double check your upgrade procedure and make sure no steps were missed.
https://docs.iredmail.org/upgrade.iredm … db-special

Thanks for the quick reply, somehow I missed that part, now it's working.
On the other hand, the domain still not showing on the admin page, only, when I go through the add new user option, and back to domain. I'll upload screenshots, to show you.

Thanks

Post's attachments

Screenshot 2021-07-30 at 8.57.21.png
Screenshot 2021-07-30 at 8.57.21.png 79.12 kb, file has never been downloaded. 

Screenshot 2021-07-30 at 8.57.48.png
Screenshot 2021-07-30 at 8.57.48.png 78.13 kb, file has never been downloaded. 

Screenshot 2021-07-30 at 8.57.57.png
Screenshot 2021-07-30 at 8.57.57.png 85.47 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,789

Re: Can't create new user after upgrade!

I guess you missed some SQL structure changes. Please go through all the iRedMail upgrade tutorials you applied, figure out which SQL column(s) is missing.