Category: Forum

If the forum feature is enable, the Tiki stats are broken.

__~~#F00:UPDATE~~__: It may happen if there is no forum or topic or thread yet.
I created a forum, a topic and a few threads, refresh index, caches several times and I played with the code at lib/stats/statslib.php I got it to work. After 20mn the page was displayed without the error.

{CODE()}
Erreur système.
Le message d'erreur suivant a été renvoyé:

Column 'parentId' in where clause is ambiguous
La requête était:

select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`=? and `parentId`=?
Valeurs:

forum
0
La requête construite était probablement:

select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`='forum' and `parentId`='0'
{CODE}

[http://tikiwiki.org/tiki-searchresults.php?highlight=rss&where=forums&search=Search+in+content|Link to error]

On the main forum page of tw.o I enter the text "rss" then search button and get the following:



The following error message was returned:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

The query was:
SELECT `rssId`, `url`, `actions` FROM `tiki_rss_modules` WHERE (`lastUpdated` < ? - `refresh`) AND `rssId` IN( )

Values:

1. 1270869772

The built query was likely:
SELECT `rssId`, `url`, `actions` FROM `tiki_rss_modules` WHERE (`lastUpdated` < '1270869772' - `refresh`) AND `rssId` IN( )

{syntax type="tiki" editor="plain"}
On a Tiki 27.x (updated after Tiki27.5 release) I had multiple errors while rebuilding the Unified Index.

{CODE()}
2026-02-09T09:46:45+00:00 INFO (6): addDocument forum post 1 {"memoryUsage":"42.5 MiB","memoryAvail":"-1 B"}
2026-02-09T09:46:45+00:00 ERR (3): WARNING: Undefined array key "is_html" {"code":2,"file":"/home/domain/public_html/lib/tikilib.php","line":6477}
2026-02-09T09:46:45+00:00 INFO (6): addDocument forum post 4 {"memoryUsage":"42.5 MiB","memoryAvail":"-1 B"}
.../...
{CODE}

See solution for the fix I used.

{syntax type="tiki" editor="plain"}
!The forum display on
[http://tikiwiki.org/tiki-forums.php?forumId=2]
forumId=2 and all others

has normally headers of columns.
These header are button to sort the message on.

!!!The concerned headers are :
#Type
#Title
#Hits
#Author

The activate generates a request to sort the list.

__These sort requests generates a SYSTEM ERROR SQL Request with the main error type :

#Column 'type' in order clause is ambiguous
#Column 'title' in order clause is ambiguous
#Column 'hits' in order clause is ambiguous
#Column 'userName' in order clause is ambiguous__

Thank's for action

Greetings
I get the following error message when trying to access a forum.

Error
Notice: invalid variable value: $_GET["comments_parentId"] = 5-Forum-to-find-projects

I created a new forum after updating to 1.8.5 thinking that it was something to do with upgrading but it did not help. All my forums are located at

https://www.p-brane.com/nano/forums

They all produce the same error.

Sincerely,
Jay Morreale
Member
p-brane LLC

On this page:

/tiki-view_forum_thread.php?comments_parentId=15&forumId=1

The previous topic link produces this url:

/tiki-view_forum_thread.php?comments_parentId=12&topics_offset=-1

This page is a Error Page.

This page also gets indexed by google and is crawled by bots.

I have added a line to my robots.txt to tell google bots not to include it in there indexing

Disallow: /*topics_offset=-1

Thanks, for considering addressing this. Really appreciate tiki.

Forum last posts module gives the following Notice errors on top of tiki-objectpermissions.php page and messes up the font size of permissions list.

Notice: Undefined index: forumId in ../proposed/5.x/lib/core/lib/Perms.php on line 185

Notice: Undefined index: forumId in ../proposed/5.x/lib/core/lib/Perms.php on line 229

For every topic created you will get another 2 of those Notices.
When there are 100 forum topics not that hard to get you will need to scroll down 200 lines of notices just to edit a few permissions.

Reproduce:
Turn on feature forum
Asign forum last posts module
Create a forum and a topic


One of the notices i got is fixed in Revision 29138
Notice: Use of undefined constant ttz - assumed 'ttz' in ../proposed/5.x/lib/tikilib.php on line 7682

I get "Fatal error: Class 'Comments' not found in .../lib/importerlib.php on line 24" when trying to import a forum (at'tiki-forum_import.php').

I'm running 1.9.2. I am unable to get the attachment portion of inbound emails to show up as an attachment to a forum post or wiki page. I expect this also applies to analogous emails of other types of content. I think this was working in January 2006.

I will be posting a related issue in the next item. It deals with e-mails to forums having "Use this thread to discuss the [tiki-index.php?page=xxx|xxx] page." added to the body of the forum post, as if it was a Discussion of a wiki page.

Feature to discuss wiki pages in forums sends a notification email (user watches) each time the use clicks at the button 'Start discussion' (even if the discussion and thread was already started by someone else previously)

Reproduced:

http://xavi-9794-6188.show.tikiwiki.org/tiki-index.php?page=HomePage
u: admin
p: 12345

u: user1
p: user1

Mail sending is logged in the syslogs
Login as user1 and click at access discussion of the homepage (link above bottom bar). Registered users (through group watches) will receive an email as if you started the thread. But thread was started already, and you didn't post anything else to trigger a new email sent.

I must be missing something... yes?

{img fileId="1365" thumb="box" width=640}
See https://tiki.org/forumthread73548-comments-on-blog-posts

See screenshot

The form element "select" in forms of Tiki Forum and in other features of Tiki is missing the term (selector) "custom-select" as part of the CSS class to render it correctly in the Bootstrap theme design.

Making this simple change would greatly improve and unify the UI of Tiki with the currently available Themes.

See attached screen shot of added term in inspector for Tiki Forum feature.

{img fileId="1380" thumb="box"}

I have noticed that the number of readings of a change post does not increase even if you connect with another user.

Tiki 1.9.x forums have improved nicely over the last few months. One more thing to make them cleaner is to make the default threading to plain.

Let's face it, it looks cleaner :-)


{img src=images/code.png}%%% {CODE()}
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/comments.php,v
retrieving revision 1.31.2.50
diff -c -r1.31.2.50 comments.php
*** comments.php 11 May 2007 23:15:50 -0000 1.31.2.50
--- comments.php 31 May 2007 04:01:10 -0000
***************
*** 386,392 ****

if (!isset($_REQUEST["comments_style"])) {
// TODO: Make this an option.
! $_REQUEST["comments_style"] = 'commentStyle_threaded';
} else {
$smarty->assign('comments_style_param', '&amp;comments_style='.$_REQUEST['comments_style']);
$comments_show = 'y';
--- 386,392 ----

if (!isset($_REQUEST["comments_style"])) {
// TODO: Make this an option.
! $_REQUEST["comments_style"] = 'commentStyle_plain';
} else {
$smarty->assign('comments_style_param', '&amp;comments_style='.$_REQUEST['comments_style']);
$comments_show = 'y';

{CODE}

Google Group list and forum posting are working perfectly after following [https://doc.tiki.org/Forum+and+Mailing+List+Synchronization|setup guide here].

According to the guide, email addresses unknown to tiki are to show as "Anonymous" posts. They do not. Instead, they show as the complete From: email address, "full name <email@somewhere.com"

Take a look here (I edited the sql database and changed the email address slightly to make it inoperable, but left the address there so you can see what happens.):

http://tiki.lingtransoft.info/tiki-view_forum_thread.php?comments_parentId=22&topics_offset=1

There is nowhere to turn this off, and it is a huge security risk as those addresses are posted in plain text.

the problem is moderation of forum posts.

can not delete a created forum.
When I ty to delete the forum entry the window to ask it i wish to delete the forum pops up.
When I say yes, nothing happens.

Best regards

Jürgen

Hi,

I tried to set up a forum as archive for the commit emails from our svn.
It kind of works, but yesterday there was a long commit email. Our commit emails also contain the diff which was committed. This one contained also html pages, so there was html-markup in the email. Additionally the email was *very* long.
I disabled wiki syntax for the forum.
Nevertheless, there were two problems:
the html markup in the email was interpreted, i.e. rendered as html instead of displayed as plain text. I'm not sure whether this is a bug or a feature request. I would prefer if it would just display the message as plain text. The rendered html was all over the page, i.e. it escaped the text box.

And it already appeared on the page which should actually list only the threads, not show the post contents. It seems it was maybe only an error message (which as described above caused another problem).

This is how the displayed wiki html page starts:

--------8<---------------8<---------------------8<-----------------------
This is TikiWiki v1.9.10.1 -Sirius- © 2002–2007 by the Tiki community Thu 23 of Oct, 2008 [15:26]
+ +
+Definition at line 50 of file interface.c. +
+References MAXSIZE.

--------8<---------------8<---------------------8<-----------------------

(the lines with the plus signs come from the commit mail).

Then the tikiwiki boxes start.
In the box where actually the thread list should appear, the following appears:
--------8<---------------8<---------------------8<-----------------------
Error


An error occured in a database query!

+ +
+Definition at line 577 of file interface.c. +
+Referenced by print_cpu(), and print_net().
Context:
File tiki-view_forum.php
Url tiki-view_forum.php?forumId=2
Query:
insert into `tiki_comments`(`objectType`, `object`, `commentDate`, `userName`, `title`, `data`, `votes`, `points`, `hash`, `parentId`, `average`, `hits`, `type`, `summary`, `smiley`, `user_ip`, `message_id`, `in_reply_to`) values ( ?, ?, ?, ?, ?, ?, 0, 0, ?, ?, 0, 0, ?, ?, ?, ?, ?, ?)
Values:
0 forum
1 2
2 1224768390
3 Anonymous
4 - zoum in trunk/zoum/trunk/interface/docs
5 Author: zoum Date: 2008-10-23 00:06:36 +0200 (Thu, 23 Oct 2008) New Revision: 648 Added: trunk/zoum/trunk/interface/docs/html/classes.html trunk/zoum/trunk/interface/docs/html/cpu__implement_8c-source.html trunk/zoum/trunk/interface/docs/html/example1_8c-source.html trunk/zoum/trunk/interface/docs/html/examp

.....
a lot of text skipped

.....
trunk/zoum/trunk/interface/docs/perlmod/doxyrules.make ___________________________________________________________________ Name: svn:eol-style + native
6071ba94cc94282dcc6dce5f2694e6a547238n91011131.246.77.1381220081022220639.193F1A2363@somehost.uni-foo.de13Message:Error MessageGot a packet bigger than 'max_allowed_packet' bytes

Go back


--------8<---------------8<---------------------8<-----------------------

Alex

Currently, (2.2) when using the mailin feature to post to a forum, Tiki does not actually check the email until a user views the forum. Only then, is the email checked and new messages posted to the forum.

This means that the RSS feed for the forums, and modules such as last_post will not be correct until a user goes to the forum.

Instead, Tiki should check the email at regular intervals (in the same way that Tiki checks for article mail-ins.

Does anyone know of a migration script / strategy for moving tiki forums
from one Tiki to another?

I want to move this Galaxia forum:
http://tikiwiki.org/tiki-view_forum.php?forumId=11
to:
http://workflow.tikiwiki.org/

The themes forum
http://tikiwiki.org/tiki-view_forum.php?forumId=14
to:
http://themes.tikiwiki.org/

And the Multilingual/i18n <tiki-view_forum.php?forumId=13> forum:
http://tikiwiki.org/tiki-view_forum.php?forumId=13
http://tikiwiki.org/tiki-view_forum.php?forumId=10
http://tikiwiki.org/tiki-view_forum.php?forumId=15
http://tikiwiki.org/tiki-view_forum.php?forumId=7
http://tikiwiki.org/tiki-view_forum.php?forumId=8
http://tikiwiki.org/tiki-view_forum.php?forumId=9
http://tikiwiki.org/tiki-view_forum.php?forumId=16
to an eventual i18n.tikiwiki.org

{syntax type="tiki" editor="plain"}
although they have tiki_p_admin_forum permission=__n__ (on v3.2).
My forum mods gets on tiki-view_forum.php?forumId=<int> the "Edit forum" button, which should be visible to forum admin only.
If they click on the button they get the error messages about missing permissions, so there is no serious problem with it, but it's confusing to see this button.

I've looked over templates/tiki-view_forum.tpl but didn't see anything as explanation for this.
(Btw: the if/else clause from line 15 to 19 doesn't make a sense (for me); it makes the same, never mind the case of the if-clause)

Forums tools and names support Tiki Multilingual feature but the breadcrumb that doesn’t display translation.

After posting to a non-moderated forum, users sees the message as if the forum was moderated:
^
Your message has been queued for approval, the message will be posted after a moderator approves it.
^

Message is posted instantly, without any check from anybody