Project:Taxonomy Lineage
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

the Script (lineage.pgsql) in zip Download is like about:

CREATE TABLE term_lineage (
tid integer NOT NULL default '0',
lineage varchar(255) NOT NULL default ''
depth integer varchar(255) NOT NULL default ''
);
CREATE INDEX term_lineage_tid_idx ON term_lineage(tid);
CREATE INDEX term_lineage_lineage_idx ON term_lineage(lineage);

1) The field depth is Integer
2) The character "," is missing in line 3

This script will working correctly:
CREATE TABLE term_lineage (
tid integer NOT NULL default '0',
lineage varchar(255) NOT NULL default '',
depth integer NOT NULL default '0'
);
CREATE INDEX term_lineage_tid_idx ON term_lineage(tid);
CREATE INDEX term_lineage_lineage_idx ON term_lineage(lineage);

Comments

#1

Status:active» fixed

I appear to have fixed this a month ago and just forgot to close the issue.

#2

Status:fixed» closed (fixed)