Support » Plugin: WP Survey And Quiz Tool » [Plugin: WP Survey And Quiz Tool] Total Results vs. Single Results = No Match

  • david.witthaus@tdhengineering.com

    (@davidwitthaustdhengineeringcom)


    The Total Results do not appear to be generated on the fly from the all_results table (instead stored in survey_cache_results?). Is it possible to reconstruct the cached values from the results table so they match?

    When the survey was created initially there were fewer answers for some questions, and the original answers are being used to report answer totals instead of the new answers.

    I have deleted all early responses from the all_results table, but not sure how to manually manipulate the cache_results table.

    Suggestions?

    http://wordpress.org/extend/plugins/wp-survey-and-quiz-tool/

Viewing 4 replies - 1 through 4 (of 4 total)
  • I’m having the same, urgent problem.
    Did you (or anyone else) ever find a solution to this?

    Thread Starter david.witthaus@tdhengineering.com

    (@davidwitthaustdhengineeringcom)

    Unfortunately, no. I think with a little more diligence I could have done something, but the reporting would have been very limited, anyway.

    If I remember correctly there is a database table that is created called something…”cache”. Not sure about that, though. Each entry is posted in this table and when an item is deleted through the WP interface it is not deleted here.

    I can’t remember what the data format is for the type of entry that is made, but instead of being a row for each entry it combines all new entries in a sigle data field in the database using some abbreviated code. I coudn’t figure out how to parse the data and remove what I didn’t want.

    In the end I just ended up manually entering all surveys in an Excel spreadheet…what a pain!

    Yeah, thats about how far I’ve gotten as well. I’ve looked at/tried to modify all files, and the database. But the combined “cache-table” gave me nightmares only by looking at it.

    At the moment I’m also on the manual route with pen and paper. Luckily theres “only” about 100 submissions to go through….

    Thread Starter david.witthaus@tdhengineering.com

    (@davidwitthaustdhengineeringcom)

    Good luck. If you find another plugin that works better I’d love to hear which one.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: WP Survey And Quiz Tool] Total Results vs. Single Results = No Match’ is closed to new replies.