I have a local (on my laptop) version of 1.5.2 runing and cannot get the forum activity working. I can add a new Forum and then add a discussion but the discussions do not show up. If I view the "Forums" page I can see my forum and the page indicates that there is a discussion. If I select the forum, it says that "There are no discussion topics yet in this forum".
Any thoughts?
Recently,I have the same problem.Moodle version is 1.5.3(stable).I haven't solve it yet.
I found the problem and the solution. It looks like it might be a result of a change in MySQL 5. It has to do with the order of the tables in the FROM clause in the SQL statement. On line 1296 of mod/forum/lib.php you need to change the order of the FROM clause. This is what it should look like:
FROM {$CFG->prefix}user u,
{$CFG->prefix}forum_posts p,
{$CFG->prefix}forum_discussions d
Notice that I changed the order of the user table and the forum_discussion table.
Mark <><
Great!
I change mysql 5.0.15 to 4.1.17,then it works well.
/// Given a log entry, return the forum post details for it.
global $CFG;
if ($log->action == "add post") {
u.firstname, u.lastname, u.email, u.picture
FROM {$CFG->prefix}user u,
{$CFG->prefix}forum_posts p,
{$CFG->prefix}forum_discussions d
Hi and thanks for this advice which I needed quite desparately last night.
For the record, I found the fault around line 1330.
Would it be worth posting this (and the solution) to the bug tracker so that it makes it into cvs, or should it really be mySQL who should fix it.
Cheers
Andy D
I have tried this change but it doesn't work. Although it is only the 'standard forum for general use' that doesn't show up. A single simple discussion works OK.
Any othe ideas.
Adrian
It took me about four tries before I managed to make it work. Be careful that the comma's are in the correct place as well when you re-arrange those lines. The line moved to the top should have a comma, and the last one should not.
Ax
Excellent - it worked. Silly me for not seeing the comma out of place.
Many thanks
Adrian
hej all!
I feel a bit stupid to come back to a problem which most of you seem to have resolved some months ago, yet I just had my discussions dissapearing after an upgrade of the mySQL in the server. I tried to change the lines in lines 1293 - 1305 (and paid attention to the commas!) but I still don't see the discussions on the web
the code looks like that:
} else {
return get_records_sql("SELECT $postdata, d.name, d.timemodified, d.usermodified, d.groupid,
u.firstname, u.lastname, u.email, u.picture $umfields
FROM {$CFG->prefix}user u,
{$CFG->prefix}forum_posts p,
{$CFG->prefix}forum_discussions d
$umtable
WHERE d.forum = '$forum'
AND p.discussion = d.id
AND p.parent = 0
AND p.userid = u.id $groupselect $userselect
ORDER BY $forumsort $limit");
}
Any ideas?
many thanks!
Nikos
Kevin,
I am wondering if there has been a resolution to this issue on the latest stable branch for 1.5.3? I am having his problem, and I made an initial pass at applying your changes without success.
Thank you!
Works for me 
Roger
Thanks very much for your input here, this has solved my long standing problem of missing forums.
Regards Chris Cowley, Finland
Thanks Mark, I've been using Moodle for a couple of years and this is the first time I really needed some help. I appreciated your solution to this problem and it made me appreciate Open Source again.
Charlie
THANK YOU!
Just another greatful Moodle user. How did you ever figure that out? You have racked up some good karma with this tip.
Thanks again.
Thank you,
Changing the order of those lines fixed my problem!
