| Ticket UUID: | 309c57b3d27219fa6ad601c0021dc067a7cb992d | ||
| Title: | database error on hyperlinked tagname in tag menu | ||
| Status: | Fixed | Type: | Code_Defect |
| Severity: | Important | Priority: | |
| Subsystem: | Resolution: | Fixed | |
| Last Modified: | 2009-01-20 23:49:59 | ||
| Version Found In: | [4d39bbac10] 2009-01-20 22:38:56 | ||
| Description & Comments: | |||
|
Fossil version 4d39bbac10 2009-01-20 22:38:56
repo not rebuild, click on: http://localhost:8080/tagview?name=cvs2fossil-complete cvs2fossil-complete: Database Error near "desc": syntax error SELECT blob.rid, uuid, datetime(event.mtime,'localtime') AS timestamp, coalesce(ecomment, comment), coalesce(euser, user), (SELECT count(*) FROM plink WHERE pid=blob.rid AND isprim=1), (SELECT count(*) FROM plink WHERE cid=blob.rid), NOT EXISTS (SELECT 1 FROM plink WHERE pid=blob.rid), bgcolor, event.type, (SELECT group_concat(substr(tagname,5), ', ') FROM tag, tagxref WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid AND tagxref.rid=blob.rid AND tagxref.tagtype>0) FROM event JOIN blob WHERE blob.rid=event.objid AND EXISTS (SELECT 1 FROM tagxref WHERE tagxref.rid = event.objid AND tagxref.tagtype > 0 AND tagxref.tagid = 11 ORDER BY 3 desc repo rebuild click on link: http://localhost:8080/tagview?name=cvs2fossil-complete cvs2fossil-complete: Database Error near "desc": syntax error SELECT blob.rid, uuid, datetime(event.mtime,'localtime') AS timestamp, coalesce(ecomment, comment), coalesce(euser, user), (SELECT count(*) FROM plink WHERE pid=blob.rid AND isprim=1), (SELECT count(*) FROM plink WHERE cid=blob.rid), NOT EXISTS (SELECT 1 FROM plink WHERE pid=blob.rid), bgcolor, event.type, (SELECT group_concat(substr(tagname,5), ', ') FROM tag, tagxref WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid AND tagxref.rid=blob.rid AND tagxref.tagtype>0) FROM event JOIN blob WHERE blob.rid=event.objid AND EXISTS (SELECT 1 FROM tagxref WHERE tagxref.rid = event.objid AND tagxref.tagtype > 0 AND tagxref.tagid = 13 ORDER BY 3 desc drh added on 2009-01-20 23:49:59: | |||
View Ticket