[Plugin: WP Survey And Quiz Tool] Fatal Error

It seems you’ve got it activated and then tried to activate it again.

For the stuff not showing up in the tables try setting a number of items per page option in the options page. I thought I had it set one by default but that may not have worked.

Hi,
I deactivated the plugin, and then tried to re-activate it (only once), still see the error. I have set number of items per page, the plugin seems to remember this setting when I revisit the options page, but unfortunately the problems I noted above still persist I’m afraid.

Hi,

Well the only way you would be getting the can’t re declare function is if the file was included twice.

May I ask what version of wordpress you are using? Also could you provide the options you gave to create the quiz.

I’m on WP 3.0.1, a single site, though using a table prefix in the database. php is 5.2, mysql is 5.1

I’ve tried various combos of options in the create a survey/quiz page, none seem to work. Would you still like me to provide an example set?
All I see is “No quizes or surveys yet!”

I also tried on a different blog, so no danger of the “second activation” issue with the same fatal error. Is there anything I can try and look for in the database to see what is getting saved? (though I’m a novice with phpymyadmin)

Hey,

If you don’t mind providing a sample set that would be great.

If you look in phpMyAdmin at the table there should be

(prefix)_wpqst_quiz
(prefix)_wpsqt_questions
(prefix)_wpsqt_answers
(prefix)_wpsqt_results
(prefix)_quiz_sections

look at the number of rows for those if they aren’t there or if they are all zero then it’s not saving the data.

The tables are not there, I guess the fatal error on activation is stopping them from being created properly???

Well a fatal error in activation would prevent the plugin from being activated and the forms and what not appear.

Two questions who is your hosting provider and do you know if you your mysql user has permissions to create new tables.

I’m on a local Intranet at a UK University

yes, my mysql account can create new tables, I have other WP plugins that have done that.

I’ve managed to recreate the issue and yea since the activation isn’t working properly the tables aren’t getting created. I am going to try and find the solution for this problem tho I’ll most likely do a release with a quick work around within the next few hours.

Brilliant, thanks.
I am actually really looking forward to getting this plugin to help with my teaching. Some of the other quiz plugins I found did not quite deliver what yours promises.

I’ve just committed a new version with a nasty workaround that runs the install function if the tables don’t exist. I’ll try and figure out why the error is raised in the 1st place.

The plugin looks amazing from the description. But, downloaded this today and found that this has the same errors i.e. Clicking on Quizzes or Surveys shows up nothing.

I also wanted to know if this plugin includes the question type…for rating on a scale… e.g.scale of 5…..excellent…v good….good..fair…poor

Thanks in advance.

Well the bug in this thread has been fixed for over 2 weeks. I am going to assume you’re affected by the bug in 1.1.2 which was reported yesterday morning and fixed yesterday afternoon. Therefore please download latest version 1.1.3.

Thanks for your response Backie. I downloaded and installed yesterday. Today, I removed the plugin from my site and dropped all the related tables from the database. Then I downloaded 1.1.4 and installed. It gives the same issue. Nothing appears when I click on Surveys or Quizzies.
I checked in the database and noticed the browse option is disabled. Is it because there is nothing in these tables or is that a permission issue?
Further, For one of the tables…wp_wpsqt_survey_results, there is this following error:
PRIMARY and INDEX keys should not both be set for column id

could you plz advise what might be wrong. Meanwhile, I am trying to fix it at my end.

thanks so much!

Can I ask what version of mysql you are using? Also what version of wordpress aswell.

Thanks