Forum .LRN Q&A: Re: Forums in dotLRN broken?

Collapse
Posted by Jarkko Laine on
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)