WP-Surveys won’t create tables

  • Resolved mickcottingham

    (@mickcottingham)


    16 years, 2 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.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter mickcottingham

    (@mickcottingham)

    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 https:// so if you run a secure server you may want to change some or all of them to https://

    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.

    whoops – it didn’t appear to go through. Duplicate post.

    this was another duplicate post. sorry about that.

    missmoxie

    (@missmoxie)

    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

    missmoxie

    (@missmoxie)

    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! ??

    the trick didn’t work for me on wp 2.7

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WP-Surveys won’t create tables’ is closed to new replies.