OK, I ran debug, and I found the problem... Category has no field "CatRoot" in it!
The actual error is:
GT::SQL::error = Failed to execute query: 'SELECT ID,CatRoot,FatherID,CatDepth FROM Category WHERE (CatRoot > ? AND CatRoot <= ?) ORDER BY CatRoot, CatDepth': Unknown column 'CatRoot' in 'field list'
Looking at Category, I do note it also does not have CatDepth.
What should I do at this point????
dave
Big Cartoon DataBase
Big Comic Book DataBase
The actual error is:
GT::SQL::error = Failed to execute query: 'SELECT ID,CatRoot,FatherID,CatDepth FROM Category WHERE (CatRoot > ? AND CatRoot <= ?) ORDER BY CatRoot, CatDepth': Unknown column 'CatRoot' in 'field list'
Looking at Category, I do note it also does not have CatDepth.
What should I do at this point????
dave
Big Cartoon DataBase
Big Comic Book DataBase