Forum .LRN Q&A: Re: Forums in dotLRN broken?
I think you are seeing the bug Rafael Calvo ran into
here https://openacs.org/forums/message-view?message_id=60280
here https://openacs.org/forums/message-view?message_id=60280
You might try deleting the entries in site_nodes where the
package_id is 0.
Jeff,
I assume you mean object_id. However, this time it seems not to be the case, i.e. no rows with object_id 0, just applets without object_id:
dotlrn-test=# select * from site_nodes;
node_id | parent_id | name | directory_p | pattern_p | o
bject_id | tree_sortkey
---------+-----------+-----------------------------+-------------+-----------+--
---------+------------------------------------------------------------------
2603 | | | t | t |
2576 | 00000000
2604 | 2603 | acs-admin | t | t |
372 | 0000000000000000
2605 | 2603 | acs-service-contract | t | t |
516 | 0000000000000001
2606 | 2603 | acs-content-repository | t | t |
1068 | 0000000000000010
2607 | 2603 | acs-workflow | t | t |
2547 | 0000000000000011
2608 | 2603 | doc | t | t |
1356 | 0000000000000100
2609 | 2603 | api-doc | t | t |
411 | 0000000000000101
4825 | 2603 | dotlrn | t | t |
4827 | 0000000000000110
4862 | 2603 | attachments | t | t |
4864 | 0000000000001000
4861 | 2603 | notifications | t | t |
4868 | 0000000000000111
4872 | 2603 | portal | t | t |
4873 | 0000000000001001
4884 | 4825 | attach | t | t |
4864 | 000000000000011000000000
4885 | 4825 | applets | t | t |
| 000000000000011000000001
4887 | 4825 | file-storage | t | t |
4888 | 000000000000011000000010
4896 | 4885 | fs | t | t |
4508 | 00000000000001100000000100000000
4897 | 4825 | calendar | t | t |
4898 | 000000000000011000000011
4903 | 4885 | forums | t | t |
4798 | 00000000000001100000000100000001
4906 | 4885 | static-portlet | t | t |
4907 | 00000000000001100000000100000010
5172 | 4825 | classes | t | t |
5173 | 000000000000011000000100
5296 | 4825 | clubs | t | t |
5297 | 000000000000011000000101
5467 | 5172 | tiedonhallinta | t | t |
5468 | 00000000000001100000010000000000
5504 | 5467 | software-business | t | t |
5505 | 0000000000000110000001000000000000000000
5654 | 5504 | software-business | t | t |
5655 | 000000000000011000000100000000000000000000000000
5696 | 5654 | file-storage | t | t |
5697 | 00000000000001100000010000000000000000000000000000000000
5719 | 5654 | forums | t | t |
5720 | 00000000000001100000010000000000000000000000000000000001
5724 | 5719 | attach | t | t |
4864 | 0000000000000110000001000000000000000000000000000000000100000000
5732 | 5654 | calendar | t | t |
5733 | 00000000000001100000010000000000000000000000000000000010
5734 | 5732 | attach | t | t |
4864 | 0000000000000110000001000000000000000000000000000000001000000000
5745 | 5654 | faq | t | t |
5746 | 00000000000001100000010000000000000000000000000000000011
5754 | 5654 | news | t | t |
5755 | 00000000000001100000010000000000000000000000000000000100
5813 | 5467 | tiedonhallinnan-peruskurssi | t | t |
5814 | 0000000000000110000001000000000000000001
5963 | 5813 | tiedonhallinnan-peruskurssi | t | t |
5964 | 000000000000011000000100000000000000000100000000
6005 | 5963 | file-storage | t | t |
6006 | 00000000000001100000010000000000000000010000000000000000
6028 | 5963 | forums | t | t |
6029 | 00000000000001100000010000000000000000010000000000000001
6033 | 6028 | attach | t | t |
4864 | 0000000000000110000001000000000000000001000000000000000100000000
6041 | 5963 | calendar | t | t |
6042 | 00000000000001100000010000000000000000010000000000000010
6043 | 6041 | attach | t | t |
4864 | 0000000000000110000001000000000000000001000000000000001000000000
6054 | 5963 | faq | t | t |
6055 | 00000000000001100000010000000000000000010000000000000011
6063 | 5963 | news | t | t |
6064 | 00000000000001100000010000000000000000010000000000000100
(39 rows)