Re: Error on creating new customer

["Paul Browne" <..hidden..>]

Managed to replicate the error below

DBD::Pg::db do failed: ERROR: attribute 2 has wrong type
DETAIL: Table has type character varying, but query expects character
varying.
Error!

UPDATE vendor
SET vendornumber = '2',
name = 'L & M',
address1 = 'L & M (Heating) Supplies LTD',
address2 = 'Mike Jones',
city = '97 Lockfield Avenue',
state = 'Enfield, Middx EN3 7PY',
zipcode = '',
country = '',
contact = 'Mike Jones',
phone = '0208 443 5111',
fax = '0208 443 5588',
email = '..hidden..',
cc = '',
bcc = '',
notes = '',
terms = 0,
discount = 0,
creditlimit = 0,
taxincluded = '0',
gifi_accno = '',
business_id = 0,
taxnumber = '',
sic_code = '',
iban = '',
bic = '',
employee_id = 0,
language_code = '',
pricegroup_id = 0,
curr = 'GBP',
startdate = NULL,
enddate = NULL
WHERE id = 10281
ERROR: attribute 2 has wrong type
DETAIL: Table has type character varying, but query expects character
varying. 

-----Original Message-----
From: ..hidden..
[mailto:..hidden.. On Behalf Of Chris
Travers
Sent: 09 February 2007 08:20
To: ..hidden..
Subject: Re: [Ledger-smb-users] Error on creating new customer

Which version of PostgreSQL?  You may also want to try on the PostgreSQL
list (pg-general).  We have a few PostgreSQL geeks on this list, but they
have more, and better :-)

Best Wishes,
Chris Travers

On 2/8/07, DK <..hidden..> wrote:
> I new that I'm lucky.
> =======================
> test1=> insert into customer(name) values ('something');
> ERROR:  attribute 9 has wrong type
> DETAIL:  Table has type character varying, but query expects character
varying.
> =======================
> something wrong with postgre I suppose.
>
> On 09/02/07, Chris Travers <..hidden..> wrote:
> > I have never seen that error before.
> >
> > If you copy the query and run it manually against psql, do you get an
error?
> >
> > Best Wishes,
> > Chris Travers
> >
> > On 2/8/07, DK <..hidden..> wrote:
> > > perl-DBD-Pg-1.49-1.fc6
> > >
> > > On 09/02/07, Chris Travers <..hidden..> wrote:
> > > > Which version of DBD::Pg are you using?
> > > >
> > > > Best Wishes,
> > > > Chris Travers
> > > >
> > > > On 2/8/07, DK <..hidden..> wrote:
> > > > > After filling the 'Add customer' form and pressing button Save 
> > > > > I have this message:
> > > > >
> > > > > ======= quote ========
> > > > > DBD::Pg::db do failed: ERROR: attribute 9 has wrong type
> > > > > DETAIL: Table has type character varying, but query expects
character varying.
> > > > > Error!
> > > > >
> > > > > INSERT INTO customer (name)
> > > > > VALUES ('Fri Feb 9 01:46:00 20073589')
> > > > > ERROR: attribute 9 has wrong type
> > > > > DETAIL: Table has type character varying, but query expects
character varying.
> > > > >
> > > > > ======= unquote ========
> > > > > version 1.1.8
> > > > > postgre encoding UTF8
> > > > >
> > > > > The error occures irrespective of the values entered in 
> > > > > specific fields. Any ideas please?
> > > > >
> > > > > --------------------------------------------------------------
> > > > > ----------- Using Tomcat but need to do more? Need to support 
> > > > > web services, security?
> > > > > Get stuff done quickly with pre-integrated technology to make your
job easier.
> > > > > Download IBM WebSphere Application Server v.1.0.1 based on 
> > > > > Apache Geronimo
> > > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&;
> > > > > dat=121642 _______________________________________________
> > > > > Ledger-smb-users mailing list
> > > > > ..hidden..
> > > > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > > > >
> > > >
> > > > ----------------------------------------------------------------
> > > > --------- Using Tomcat but need to do more? Need to support web 
> > > > services, security?
> > > > Get stuff done quickly with pre-integrated technology to make your
job easier.
> > > > Download IBM WebSphere Application Server v.1.0.1 based on 
> > > > Apache Geronimo
> > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da
> > > > t=121642 _______________________________________________
> > > > Ledger-smb-users mailing list
> > > > ..hidden..
> > > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > > >
> > >
> > >
> > > --
> > > Dmitri Kourbatsky
> > >
> > > Suris Accwel Ltd.
> > > tel: +357 99 608290
> > > fax +357 25 311517
> > >
> > > ------------------------------------------------------------------
> > > ------- Using Tomcat but need to do more? Need to support web 
> > > services, security?
> > > Get stuff done quickly with pre-integrated technology to make your job
easier.
> > > Download IBM WebSphere Application Server v.1.0.1 based on Apache 
> > > Geronimo
> > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=
> > > 121642 _______________________________________________
> > > Ledger-smb-users mailing list
> > > ..hidden..
> > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > >
> >
> > --------------------------------------------------------------------
> > ----- Using Tomcat but need to do more? Need to support web 
> > services, security?
> > Get stuff done quickly with pre-integrated technology to make your job
easier.
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache 
> > Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=12
> > 1642 _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
>
>
> --
> Dmitri Kourbatsky
>
> Suris Accwel Ltd.
> tel: +357 99 608290
> fax +357 25 311517
>
> ----------------------------------------------------------------------
> --- Using Tomcat but need to do more? Need to support web services, 
> security?
> Get stuff done quickly with pre-integrated technology to make your job
easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache 
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216
> 42 _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users