[ postfixadmin-Bugs-2221002 ] VARCHAR alias,goto

[SourceForge.net <no...@so...>]

Bugs item #2221002, was opened at 2008-11-04 14:49
Message generated for change (Comment added) made by christian_boltz
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: VARCHAR alias,goto

Initial Comment:
It is possible to increase varchar in table alias, field goto ?
Thanks, a lot of our customers need more than 255 for alias e-mail.
Bye

----------------------------------------------------------------------

>Comment By: Christian Boltz (christian_boltz)
Date: 2008-11-12 23:10

Message:
Good to know that I fixed the right bug ;-) - thanks for testing!

----------------------------------------------------------------------

Comment By: Falco (fschmutz)
Date: 2008-11-12 21:37

Message:
Work !! Thanks !
If you need some help to test new update, you can contact me ;)
Thanks again 
Bye

---------

Updating database:

- old version: 472; target version: 477

updating to version 473 (MySQL)...   done

---------

----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2008-11-12 21:17

Message:
This is probably fixed in SVN r477 (int pointed out the bug on IRC). Please
test again ;-) and tell me the result.

----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2008-11-12 21:07

Message:
I assume you are talking about setup.php/upgrade.php?

Please run setup.php?debug=1 and tell me the last query it (tries to)
execute.

----------------------------------------------------------------------

Comment By: Falco (fschmutz)
Date: 2008-11-12 15:35

Message:
Hi, im register to sf now :)
But some mistake :
DEBUG INFORMATION:
Invalid query: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
') /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ NOT NULL' at
line 1

Good journey

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2008-11-12 15:03

Message:
Thanks for this fix :)

----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2008-11-06 23:10

Message:
Good catch - the goto field should never have changed to varchar :-(

Fixed in SVN r473.

----------------------------------------------------------------------

Comment By: GingerDog (gingerdog)
Date: 2008-11-06 09:47

Message:
Hi,

Ideally it would remain a varchar field, and the table would be
re-organised to have a proper relational model - i.e.

address -> alias, goto; alias, goto etc

Instead of being separated by commas.

Anyway, interestingly enough, my local postfix database has alias.goto as
a text field; and it is initially created as this in the upgrade.php file.
However, having said this, the last update Christian made sets it to be a
varchar(255). Have we gotten out of sync somewhere?



----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2008-11-04 14:51

Message:
Sorry, we forgot something, maybe it is possible to change this field in
text format ?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583