Fossil SCM
database error on hyperlinked tagname in tag menu
309c57b3d27219f…
· opened 17 years, 2 months ago
- Type
- Code_Defect
- Priority
- —
- Severity
- Important
- Resolution
- Fixed
- Subsystem
- —
- Created
- Jan. 20, 2009 10:54 p.m.
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:
Fixed by check-in [bf7ca1a4d8ce33c852164c9105fa35c3e8c81339].