(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?