Login | Register
My pages Projects Community openCollabNet

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

Re: [Catacomb] CheckIn error



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@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@webdav.org
> > > http://mailman.webdav.org/mailman/listinfo/catacomb
> > >
> >
> >
>