Comments dont show up when comments_archive is set
- Status
- Closed
- Subject
- Comments dont show up when comments_archive is set
- Category
- Error
- Feature
- Comment
- Resolution status
- Fixed or Solved
- Submitted by
- Ushindi Gedeon
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
\db\tiki.sql 548:
CREATE TABLE `tiki_comments` ... `archived` char(1) default NULL, ..
\lib\comments\commentslib.php 1337:
if ($prefs'comments_archive' == 'y' && $tiki_p_admin_comments != 'y') {
$conditions'archived' = 'n';
}
unarchived comments have `archived` = NULL, not 'N'- Solution
CREATE TABLE `tiki_comments` ... `archived` char(1) NOT NULL default 'n', ...
ALTER TABLE `tiki_comments` ... `archived` char(1) NOT NULL default 'n', ...
UPDATE tiki_comments SET `archived` = 'n' WHERE `archived` <> 'y'- Workaround
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3981
- Created
- Wednesday 24 August, 2011 12:27:04 UTC
by Gustav Graf - LastModif
- Thursday 02 July, 2026 10:02:51 UTC