I've installed quiz 6.x-3.x-dev (after having the same problem with 6.x-2.1) and can't seem to get the database tables created. The long answer ones show up just fine, but the quiz and multichoice tables do not. Consequently, the
choices on multichoice questions do not get saved. Looking at my db, I see only two tables beginning with "quiz" - and they are both long answer tables.

I do have a prefix on my tables, but the long answer module doesn't seem to mind those at all.

I would appreciate any help that anyone can offer. I've searched through drupal.org for 2 days without coing up with a solution.

php 5.2.6
safe mode on
apache 2.2.9

TIA,

Terry Monnett
The Ohio State University

Comments

mbutcher’s picture

mbutcher commented

When you run update.php, are there any errors?

What version of MySQL are you running?(Or are you running PostgreSQL?)

If there's a bug in the installation, I'd really like to ferret it out, so give me as much info as you can and we'll see if we can get this fixed.

Terry.Monnett’s picture

Terry.Monnett commented

Thank you for your quick reply.

I get no errors when I run update.php - none are returned to the screen and the log doesn't show any. Log errors do occur when I try to save a multichoice question - and they are all of the "table xxxxx doesn't exist" nature.

I am running MySQL 5.0.51a

I am happy to provide any additional information I can give you. In fact, if you would like to contact me directly, I can give you admin access to my installation.

monnett.5@osu.edu

Thanks again

Terry Monnett

VeeLin’s picture

VeeLin commented

I am also getting this error with 6x-2.1(will open a ticket for that version). I'm using postgreSQL.

Hope this helps.

V

thummel’s picture

thummel commented

I had the same problem. I manually created each of the 7 tables using the information in the multichoice.install and quiz.install files. Works fine now.

Drupal 6.9; mysql: 5.0.22

Tracey

mbutcher’s picture

mbutcher commented
Status: Active » Fixed

My recent tests have indicated that installing a new version of quiz and then running update.php is working as expected.

I have not tested PostgreSQL, but everything is done using Drupal's built-in schema module, so database definition should not be a problem.

VeeLin’s picture

VeeLin commented

esteed install on pgsql and instal worked well for quiz and multichoice question type. However the following error occures after adding questions to a quiz:



    * warning: pg_query() [function.pg-query]: Query failed: ERROR: operator is not unique: bigint + smallint_unsigned LINE 1: SELECT COUNT(*) + (SELECT number_of_random_questions FROM qu... ^ HINT: Could not choose a best candidate operator. You might need to add explicit type casts. in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\d6_v2\includes\database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(*) + (SELECT number_of_random_questions FROM quiz_node_properties WHERE vid = 10 AND nid = 10) FROM quiz_node_relationship qnr WHERE qnr.parent_vid = 10 AND qnr.parent_nid = 10 AND question_status = 1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\d6_v2\sites\all\modules\quiz\quiz.module on line 908.
VeeLin’s picture

VeeLin commented

Hello Again,

I have discussed this issue with our local Drupal expert. He is able to dedicate some time to helping to resolve this issue if you would like help. We would very much like to use the Quiz module on our site, but need a solution ASAP.

Kind Regards,

V

mbutcher’s picture

mbutcher commented

I would very much welcome any patches for this.

I'm stumped as to why adding a bigint to a smallint would cause the problem, and I don't have postgresql to test on.

spydmobile’s picture

spydmobile commented

Hi Matt, I work with Vera (VeeLin) and I will dedicate some time starting today to tray and debug this issue on PGsql. We need a quiz/test solution working before next week, so my manager has approved some hours I can dedicate to this. I will begin after 1pm MST today and see what I can figure out! Do you want to start a new issue or keep using this one?
Franco

mbutcher’s picture

mbutcher commented

spyydmobile: We should probably start a new one, since the original item for this bug is actually related to installation.

VeeLin’s picture

VeeLin commented

The discussion regarding pg compatibility is continues here:
http://drupal.org/node/453384

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.