WordPress.org

Ready to get started?Download WordPress

Forums

Watu
[resolved] Unknown Column 'randomize in 'field list' (24 posts)

  1. Business Matrix
    Member
    Posted 1 year ago #

    Each time I try to create a new exam this is the message that I get. Unknown Column 'randomize in 'field list' along with a gray highlight message about INSERT INTO wp_master (.......etc. Can you help

    http://wordpress.org/extend/plugins/watu/

  2. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Deactivate and activate the plugin and the column will be created.

  3. Business Matrix
    Member
    Posted 1 year ago #

    Sorry should have mentioned ive tried this a few times no joy.

  4. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    In this case you'll have to manually create the missing column in phpMyAdmin

  5. Business Matrix
    Member
    Posted 1 year ago #

    Ok Iam in my PHP but what do I do next

  6. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Select the database, go in SQL mode and run the following command:

    ALTER TABLE wp_watu_master ADD randomize TINYINT NOT NULL DEFAULT 0

  7. Business Matrix
    Member
    Posted 1 year ago #

    should it come up with #1046 - No database selected

  8. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    No, you need to select the database from the dropdown at left first.

  9. Business Matrix
    Member
    Posted 1 year ago #

    There now seems to be a singlepage field error. ?

  10. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    ALTER TABLE wp_watu_master ADD single_page TINYINT NOT NULL DEFAULT 0;

  11. Business Matrix
    Member
    Posted 1 year ago #

    Thank you sorted. You are a master of your project.

  12. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks! Sorry you had to do it manually, for some reason the auto-update hasn't went smooth in your case. Version 2.0 is soon on its way.

  13. Business Matrix
    Member
    Posted 1 year ago #

    Sorry new problems after having to deactivate your plugin for a bulk install on starting to set the questions I now get.

    INSERT INTO wp_watu_question (exam_id, question, answer_type, is_required) VALUES(1, 'This is my test question', 'radio', 0)

  14. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Sorry, no idea why it would output the query. There is no such thing in the code.

  15. Business Matrix
    Member
    Posted 1 year ago #

    does this help

    WordPress database error: [Unknown column 'is_required' in 'field list']

  16. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Yes. Deactivate and activate.

  17. Business Matrix
    Member
    Posted 1 year ago #

    Should have thought of that one thanks.

    There is something that I would like to discuss with you regarding a customization of your software as a bespoke project would you be interested.

  18. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Maybe, pls drop me a line on email (you can find contact details on the pro version site)

  19. Business Matrix
    Member
    Posted 1 year ago #

    Sorry bout this next issue.

    When I click the question next button i go to the next question but it does not reset to the top of the page. Doesnt look good with the next page loading half way down the page.

  20. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Works fine for me. Sorry, I can't provide endless individual support on a free plugin.

  21. Business Matrix
    Member
    Posted 1 year ago #

    next

    WordPress database error: [Unknown column 'result' in 'field list']
    INSERT INTO wp_watu_takings SET exam_id=1, user_id=1, ip='92.26.167.159', date=CURDATE(), points=9, grade_id=16, result='1<p>No use, understanding or resourcing, and no objective to make change.</p>'

    Ive tried the de re thing already.

    We will get there

  22. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    ALTER TABLE wp_watu_takings ADD result TEXT NOT NULL;

    And this is the last time I am taking care for your problems. If you have more problems, I will not answer, so please stop posting them and hire someone to take care for your case.

  23. Business Matrix
    Member
    Posted 1 year ago #

    Thanks for your support. Understood and due to your speedy response I now fell confident in your product and support .I have now purchased Watu.

    Thanks again for what looks like a great plugin.

  24. prasunsen
    Member
    Plugin Author

    Posted 1 year ago #

    Thank you, hope it will work well for you.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic