quiz 7.x-4.0-beta2 [#2126361]

I just from my "install new Module" install a recommended security update for the Quiz module, the quiz 7.x-4.0-beta2.

The module said successful, but when I tried to select my Content menu or the Find Content logged in as administrator I get the following error.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'qnp.userpoints_tid' in 'field list': SELECT qnp.aid AS aid, qnp.number_of_random_questions AS number_of_random_questions, qnp.max_score_for_random AS max_score_for_random, qnp.pass_rate AS pass_rate, qnp.summary_pass AS summary_pass, qnp.summary_pass_format AS summary_pass_format, qnp.summary_default AS summary_default, qnp.summary_default_format AS summary_default_format, qnp.randomization AS randomization, qnp.backwards_navigation AS backwards_navigation, qnp.repeat_until_correct AS repeat_until_correct, qnp.feedback_time AS feedback_time, qnp.display_feedback AS display_feedback, qnp.quiz_open AS quiz_open, qnp.quiz_close AS quiz_close, qnp.takes AS takes, qnp.show_attempt_stats AS show_attempt_stats, qnp.keep_results AS keep_results, qnp.time_limit AS time_limit, qnp.quiz_always AS quiz_always, qnp.tid AS tid, qnp.has_userpoints AS has_userpoints, qnp.userpoints_tid AS userpoints_tid, qnp.allow_skipping AS allow_skipping, qnp.allow_resume AS allow_resume, qnp.allow_jumping AS allow_jumping, qnp.show_passed AS show_passed, qnp.mark_doubtful AS mark_doubtful FROM {quiz_node_properties} qnp WHERE (vid = :db_condition_placeholder_0) AND (nid = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 142 [:db_condition_placeholder_1] => 5 ) in quiz_load() (line 977 . . . . .

For the most part I am still able to access certain part on Drupal installation, like I can access the modules, performance, configuration menu items without and issues (so far). It just when I access the Content, or Find Content or the Dashboard I get this error.

I tried running the update.php for while , but it just page just sit there like it is running sometime. After research of some past Quiz update posts, it was noticed that sometime the update seems to just hang, and that it might take a few minutes or even hours before its complete depending on the server it sits on.

So I hit my back button on my browser to reselect the update.php. This time I just let it run overnight. It has be running for over 13 hours. I only build 1 quiz with 20 questions. So my question is:

1. Is the update.php really still running ( can I manually check some way to seem if it is really running.

2. Can I update the database directly with the updated db struct for the Quiz Module. (base upon the error, it looks like the data structure for Quiz need to be updated for the new Quiz Module scripts).

I tried reinstalling the same update, but it said "Already Updated".

Question: I am forced or recommend to delete the Quiz Module , will I loose my existing quizzes. What other side-affects can I anticipate?

Any ideas will be appreciated.

Comments

Comment #1

davidflash CreditAttribution: davidflash commented 3 November 2013 at 17:53

I do not what really happen. I could not wait for a response, so I decided to remove the Quiz altogether and reinstall to new quiz 7.x-4.0-beta2. But in order to remove quiz module I had to first remove quiz questions, long answer, matching questions, quiz multichoice, drag and drop, scale short answers, and true/false modules. So I did. The module uninstall asked me to confirm. And I did

So I preceded to install the quiz 7.x-4.0-beta2. But, Drupal told me already installed ???? So I clear Caches and double check but Quiz is still there.

Now I do not get that error anymore . Go figure.

David

But when

Comment #2

Sivaji_Ganesh_Jojodae CreditAttribution: Sivaji_Ganesh_Jojodae commented 4 November 2013 at 05:34

@davidflash, sorry to hear the trouble you are facing. Column "userpoints_tid" is newly added. There is an hook_update_N() to add that column. I'm not sure why update.php is not completing successfully in your case. See Recent log messages for any clue. Maybe try using drush if you could. As a wiser option you could take professional support, see project page for the same.