Index: branches/5.2.x/core/units/content/content_config.php =================================================================== --- branches/5.2.x/core/units/content/content_config.php (revision 16669) +++ branches/5.2.x/core/units/content/content_config.php (revision 16670) @@ -1,75 +1,75 @@ 'content', 'ItemClass' => Array ('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'), 'ListClass' => Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'), 'EventHandlerClass' => Array ('class' => 'ContentEventHandler', 'file' => 'content_eh.php', 'build_event' => 'OnBuild'), 'TagProcessorClass' => Array ('class' => 'ContentTagProcessor', 'file' => 'content_tp.php', 'build_event' => 'OnBuild'), 'AutoLoad' => true, 'QueryString' => Array ( 1 => 'id', 2 => 'Page', 3 => 'PerPage', 4 => 'event', 5 => 'mode', // needed? ), 'IDField' => 'PageContentId', 'ParentTableKey' => Array ('c' => 'CategoryId', 'st' => 'CategoryId', 'page-revision' => 'RevisionId'), // linked field in master table 'ForeignKey' => Array ('c' => 'PageId', 'st' => 'PageId', 'page-revision' => 'RevisionId'), // linked field in subtable 'ParentPrefix' => 'c', 'AutoDelete' => true, 'AutoClone' => true, 'TitleField' => 'ContentNum', // field, used in bluebar when editing existing item 'TitlePresets' => Array ( 'default' => Array ( 'new_status_labels' => Array ('content' => '!la_title_Adding_Content!'), 'edit_status_labels' => Array ('content' => '!la_title_Editing_Content!'), ), 'content_edit' => Array ('prefixes' => Array ('content'), 'format' => '#content_status# - !la_title_General!'), ), 'TableName' => TABLE_PREFIX . 'PageContent', 'ListSQLs' => Array ( '' => ' SELECT %1$s.* %2$s FROM %1$s - JOIN ' . TABLE_PREFIX . '%3$sPageRevisions pr ON pr.PageId = %1$s.PageId AND pr.RevisionId = %1$s.RevisionId' + LEFT JOIN ' . TABLE_PREFIX . '%3$sPageRevisions pr ON pr.PageId = %1$s.PageId AND pr.RevisionId = %1$s.RevisionId', ), 'ListSortings' => Array ( '' => Array ( 'Sorting' => Array ('ContentNum' => 'asc', 'RevisionNumber' => 'desc'), ) ), 'Fields' => Array ( 'PageContentId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), 'ContentNum' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), 'PageId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), 'RevisionId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), 'Content' => Array ( 'type' => 'string', 'max_len' => 65536, 'formatter' => 'kMultiLanguage', 'using_fck' => 1, 'default' => '' ), ), -); \ No newline at end of file +);