Re: [CSCMail-Users] Error running dbswitch.pl

[Jak <ja...@no...>]

On 03 Nov 2000 11:30:30 EST, Steven Kordik said:

> On 03 Nov 2000 14:03:30 GMT, Jak said:
<Snippage>
> > Now I know that's I've probably missed something obvious and self-kick
worthy
> > but... I'm getting the following error running
> /migration-scripts/dbswitch.pl
> > CSV Pg
> > 
> > DBD::Pg::st execute failed: ERROR:	pg_atoi: error in "<example text>":
can't
> > parse "<example text>"
> 
> It actually says "<example text>"  or you put that in there???	If it
really
> says <example text> that is very wierd... what versions of DBD::Pg and
> PostgreSQL are you using?

Sorry for lack of clarity - I put the <example text> in there... It was
someone's name who sent me the email - eg ...error in "Joe Bloggs": can't parse
"Joe Bloggs"

> 
> > The tables are creating with no problem, I've added the bcc to messages,
and
> > query and body to boxlist. The problem appears to occur when the
dbswitch.pl
> is
> > trying to shift the actual "content" as it were.
> 
> Very odd... I run Postgres here, so I'll try and run some tests and see what
I
> come up with.. if you could let me know what versions you are running, it
would
> help...

PostgreSQL 7.0.2
DBD::Pg 0.95

Hope this is of use.

Jak