«

Hi all,

recently we upgraded to DBD:g 1.43 and DBI 1.50 and DBIx::TextIndex
0.25 and Postgresql
8.1

while indexing we got some errors like ;

" DBD:g error: statement execution failed: can't execute multiple
commands
in prepare,, "

then i degrade to DBD:g 1.32 now it works fine, but some errors ..
can i use below configuration for my application

1) DBD:g 1.32
2) DBI 1.50
3) DBIx::TextIndex 0.25
4) Postgresql 8.1
5) Ubuntu 5.10 and Mandrake 10

is this combination good,, please give me advise..

thanks,

shankar wrote:
> Hi all,
>
> recently we upgraded to DBD:g 1.43 and DBI 1.50 and DBIx::TextIndex
> 0.25 and Postgresql
> 8.1
>
> while indexing we got some errors like ;
>
> " DBD:g error: statement execution failed: can't execute multiple
> commands in prepare,, "
>
> then i degrade to DBD:g 1.32 now it works fine, but some errors ..
> can i use below configuration for my application
>
> 1) DBD:g 1.32
> 2) DBI 1.50
> 3) DBIx::TextIndex 0.25
> 4) Postgresql 8.1
> 5) Ubuntu 5.10 and Mandrake 10
>
> is this combination good,, please give me advise..

I'd suggest fixing your code to correct the error. Possibly an older
version of those modules allowed something that is no longer valid and,
generally speaking, using the most recent released version is a good
idea. If it turns out to be an issue with DBIx::TextIndex, then take
it up with the author.