Login | Register
My pages Projects Community openCollabNet

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Catacomb] Re: CheckIn error



Hi,

i have the same problems using mysql 4.0.24 with catacomb 0.9. 
Does anyone knows something more specific about that problem or even exists a 
solution?

Markus


> Hi,
> It is weird. It works on lower version. Can you change the '' with "" in
> the SQL? That is,
>
> CREATE temporary table tmp_resforvcr SELECT serialno,
> 1+0+0,URI,1058965725153618,displayname,
> getcontentlanguage,getcontentlength,getcontenttype,null,1058965725153625+0,
> resourcetype,source,depth,istext,
> textcontent, bincontent, ""
> FROM dasl_resource WHERE serialno=21
>
> If it works with "", we can consider to change the source.
>
> Kai
>
> On Thu, 24 Jul 2003, Alexander Gavrilenko wrote:
> > Hello,
> > I tryed to run the command and mysql return error... But i have newer
> > version: 4.0.13...
> >
> > > Hi,
> > > Could run this SQL command on your MySQL database?
> > >
> > > CREATE temporary table tmp_resforvcr SELECT serialno,
> > > 1+0+0,URI,1058965725153618,displayname,
> >
> > getcontentlanguage,getcontentlength,getcontenttype,null,1058965725153625+
> >0,r esourcetype,source,depth,istext,
> >
> > > textcontent, bincontent, ''
> > > FROM dasl_resource WHERE serialno=21
> > >
> > > And see whether it works or not. This SQL worked well in my MySQL
> > > database. It didn't cause a SQL error. What's the version of MySQL and
> >
> > Catacomb are you using?
> >
> > > The version of MySQL I am using is 3.23.
> > >
> > > Kai
> > >
> > > On Wed, 23 Jul 2003, griffin wrote:
> > > > Hello.
> > > > I have a problem with checkin.
> > > > Apache return 409 error:
> > > > Conflict
> > > > The server encountered an internal error or misconfiguration and was
> >
> > unable to complete your request.
> >
> > > > Please contact the server administrator, you at your.address and
> > > > inform
> >
> > them of the time the error occurred, and anything you might have done
> > that may have caused the error.
> >
> > > > More information about this error may be available in the server
> > > > error
> >
> > log.
> >
> > > > Apache log:
> > > >
> > > > [Wed Jul 23 17:08:45 2003] [error] - TRACE : dav_repos_get_resource
> > > > [Wed Jul 23 17:08:45 2003] [error] - TRACE : dbms_get_property
> > > > [Wed Jul 23 17:08:45 2003] [error] Query to execute: SELECT
> >
> > serialno,creationdate,displayname,getcontentlanguage,getcontentlength,
> >
> > > getcontenttype,getetag,getlastmodified,resourcetype,source,depth,istext
> > >,
> >
> > isversioned, checkin, checkout
> >
> > > From dasl_resource Where URI='/repos/bg_bott01.gif'
> > >
> > > > [Wed Jul 23 17:08:45 2003] [error] - TRACE : dav_repos_checkin
> > > > [Wed Jul 23 17:08:45 2003] [error] - TRACE : dbms_create_vr
> > > > [Wed Jul 23 17:08:45 2003] [error] Query to execute: drop table
> >
> > tmp_resforvcr
> >
> > > > [Wed Jul 23 17:08:45 2003] [error] Error in the drop table command
> > > > [Wed Jul 23 17:08:45 2003] [error] Query to execute: CREATE temporary
> >
> > table tmp_resforvcr SELECT serialno,
> > 1+0+0,URI,1058965725153618,displayname,
> >
> > getcontentlanguage,getcontentlength,getcontenttype,null,1058965725153625+
> >0,r esourcetype,source,depth,istext, textcontent, bincontent, ''
> >
> > > FROM dasl_resource WHERE serialno=21
> > >
> > > > [Wed Jul 23 17:08:45 2003] [error] Error: Error in the create
> > > > temporary
> >
> > command
> >
> > > > Error Number: 1166
> > > > ErrorMessage:Incorrect column name ''
> > > >
> > > > [Wed Jul 23 17:08:45 2003] [error] [client 212.57.108.202] Could not
> >
> > CHECKIN resource /repos/bg_bott01.gif.  [409, #0]
> >
> > > > [Wed Jul 23 17:08:45 2003] [error] [client 212.57.108.202] DBMS Error
> >
> > [500, #0]
> >
> > > > Any thoughts?
> > > > _______________________________________________
> > > > Catacomb mailing list
> > > > Catacomb at webdav.org
> > > > http://mailman.webdav.org/mailman/listinfo/catacomb

-- 
Markus Litz
Abt. Verteilte Systeme und Komponentensoftware
Deutsches Zentrum fuer Luft- und Raumfahrt e.V. (DLR)
Simulations- und Softwaretechnik (SISTEC) Koeln-Porz
http://www.dlr.de/sc
mailto:Markus.Litz@dlr.de