WordPress.org

1. mickcottingham
   Member
   Posted 10 months ago #

   WP-Surveys is exactly what I need on a site I am developing but although the plugin installs and is recognised (Surveys tab appears), I cannot create any surveys.

   I have successfully created a post with [wp_surveys] in the content, which correctly returns a page with "There are no surveys to display.", so this is promising!

   Version 0.8.2.1 on WP 2.6.5 doesn't create any tables in the database. As far as I can tell, the php code which does the table creation does not run.

   Select Surveys tab as admin
   Select Add Survey button
   Enter Title (and description)
   Select Add this survey
   Returns a blank screen

   Any help would be much appreciated. Thanks.

2. mickcottingham
   Member
   Posted 10 months ago #

   The problem was caused by mysql not liking 'DEFAULT CHARACTER SET utf8' in the CREATE sql. Removing these 4 words in each place does the trick!

   Also, the php files make explicit references to http:// so if you run a secure server you may want to change some or all of them to https://

3. kurtis.a
   Member
   Posted 10 months ago #

   Hey Mick,
   I'm having a similar problem with my surveys. I go to the Surveys page and click the "Add Survey" button. Then I add the title and description and click the "Add this survey" button and it returns a blank screen.

   I tried removing the 'DEFAULT CHARACTER SET utf8' from the wp-surveys.php file on lines 257, 279, 288 and 297, but that didn't change anything. I didn't find those words in any other file so I'm not sure if that's the problem.

   How were you able to see that mysql didn't like that line? Is there a place that displays mysql errors? Where would I find that?

   I'm running Version 0.8.2.1 of WP-Surveys on WordPress 2.7.

   Thanks for any assistance.

4. kurtis.a
   Member
   Posted 10 months ago #

   whoops - it didn't appear to go through. Duplicate post.

5. kurtis.a
   Member
   Posted 10 months ago #

   this was another duplicate post. sorry about that.

6. missmoxie
   Member
   Posted 9 months ago #

   Hi there,

   I'm having the same issue. I went into phpMyAdmin and did a search for that phrase to see if I could figure out how to remove "DEFAULT CHARACTER SET utf8", but it doesn't say it's in there.

   Could you post more explicit instructions on how to accomplish this change? I'd really appreciate it. :)

   Thank you!
   Joelle

7. missmoxie
   Member
   Posted 9 months ago #

   Ok, I figured it out, so I'll share:

   1. Deactivate the plugin.

   2. Go into Plugins > Edit > WP-Survey.php

   3. Remove all instances of DEFAULT CHARACTER utf8 (only those words, leave the semicolon after)

   4. Save and reactivate the plugin.

   TA DA! :)

8. alekone
   Member
   Posted 5 months ago #

   the trick didn't work for me on wp 2.7

Reply

You must log in to post.