When accessing the results from taken quizzes via "Administer > quizzes" and clicking on "View" on one of the taken quizzes, I get:

user warning: Table 'lab_drupal5dev-20070209.quiz' doesn't exist query: SELECT quiz.nid FROM quiz, quiz_result WHERE quiz_result.quiz_nid = quiz.nid AND quiz_result.rid = 3 in E:\xampplite-1.5.4a\htdocs\lab\drupal5dev-20070209\includes\database.mysql.inc on line 172.

I'm using table prefix drupal_, which seem to be missing in this SQL query.

This was tested on the version of the module posted at http://drupal.org/node/114885, on Drupal 5.2 dev as of 2007-02-09, running on:
Windows XP Professional
ApacheFriends XAMPP Lite version 1.5.4a
+ Apache 2.2.3
+ MySQL 5.0.24a
+ PHP 5.1.6 + PEAR (basic package)

CommentFileSizeAuthor
#2 quiz-5.1-admin-delete.patch1.29 KBjinside

Comments

saml’s picture

saml commented

Also, when clicking "delete" on any of the nodes, I get a white "screen" saying:
Fatal error: Cannot use string offset as an array in E:\xampplite-1.5.4a\htdocs\lab\drupal5dev-20070209\modules\system\system.module on line 2160

jinside’s picture

jinside commented
StatusFileSize
new quiz-5.1-admin-delete.patch1.29 KB

Attached is a patch for the delete issue. The form was still using the 4.7 style.

goose2000’s picture

goose2000 commented

I am seeing a similar issue. I have a 2nd site with DB prefixes. I am seeing this error when I try to view the quiz. My system is 4.7.6 my prefix here is 'bhi_' The tables correctly reflect this in the DB.

Ideas? Thanks

Field 'score' doesn't have a default value query: INSERT INTO bhi_quiz_result (rid, quiz_nid, uid, time_start) VALUES (10, 12, 1, 1172252562) in C:\Inetpub\wwwroot\BHRP\includes\database.mysql.inc on line 121.

goose2000’s picture

goose2000 commented

UPDATE - my problem is solved. It was MySQL DB 5 and how the default value in the 'score' field was empty. I simply put a 0 in there and it worked fine. This might be changed in the database setup? If people move to MuSQL 5, eventually...

BTW - my this is a 2nd site with a prefix in the DB tables, all seems fine.

goose2000’s picture

goose2000 commented

Well, I see this is a problem now from the exact page admin view page described above. funny most other quiz features / pages. And ideas on this ? I'm getting a little desperate.

John

saml’s picture

saml commented
Status: Active » Needs review

goose2000, which version of quiz are you using?
The ones referred to above are for drupal 5, and might not work on 4.7.6... (just in case... =) )

The original issue in this post seem to be fixed now in the nwq 5.1 version of wmostrey at http://drupal.org/node/114885#comment-203899
(If you use it, be sure to also apply the patch by jinside at http://drupal.org/node/114885#comment-205087, since it fixes another critical issue)

Good luck!

Samuel Lampa
Drupal / MediaWiki Theme design

add1sun’s picture

add1sun commented
Status: Needs review » Fixed

All included now from the work in http://drupal.org/node/114885 before the branches were made.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)