Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Trivial
-
Resolution: Cannot Reproduce
-
Affects Version/s: 1.5
-
Fix Version/s: None
-
Component/s: Forum
-
Labels:None
-
Environment:All
-
Database:PostgreSQL
-
Affected Branches:MOODLE_15_STABLE
Description
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.
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
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.