[ome-devel] Re: Import Error

[Chris Allan]

Which version of DBD::Pg Tony? This is something I noticed just before I
left for holiday. Versions of DBD::Pg > 1.40 (I think anyway, I was
testing 1.42) do not react the same to the types of "NULL" placeholder
and bind value queries we do in DBObject. I'm not completely sure if
it's a DBD::Pg bug or a DBObject bug.

Anyway, give a DBD::Pg downgrade a try. Ideally something before 1.40.

Ciao.

-Chris

On Thu, Aug 11, 2005 at 05:28:32PM -0400, Tony Scelfo wrote:
> As a followup, Tomasz suggested that I upgrade to the CVS version. 
> When I run the installer, it fails with the following error:
> 
> ------------------------
>  Bootstrapping Database
> ------------------------
> 
>   \__ Creating repository object
> 
> What is the URL of the OME Image server (omeis) ?
> [http://ome-sorger1.mit.edu/cgi-bin/omeis]:
> Checking OMEIS repository [SUCCESS].
> Importing bootstrap XML
>   \__ /home/tonys/ome_cvs/OME/src/xml/OME/Annotations/InstallationModule.ome
> OME::Tasks::LSIDManager::getRemoteObject() is not implemented. at
> /home/tonys/ome_cvs/OME/src/perl2/OME/ImportExport/ModuleImport.pm
> line 222
> DBD::Pg::st execute failed: ERROR:  syntax error at or near "$1" at
> character 173
> 
> Something seems related here since both errors are in DBD::Pg::st near
> "$1"... granted that the errors occur in different lines.
> 
> I am running OME on a debian installation.
> 
> Tony
> 
> On 8/11/05, Tony Scelfo <scelfo at gmail.com> wrote:
> > Does anyone know what might cause the following import error?
> > 
> > - Adding Dataset "002B48" to Project "CellP"...
> > Importing files
> >          1/772: [IN PROGRESS] Starting import
> >          23/772: [IN PROGRESS] Uploaded files//002B48_A11_w1.TIF
> >          48/772: [IN PROGRESS] Uploaded files//002B48_A23_w2.TIF
> > ...
> > ...
> >          755/772: [IN PROGRESS] Uploaded files//002B48_P17_w1.TIF
> >          771/772: [IN PROGRESS] Importing
> > DBD::Pg::st execute failed: ERROR:  syntax error at or near "$1" at
> > character 348
> >          771/772: [DIED] Importing
> > Successfully Imported:
> > 6884: Plate Scan Well A01
> > 6885: Plate Scan Well A02
> > 6886: Plate Scan Well A03
> > 6887: Plate Scan Well A04
> > 6888: Plate Scan Well A05
> > ...
> > ...
> > 7267: Plate Scan Well P24
> > Exiting...
> > Exiting...
> > 
> > The import process generates a dataset but there are no images in it.
> > I'm importing a bunch of tif files and an htd file.
> > 
> > Thanks,
> > Tony
> >
> _______________________________________________
> ome-devel mailing list
> ome-devel at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-devel