1 Topic by spyooo7

  • spyooo7
  • Member
  • Offline
  • Registered: 2012-02-02
  • Posts: 4

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

I Just purchased iredadmin pro i install it everything is ok when i login to iredadmin and i click on admins i got this error please help

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

----

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,082

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

To fix it quickly:

$ mysql -uroot -p
mysql> USE vmail;
mysql> ALTER TABLE admin ADD COLUMN name VARCHAR(255) NOT NULL DEFAULT '';

The root cause is mentioned in your another post here:
http://www.iredmail.org/forum/topic2899 … bbcom.html

3 Reply by spyooo7

  • spyooo7
  • Member
  • Offline
  • Registered: 2012-02-02
  • Posts: 4

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

this issue has been solved when i click on admins its working thanks