My quiz module no longer works on postgresql and I get many serious messages, for example:
I made a quiz node and got this

You just created a new quiz. Now you have to add questions to it. This page is for adding and managing questions. Here you can create new questions or add some of your already created questions. If you want to change the quiz settings, you can use the "edit" tab.
Quiz wx has been created.

then right after that I got:

warning: pg_query(): Query failed: ERROR: LIMIT #,# syntax is not supported LINE 10: ) LIMIT 0, 250) tbl ^ HINT: Use separate LIMIT and OFFSET clauses. in /var/www/sparcs/includes/database.pgsql.inc on line 139.
user warning: query: SELECT COUNT(*) FROM ( SELECT n.nid FROM node n LEFT OUTER JOIN users u ON n.uid = u.uid WHERE n.type IN ('long_answer', 'matching', 'multichoice', 'quiz_directions', 'scale', 'short_answer', 'truefalse') AND n.nid NOT IN ( SELECT child_nid FROM quiz_node_relationship WHERE parent_vid = 662967 ) LIMIT 0, 250) tbl in /var/www/sparcs/sites/all/modules/quiz/quiz.admin.inc on line 1307.

Since you no longer support the 3.x branch, and 4.0 wont work correctly on postgres, this is a showstopper for me.

Comments

sivaji_ganesh_jojodae’s picture

We need to refrain from using LIMIT in SQL queries to fix this.

The LIMIT syntax varies between database servers, so that is abstracted into db_query_range() arguments.

See http://api.drupal.org/api/drupal/includes--database.inc/group/database/6

falcon’s picture

Priority: Critical » Minor
Status: Active » Postponed

I'm sorry, but I don't have the time to fix any database specific bugs in Quiz 4 for D6, but I'll be happy to commit patches. I've also updated the project page accordingly.

ezraw’s picture

Component: Code » Code - Quiz core
Issue summary: View changes
Status: Postponed » Closed (duplicate)