Login | Register
My pages Projects Community openCollabNet

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

Re: [Catacomb] CheckIn error



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,resourcetype,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,resourcetype,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
>