Unknown Column 'randomize in 'field list'

Viewing 15 replies - 1 through 15 (of 23 total)
1 2
  • Plugin Author Bob

    (@prasunsen)

    11 years ago

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

    Thread Starter Business Matrix

    (@business-matrix)

    11 years ago

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

    Plugin Author Bob

    (@prasunsen)

    11 years ago

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

    Thread Starter Business Matrix

    (@business-matrix)

    11 years ago

    Ok Iam in my PHP but what do I do next

    Plugin Author Bob

    (@prasunsen)

    11 years 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

    Thread Starter Business Matrix

    (@business-matrix)

    11 years ago

    should it come up with #1046 – No database selected

    Plugin Author Bob

    (@prasunsen)

    11 years ago

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

    Thread Starter Business Matrix

    (@business-matrix)

    11 years ago

    There now seems to be a singlepage field error. ?

    Plugin Author Bob

    (@prasunsen)

    11 years ago

    ALTER TABLE wp_watu_master ADD single_page TINYINT NOT NULL DEFAULT 0;

    Thread Starter Business Matrix

    (@business-matrix)

    11 years ago

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

    Plugin Author Bob

    (@prasunsen)

    11 years 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.

    Thread Starter Business Matrix

    (@business-matrix)

    11 years 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)

    Plugin Author Bob

    (@prasunsen)

    11 years ago

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

    Thread Starter Business Matrix

    (@business-matrix)

    11 years ago

    does this help

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

    Plugin Author Bob

    (@prasunsen)

    11 years ago

    Yes. Deactivate and activate.

Viewing 15 replies - 1 through 15 (of 23 total)
1 2
  • The topic ‘Unknown Column 'randomize in 'field list'’ is closed to new replies.