1 Topic by ciscokid

  • ciscokid
  • Member
  • Offline
  • Registered: 2018-07-03
  • Posts: 2

Topic: Unknown column 'goto' in 'field list'

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8 - Brand new clean install
- Linux/BSD distribution name and version: Ubuntu 16.04.4 LTS (Xenial Xerus)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? No - Community
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi I followed the following tutorial
https://docs.iredmail.org/sql.user.mail … 70701.html

I issued the commad
UPDATE alias SET goto='user@domain.com,forward_1@example.com' WHERE address='user@domain.com';
and I got an error as per the subject line
Unknown column 'goto' in 'field list'
Just in case, yes, I did substitute the e-malil addresses with valid ones:)
Any ideas?
Cheers

----

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

Re: Unknown column 'goto' in 'field list'

The one you used is for old iRedMail release. You need this tutorial instead:
https://docs.iredmail.org/sql.user.mail.forwarding.html

3 Reply by ciscokid

  • ciscokid
  • Member
  • Offline
  • Registered: 2018-07-03
  • Posts: 2

Re: Unknown column 'goto' in 'field list'

Hi
Your tutorial you mentioned above is for iRedMail-0.9.6 and earlier releases.

My iRedmail release is a later one, which is 0.9.8 and the tutorial I used is applicable to iRedMail-0.9.7 and later releases

Cheers

4 Reply by ciscokid

  • ciscokid
  • Member
  • Offline
  • Registered: 2018-07-03
  • Posts: 2

Re: Unknown column 'goto' in 'field list'

OK - my bad. I didn't read the headings closely enough on the tutorials and got them mixed up. Must be my dyslexia kicking in
Thanks

PS - It seems that the earlier versions had it much easier to configure (less coding) than for the later releases?

5 Reply by ZhangHuangbin

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

Re: Unknown column 'goto' in 'field list'

ciscokid wrote:

PS - It seems that the earlier versions had it much easier to configure (less coding) than for the later releases?

New version is easier to index and search (better SQL performance).