The mail interface is beautiful, thank you! However, when attempting to
update the emailadmin server settings (using PostgreSQL), I get the following:
ERROR: invalid input syntax for integer: “defaultsmtp” at character 67
STATEMENT: UPDATE egw_emailadmin SET
ea_smtp_server=‘127.0.0.1’,ea_smtp_type=‘defaultsmtp’, …
When checking into the DB, the column ea_smtp_type is of type INTEGER after
the upgrade:
========================
process->upgrade(): Incoming : appname: emailadmin, version: 1.7.003, status:
U
process->upgrade(): emailadmin(1.7.003 --> 1.7.004): running
emailadmin_upgrade1_7_003()
AlterColumnSQL(‘egw_emailadmin’,‘ea_imap_type C(56)’,‘ea_imap_type C(56)’)
sql=
Array
(
[0] => BEGIN
[1] => SELECT * INTO TEMPORARY TABLE egw_emailadmin_tmp FROM
egw_emailadmin
[2] => DROP TABLE “egw_emailadmin”
[3] => CREATE TABLE “egw_emailadmin” (
“ea_imap_type” VARCHAR(56)
)
[4] => INSERT INTO egw_emailadmin SELECT FROM egw_emailadmin_tmp
[5] => DROP TABLE egw_emailadmin_tmp
[6] => COMMIT
)
AlterColumnSQL(‘egw_emailadmin’,‘ea_smtp_type C(56)’,‘ea_smtp_type C(56)’)
sql=
Array
(
[0] => BEGIN
[1] => SELECT * INTO TEMPORARY TABLE egw_emailadmin_tmp FROM
egw_emailadmin
[2] => DROP TABLE “egw_emailadmin”
[3] => CREATE TABLE “egw_emailadmin” (
“ea_smtp_type” VARCHAR(56)
)
[4] => INSERT INTO egw_emailadmin SELECT FROM egw_emailadmin_tmp
[5] => DROP TABLE egw_emailadmin_tmp
[6] => COMMIT
)
–> 1.7.004
process->upgrade(): Upgrade of emailadmin to 1.7.004 is completed.
app_registered(): checking emailadmin, table: egw_applications… app
previously registered.
update_app(): emailadmin, version: 1.7.004, table: egw_applications
app_registered(): checking emailadmin, table: egw_applications… app
previously registered.
process->upgrade(): Outgoing : appname: emailadmin, status: C
For PostgreSQL, we need:
ALTER TABLE egw_emailadmin ALTER ea_smtp_type TYPE character varying(56);
ALTER TABLE egw_emailadmin ALTER ea_imap_type TYPE character varying(56);
After making the changes, I am able to modify the server settings. Thanks. -
A
–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E
