Re: [eGroupWare-developers] PostgreSQL error updating emailadmin afterupdate to trunk@30328

[Klaus L. <kl...@st...>]

Hi Anthony,
what PostgreSQL Version are you using?
I am trying to investigate (and resolve, if possible within the timeframe
available) the issue (believed to be caused by the adodb drivers)
Best regards
Klaus Leithoff
 
----------------ursprüngliche Nachricht-----------------
Von: "Anthony Messina" ame...@me... 
An: egr...@li... 
Datum: Fri, 21 May 2010 23:38:19 -0500
-------------------------------------------------
 
 
> 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', ...<snipped>
> 
> 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
> 

__________________________________________________
> 
> --------------------------------------------------------------------
> ----------
> 
> 

__________________________________________________
> _______________________________________________
> eGroupWare-developers mailing list
> eGr...@li... 
> https://lists.sourceforge.net/lists/listinfo/egroupware-developers
> 

-- 
kl...@st... 
Stylite GmbH
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden

fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de

Geschäftsführer: Andre Keller, Gudrun Müller, Ralf Becker
Handelsregister Kaiserslautern HRB 30575
USt-ID: DE214280951