Issue Details (XML | Word | Printable)

Key: MDL-3074
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Trivial Trivial
Assignee: Unassigned
Reporter: Petri Asikainen
Votes: 0
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Can't see message lists

Created: 29/Apr/05 06:47 PM   Updated: 01/Mar/06 08:41 AM
Component/s: Forum
Affects Version/s: 1.5
Fix Version/s: None

Environment: All

Database: PostgreSQL
Participants: Martin Dougiamas and Petri Asikainen
Security Level: None
Affected Branches: MOODLE_15_STABLE


 Description  « Hide
After updating current CVS-version postgresql does not show messages from forums.

this seems to be issue with LEFT JOIN ()

I replaced LEFT JOIN with common where/from syntax and it seems to work now with my postgresql.

If some one could test this with mysql too and apply patch to CVS if it works.



 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Martin Dougiamas added a comment - 01/Mar/06 08:41 AM
From (penny at catalyst.net.nz) Monday, 12 December 2005, 11:42 AM:

What version of postgresql are you running?

Can you upgrade to the latest version of 1.5.3+ and see if you still have the problem? I can't see a problem with the LEFT JOIN, and your patch (as far as I can see without applying it and running it) will change functionality as it changes from a LEFT JOIN to a INNER JOIN.

From (penny at catalyst.net.nz) Tuesday, 20 December 2005, 08:23 AM:

Hi, any update on this bug?

From (penny at catalyst.net.nz) Thursday, 2 February 2006, 04:04 AM:

Hi, any update on this bug? I will close soon after 9 months of no activity.

From (penny at catalyst.net.nz) Wednesday, 1 March 2006, 08:41 AM:

closing.