1 Topic by georgefong

  • georgefong
  • Member
  • Offline
  • Registered: 2013-08-06
  • Posts: 2

Topic: Error: (1054, "Unknown column 'defaultlanguage' in 'field list'")

Hi all,

I have just upgraded IRedAdmin--Pro (MySQL) to version 1.70. running on a CentOS 6.3 (x86_64

After doing this I went to add a Domain under domain and accounts. As soon as I hit the "Add" button, I get the following error:

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

It would appear that I have missed someting very simple in the upgrade but I am seriously not sure what. Any assistance would be gratefully accepted.

Cheers
George

----

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

2 Reply by hferreira

  • hferreira
  • Member
  • Offline
  • Registered: 2012-08-14
  • Posts: 81

Re: Error: (1054, "Unknown column 'defaultlanguage' in 'field list'")

Did you follow the upgrade tutorial? You have to run some MySQL scripts. The erro seems to be one missing column there by one missing script.

3 Reply by rnmrheinneckar

  • rnmrheinneckar
  • Member
  • Offline
  • Registered: 2011-09-02
  • Posts: 7

Re: Error: (1054, "Unknown column 'defaultlanguage' in 'field list'")

I Have the same problems

4 Reply by ZhangHuangbin

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

Re: Error: (1054, "Unknown column 'defaultlanguage' in 'field list'")

The latest iRedAdmin-Pro requires iRedMail-0.8.5, please upgrade your iRedMail to the latest stable release first:
http://www.iredmail.org/doc.html#upgrade_tutorial

New SQL column 'defaultlanguage' is mentioned in the last one upgrade tutorial:
http://iredmail.org/wiki/index.php?titl … .8.4-0.8.5

5 Reply by georgefong

  • georgefong
  • Member
  • Offline
  • Registered: 2013-08-06
  • Posts: 2

Re: Error: (1054, "Unknown column 'defaultlanguage' in 'field list'")

I feel terribly embarrassed. My team jumped on the IRedmail site and read the upgrade instructions properly and fixed it. My apologies, IredAdmin-Pro is back at its best again.

Thank you for your very prompt response. I will read the upgrade instructions more thoroughly next time.

Cheers
g.