Mantis - Quercus
Viewing Issue Advanced Details
3824 minor always 12-22-09 10:13 12-22-09 10:13
ferg  
 
normal  
new  
open  
none    
none  
0003824: moodle bug
(rep by cayhorstmann)

I am using Moodle 1.9.7, Quercus 4.0.2, PostgreSQL 7.4, and GlassFish 3.0. When I take a quiz in Moodle, there are SQL related issues that cause Moodle to fail. When I run the same with PHP Java Bridge instead of Quercus, all is well--which is why I am posting here :-)

I started logging the PHP queries that are the proximate causes for the error messages, and indeed they give me errors when I issue them directly in PSQL. But they are caused by the fact that some records have been inserted more than once with the same ID. The Moodle code is rather messy, so I thought I'd ask for any hints first before digging deeper into it.

What level of compatibility should I expect with respect to PHP and PostgreSQL? How can I most effectively debug this?

There are no notes attached to this issue.