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
Comment #1
sivaji_ganesh_jojodae commentedWe need to refrain from using LIMIT in SQL queries to fix this.
See http://api.drupal.org/api/drupal/includes--database.inc/group/database/6
Comment #2
falcon commentedI'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.
Comment #3
ezraw commentedDupe of #935470: Support for Postgres