Start a new topic

2 database queries that do not match table definitions

codewzrd @ Fri May 23 09:45:47 EEST 2014
DOMAIN_ROOT_LIST AND INHERITANCE tables both have table definitions that do not match the queries found in pref.XML.

INSERT INTO DOMAIN_ROOT_LIST (USERID,DOMAIN,PATH,SORT_ORDER) VALUES(?,?,?,?)

But the DOMAIN_ROOT_LIST table only has userid, domain, path columns and no sort_order column.

SELECT * FROM INHERITANCE WHERE SERVER_GROUP=?

But the INHERITANCE table only has userid, inherit_username, sort_order columns and no server_group column.

For domain root list, I can ignore the sort_order column, but not sure if the java code expects it on a SELECT.
Not sure how to handle the INHERITANCE.

Any ideas?
Thanks,
1 Comment

spinkb @ Sat May 24 22:17:28 EEST 2014
Both of these issues have now been fixed in the Wiki pages and the current build in the schema it gives you to use.

Thanks for letting us know about these.
Login to post a comment